How machas-6697/hr-database_management_system-cli-flask-sqlalchemy works
This HR management system offers employee, department, and project administration through a Click CLI, alongside business-query reporting; a minimal Flask route reports status rather than providing operational management. The CLI opens the SQLite database and runs SQL for management and reporting. The database initializer creates the schema, loads sample data, and verifies records. README capabilities also include attendance, leave, performance reviews, and payroll, represented in the schema/data layer though their CLI implementation is not fully shown. Arrows are limited to relationships evidenced by excerpts or README; unsampled CLI commands are not assigned speculative calls.
Main entry points: hr_cli.py HR CLI · schema.sql HR schema and records · init_db.py Database initialization · app.py Status page
Components 14
User Interfaces
- HR CLI
hr_cli.py - Status page
app.py
HR Operations
- Employee management
hr_cli.py - Department management
hr_cli.py - Project management
hr_cli.py - Attendance and leave
schema.sql - Performance reviews
schema.sql - Payroll
schema.sql
Reporting
- Business queries
queries.sql - Query commands
hr_cli.py
Database
- Database initialization
init_db.py - HR schema and records
schema.sql - SQLite database
Other components
- Operator
Connections 17
- Operator → HR CLI: runs commands
README.md - Operator → Status page: views status
app.py - HR CLI → Employee management: dispatches
hr_cli.py - HR CLI → Department management: dispatches
hr_cli.py - HR CLI → Project management: dispatches
hr_cli.py - HR CLI → Query commands: dispatches
hr_cli.py - Employee management → SQLite database: queries
hr_cli.py - Department management → SQLite database: queries
hr_cli.py - Project management → SQLite database: queries
hr_cli.py - Query commands → SQLite database: executes SQL
hr_cli.py - Query commands → Business queries: runs reports
README.md - Database initialization → HR schema and records: loads schema and data
init_db.py - Database initialization → SQLite database: creates database
init_db.py - Status page → SQLite database: configures SQLite
app.py - HR schema and records → Attendance and leave: defines records
README.md - HR schema and records → Performance reviews: defines records
README.md - HR schema and records → Payroll: defines records
README.md