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
4.8 KB
Raw Blame
import fs from 'node:fs';
import path from 'node:path';
import assert from 'node:assert/strict';
import { Database } from '../packages/db/src/database.js';

async function verifyIsolation() {
  console.log('============================================================');
  console.log('🔍 VERIFYING PRODUCTION RESET AND DEVELOPMENT DATABASE ISOLATION');
  console.log('============================================================');

  // 1. Check Production Database
  const dbPath = path.resolve(process.cwd(), 'data/youpi_pg.sqlite');
  const prodDb = new Database({ dbPath });
  const prodMerchants = prodDb.queryOne('SELECT count(*) as c FROM merchants').c;
  const prodAccounts = prodDb.queryOne('SELECT count(*) as c FROM payment_receiving_accounts').c;
  const prodCustomers = prodDb.queryOne('SELECT count(*) as c FROM customers').c;
  const prodSessions = prodDb.queryOne('SELECT count(*) as c FROM payment_sessions').c;
  const prodObservations = prodDb.queryOne('SELECT count(*) as c FROM payment_observations').c;
  const prodTickets = prodDb.queryOne('SELECT count(*) as c FROM support_tickets').c;
  const prodMessages = prodDb.queryOne('SELECT count(*) as c FROM ticket_messages').c;
  const prodWebhooks = prodDb.queryOne('SELECT count(*) as c FROM webhook_deliveries').c;
  const prodAudit = prodDb.queryOne('SELECT count(*) as c FROM audit_logs').c;

  console.log('\n--- PRODUCTION DATABASE COUNTS ---');
  console.table({
    merchants: prodMerchants,
    receivingAccounts: prodAccounts,
    customers: prodCustomers,
    paymentSessions: prodSessions,
    observations: prodObservations,
    supportTickets: prodTickets,
    ticketMessages: prodMessages,
    webhookDeliveries: prodWebhooks,
    auditLogs: prodAudit
  });

  // Verify production acceptance criteria
  assert.ok(prodMerchants >= 1, 'Production merchant must be preserved');
  assert.ok(prodAccounts >= 1, 'Production receiving account must be preserved');

  const merchantRow = prodDb.queryOne('SELECT id, business_name, slug, webhook_url, branding FROM merchants');
  console.log('Preserved Merchant:', merchantRow);
  const accountRow = prodDb.queryOne('SELECT id, upi_id, payee_name, is_active, is_slot_busy, current_active_session_id FROM payment_receiving_accounts');
  console.log('Preserved Receiving Account:', accountRow);

  prodDb.close();

  // 2. Check Development Database (MUST BE UNTOUCHED)
  const devDbPath = process.env.DEV_DB_PATH || path.resolve(process.cwd(), 'data/youpi_pg_dev.sqlite');
  if (fs.existsSync(devDbPath)) {
    const devDb = new Database({ dbPath: devDbPath });
  const devMerchants = devDb.queryOne('SELECT count(*) as c FROM merchants').c;
  const devAccounts = devDb.queryOne('SELECT count(*) as c FROM payment_receiving_accounts').c;
  const devCustomers = devDb.queryOne('SELECT count(*) as c FROM customers').c;
  const devSessions = devDb.queryOne('SELECT count(*) as c FROM payment_sessions').c;
  const devObservations = devDb.queryOne('SELECT count(*) as c FROM payment_observations').c;
  const devTickets = devDb.queryOne('SELECT count(*) as c FROM support_tickets').c;
  const devMessages = devDb.queryOne('SELECT count(*) as c FROM ticket_messages').c;
  const devWebhooks = devDb.queryOne('SELECT count(*) as c FROM webhook_deliveries').c;
  const devAudit = devDb.queryOne('SELECT count(*) as c FROM audit_logs').c;

  console.log('\n--- DEVELOPMENT DATABASE COUNTS (MUST BE UNTOUCHED) ---');
  console.table({
    merchants: devMerchants,
    receivingAccounts: devAccounts,
    customers: devCustomers,
    paymentSessions: devSessions,
    observations: devObservations,
    supportTickets: devTickets,
    ticketMessages: devMessages,
    webhookDeliveries: devWebhooks,
    auditLogs: devAudit
  });

  // Verify development database is completely untouched
  assert.equal(devMerchants, 1, 'Development merchant count intact');
  assert.equal(devAccounts, 1, 'Development receiving account count intact');
  assert.equal(devCustomers, 2, 'Development customer count intact');
  assert.equal(devSessions, 25, 'Development payment sessions count intact');
  assert.equal(devObservations, 482659, 'Development observations count intact');
  assert.equal(devTickets, 2, 'Development tickets count intact');
  assert.equal(devMessages, 5, 'Development ticket messages count intact');
  assert.equal(devWebhooks, 22, 'Development webhooks count intact');
  assert.equal(devAudit, 533, 'Development audit logs count intact');

  devDb.close();
  } else {
    console.log('\n[i] Development database not present, skipping dev isolation count assertions.');
  }

  console.log('============================================================');
  console.log('🎉 DATABASE ISOLATION AND COUNTS VERIFIED 100%');
  console.log('============================================================');
}

verifyIsolation().catch(err => {
  console.error('ISOLATION VERIFICATION FAILED:', err);
  process.exit(1);
});