abbyxsu / bucket_list_budgeter Goto Github PK

As a budget planner, I want to access my personal budget planner so that I can update / review / delete my budget log details

Database should fulfill users table in ERD of #10
Epic #2

AS A Budget user I want to delete items SO THAT I can manage the items of my bucket list

GIVEN a table row on bucket list
WHEN the delete action is clicked
THEN the item is removed from the view
and then the item gets removed from the database
and then the page will be auto refreshed with most updated bucket list

Hosting the server & simple triggers proof of concept & how-to doc

AS A Budget user I want to add or delete items on my to do list SO THAT I can manage or prioritise the items of my bucket list

Acceptance Criteria:
GIVEN a bucket-list exists in the system
WHEN a user navigates to the /bucket-list uri
THEN the bucket-list table view is loaded, containing current bucket-list items

GIVEN a bucketlist has not been created
WHEN a user navigates to the /bucketlist uri
THEN a create bucketlist action is available

GIVEN the Create bucketlist action is available
WHEN it's clicked
THEN a bucketlist table view is shown with each field editable

Given a bucketlist table view edit form is open
WHEN the fields are all filled out
THEN the submit button can be clicked

GIVEN a bucketlist table view
WHEN it has rows in it
THEN there should be a delete action link on each row

GIVEN a table row on bucket list
WHEN the delete action is clicked
THEN the todo list item is removed from the view
and then the item gets removed from the database

GIVEN a bucket list table
WHEN there are rows displayed
THEN each row should have an edit action available

GIVEN a table row
WHEN the edit button is clicked
THEN the edit form should open, populated with the current state from that row

Update ERD to reflect the latest changes and detailed specification

As a user, I want to be able to register and log in the Web App via register and login page so that I can register and log on to my own account

Database should fulfill users table in ERD of #10
Epic #4

GIVEN user load onto the page,
WHEN user input register/login details
THEN user data will be created and stored in the database

AS A budgeter I want to filter by users so that i can view my own data or my friends data

GIVEN the website is accessed
WHEN no user is selected
THEN redirect to the /Users page
AND THEN display users in the system

Given there are users
when the /users page is accessed
then show a table view of users with columns for key user data, including columns for total budget, total todo item conut, current balance.

GIVEN /users page
WHEN Select user button pressed
THEN selection stored in session
AND THEN all other pages get data filtered to user=current_user

[Notes for approach]
e.g. store current user in session state in browser
Append a query string to the URIs ?user={the logged in username}
Results should be filtered server side to only include results matched to that user
Have a /Users page to display users in the system, along with summary of their data (e.g. COUNT OF TODO items, Budget, balance)

produce simple PoC

AS A Budget user I want to edit all fields of my items on my list SO THAT I can manage or prioritise the items of my bucket list

GIVEN a table row
WHEN the update button is clicked
THEN the edit form should open, populated with the current state from that row

GIVEN the bucket item has been updated
WHEN the submit button is clicked
THEN the items information will be updated in the database and user will be redirect to their bucket list table to have full views of all their item

produce a simple PoC which deploys a flask web app to GCP

As a user, I want to be remembered in the database/system so that I can view my personal data

Database should fulfill users table in ERD of #10
Epic #4

As a planner, I want to access my Todo List in my personal database/system so that I can review my personal todo items

Database should fulfill users table in ERD of #10
Epic #3

As a planner I want to have a option to delete items on my bucket list SO THAT I can delete the items of my bucket list

GIVEN a bucketlist table view
WHEN it has rows in it
THEN there should be a delete action link on each row

Output: simple proof of concept , to do list API

AS A budget planner I want to be able to be encourage to review, add, update, delete my savings data SO THAT the budget data reflects my most up-to-date finance situation

Acceptance Criteria:
GIVEN user enters an amount (currency) AND selects an action type (Add/Withdraw)
WHEN the amount and action type is submitted
THEN data of last submission and the latest submission will be displayed (with -+%, % to target,remaining amount to target)
AND THEN a positivity quote will be shown.

If on same calendar month as last submission, the view should have an edit this months savings option / action link
If no data submission in current month, display request for new data submission

(simple PoC to be produced)

AS A budget planner I want to be able to add/withdraw the amount of money on the budget planner SO THAT the budget data reflects my most up-to-date finance /saving situation

Acceptance Criteria:
GIVEN user enters an amount (currency) AND selects an action type (Add)
WHEN the amount and action type is submitted
THEN data of last submission and balance will be displayed
with -+%
with % to target
with remaining amount to target
with positivity quote

AS A {budget planner} I want to monitor my savings on the app SO THAT I have enough finance to do the items from my post-covid to do list after the pandemic

Acceptance Criteria:
GIVEN a quantity of savings balance , total costs
WHEN Account summary is click
THEN a lits account summary should present including no. of bucket items, total costs current total budget and target budget with percentage and cost -budget gap

Result lists should be limited to 5 items
savings field should be formatted as currency
On submission of savings, results lists should be shown along with current total budget and target budget with percentage

AS A planner r I want to access my bucket list SO THAT I can view my bucket list,

Acceptance Criteria:
GIVEN a bucket-list exists in the system
WHEN a user navigates to the /bucket-list uri
THEN the bucket-list table view is loaded, containing current bucket-list items

However, if the user is not register, the page will direct user to register page to register an account

AS A planner r I want to edit and update my bucket list SO THAT I can amend my bucket list,

Acceptance Criteria:
GIVEN the bucketlist action update button is available
WHEN it's clicked
THEN an pre-populated bucket item table view is shown with each field editable

AS A planner I want to see an summary of my account including my budget and bucket lists status SO THAT I have a quick look of my current situation

Acceptance Criteria:
GIVEN a quantity of savings balance , total costs
WHEN Account summary is click
THEN a list account summary should present including no. of bucket items, total costs current total budget and target budget with percentage and cost -budget gap

AS A planner I want to see the bucket List ordered by my preference SO THAT I can priority my bucket item

GIVEN a table /list of bucket Items
WHEN a planner view the table or update the table
THEN the items will be order by its preference number

simple DAL (Data access layer) in a python app which is able to connect to a sql server instance and perform simple queries:
select query and parse the result into python objects
insert & update queries & parsing response (using RETURNING statement to return the affected IDs)

Unit Testing for Flask with WTForm

1. investigate how to do the unit test
   2.Unit Testing/mocking with SQLalchemy

AS A budget planner I want to be able to be encourage to review my savings data SO THAT i understand my most up-to-date finance situation

GIVEN the link 'my saving journey'
WHEN its clicked
THEN data of submissions of the past data will be display with total balance

if account is not created , it will redirect to the register page
if no data submission in current month, redirect/ display request for new data submission

AS A planner I want to see my latest budget activity SO THAT I monitor my saving progress

GIVEN a table /list of budget activity
WHEN a planner view the table or update the table
THEN the items will be order by action time from latest to oldest