ECC

Note: Unable to connect to postgres db in docker container via my python script
- (Though the DB initializes with two tables eod and intraday generated using the init.sql upon launching the docker containers)
- Launch using docker-compose up -d
- localhost:8080 endpoint - Adminer GUI to view data in Postgres
- docker-compose down --volumes
Using sample csv files under the input folder to continue further with business checks(Docker containers are not required)
- eod.csv - Daily end of day report - schematic excerpt of CC050 table
- first_intraday_report.csv - First intraday report extract (ideally would be extracted via a sql query to filter min time of day from CI050 table)
Description and Steps to run Python script - daily_checks.py
- Classes and functions to read from csv, DB and perform required checks
- python3 -m smtpd -c DebuggingServer -n localhost:1025 from prject terminal to start debug server to listen and display mail content
- Run this file to execute the checks
margin_types.json - Holds configurable margin type list to filter out before performing row wise comparison
module holds the code for sample email functionality
Tests -

Provide feedback