Function cbm_store_open_path_query

src/store/store.c:837–923

}

cbm_store_t *cbm_store_open_path_query(const char *db_path) {
    if (!db_path) {
        return NULL;
    }

    cbm_store_t *s = calloc(CBM_ALLOC_ONE, sizeof(cbm_store_t));
    if (!s) {
        return NULL;
    }

    /* Query tools open the project DB READ-ONLY: a read query must never
     * mutate the DB (the previous READWRITE open + WAL write-pragmas did),
     * and must work on a read-only DB file / filesystem.
     *
     * Try a plain READONLY open first — on a normal writable filesystem this
     * reads WAL frames correctly via the -shm wal-index. SQLite opens lazily,
     * so a read-only-filesystem failure (cannot create -shm for a WAL-mode
     * DB) surfaces on first access, not at open time; we probe with a trivial
     * read to force it. If the probe fails, retry once with an immutable URI
     * that bypasses WAL and reads the main DB file directly.
     *
     * No SQLITE_OPEN_CREATE on either path — a missing DB must return NULL
     * (no ghost .db for unknown/unindexed projects). */
    char open_path[4096];
    if (!cbm_path_for_file_api(db_path, open_path, sizeof(open_path))) {
        free(s);
        return NULL;
    }
    int rc = sqlite3_open_v2(open_path, &s->db, SQLITE_OPEN_READONLY, NULL);
    if (rc == SQLITE_OK) {
        /* Force first DB access so a read-only-FS WAL failure surfaces now. */
        if (sqlite3_exec(s->db, "SELECT 1 FROM sqlite_master LIMIT 1;", NULL, NULL, NULL) !=
            SQLITE_OK) {
            sqlite3_close(s->db);
            s->db = NULL;
            rc = SQLITE_CANTOPEN; /* trigger immutable fallback */
        }
    }
    if (rc != SQLITE_OK) {
        sqlite3_close(s->db); /* no-op if already NULL */
        s->db = NULL;
        /* A genuinely missing DB must return NULL without creating anything —
         * only retry with the immutable URI when the file exists but could not
         * be opened (the read-only-filesystem case). This also keeps the
         * common "project not found" path to a single open attempt. */
        if (!cbm_file_exists(db_path)) {
            free(s);
            return NULL;
        }
        char uri[ST_QUERY_URI_MAX];
        if (!build_immutable_uri(db_path, uri, sizeof(uri))) {
            free(s);
            return NULL;
        }
        rc = sqlite3_open_v2(uri, &s->db, SQLITE_OPEN_READONLY | SQLITE_OPEN_URI, NULL);
        if (rc != SQLITE_OK) {
            /* sqlite3_open_v2 allocates a handle even on failure — must close it. */
            sqlite3_close(s->db);