This a C# Console Application designed to store and track habits on a very basic level.
This application makes use of Sqlite and CRUD operations.
- Application must store and retrieve data from a database
- Application must create a db if one does not exist
- The app must create a table in the db where the habit will be stored
- The app must be able to perform CRUD operations
- The application must exit only upon user request
- Cannot use data mappers, raw SQL only
- Project must contain a ReadMe file
- User can create custom habits and units of measurement
- App to have report functionality
- My knowledge of SQL is limited. Basic crud ops are simple. I ran into trouble creating a table to store units of measurement. In the end, I used the habit's tabe name as a key for the unit table but this feels incorrect. I also was unsure how to combine the queries into some sort of joiner and ended up performing 2 queries for the report function.
- A lot of the program code is UI specific but feels a bit long and jumbled. In the future I might look for a better way to further seperate the program responsibilities. I do feel as though I seperated data logic and UI logic fairly well.
- I need to improve writing my commits. I do well enough to keep the commit message concise but I seldom explain in more detail afterwards.