Verify NitroSQLite iOS database directory in native CI #103804

Problem

On iOS, NitroSQLite reads the RNNitroSQLite_DatabaseLocation plist key to store the Onyx database in Library/Application Support. If a dependency upgrade changes how its native code reads that key, NitroSQLite silently falls back to Documents. With file sharing enabled, Documents is visible in the Files app, so the Onyx database files become visible, shareable, and deletable by users.

The current CI checks only assert that the plist contains the key and value. They would still pass after such an upgrade, even though the native code no longer honors the setting. A regression like this was reported in iOS- Onyx files appears in Files and Unable to view attachment after upgrade.

Solution

Add a native regression check to the existing macOS verification job, renamed Verify iOS native configuration:

• Compile the installed NitroSQLite package's unchanged ios/OnLoad.mm.
• Run its iOS directory-selection branch with the host plist in a temporary bundle.
• Assert that the selected directory is Application Support, and report the actual selection on failure.
• Run the job on dependency and iOS changes, and also when the native test, the workflow, or NitroSQLite patches change.

Original proposal: https://github.com/Expensify/Mobile-Expensify/pull/14129#discussion_r4160094962

Related

• PR: [No QA] test(ios): Verify NitroSQLite database directory in native CI
• chore(deps): Update NitroSQLite from 9.6.0 to 9.8.0
• chore(deps): Upgrade NitroSQLite from 9.8.3 to 10.2.0