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
import { test } from 'node:test';
import assert from 'node:assert/strict';
import fs from 'node:fs';
import path from 'node:path';
import { Database, runMigrations } from '../index.js';
test('Production & Development Database Safe Customer Reset and Zero Residue Invariant', () => {
// 1. PROD RESET & VERIFICATION
const prodPath = path.resolve('data/youpi_pg.sqlite');
if (!fs.existsSync(prodPath)) {
const parentDir = path.dirname(prodPath);
if (!fs.existsSync(parentDir)) {
fs.mkdirSync(parentDir, { recursive: true });
}
const initDb = new Database({ dbPath: prodPath });
runMigrations(initDb);
initDb.close();
}
assert.ok(fs.existsSync(prodPath), `Production DB must exist at ${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`);
fs.copyFileSync(prodPath, prodBackupPath);
assert.ok(fs.existsSync(prodBackupPath), 'Production backup must be created');
const prodDb = new Database({ dbPath: prodPath });
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 customer count must strictly equal 0');
assert.equal(prodCustomerSessions, 0, 'Production customer session count must strictly equal 0');
assert.equal(prodMerchantsAfter, prodMerchantsBefore, 'Production merchants must remain 100% intact');
assert.equal(prodAccountsAfter, prodAccountsBefore, 'Production receiving accounts must remain 100% intact');
prodDb.close();
// 2. DEV RESET & VERIFICATION
const devPath = process.env.DEV_DB_PATH || path.resolve('data/youpi_pg_dev.sqlite');
if (fs.existsSync(devPath)) {
const devBackupDir = path.resolve('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);
assert.ok(fs.existsSync(devBackupPath), 'Dev backup must be created');
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 customer count must strictly equal 0');
assert.equal(devCustomerSessions, 0, 'Dev customer session count must strictly equal 0');
assert.equal(devMerchantsAfter, devMerchantsBefore, 'Dev merchants must remain 100% intact');
assert.equal(devAccountsAfter, devAccountsBefore, 'Dev receiving accounts must remain 100% intact');
assert.equal(devObsAfter, devObsBefore, 'Dev observations must remain 100% intact');
devDb.close();
}
});