seed

export const usersTable = sqliteTable("users", {
  id: text("id", { length: 36 }).primaryKey().default(crypto.randomUUID()),
  role: text("role", { enum: [ROLE.chief, ROLE.admin, ROLE.client] }).default(
    ROLE.client
  ),
  username: text("username").unique().notNull(),
  email: text("email").unique().notNull(),
  password: text("password").notNull(),
  img: text("img"),
  createdAt: text("created_at").default(sql`(CURRENT_TIMESTAMP)`),
  updateAt: text("updated_at").$onUpdate(() => sql`(CURRENT_TIMESTAMP)`),
});

import "../utils/dotenv";
import { BCRYPT } from "../constants/bcrypt";
import { db } from "./db";
import { ROLE, usersTable } from "./schema";
import bcrypt from "bcrypt";

const EDARCODE = {
  id: crypto.randomUUID(),
  username: process.env.CHIEF_USERNAME as string,
  email: process.env.CHIEF_EMAIL as string,
  password: process.env.CHIEF_PASSWORD as string,
  role: ROLE.chief,
};

const LORE = {
  id: crypto.randomUUID(),
  username: "lore",
  email: "lore@gmail.com",
  password: "123456",
  role: ROLE.client,
};

const seedUsers = async () => {
  console.log("seed");
  EDARCODE.password = await bcrypt.hash(EDARCODE.password, BCRYPT.salt);
  LORE.password = await bcrypt.hash(LORE.password, BCRYPT.salt);

  await db.insert(usersTable).values([EDARCODE, LORE]);
};

seedUsers().catch(console.error);

createdAt: text("created_at").default(sql`(CURRENT_TIMESTAMP)`)