search

CSC207-2022F-UofT / course-project-bill-gates

A bill recording software developed by team "Bill Gates."
9 stars 4 forks source link

[+] Added database connection gateway #16

Closed Lei-Tin closed 1 year ago

Lei-Tin commented 1 year ago

Not complete yet, do not review

I will request for review once the feature is fully implemented.

Lei-Tin commented 1 year ago

My part of trying to get the Database functioning is pretty much done The remaining work to be done is just the refacotring of garbage code (Which I accidentally might have included too much :P)

Lei-Tin commented 1 year ago

The way I organized the database is as follows: image

The main databse is called "bill"

Users

The red box is the table used to store all the user login information (Doesn't have nickname, email, etc., only username and password) When setting up, we might have to call CREATE TABLE user (username TEXT, password TEXT)

Bills

The blue box highlights one of the temporary bill I have created for a specific user, which is called bill{#number}, the number can be decided by the userId.

Each bill can be created by calling DatabaseGateway.createBill(billId), which contains the columns shown in the green box in the picture above

Please leave any opinions here and I will modify correspondingly :3

Lei-Tin commented 1 year ago

Overall GOOD.

It's ok, you will help me fix this 💩