gem-hunter

install the packages needed

setup nodemon

{
    "watch": [
        "src"
    ],
    "ext": ".js,.ts",
    "exec": "npx ts-node ./src/index.ts"
}

  "scripts": {
    "start": "npx nodemon"
  },

install prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

DATABASE_URL="postgresql://johndoe:randompassword@localhost:5432/mydb?schema=public"

db setup

CREATE DATABASE ecommerce;

DATABASE_URL="mysql://root:Bassguitar1@localhost:3306/ecommerce?schema=public"

In the schema.prisma file, define the models

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

model User {
  id       Int      @id @default(autoincrement())
  email    String   @unique
  name     String?
  password String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@map("users") // map to the users table in the database
}

Run the migration

go to prisma studio

Seed the database with some data using the seed.ts file

import { prismaClient } from "..";


//seed data
const seedData = async () => {
    for (let i = 0; i < 10; i++) {
        
   await prismaClient.user.create({
        data: {
            email: `user-${i + 10}-one@yopmail.com`,
            name: `user-${i + 10}-one`,
            password: "password",
        },
    });
    }
}

seedData().then(() => {
    console.log("seeded data");
    process.exit(0); //exit the process after seeding data, 0 means success
}
).catch((error) => {
    console.log(error);
    process.exit(1); //exit the process after seeding data, 1 means failure
});

Run the seed file steps

 {
     "scripts": {
         "seed": "ts-node --transpile-only ./src/utils/seed.ts"
     }

 }