CASH APP

Hello! This is a Cash App clone!

Relational Table

USER(user_id, user_name)
USER_FRIEND(user_id, friend)
USER_HAS_GROUP_EXPENSE(user_id, group_id, expense_id)
HAS_GROUP(group_id, group_name)
EXPENSE(expense_id, creditor, amount, is_settled, expense_date)

Files

Folders

1. scipts - the sql scripts local - script for generating the database locally remote - script for generating the database remote
2. src - python scripts

Running App

In running the app is separated by the remote and local database. But first installing the environment and the requirements

1. Installation of python (v.3.9) or creating an environment
2. Installing the requirements

pip install -r ./requirements.txt

3. Also get the .env in the root directory of the file

Remote Database

The remote database uses the the remote database using railway app. Thus, only needed to run the main app

4. Running the app

make run

Local Database

The local database uses the scripts to generate the new database and populating it.

4. Populating the database

make create-database
make populate-database
make create-admin

5. Accessing the database

mysql -uadmin -padmin --database=127project

6. Running the main app

make run

Makefile

The make file automate the development of the database

|_ make create-database
|   - script that will create the database and the tables 
|        note: that it will  not populate the database  yet
|_ make populate-database
|   - after creating the database, populating the database is next. python script that will populate the tables in the database 
|_ make create-admin
|   -  create admin user for that is granted all priveleges for all tables in the databse 
|_ make delete-database 
|   - deletes the database 
|_ make run
    - run the app