Scenario Log

Description

A **function **to add an entry to the scenario log table. Implemented for SQL and Python. Covers and documents the creation of the database structure (tables) and the import and export of data.

Inputs:

• project
• version
• io
• schema_name
• table_name
• script_name
• comment

Outputs (to table):

• id (*)
• project
• version
• io
• schema_name
• table_name
• script_name
• entries (*)
• comment
• user_name (*)
• timestamp (*)
• metadata (*)

(*) Generated from the database system

Execution

In SQL-Scripts:

-- scenario log (project,version,io,schema_name,table_name,script_name,comment)
SELECT scenario_log('REEEM','v0.1.0','setup','model_draft','scenario_log','reeem_scenario_log.sql','Function test');

In Python-Scripts:

# scenario log (con,project,version,io,schema_name,table_name,script_name,comment)
scenario_log(con, 'REEEM', fns['version'], fns['io'], db_schema, db_table, os.path.basename(__file__), filename)

Code

Scenario Log table setup Scenario Log function