Method loadDatabaseFromFile

YACReaderLibrary/db/data_base_management.cpp:158–185

}

QSqlDatabase DataBaseManagement::loadDatabaseFromFile(QString filePath)
{
    const QString dbPath = QDir::cleanPath(filePath);
    if (!QFile::exists(dbPath)) {
        return QSqlDatabase();
    }

    QString threadId = QString::number((quintptr)QThread::currentThreadId(), 16);
    QString connectionName = dbPath + threadId;
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", connectionName);
    db.setConnectOptions("QSQLITE_BUSY_TIMEOUT=2000");
    db.setDatabaseName(dbPath);
    if (!db.open()) {
        // se devuelve una base de datos vacía e inválida

        const QString error = db.lastError().text();
        db = QSqlDatabase();
        QSqlDatabase::removeDatabase(connectionName);
        QLOG_ERROR() << "loadDatabaseFromFile: failed to open" << dbPath << error;
        return QSqlDatabase();
    }
    QSqlQuery pragmaFK(db);
    if (!pragmaFK.exec("PRAGMA foreign_keys = ON")) {
        QLOG_ERROR() << "loadDatabaseFromFile: failed to enable foreign keys for" << dbPath << pragmaFK.lastError().text();
    }

    return db;
}

bool DataBaseManagement::createTables(QSqlDatabase &database)
{