The purpose of this project is to create a non-trivial app to track monthly spending.
The idea is that there will be a Dashboard view of recent activity and easy ways to add spending events. Old activities can be easily edited or deleted.
Spending events will be stored in a DB (start with postgresql) and I will use Bootstrap CSS framework as the front end.
- Initialize DB
- Users
- Spending categories (FK constraints)
- Spending events
- Dashboard
- Branding
- Nav sidebar
- User preferences
- Reports
- Charting (this month, annual)
- Activity table (Add, Edit, Delete)
- CGI scripts to get data
- Process old data into DB
File Structure Below is the file structure that I will be using. I can git init this directory and push this to different parts of the computer to sync code for different applicaitons (DB, web, scripting) projects
pubsub/
├── deploy.sh: pushing changes to local machine and working directories
├── lib: code that could be used by other projects
│ ├── python
│ │ └── pkgs
│ │ ├── element.py
│ │ ├── __init__.py
│ │ └── web.py
│ └── web
│ ├── component:
│ │ └── js
│ │ └── component.js
│ └── scrollbar
│ ├── css
│ │ └── styles.css
│ └── js
│ └── scrollbar.js
├── postgresql
│ └── init.sql
├── python
│ └── pkgs
│ ├── __init__.py
│ └── web.py
├── README.md
└── web
├── app
│ ├── index.html
│ ├── js
│ │ ├── composition.js
│ │ ├── main.js
│ │ └── messaging.js
│ └── lib
│ └── component
│ └── component.js
└── cgi-bin
├── get_schemas.py
├── get_table_columns.py
├── get_table_data.py
├── get_tables.py
├── test_update_row.py
└── update_row.py
19 directories, 23 files