cleanup-storage.ts

import { supabase } from '../src/services/supabase';

async function cleanupStorage() {
  console.log('Cleaning up storage...');
  // Remove all files from storage
  const { data: files, error: listError } = await supabase
    .storage
    .from('templates')
    .list();

  if (listError) {
    console.error('Error listing files:', listError);
    return;
  }

  if (files && files.length > 0) {
    const { error: removeError } = await supabase
      .storage
      .from('templates')
      .remove(files.map(file => file.name));

    if (removeError) {
      console.error('Error removing files:', removeError);
      return;
    }
  }

  console.log('Storage cleaned');

  console.log('Cleaning up database...');
  // Delete all template records from the database
  const { error: dbError } = await supabase
    .from('templates')
    .delete()
    .neq('id', '00000000-0000-0000-0000-000000000000'); // Delete all records

  if (dbError) {
    console.error('Error cleaning database:', dbError);
    return;
  }

  console.log('Database cleaned');
  console.log('Cleanup complete! Ready for reseeding.');
}

cleanupStorage().catch(console.error);