Syntax Warriors

Database Systems 2022 term project (Software Engineering)

Project Definition

A full-stack web application for programming contests, inspired by EMKC. Uses Piston for code execution.

The main focus is on performing database queries. Many of the web development best practices were not followed for simplicity. For example, the passwords are stored as plain text in the database and all of the requests performed on the API endpoints are POST requests.

Building the project

Prerequisites

• NodeJS (>= 18)
• NPM
• MySQL (Docker images are ok)

Steps

1. Clone the repository using git clone
2. cd into the directory of the project
3. cd into src
4. Copy db/config.js.sample into db/config.js
5. Edit config.js with your MySQL information
6. Run npm install to install the node modules
7. Run npm run initdb to initialize the database
8. Run npm run migrate to apply the database migrations
9. Run npm run api and npm run front
10. Access the website at 127.0.0.1:3000

Team members

Team members

• Omar Adel Abdel Hamid Ahmed Brikaa - 20206043
• Ahmed Wael Nagy Wanas - 20206008
• Adham Hazem Fahmy Shafhei - 20206011
• Ali Esmat Ahmed Orfi - 20206123
• Mootaz Medhat Ezzat AbdelWahab - 20206074