Method checkDatabase

AdaptixClient/Source/Client/Storage.cpp:43–94

}

void Storage::checkDatabase()
{
    auto queryProjects = QSqlQuery(QSqlDatabase::database(DB_CONNECTION_NAME));
    queryProjects.prepare("CREATE TABLE IF NOT EXISTS Projects ( "
            "project TEXT UNIQUE PRIMARY KEY, "
            "data TEXT );"
    );
    if ( !queryProjects.exec() )
        LogError("Table PROJECTS not created: %s\n", queryProjects.lastError().text().toStdString().c_str());



    auto queryExtensions = QSqlQuery(QSqlDatabase::database(DB_CONNECTION_NAME));
    queryExtensions.prepare("CREATE TABLE IF NOT EXISTS Extensions ( "
                          "filepath TEXT UNIQUE PRIMARY KEY, "
                          "enabled BOOLEAN );"
    );
    if ( !queryExtensions.exec() )
        LogError("Table EXTENSIONS not created: %s\n", queryExtensions.lastError().text().toStdString().c_str());



    auto querySettings = QSqlQuery(QSqlDatabase::database(DB_CONNECTION_NAME));
    querySettings.prepare("CREATE TABLE IF NOT EXISTS Settings ( "
                            "key TEXT UNIQUE PRIMARY KEY, "
                            "data TEXT );"
    );
    if ( !querySettings.exec() )
        LogError("Table Settings not created: %s\n", querySettings.lastError().text().toStdString().c_str());



    auto queryListenerProfiles = QSqlQuery(QSqlDatabase::database(DB_CONNECTION_NAME));
    queryListenerProfiles.prepare("CREATE TABLE IF NOT EXISTS ListenerProfiles ( "
                            "project TEXT, "
                            "name TEXT, "
                            "data TEXT, "
                            "PRIMARY KEY (project, name) );"
    );
    if ( !queryListenerProfiles.exec() )
        LogError("Table ListenerProfiles not created: %s\n", queryListenerProfiles.lastError().text().toStdString().c_str());

    auto queryAgentProfiles = QSqlQuery(QSqlDatabase::database(DB_CONNECTION_NAME));
    queryAgentProfiles.prepare("CREATE TABLE IF NOT EXISTS AgentProfiles ( "
                            "project TEXT, "
                            "name TEXT, "
                            "data TEXT, "
                            "PRIMARY KEY (project, name) );"
    );
    if ( !queryAgentProfiles.exec() )
        LogError("Table AgentProfiles not created: %s\n", queryAgentProfiles.lastError().text().toStdString().c_str());
}

/// PROJECTS