Method attachExtraDatabases

src/iso19111/factory.cpp:1322–1429

// ---------------------------------------------------------------------------

void DatabaseContext::Private::attachExtraDatabases(
    const std::vector<std::string> &auxiliaryDatabasePaths) {

    auto l_handle = handle();
    assert(l_handle);

    auto tables = run("SELECT name, type, sql FROM sqlite_master WHERE type IN "
                      "('table', 'view') "
                      "AND name NOT LIKE 'sqlite_stat%'");

    struct TableStructure {
        std::string name{};
        bool isTable = false;
        std::string sql{};
        std::vector<std::string> columns{};
    };
    std::vector<TableStructure> tablesStructure;
    for (const auto &rowTable : tables) {
        TableStructure tableStructure;
        tableStructure.name = rowTable[0];
        tableStructure.isTable = rowTable[1] == "table";
        tableStructure.sql = rowTable[2];
        auto tableInfo =
            run("PRAGMA table_info(\"" +
                replaceAll(tableStructure.name, "\"", "\"\"") + "\")");
        for (const auto &rowCol : tableInfo) {
            const auto &colName = rowCol[1];
            tableStructure.columns.push_back(colName);
        }
        tablesStructure.push_back(std::move(tableStructure));
    }

    const int nLayoutVersionMajor = l_handle->getLayoutVersionMajor();
    const int nLayoutVersionMinor = l_handle->getLayoutVersionMinor();

    closeDB();
    if (auxiliaryDatabasePaths.empty()) {
        open(databasePath_, pjCtxt());
        return;
    }

    sqlite3 *sqlite_handle = nullptr;
    sqlite3_open_v2(
        ":memory:", &sqlite_handle,
        SQLITE_OPEN_READWRITE | SQLITE_OPEN_NOMUTEX | SQLITE_OPEN_URI, nullptr);
    if (!sqlite_handle) {
        throw FactoryException("cannot create in memory database");
    }
    sqlite_handle_ = SQLiteHandle::initFromExisting(
        sqlite_handle, true, nLayoutVersionMajor, nLayoutVersionMinor);
    l_handle = sqlite_handle_;

    run("ATTACH DATABASE ? AS db_0", {databasePath_});
    detach_ = true;
    int count = 1;
    for (const auto &otherDbPath : auxiliaryDatabasePaths) {
        const auto attachedDbName("db_" + toString(static_cast<int>(count)));
        std::string sql = "ATTACH DATABASE ? AS ";