#!/usr/bin/env tsx
import { createClient } from '@supabase/supabase-js';
import dotenv from 'dotenv';
dotenv.config();
async function resetDatabase() {
const supabase = createClient(
process.env.SUPABASE_URL!,
process.env.SUPABASE_KEY!
);
console.log('๐๏ธ Resetting database tables...');
try {
// ๊ธฐ์กด ๋ฐ์ดํฐ ์ญ์ (ํ
์ด๋ธ ๊ตฌ์กฐ๋ ์ ์ง)
console.log('Clearing existing data...');
const { error: clearError } = await supabase
.from('magma_documents')
.delete()
.neq('id', 0); // ๋ชจ๋ ๋ ์ฝ๋ ์ญ์
if (clearError) {
console.log('Clear error (expected if table doesn\'t exist):', clearError);
}
const { error: clearAdvancedError } = await supabase
.from('magma_documents_advanced')
.delete()
.neq('id', 0); // ๋ชจ๋ ๋ ์ฝ๋ ์ญ์
if (clearAdvancedError) {
console.log('Clear advanced error (expected if table doesn\'t exist):', clearAdvancedError);
}
console.log('โ
Database cleared successfully!');
console.log('๐ Now run: npm run index-advanced');
} catch (error) {
console.error('โ Reset error:', error);
}
}
resetDatabase().catch(console.error);
