akvo / agriconnect / #80

91%

push

github

[#21] APP: fix(database): resolve SQLite NullPointerException by implementing single connection architecture

- Root cause: Multiple concurrent database connections causing race conditions
- Created database context hook (useDatabase) to access SQLiteProvider instance
- Refactored DAOManager to accept database instance instead of creating new connections
- Updated AuthContext to use database from context with useMemo
- Modified all utility functions to accept database parameter
- Updated migrateDbIfNeeded to use provided database instance
- Removed all direct openDatabaseSync() calls throughout the app
- Updated DAO and database documentation with best practices

The app now uses a single database connection managed by SQLiteProvider,
preventing java.lang.NullPointerException errors during database operations.

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

Co-Authored-By: Claude <noreply@anthropic.com>

259 of 378 branches covered (68.52%)

Branch coverage included in aggregate %.

1574 of 1896 relevant lines covered (83.02%)

0.83 hits per line