import { betterAuth } from "better-auth";
import { Pool } from "pg";
const emailManager = require('../_miniapps/EmailManager/EmailManager');

const connectionString = process.env.DB_ENV_URL;
console.log(process.env.DB_ENV_URL)

if (!connectionString) {
    throw new Error("POSTGRES_URL is not defined in environment variables.");
}

const pool = new Pool({connectionString});

pool.query(`select * FROM user`).then(r => console.log('From USER: ', r.rows));
pool.query(`select * FROM session`).then(r => console.log('From SESSION: ', r.rows));
pool.query(`select * FROM account`).then(r => console.log('From ACCOUNTL ', r.rows));
pool.query(`select * FROM verification`).then(r => console.log('From VERIFICATION: ', r.rows));

pool.query(`select current_database(), current_schema();`).then(r => console.log("Current DB: ", r.rows[0].current_database, " Current Schema: ", r.rows[0].current_schema))

export const auth = betterAuth({
    database: pool,
    emailAndPassword: {
        enabled: true
    },
    emailVerification: {
        sendOnSignUp: true,
        autoSignInAfterVerification: true,
        sendVerificationEmail: async ({user, url, token}, request) => {
            await emailManager.sendAccountVerificationEmail(user.email, url)
        }
    }
});