2.1

[diegoabeltran16]

feature/database-extensions

[diegoabeltran16]

Roadmap

Objective

Expand the existing SQLite database schema to support additional features such as budgeting, detailed expense categories, and timestamps. These changes will allow the bot to handle new functionalities like expense reporting, budget management, and expense categorization.

Step 1: Analyze Existing Database

. Goal: Understand the current schema and data points stored in the database. . Action: Review the existing database (expenses.db) and identify what tables, columns, and relationships are already in place (likely a table for expenses).

Step 2: Define New Tables and Columns

. Goal: Identify what new tables and columns are needed to support the upcoming features.

Step 3: Write Migration Script

. Goal: Create a migration script to update the existing database without losing data.

Step 4: Update CRUD Operations

. Goal: Modify existing code to handle the new schema. Update the db.py file to include functions for managing budgets and categorizing expenses.

Step 5: Testing Database Changes

. Goal: Ensure the database schema changes work as expected without introducing errors.

[diegoabeltran16]

Files and folders

Folders and files will be updated and new files will be added for the feature/database-extensions roadmap.

• src/utils/db.py (Update) : Add new database operations for budgets and categories.
• src/commands/generate_report.py (Update): Update to work with the new database schema (categories and budgets).
• src/utils/database.py (Update): Add migration logic or update general database setup code.
• tests/test_database.py (Update): Add tests for database migration and CRUD operations.
• src/migrations/migrate_database.py (New): Migration script to handle the database schema changes.
• tests/test_budget.py (New): Unit tests for the budgeting features.

[diegoabeltran16]

[project_details\development-plan\Cycle-2\cycle_2_feature-database-extensions.md](https://github.com/diegoabeltran16/Passive-Expenses-Bot/blob/main/project_details/development-plan/Cycle-2/cycle_2_feature-database-extensions.md)