stackstorm-sql/actions/insert_bulk.yaml at b8ceadb0ec6d5e612a81ce1fae3e86b96ff165b5 · StackStorm-Exchange/stackstorm-sql · GitHub

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
---
  name: insert_bulk
  runner_type: "python-script"
  description: "Insert bulk data into a SQL database"
  enabled: true
  entry_point: insert.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 insert data into."
      required: true
    data:
      type: array
      description: >
        List of Dictionaries of data to be inserted where the key corresponds to the column of the table
        [{
          "column_1": "data_to_insert_1",
          "column_2": "data_to_insert_2",
          "column_3": "data_to_insert_3",
          "column_4": "data_to_insert_4",
        },{
          "column_1": "data_to_insert_1",
          "column_2": "data_to_insert_2",
          "column_3": "data_to_insert_3",
          "column_4": "data_to_insert_4",
        }]
      required: true