import { Surreal } from 'surrealdb';

const locationTypesTranslations = [
	{ name: 'mall', label: 'Centre commercial' },
	{ name: 'store', label: 'Magasin' },
	{ name: 'restaurant', label: 'Restaurant' },
	{ name: 'cafe', label: 'Café' },
	{ name: 'hotel', label: 'Hôtel' },
	{ name: 'airport', label: 'Aéroport' },
	{ name: 'station', label: 'Gare' },
	{ name: 'hospital', label: 'Hôpital' },
	{ name: 'gym', label: 'Salle de sport' },
	{ name: 'office', label: 'Bureau' },
	{ name: 'outdoor', label: 'Extérieur' },
	{ name: 'event', label: 'Événementiel' },
	{ name: 'other', label: 'Autre' }
];

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!');
	console.log('\n📝 Updating location types labels to French...\n');
	
	for (const locationType of locationTypesTranslations) {
		console.log(`   Updating: ${locationType.name} → ${locationType.label}`);
		await db.query(
			`UPDATE location_type SET label = $label WHERE name = $name`,
			{ name: locationType.name, label: locationType.label }
		);
	}
	
	console.log('\n✅ All location types updated!');
	
	// Vérifier
	const result = await db.query('SELECT * FROM location_type ORDER BY label');
	console.log(`\n📊 Updated location types:\n`);
	for (const lt of result[0]) {
		console.log(`   - ${lt.name}: ${lt.label}`);
	}
	
	await db.close();
	process.exit(0);
} catch (error) {
	console.error('❌ Error:', error);
	process.exit(1);
}