Skip to content

A self-hosted UPI & COD payment gateway with zero per-transaction platform fees, universal JavaScript checkout integration, dynamic QR payments, WhatsApp OTP authentication, and automated payment verification.

JavaScript
6.1 KB
Raw Blame
import fs from 'node:fs';
import path from 'node:path';
import assert from 'node:assert/strict';
import { Database, runMigrations } from '../packages/db/src/index.js';

async function executeCleanReset() {
  console.log('============================================================');
  console.log('🛡️ EXECUTING ZERO-CUSTOMER CLEAN RESET ON DEV AND PROD');
  console.log('============================================================');

  const isConfirmed = process.argv.includes('--confirm-clean-customer-reset') || process.env.ALLOW_CUSTOMER_RESET === 'true';
  if (!isConfirmed) {
    console.error('\n❌ [SAFETY ABORT] Clean customer database reset requires explicit confirmation.');
    console.error('To proceed, re-run with `--confirm-clean-customer-reset` or set `ALLOW_CUSTOMER_RESET=true`.\n');
    process.exit(1);
  }

  // --- 1. PRODUCTION RESET ---
  const prodPath = path.resolve('data/youpi_pg.sqlite');
  console.log('\n[1] Processing Production Database:', prodPath);

  const prodBackupDir = path.resolve('data/backups');
  if (!fs.existsSync(prodBackupDir)) {
    fs.mkdirSync(prodBackupDir, { recursive: true });
  }
  const prodBackupPath = path.join(prodBackupDir, `prod_pre_auth_reset_${Date.now()}.sqlite`);
  const prodDb = new Database({ dbPath: prodPath });

  try {
    prodDb.execute('VACUUM INTO ?', [prodBackupPath]);
    console.log('  [✓] Created WAL-consistent atomic production backup at:', prodBackupPath);
  } catch (err) {
    console.warn('  [!] VACUUM INTO failed, falling back to copyFileSync:', err.message);
    if (fs.existsSync(prodPath)) {
      fs.copyFileSync(prodPath, prodBackupPath);
    }
  }
  const prodMerchantsBefore = prodDb.query('SELECT count(*) as c FROM merchants')[0].c;
  const prodAccountsBefore = prodDb.query('SELECT count(*) as c FROM payment_receiving_accounts')[0].c;

  try { prodDb.execute('UPDATE payment_sessions SET customer_id = NULL WHERE customer_id IS NOT NULL;'); } catch {}
  try { prodDb.execute('DELETE FROM ticket_messages;'); } catch {}
  try { prodDb.execute('DELETE FROM support_tickets;'); } catch {}
  try { prodDb.execute('DROP TABLE IF EXISTS customer_sessions;'); } catch {}
  try { prodDb.execute('DROP TABLE IF EXISTS customers;'); } catch {}

  runMigrations(prodDb);

  prodDb.execute('DELETE FROM customer_sessions;');
  prodDb.execute('DELETE FROM customers;');

  const prodCustomers = prodDb.query('SELECT count(*) as c FROM customers')[0].c;
  const prodCustomerSessions = prodDb.query('SELECT count(*) as c FROM customer_sessions')[0].c;
  const prodMerchantsAfter = prodDb.query('SELECT count(*) as c FROM merchants')[0].c;
  const prodAccountsAfter = prodDb.query('SELECT count(*) as c FROM payment_receiving_accounts')[0].c;

  assert.equal(prodCustomers, 0, 'Production customers must be 0');
  assert.equal(prodCustomerSessions, 0, 'Production customer sessions must be 0');
  assert.equal(prodMerchantsAfter, prodMerchantsBefore, 'Production merchants must remain intact');
  assert.equal(prodAccountsAfter, prodAccountsBefore, 'Production receiving accounts must remain intact');

  const prodAccount = prodDb.query('SELECT upi_id, payee_name, is_active FROM payment_receiving_accounts WHERE is_active = 1')[0];
  console.log(`  [✓] Production verified: Customers=0, Sessions=0, Merchants=${prodMerchantsAfter}, Active VPA=${prodAccount.upi_id}`);
  prodDb.close();

  // --- 2. DEVELOPMENT RESET ---
  const devPath = process.env.DEV_DB_PATH || path.resolve(process.cwd(), 'data/youpi_pg_dev.sqlite');
  console.log('\n[2] Processing Development Database:', devPath);

  if (fs.existsSync(devPath)) {
    const devBackupDir = path.resolve(process.cwd(), 'data/backups');
    if (!fs.existsSync(devBackupDir)) {
      fs.mkdirSync(devBackupDir, { recursive: true });
    }
    const devBackupPath = path.join(devBackupDir, `dev_pre_auth_reset_${Date.now()}.sqlite`);
    fs.copyFileSync(devPath, devBackupPath);
    console.log('  [✓] Created dev backup at:', devBackupPath);

    const devDb = new Database({ dbPath: devPath });
  const devMerchantsBefore = devDb.query('SELECT count(*) as c FROM merchants')[0].c;
  const devAccountsBefore = devDb.query('SELECT count(*) as c FROM payment_receiving_accounts')[0].c;
  const devObsBefore = devDb.query('SELECT count(*) as c FROM payment_observations')[0].c;

  try { devDb.execute('UPDATE payment_sessions SET customer_id = NULL WHERE customer_id IS NOT NULL;'); } catch {}
  try { devDb.execute('DELETE FROM ticket_messages;'); } catch {}
  try { devDb.execute('DELETE FROM support_tickets;'); } catch {}
  try { devDb.execute('DROP TABLE IF EXISTS customer_sessions;'); } catch {}
  try { devDb.execute('DROP TABLE IF EXISTS customers;'); } catch {}

  runMigrations(devDb);

  devDb.execute('DELETE FROM customer_sessions;');
  devDb.execute('DELETE FROM customers;');

  const devCustomers = devDb.query('SELECT count(*) as c FROM customers')[0].c;
  const devCustomerSessions = devDb.query('SELECT count(*) as c FROM customer_sessions')[0].c;
  const devMerchantsAfter = devDb.query('SELECT count(*) as c FROM merchants')[0].c;
  const devAccountsAfter = devDb.query('SELECT count(*) as c FROM payment_receiving_accounts')[0].c;
  const devObsAfter = devDb.query('SELECT count(*) as c FROM payment_observations')[0].c;

  assert.equal(devCustomers, 0, 'Dev customers must be 0');
  assert.equal(devCustomerSessions, 0, 'Dev customer sessions must be 0');
  assert.equal(devMerchantsAfter, devMerchantsBefore, 'Dev merchants must remain intact');
  assert.equal(devAccountsAfter, devAccountsBefore, 'Dev receiving accounts must remain intact');
  assert.equal(devObsAfter, devObsBefore, 'Dev observations must remain 100% intact');

  console.log(`  [✓] Dev verified: Customers=0, Sessions=0, Merchants=${devMerchantsAfter}, Observations=${devObsAfter}`);
    devDb.close();
  } else {
    console.log('  [i] Development database not present, skipping dev reset.');
  }

  console.log('\n============================================================');
  console.log('🎉 BOTH DEV & PROD FINISHED CLEANLY WITH CUSTOMER COUNT = 0');
  console.log('============================================================');
}

executeCleanReset().catch(err => {
  console.error('Reset failed:', err);
  process.exit(1);
});