import { createDBPool } from "./src/internal/datastore/index";
import * as dotenv from "dotenv";
import path from "path";
dotenv.config({ path: path.resolve(process.cwd(), '../../.env') });

const config = {
  host: process.env.DATABASE_HOST,
  port: parseInt(process.env.DATABASE_PORT || "5432"),
  database: process.env.DATABASE_NAME,
  user: process.env.DATABASE_USER,
  password: process.env.DATABASE_PWD,
  ssl:
    process.env.DATABASE_HOST !== "localhost" &&
      process.env.DATABASE_HOST !== "127.0.0.1"
      ? { rejectUnauthorized: false }
      : undefined,
};

async function checkLogs() {
  const db = createDBPool(config);
  try {
    const logs = await db.selectFrom('admin_activity_log' as any).selectAll().orderBy('performed_at desc').limit(10).execute();
    console.log("Latest Logs:");
    console.log(JSON.stringify(logs, null, 2));
  } catch (e) {
    console.error(e);
  } finally {
    await db.destroy();
  }
}

checkLogs();