Skip to content

alijavaidistar/WhiteRock

Repository files navigation

White Rock v2:

Group Repository for COSC 4353 Software Design

Run Locally

These are instructions for WSL but the process should be similar for Mac/Linux systems.

# Open Powershell and enter WSL
wsl

# Clone repo and go to django_app 
git clone https://github.com/alijavaidistar/WhiteRock/
cd WhiteRock

# Install dependencies if you don't already have them
sudo apt install python3
sudo apt install python3-pip
sudo apt install python3-django
sudo apt-get install python3-dev default-libmysqlclient-dev build-essential

TENANT_ID=170bbabd-a2f0-4c90-ad4b-0e8f0f0c4259
CLIENT_ID=92088f70-53f7-4321-a0af-85f9463af0c0
CLIENT_SECRET=Get it from mominnaim

export DB_USER=<YOUR_USERNAME>
export DB_PASSWORD=<YOUR_PASSWORD>

python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt
python manage.py runserver

Query Database

These are instructions for WSL to connect to the database and run queries. The process should be similar for Mac/Linux Systems.

# Install MySQL cli
sudo apt install mysql-server

# Connect to the database
 mysql --host=whiterock.mysql.database.azure.com --user=<USER> --password=<PASSWORD> --port=3306 --database=mjapp
 
# List dbs, tables, and columns
mysql> show databases;
mysql> show tables;
mysql> show columns from users;

# Run query
mysql> select * from users;
 
# Exit
mysql> exit

Run with Docker

Prerequisites make sure you have the following installed:

# 1. Clone the repository
git clone https://github.com/alijavaidistar/WhiteRock
cd White Rock

# 2. Build and start the containers
docker-compose build
docker-compose up

# 3. Run database migrations
docker-compose exec web python manage.py migrate

# (Optional) Create a superuser
docker-compose exec web python manage.py createsuperuser

About

Software Design Project

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Contributors