Function wipeDatabase

scripts/wipe-db.ts:44–79

()

}

async function wipeDatabase() {
  // Skip Azure Blob Storage wipe to save costs - images will be reused
  //await wipeAzureBlobs();

  console.log('🗑️  Wiping database (keeping Azure Blob Storage images)...');

  try {
    // Get all table names
    const tables = [
      'distro_sources',
      'packages',
      'apps',
      'sources',
      'distros',
      'categories',
      'verification',
      'account',
      'session',
      'user',
    ];

    // Delete all data from tables in reverse order (to respect foreign keys)
    for (const table of tables) {
      await db.run(sql.raw(`DELETE FROM ${table}`));
      console.log(`  ✓ Cleared ${table}`);
    }

    console.log('✅ Database wiped successfully!');
    console.log('💡 Run "bun run db:seed" to populate with initial data');
  } catch (error) {
    console.error('❌ Failed to wipe database:', error);
    process.exit(1);
  }

  process.exit(0);
}

wipeDatabase();