reset-database.tsβ’1.22 kB
#!/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);