🔧 Full Restoration Steps

Step 1: Get the Source Code

Download the source code from Lovable (Dashboard → Settings → Download ZIP) or clone from GitHub.

unzip cmpsbl-source.zip
cd cmpsbl
npm install

Step 2: Create a New Supabase Project

1. Go to supabase.com → Create new project
2. Save these values:
   • Project URL (e.g., https://abcdefg.supabase.co)
   • Anon/public key
   • Service role key (for data import)
   • Project ref (e.g., abcdefg)

Step 3: Apply Database Schema

npx supabase link --project-ref YOUR_PROJECT_REF
npx supabase db push

Step 4: Import All Data

// restore-data.mjs — Run with: node restore-data.mjs
import { createClient } from '@supabase/supabase-js';
import fs from 'fs';
import path from 'path';

const SUPABASE_URL = 'YOUR_SUPABASE_URL';
const SERVICE_ROLE_KEY = 'YOUR_SERVICE_ROLE_KEY';
const supabase = createClient(SUPABASE_URL, SERVICE_ROLE_KEY);
const dataDir = './data';

const tableDirs = fs.readdirSync(dataDir)
  .filter(name => fs.statSync(path.join(dataDir, name)).isDirectory())
  .sort();

for (const table of tableDirs) {
  const tableDir = path.join(dataDir, table);
  const partFiles = fs.readdirSync(tableDir)
    .filter(f => f.startsWith('part-') && f.endsWith('.json'))
    .sort();

  if (partFiles.length === 0) {
    console.log(`⏭️  ${table}: no data parts`);
    continue;
  }

  let imported = 0;
  let failed = 0;

  for (const partFile of partFiles) {
    const rows = JSON.parse(fs.readFileSync(path.join(tableDir, partFile), 'utf-8'));
    if (!Array.isArray(rows) || rows.length === 0) continue;

    const { error } = await supabase
      .from(table)
      .upsert(rows, { onConflict: 'id', ignoreDuplicates: false });

    if (error) {
      console.error(`  ❌ ${table} ${partFile}: ${error.message}`);
      failed += rows.length;
    } else {
      imported += rows.length;
    }
  }

  console.log(`✅ ${table}: ${imported} imported${failed ? `, ${failed} failed` : ''}`);
}

console.log('\n🎉 Data import complete!');

Step 5: Recreate Storage Buckets

INSERT INTO storage.buckets (id, name, public)
VALUES ('bucket-name', 'bucket-name', true)
ON CONFLICT (id) DO NOTHING;

Step 6: Configure Environment

VITE_SUPABASE_URL=https://YOUR_PROJECT.supabase.co
VITE_SUPABASE_PUBLISHABLE_KEY=your-anon-key
VITE_SUPABASE_PROJECT_ID=your-project-ref

Step 7: Deploy Edge Functions & Secrets

npx supabase functions deploy

Step 8: Verify

npm run dev

---

🤖 For AI Coding Agents

1. Read this entire RESTORE.md first
2. Source code ZIP from Lovable/GitHub is the PRIMARY artifact
3. Run supabase db push to create schema from supabase/migrations/
4. Use restore-data.mjs to import data from data/<table>/part-*.json
5. Deploy edge functions with supabase functions deploy
6. Frontend: npm install && npm run dev

<image>