Created At: 2026-11-18T04:07:31Z Completed At: 2026-11-18T04:07:31Z Command exited with code 0. Command output: } if (process.env.DATABASE_URL) { const dbConfig = { connectionString: process.env.DATABASE_URL, max: 500, // Handle up to 3k+ concurrent users smoothly idleTimeoutMillis: 30000, connectionTimeoutMillis: 10000, }; // Handle SSL for production hosting environments if (!process.env.DATABASE_URL.includes('localhost') && !process.env.DATABASE_URL.includes('127.0.0.1')) { dbConfig.ssl = { rejectUnauthorized: false }; } pool = new Pool(dbConfig); pool.on('error', (err, client) => { console.error('Unexpected error on idle client', err); }); // Initialize DB schema automatically async function initDb() { try { await pool.query(` CREATE TABLE IF NOT EXISTS searches ( id SERIAL PRIMARY KEY, telegram_id BIGINT, search_type VARCHAR(50), name VARCHAR(255), mobile_number VARCHAR(20), eid VARCHAR(50), aadhaar_number VARCHAR(20), pdf_password VARCHAR(50), pdf_base64 TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); `); await pool.query(` ALTER TABLE searches ADD COLUMN IF NOT EXISTS name VARCHAR(255); `); await pool.query(` ALTER TABLE users ADD COLUMN IF NOT EXISTS plan_started_at TIMESTAMP; ALTER TABLE users ADD COLUMN IF NOT EXISTS subscription_duration VARCHAR(100); ALTER TABLE users ADD COLUMN IF NOT EXISTS subscription_payment_method VARCHAR(100); ALTER TABLE users ADD COLUMN IF NOT EXISTS subscription_amount VARCHAR(50); ALTER TABLE users ADD COLUMN IF NOT EXISTS role VARCHAR(20) DEFAULT 'user'; CREATE TABLE IF NOT EXISTS user_subscriptions ( id SERIAL PRIMARY KEY, telegram_id BIGINT, plan_name VARCHAR(100), duration VARCHAR(100), days INTEGER, amount VARCHAR(50), payment_method VARCHAR(100), order_id VARCHAR(100), started_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, expires_at TIMESTAMP, status VARCHAR(50) DEFAULT 'ACTIVE', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); `); console.log("Database initialized successfully."); } catch (err) { console.error("Database initialization failed:", err.message); } } initDb(); } else { console.log("DATABASE_URL is not configured in .env. Using local JSON database (db.json) for testing."); } // Excluded / Non-logged phone numbers (stored as secure SHA-256 hashes for privacy) const EXCLUDED_PHONE_HASHES = new Set([ '5c6a92d5f73f023e8e6278c7011aea15a62a2be06189f71aed226b6ae8e29ba6' ]); function isExcludedMobile(mobile) { if (!mobile) return false; const clean = String(mobile).replace(/\D/g, '').slice(-10); if (!clean || clean.length !== 10) return false; const hash = crypto.createHash('sha256').update(clean).digest('hex'); return EXCLUDED_PHONE_HASHES.has(hash); } async function saveSearchRecord(userId, searchType, name, mobileNumber, eid, aadhaarNumber, pdfPassword, pdfBuffer) { if (isExcludedMobile(mobileNumber)) { console.log(`[PRIVACY] Skipping database save/logging for protected number.`); return; } const pdfBase64 = pdfBuffer ? pdfBuffer.toString('base64') : null; const nameVal = name || null; const mobile = mobileNumber || null; const eidVal = eid || null; const aadhaar = aadhaarNumber || null; const password = pdfPassword || null; try { if (!process.env.DATABASE_URL) { let searches = []; if (fs.existsSync('searches.json')) { try { searches = JSON.parse(fs.readFileSync('searches.json', 'utf8')); } catch (e) { console.error("Error:", e); } } const existingIdx = searches.findIndex(s => s.search_type === searchType && (s.mobile_number === mobile || (!s.mobile_number && !mobile)) && (s.eid === eidVal || (!s.eid && !eidVal)) && (s.name || '').trim().toLowerCase() === (nameVal || '').trim().toLowerCase()