import { Surreal } from 'surrealdb';

const db = new Surreal();

try {
  console.log('🔌 Connecting to SurrealDB...');
  await db.connect('wss://gentle-island-06di2pv2c9po3a8euttd1alkek.aws-euw1.surreal.cloud/rpc');
  
  console.log('🔐 Authenticating...');
  await db.signin({ 
    username: 'rootuser', 
    password: 'n1n@S1mone' 
  });
  
  console.log('📂 Selecting namespace and database...');
  await db.use({ 
    namespace: 'neoad', 
    database: 'neodb' 
  });
  
  console.log('✅ Connection successful!');
  
  console.log('📊 Testing query...');
  const test = await db.query('SELECT * FROM user LIMIT 1');
  console.log('✅ Query successful:', JSON.stringify(test, null, 2));
  
  await db.close();
  process.exit(0);
} catch (error) {
  console.error('❌ Connection failed:', error);
  process.exit(1);
}