i'm trying to migrate my databse

import { drizzle } from "drizzle-orm/mysql2";
import mysql from "mysql2/promise";
import "dotenv/config";
import * as schema from "./schema";


export default class dbClass {
    private static pool = mysql.createPool({
        host: "127.0.0.1",
        user: "root",
        database: "saturn-test",
      });
      
    static db = drizzle(dbClass.pool, { schema, mode: 'default' });
};

my code and schema is soemthing like
import { int, text, mysqlSchema } from "drizzle-orm/mysql-core";

export const schema = mysqlSchema("saturn");

export const user = schema.table("users", {
    id: int("id").primaryKey().autoincrement(),
    username: text("username"),
    password: text("password"),
    perm: int("perm"),
});
Was this page helpful?