<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    public function run()
    {
        \DB::statement('PRAGMA foreign_keys = OFF;');

        // Supprimer les données existantes dans l'ordre inverse des dépendances
        \DB::table('gallery_members')->delete();
        \DB::table('artworks')->delete();
        \DB::table('galleries')->delete();
        \DB::table('users')->delete();

        // Réactiver les contraintes
        \DB::statement('PRAGMA foreign_keys = ON;');

        // Lancer nos seeders personnalisés
        $this->call([
            UserSeeder::class,
            GallerySeeder::class,
            ArtworkSeeder::class,
            GalleryMemberSeeder::class,
        ]);
    }
}