Files
root 9ebcc359ae Fix code quality violations and enhance ROUTE-EXISTS-01 rule
Implement JQHTML function cache ID system and fix bundle compilation
Implement underscore prefix for system tables
Fix JS syntax linter to support decorators and grant exception to Task system
SPA: Update planning docs and wishlists with remaining features
SPA: Document Navigation API abandonment and future enhancements
Implement SPA browser integration with History API (Phase 1)
Convert contacts view page to SPA action
Convert clients pages to SPA actions and document conversion procedure
SPA: Merge GET parameters and update documentation
Implement SPA route URL generation in JavaScript and PHP
Implement SPA bootstrap controller architecture
Add SPA routing manual page (rsx:man spa)
Add SPA routing documentation to CLAUDE.md
Phase 4 Complete: Client-side SPA routing implementation
Update get_routes() consumers for unified route structure
Complete SPA Phase 3: PHP-side route type detection and is_spa flag
Restore unified routes structure and Manifest_Query class
Refactor route indexing and add SPA infrastructure
Phase 3 Complete: SPA route registration in manifest
Implement SPA Phase 2: Extract router code and test decorators
Rename Jqhtml_Component to Component and complete SPA foundation setup

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
2025-11-19 17:48:15 +00:00
..

Database Connection Test

Tests basic database CRUD operations using the test database.

What it verifies

  • Database insert operations work
  • Database query operations work
  • Database update operations work
  • Database delete operations work
  • Data retrieval returns correct values

Prerequisites

  • rspade_test database exists
  • rspade user has access to rspade_test
  • Test environment helpers functional

How to run

./run_test.sh              # Full test with database reset
./run_test.sh --skip-reset # Skip database reset (faster)

What happens

  1. Creates temporary table
  2. Inserts test data
  3. Verifies data was inserted
  4. Queries specific data
  5. Updates data
  6. Verifies update worked
  7. Deletes data
  8. Verifies deletion worked
  9. Cleans up (temporary table auto-removed)

Expected output

[SETUP] Preparing database connection test...
[SETUP] Resetting test database...
[DB RESET] Dropping rspade_test database...
[DB RESET] Creating rspade_test database...
[DB RESET] Running migrations...
[DB RESET] Database reset complete
[TEST ENV] Entering test mode...
[TEST ENV] Test mode active (using rspade_test database)
[TEST] Testing database connection and operations...
[TEST] ✓ Insert operations work
[TEST] ✓ Query operations work
[TEST] ✓ Data retrieval works
[TEST] ✓ Update operations work
[TEST] ✓ Delete operations work
PASS: Database Connection
[TEST ENV] Exiting test mode...
[TEST ENV] Test mode exited (restored original database)