-
Notifications
You must be signed in to change notification settings - Fork 11
Expand file tree
/
Copy pathupdate.yaml
More file actions
64 lines (64 loc) · 2.38 KB
/
update.yaml
File metadata and controls
64 lines (64 loc) · 2.38 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
---
name: update
runner_type: "python-script"
description: "Update data in a SQL database"
enabled: true
entry_point: update.py
parameters:
connection:
type: string
description: "Name of <connection> from this pack's configuration that specifies how to connect to a database server."
required: false
host:
type: string
description: >
Optional override of the database host in <connection> (required if <connection> is not specified). Database server to connect to. If not using a default port add that here. ex. host.domain.tld or host.domain.tld:1234
required: false
username:
type: string
description: "Optional override of the username in <connection> (required if <connection> is not specified). Username for authentication"
required: false
password:
type: string
description: "Optional override of the password in <connection> (required if <connection> is not specified). Password of the specified username"
secret: true
required: false
database:
type: string
description: "Optional override of the database in <connection> (required if <connection> is not specified). Database to connect to, to run querys against."
required: false
port:
description: "Port to connect to database on. If Default leave blank"
type: integer
required: false
drivername:
type: string
description: "Optional override of the database_type in <connection> (required if <connection> is not specified). The type of database that is being connected to."
required: false
table:
type: string
description: "Database table to UPDATE."
required: true
where:
type: object
description: >
Dictionary of data to be used to create a WHERE clause for the UPDATE statement
{
'column_1': 'data_to_match_1',
'column_2': 'data_to_match_2',
'column_3': 'data_to_match_3',
'column_4': 'data_to_match_4',
}
required: false
default: {}
update:
type: object
description: >
Dictionary of data to be used to as Values to update for the UPDATE statement
{
'column_1': 'data_to_update_1',
'column_2': 'data_to_update_2',
'column_3': 'data_to_update_3',
'column_4': 'data_to_update_4',
}
required: true