Skip to content

ChristopherAlphonse/ticketing-system

Repository files navigation

Help Pilot - Read me file in working progress

Overview

to-Do:Dashboard, CRUD operation, Auth, Admin/roles

Please note that this README is currently a work in progress, and the official version will be rewritten upon completion.

Tech Stack

  • Next.js
  • Tailwind CSS
  • Prisma ORM
  • MySQL Database

Recommended Tools

To facilitate seamless development and usage of Help Pilot, we recommend the following tools:

Getting Started

To get started with Help Pilot, follow these steps:

  1. Install dependencies:
yarn i

Run the development server:

yarn dev

Open http://localhost:3000 in your browser to view the application.

updating packages

To upgrade all packages to their latest versions, use the following command:

yarn up-all

Database Operations

Push Database Changes

Run the following commands to apply database changes:

npx prisma db push

Generate Prisma Client

Generate the Prisma client to enable seamless interaction with the database:

npx prisma generate

Prisma Studio

Launch Prisma Studio for a visual representation of the database:

npx prisma studio

Formatting

Use the following command to format Prisma schema files:

npx prisma format

Migration

To create and apply database migrations, run

npx prisma migrate

The migration script will be created in the prisma/migrations/migration.sql folder.

Database Access without DataGrip If you prefer not to install DataGrip, you can use Prisma Studio directly from the terminal:

npx prisma studio

Access Prisma Studio at http://localhost:5555 in your browser.

MySQL Setup for Prisma For MySQL setup details with Prisma, refer to the Prisma Documentation.