database-interactions/cbc.yaml at main · RWTH-TIME/database-interactions · 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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
author: Anna Beckers
description: Query DB to a CSV
docker_image: ghcr.io/rwth-time/database-interactions/database-interactions
name: Database Interactions
entrypoints:
  run_query_from_file:
    description: Run the query using a file containing the query
    envs:
      DB_DSN: null
      DB_SCHEMA: null
    inputs:
      query_file:
        config:
          query_file_BUCKET_NAME: null
          query_file_FILE_EXT: null
          query_file_FILE_NAME: null
          query_file_FILE_PATH: null
          query_file_S3_ACCESS_KEY: null
          query_file_S3_HOST: null
          query_file_S3_PORT: null
          query_file_S3_SECRET_KEY: null
        description: txt file containing the SQL query
        type: file
    outputs:
      csv_output:
        config:
          csv_output_BUCKET_NAME: null
          csv_output_FILE_EXT: csv
          csv_output_FILE_NAME: null
          csv_output_FILE_PATH: null
          csv_output_S3_ACCESS_KEY: null
          csv_output_S3_HOST: null
          csv_output_S3_PORT: null
          csv_output_S3_SECRET_KEY: null
        description: CSV of the queries result
        type: file
      query_information:
        config:
          query_information_DB_DSN: null
          query_information_DB_SCHEMA: null
          query_information_DB_SOURCE_DESCRIPTION: null
          query_information_DB_TABLE: null
        description: A table containing information about the executed query
        type: database_table
      query_result_as_table:
        config:
          query_result_as_table_DB_DSN: null
          query_result_as_table_DB_SCHEMA: null
          query_result_as_table_DB_TABLE: null
        description: A table containing the queries result
        type: database_table
  run_query_from_string:
    description: Run the query directly by passing an SQL Query
    envs:
      DB_DSN: null
      DB_SCHEMA: null
    inputs:
      query_str:
        config:
          QUERY: ''
        description: Pass your SQL-Query here
        type: custom
    outputs:
      csv_output:
        config:
          csv_output_BUCKET_NAME: null
          csv_output_FILE_EXT: csv
          csv_output_FILE_NAME: null
          csv_output_FILE_PATH: null
          csv_output_S3_ACCESS_KEY: null
          csv_output_S3_HOST: null
          csv_output_S3_PORT: null
          csv_output_S3_SECRET_KEY: null
        description: CSV of the queries result
        type: file
      query_information:
        config:
          query_information_DB_DSN: null
          query_information_DB_SCHEMA: null
          query_information_DB_SOURCE_DESCRIPTION: null
          query_information_DB_TABLE: null
        description: A table containing information about the executed query
        type: database_table
      query_result_as_table:
        config:
          query_result_as_table_DB_DSN: null
          query_result_as_table_DB_SCHEMA: null
          query_result_as_table_DB_TABLE: null
        description: A table containing the queries result
        type: database_table