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

const poolConnection = mysql.createPool({
  uri: config.DB_URL,
});

export const db = drizzle(poolConnection, { schema, mode: "default", casing: "snake_case" });