Repository navigation
Tags
Tags
Refactor/pdo (#787) * Introduce opt-in PDO connection foundation (UNIT-001) * refactor(accounting): migrate open-session maintenance to PDO * refactor(exports): migrate operator CSV queries to PDO * fix(exports): align batch detail search with CSV rows * refactor(user-reports): migrate portal CSV exports to PDO * refactor(billing): create invoices and items atomically with PDO * refactor(billing): edit invoices and replace items atomically * refactor(billing): delete invoices and dependents atomically * refactor(billing): create plans and profiles atomically * refactor(billing): edit plans and profiles atomically * refactor(billing): delete plans and profiles atomically * refactor(billing): provision POS users and invoices atomically * refactor(billing): update POS users and profiles atomically * refactor(billing): delete POS users and dependents atomically * refactor(batch): create generated users atomically with PDO * refactor(batch): delete batches and dependents atomically * refactor(backup): export consistent PDO snapshots atomically * refactor(backup): restore validated SQL atomically with PDO * refactor(user): edit attributes and account atomically with PDO * refactor(user): remove accounts and attributes atomically with PDO * refactor(profile): remove attributes and mappings atomically with PDO * refactor(profile): duplicate check and reply attributes atomically with PDO * refactor(dictionary): import vendor attributes atomically with PDO * refactor(attributes): add caller-owned PDO mutation provider * refactor(users): migrate AJAX actions and refill billing to PDO * refactor(operators): create identities and ACLs atomically with PDO * refactor(operators): edit identities MFA and ACLs atomically with PDO * refactor(operators): delete operators and ACLs atomically with PDO * refactor(auth): migrate operator primary login to PDO * refactor(auth): consume operator OTP state with PDO * refactor(portal): migrate user login to PDO * refactor(portal): migrate password change to PDO * refactor(portal): migrate RADIUS password change to PDO * refactor(nas): migrate JSON import to PDO * refactor(nas): migrate CRUD lock family to PDO * feat(database): migrate group attributes to PDO (UNIT-036) * refactor(database): migrate realm and proxy workflows to PDO (UNIT-035) * fix(database): preserve group edit semantics and require InnoDB (UNIT-036) * refactor(database): add caller-owned PDO group mapping provider (UNIT-037) * refactor(database): consolidate Chilli connection helpers (UNIT-038) * refactor(database): migrate Chilli free signup atomically to PDO (UNIT-039) * refactor(database): migrate verified Chilli PayPal callbacks to PDO (UNIT-040) * fix(chilli)!: retire legacy 2Checkout signup callbacks (UNIT-041) BREAKING CHANGE: Portal2 legacy 2Checkout signup, checkout and callbacks return HTTP 410. Existing accounts and payment records are preserved. The incomplete MD5 verifier and dependent PEAR mutations are retired rather than migrated. * fix(maintenance): retire unsafe expired-account cleanup * refactor(maintenance): migrate stale-session repair to PDO * refactor(database): migrate portal password hashing CLI to PDO * refactor(database): migrate read-only monitors to PDO * refactor(database): migrate residual operator ACL reads to PDO * refactor(database): migrate operator MFA configuration to PDO * refactor(db): migrate operator message editor to PDO * refactor(db): migrate operator catalog reads to PDO * refactor(db): migrate shared operator selectors to PDO * refactor(db): add PDO dispatch for shared operator reads * refactor(db): migrate operator sidebars and realm proxy catalogs to PDO * refactor(db): migrate standard user creation to PDO * refactor(db): migrate quick user creation to PDO * refactor(db): migrate user imports to atomic PDO batches * refactor(db): migrate user AJAX and residual edit reads to PDO * refactor(db): migrate profile creation and editing to PDO * refactor(db): make group attribute deletion atomic on PDO * refactor(db): migrate residual groupcheck reads to PDO * refactor(db): finish residual groupreply and profile reads on PDO * refactor(db): migrate user-group creation and complete PDO dispatch * refactor(db): migrate user-group edits to atomic PDO operations * refactor(db): migrate complete user-group deletion to PDO * refactor(db): migrate mapping lists and harden shared group widgets * refactor(db): migrate dictionary creation and metadata edits to PDO * refactor(db): delete complete dictionary selections atomically * refactor(db): migrate dictionary lists and search to PDO * refactor(db): migrate attribute metadata JSON and validate R06 * refactor(db): migrate residual IP pool create and edit (R07a) * refactor(db): migrate residual IP pool deletion and list (R07b) * refactor(db): migrate residual huntgroup create and edit (R08a) * refactor(db): migrate residual huntgroup deletion and list (R08b) * refactor(db): migrate residual hotspot creation and editing to PDO * refactor(db): migrate hotspot batch deletion and listing to PDO * refactor(db): migrate hotspot information and chart reads to PDO * refactor(db): migrate GIS reads and mutations to PDO * refactor(db): migrate heartbeat telemetry to verified PDO writes * refactor(db): migrate standard accounting totals and date reports to PDO * refactor(db): migrate IP NAS and username accounting reports to PDO * refactor(db): migrate hotspot accounting reports and verify standard report parity * refactor(db): migrate scoped accounting purge to PDO (R12b) * refactor(db): migrate accounting plan usage and validate R12 (R12c) * refactor(db): migrate operator user lists to PDO (R13a) * refactor(db): migrate batch reports and summary reads to PDO (R13b) * refactor(db): migrate connection reports to PDO (R13c) * refactor(db): migrate history dashboard reads and validate R13 (R13d) * refactor(db): add borrowed PDO chart reads and migrate data endpoints (R14a) * refactor(db): migrate user login widgets and statistics to PDO (R14b) * refactor(db): migrate traffic statistics and preserve raw chart links (R14c) * refactor(db): migrate dashboard online widgets and validate R14 (R14d) * refactor(db): migrate invoice lists and report reads to PDO (R15a) * refactor(db): migrate invoice creation and edit form reads (R15b) * refactor(db): migrate invoice delete selector and validate R15 (R15c) * refactor(db): migrate residual billing plan reads to PDO (R16a) * refactor(db): migrate POS lists and edit form reads (R16b) * refactor(db): migrate batch selectors and validate R16 (R16c) * refactor(db): migrate payment creation to PDO (R17a) * refactor(db): migrate payment editing to PDO (R17b) * refactor(db): migrate payment deletion and lists (R17c) * refactor(db): migrate payment type creation and editing (R18a) * refactor(db): migrate payment type deletion and lists (R18b) * refactor(db): migrate rate creation and editing (R19a) * refactor(db): migrate rate deletion and lists (R19b) * refactor(db): migrate dated rates and billing history (R19c) * refactor(db): migrate merchant transaction reads (R19d) * refactor(db): migrate notification contexts and ACL (R20a) * refactor(db): migrate shared billing and invoice helpers (R20b) * refactor(db): migrate user report summaries (R20c) * refactor(db): migrate printable ticket reads (R20d) * refactor(portal): migrate user information preferences to PDO * refactor(portal): migrate invoice pages and downloads to PDO * refactor(portal): migrate accounting report reads to PDO * refactor(portal): migrate message pages and validate R21 * refactor(portal): migrate subscription and session widgets to PDO * refactor(portal): migrate login statistics tables to PDO * refactor(portal): migrate traffic tables and charts and validate R22 * refactor(db): migrate Portal1 PayPal pending signup to PDO (R23a) * refactor(db): migrate Portal1 PayPal receipt and validate R23b * refactor(db): migrate Portal2 PayPal pending signup and resume (R24a) * refactor(db): migrate Portal2 payment receipt and validate R24b * refactor(db): migrate Portal3 PayPal pending signup (R25a) * refactor(db): migrate Portal3 payment receipt and validate R25b * refactor(db): retire historical 2Checkout public receipt (R26a) * refactor(db): remove dead 2Checkout signup and validate R26b * refactor(db): migrate NAS list and JSON export to PDO (R27a) * refactor(db): migrate maintenance NAS and user reads to PDO (R27b) * refactor(db): remove unused selector and Chilli helper copies (R28a) * refactor(db): close obsolete helper dispatch and validate R28 (R28b) * refactor(db): make retained Chilli connections PDO-only * docs(db): record Chilli PDO boundary validation * refactor(db): remove non-Chilli PEAR DB compatibility * fix(db): restore nonempty user accounting JSON formatting * refactor(install): remove PEAR DB dependencies and require PDO * test(pdo): remove obsolete historical comparison suites Keep the shared HTML parser as a standalone fixture helper so retained billing tests remain runnable. * docs(pdo): remove internal database migration reports Preserve required audit manifests under tests/fixtures and update their consumers.