<?php
require_once __DIR__ . '/../src/Utils/Env.php';
require_once __DIR__ . '/../src/Config/Database.php';

use App\Utils\Env;
use App\Config\Database;

Env::load(__DIR__ . '/../../.env');
$db = Database::getInstance()->getConnection();

echo "--- CONVERSATIONS COLUMNS ---\n";
$stmt = $db->query("SHOW COLUMNS FROM conversations");
$cols = $stmt->fetchAll(PDO::FETCH_COLUMN);
print_r($cols);

echo "\n--- SAMPLE CONVERSATION ---\n";
$stmt = $db->query("SELECT * FROM conversations ORDER BY id DESC LIMIT 1");
print_r($stmt->fetch(PDO::FETCH_ASSOC));
