import Surreal from 'surrealdb';

const db = new Surreal();

async function checkUserRoles() {
  try {
    await db.connect(process.env.SURREAL_URL || "wss://gentle-island-06di2pv2c9po3a8euttd1alkek.aws-euw1.surreal.cloud/rpc");
    await db.signin({
      username: process.env.SURREAL_USER || "rootuser",
      password: process.env.SURREAL_PASS || "n1n@S1mone",
    });
    await db.use({
      namespace: process.env.SURREAL_NAMESPACE || "neoad",
      database: process.env.SURREAL_DATABASE || "neodb",
    });

    console.log("✅ Connecté à SurrealDB Cloud\n");

    const [users] = await db.query<[any[]]>(`
      SELECT id, email, role FROM user ORDER BY email ASC
    `);

    console.log("📋 Rôles actuels des utilisateurs:");
    console.log("─".repeat(60));
    for (const user of users || []) {
      console.log(`${user.email.padEnd(30)} → ${user.role}`);
    }
    console.log("─".repeat(60));

    await db.close();
  } catch (error) {
    console.error('❌ Erreur:', error);
    process.exit(1);
  }
}

checkUserRoles();