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>
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_testdatabase existsrspadeuser has access torspade_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
- Creates temporary table
- Inserts test data
- Verifies data was inserted
- Queries specific data
- Updates data
- Verifies update worked
- Deletes data
- Verifies deletion worked
- 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)