📄 Source: test_db_ops.php
<?php
require_once 'database.php';
echo "<h2>Testing Database Operations</h2>";
try {
$db = new ChatDatabase();
echo "✅ Database connected<br>";
$testEmail = "test_" . time() . "@example.com";
$convId = $db->createConversation($testEmail);
echo "✅ Created conversation ID: $convId<br>";
$db->addMessage($convId, 'user', 'Test user message');
echo "✅ Added user message<br>";
$db->addMessage($convId, 'assistant', 'Test assistant response');
echo "✅ Added assistant response<br>";
$messages = $db->getMessages($convId);
echo "✅ Retrieved " . count($messages) . " messages<br>";
$conversations = $db->getConversations($testEmail);
echo "✅ Retrieved " . count($conversations) . " conversations<br>";
echo "<h3>Messages:</h3>";
foreach ($messages as $msg) {
echo "Role: {$msg['role']}, Content: {$msg['content']}<br>";
}
} catch (Exception $e) {
echo "❌ Error: " . $e->getMessage() . "<br>";
echo "<pre>" . $e->getTraceAsString() . "</pre>";
}
?>
← Back