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');
	
	await db.signin({ 
		username: 'rootuser', 
		password: 'n1n@S1mone' 
	});
	
	await db.use({ 
		namespace: 'neoad', 
		database: 'neodb' 
	});
	
	console.log('✅ Connected!\n');
	console.log('🗑️  Deleting location_type table...');
	
	// Supprimer tous les enregistrements
	await db.query('DELETE location_type');
	
	// Supprimer la définition de la table
	await db.query('REMOVE TABLE location_type');
	
	console.log('✅ location_type table deleted!\n');
	
	await db.close();
	process.exit(0);
} catch (error) {
	console.error('❌ Error:', error);
	process.exit(1);
}