rin-proj1 1.0

CLI tool convert .csv files to .db files and vice-versa

command usage (CLI)

See list of commands with

rin_proj1 --help

Error logging is only compatible with exec-based-on-env
read_csv_and_insert_to_db : Adds contents of provided csv to a .db file
export_db_to_csv : Adds contents of provided db to a .csv file

set-config

Executes read_csv_and_insert_to_db and export_db_to_csv functions with the given config file. If no path is provided, tries to open config.yaml in the current directory.

 rin_proj1 set-config --path path/to/config.yaml

for default/config in current directory, use main1

---

set-db

Executes read_csv_and_insert_to_db and export_db_to_csv functions with the db_name provided by user.

rin_proj1 set-db saves data.db in current directory
rin_proj1 set-db db_name saves to db_name in current directory. Will create a file if not present

---

exec-based-on-env

Executes read_csv_and_insert_to_db and export_db_to_csv functions with csv file depending on the environment type

rin_proj1 exec-based-on-env

If you want to run the command in a different environment,

poetry shell
export APP_MODE=env_name
rin_proj1 exec-based-on-env

env_name options: development, testing, production

---

Successful execution should print confirmation message in terminal. If there is no output, check for a mpj1_error.log file to determine the error.

Expected yaml file layout (minimum):

LOG_LEVEL: log_level (see below for valid options)

APP_MODE:
  csv_file: path/to/data.csv
  db_file: path/to/data.db
  table_file: your_table_name

log_level options: critical, error, warning, info, debug