Integration Test Specifications

UID: DOC-IT

Type	Level	MID	UID	REFS	Title	Result	Statement	Rationale	Comment
REQUIREMENT	1		IT-001	Parents: ARCH-001 Local persistence subsystem	IT-001 reviewed First-launch DB initialisation	Passed	Instantiate AppDatabase against a temporary filesystem path at which no database file exists. Trigger the initialisation pathway by performing any query that forces Drift's onCreate migration to run. Inspect the resulting state of the database on disk and of the seeded tables.
REQUIREMENT	2		IT-002	Parents: ARCH-002 Local database encryption	IT-002 unreviewed Database file is encrypted at rest	Passed	Initialise an AppDatabase against a temporary filesystem path through the production openEncryptedConnection pathway with a known test key. Write a canonical row through the typed clinic API and close the database. Attempt to open the resulting file with the plain sqlite3 driver (no credential supplied) and read any user table. Attempt to open the same file through the production pathway with an incorrect key and read any user table. Then re-open the file through the production pathway with the correct key and read the canonical row.