https://developer.android.com/training/testing/instrumented-tests/androidx-test-libraries/runner#use-android

…word

This test would occasionally fail because the invalidation tracker runs
on a background thread and might trigger after the insert but during the
reconfigure method run after we change the password to rebuild the
connection pool. The primary connection will be closed temporarily and
this can impact the invalidation tracker when it tries to get a connection
from the connection pool. We just wait for the invalidation tracker to
complete before proceeding with our change password operation.

https://developer.android.com/reference/androidx/room/InvalidationTracker#addObserver(androidx.room.InvalidationTracker.Observer)

- Report success in onMove to allow ignored tests to pass. The call to
cursorFillWindow would call moveToPosition, but would never report a successful
move which prevented the tests from passing.
- Also requiring adding some guards to the getString implementation for invalid
values.

…ement for Room3

- Verify Room 3 integration with SQLCipherDriver, including entity
insert and query round-trip.
- Additional testing with both insertOrReplace and Upset behavior.
- Verify PRAGMA cipher_version reports expected SQLCipher version.
- Cover statementPrefix() extraction: plain statements, leading whitespace,
line/block comments, comment-only and empty input.
- Cover isJournalModeSet() dispatch: intercepts journal_mode assignments
(case-insensitive, schema-qualified), ignores journal_mode queries to
handle connection pool reconfiguration.