Setup

Setup DB

1. MySQL installed (prerequisite)

2. Create database with name - "att"

3. VSCode extensions:

   1. Name: SQLTools

      • Id: mtxr.sqltools
      • Link:https://marketplace.visualstudio.com/items?itemName=mtxr.sqltools

   2. Name: SQLTools MySQL/MariaDB/TiDB

      • Id: mtxr.sqltools-driver-mysql
      • Link:https://marketplace.visualstudio.com/items?itemName=mtxr.sqltools-driver-mysql

   3. Name: Prettier SQL VSCode (Recommended)

      • Id: inferrinizzard.prettier-sql-vscode
      • Link:https://marketplace.visualstudio.com/items?itemName=inferrinizzard.prettier-sql-vscode

4. Connect to 'att' database using SQLTools in VSCode by adding:

   • Connection name
   • Port
   • Database name
   • Username
   • Password

5. Create a '.env' file & fill the env values: HOST = "<HOST_NAME>" SQL_PORT = "<SQL_PORT>" USER = "<USER_NAME>" PASSWORD = "<PASSWORD>" DATABASE = "<DB_NAME>" PORT = PORT_NO

6. Go to /schema and start executing queries by clicking "Run on active connection" in each block (--@block) in the 'db.session.sql'.

Setup project

1. Clone the project to your local machine.

2. Run npm install

3. Run npm run dev in root folder.