A colorful and interactive command-line task manager using the MVC (Model-View-Controller) architecture, built with Python and SQLAlchemy. This project was developed through pair programming, emphasizing clean code structure, collaboration, and real-world backend practices like database migrations and CI/CD.
✅ Create, view, update, and delete tasks 📅 Validated date input (DDMMYYYY format) 🎨 Color-coded interface: 🟩 Green → Future tasks 🟨 Yellow → Today's tasks 🟥 Red → Overdue tasks 🗄️ Database versioning using Alembic 🧪 Automated testing with Pytest 🔄 CI/CD pipeline via GitHub Actions
- Python
- PostgreSQL
- SQLAlchemy
- Alembic
- Pytest
- GitHub Actions
- MVC Pattern
pip install -r requirements.txt # Install dependencies
alembic upgrade head # Apply latest DB migrations
python main.py # Launch the application- Date format: DDMMYYYY (e.g., 25122024)
- Menu options:
1-Create
2-View
3-Search
4-Update
5-Delete
6-Exit
pytest # Run all tests
pytest -m create # Creation tests only
pytest -v # Verbose output├── .github/workflows
├── alembic/
│ ├── README.md
│ ├── env.py
├── controllers/task_controller.py # Business logic
├── database/db.py # Database
├── models/task_model.py # SQLAlchemy model
├── tests/ # Test suite
│ ├── conftest.py
│ └── test_tasks.py
├── views/task_view.py # View
├── main.py # Main interface
├── alembic.ini
├── pytest.ini
└── README.md
├── requirements.txt
The following tests ensure the reliability of key application functionalities:
- TC-001: Date validation
- TC-002: Task creation
- TC-003-004: Task retrieval
- TC-005: Task updates
- TC-006: Task deletion
- TC-007: Error handling
- TC-008: Full CRUD integration
This project was developed through pair programming using Visual Studio Code Live Share, enabling real-time collaboration and agile workflow management. We split responsibilities based on MVC layers and alternated roles between driver and navigator.
Feel free to clone, fork, and contribute! Happy coding!