import Surreal from 'surrealdb';
import dotenv from 'dotenv';
dotenv.config();

const db = new Surreal();

(async () => {
  try {
    await db.connect(process.env.SURREAL_URL!, {
      namespace: process.env.SURREAL_NAMESPACE!,
      database: process.env.SURREAL_DATABASE!,
      auth: {
        username: process.env.SURREAL_USER!,
        password: process.env.SURREAL_PASS!
      }
    });
    
    const [campaigns] = await db.query<any[]>('SELECT id, name, targeting_mode, selected_country, selected_region, selected_department FROM campaign LIMIT 5');
    console.log('Campaigns:');
    campaigns?.forEach((c: any) => {
      console.log(`- ${c.name}:`);
      console.log(`  targeting_mode: ${c.targeting_mode}`);
      console.log(`  selected_country: ${c.selected_country}`);
      console.log(`  selected_region: ${c.selected_region}`);
      console.log(`  selected_department: ${c.selected_department}`);
    });
    
    await db.close();
  } catch (e) {
    console.error('Error:', e);
  }
})();