write_table_to_csv

usage: write_table_to_csv [-h] config_path dbconfig table_name output_folder

Positional Arguments

config_path Add full filepath of config.ini file, for example auth/config.ini
dbconfig dev or docker
table_name Insert table name, for example my_tablename
output_folder Define output folder, for example: /app/data

functions

datapunt_processing.extract.write_table_to_csv.export_table_to_csv(config_path, db_config, table_name, output_folder)

Export table to CSV file.

Args:
  1. pg_str: psycopg2 connection string, for example: host=localhost port=5432 user=your_username dbname=your_database_name password=very_secret
  2. table_name: for example my_tablename
  3. output_folder: define output folder, for example: /app/data
Result:
Exported csv file to output_folder/table_name_2018-12-31.csv