import { drizzle } from "drizzle-orm/mysql2";
import { createConnection } from "mysql2";
import dotenv from "dotenv";
import { schema } from "@/lib/schema";

dotenv.config({ path: ".env.local" });

export async function openConnection() {
  const connection = createConnection(process.env.DB_URL!);
  const sdb = drizzle(connection, { schema, mode: "default", casing: "snake_case" });
  const closeConnection = async () => await connection.end();
  return {
    sdb,
    closeConnection,
  }
}