| # | Test | Result | Detail |
|---|---|---|---|
| 1 | getInstance() returns PDO | ✓ PASS | PDO |
| 2 | Singleton — same PDO instance | ✓ PASS | |
| 3 | testConnection() success | ✓ PASS | Database connection successful |
| 4 | testConnection() database | ✓ PASS | chaincoz_360UAT |
| 5 | query() SELECT 1 | ✓ PASS | {"num":1} |
| 6 | query() with params | ✓ PASS | {"val":"chain360"} |
| 7 | inTransaction() false before begin | ✓ PASS | |
| 8 | inTransaction() true after begin | ✓ PASS | |
| 9 | inTransaction() false after commit | ✓ PASS | |
| 10 | rollBack() — capital B, no error | ✓ PASS | |
| 11 | lastInsertId() callable | ✓ PASS | returned: '0' |
| 12 | getStats() — no error key | ✓ PASS | |
| 13 | getStats() — has tables key | ✓ PASS | {"database":"chaincoz_360UAT","tables":{"users":115,"assets":120,"workflows":25,"workflow_instances":39,"asset_allocations":106}} |
| 14 | getStats() — users count | ✓ PASS | users=115 |
| 15 | getStats() — no employees key | ✓ PASS | employees table should not be queried |
| 16 | __wakeup() throws Exception | ✓ PASS |
⚠️ Delete test_database.php before deploying to production.