Problem
SalesTracker uses hardcoded paths for database, schema, and queries directories relative to the script location. This limits deployment flexibility (e.g., Docker, CI/CD, or alternative deployment structures), and environment variables are not considered.
Expected Behavior
Allow overriding these paths via environment variables or config file for better deployment portability.
Suggested Fix
- Refactor to allow dynamic directory configuration through environment variables or config file options.
Problem
SalesTrackeruses hardcoded paths for database, schema, and queries directories relative to the script location. This limits deployment flexibility (e.g., Docker, CI/CD, or alternative deployment structures), and environment variables are not considered.Expected Behavior
Allow overriding these paths via environment variables or config file for better deployment portability.
Suggested Fix