Skylar is web-base application for programming practice designed to help with coding assessments and interviews. Skylar focuses on SQL queries and databases. The program starts with a preloaded database with randomly generated data but can be added to by the user.
To get started with Skylar, follow these steps:
-
Clone the Repository:
git clone https://github.com/AuricFox/Skylar.git
-
Navigate to the Project Directory:
cd Skylar
-
Setup Environment:
pip install virtualenv virtualenv env .\env\Scripts\activate # Windows source env/bin/activate # Mac OS
-
Install Dependencies:
(env) pip install flask tabulate python-dotenv
-
Run Server:
(env) python app.py
The server will start running, and you can access the application by navigating to
http://localhost:5000
in your web browser.
Below is the default schema of the database used for Skylar:
cid | cname | address | city | state |
---|
- PK: cid
cid | type | value |
---|
- PK: cid, type, value
- FK: ContactInfo.cid TO Customer.cid
- type examples: cell, home, email
rid | rname | city | state | rating | ownerID |
---|
- PK: rid
- FK: Restaurant.ownerID TO Owner.oid
cid | rid | date | num_adults | num_child |
---|
- PK: cid, rid
- FK: Reservation.cid TO Customer.cid
- FK: Reservation.rid TO Restaurant.rid
Oid | oname |
---|
- PK: Oid
This project is licensed under the MIT License - see the LICENSE file for details.