import Surreal from 'surrealdb';

const SURREAL_URL = process.env.SURREAL_URL || 'wss://gentle-island-06di2pv2c9po3a8euttd1alkek.aws-euw1.surreal.cloud';
const SURREAL_USER = process.env.SURREAL_USER || 'rootuser';
const SURREAL_PASS = process.env.SURREAL_PASS || 'n1n@S1mone';
const SURREAL_NAMESPACE = process.env.SURREAL_NAMESPACE || 'neoad';
const SURREAL_DATABASE = process.env.SURREAL_DATABASE || 'neodb';

const db = new Surreal();

async function main() {
  try {
    await db.connect(SURREAL_URL);
    await db.signin({ username: SURREAL_USER, password: SURREAL_PASS });
    await db.use({ namespace: SURREAL_NAMESPACE, database: SURREAL_DATABASE });
    
    const [campaigns] = await db.query<any[]>('SELECT id, name, start_date, end_date FROM campaign LIMIT 10');
    
    console.log('Campaigns with dates:');
    campaigns.forEach((c: any) => {
      console.log(`  - ${c.name}: ${c.start_date || 'NO DATE'} → ${c.end_date || 'NO DATE'}`);
    });
    
    // Check screens with unavailable_weeks
    const [screens] = await db.query<any[]>('SELECT id, name, unavailable_weeks FROM screen WHERE unavailable_weeks != NONE LIMIT 10');
    
    console.log('\nScreens with unavailable_weeks:');
    screens.forEach((s: any) => {
      console.log(`  - ${s.name}: weeks ${s.unavailable_weeks?.join(', ') || 'none'}`);
    });
    
    await db.close();
  } catch (e) {
    console.error('Error:', e);
    process.exit(1);
  }
}

main();