Method createDatabase

src/Core/DatabaseManager.cpp:37–68

}

void DatabaseManager::createDatabase()
{
    QFile file(":/Scripts/Sql/Schema.sql");
    if (file.open(QFile::ReadOnly))
    {
        QStringList queries = QString(file.readAll()).split(";");

        file.close();

        QSqlQuery sql;
        foreach (QString query, queries)
        {
            if (query.trimmed().isEmpty())
                continue;

            if (!sql.exec(query))
                qFatal("Failed to execute sql query: %s, Error: %s", qPrintable(sql.lastQuery()), qPrintable(sql.lastError().text()));
        }

#if defined(Q_OS_WIN)
        if (!sql.exec("INSERT INTO Device (Name, Address, Port, Username, Password, Description, Version, Shadow, Channels, ChannelFormats, PreviewChannel, LockedChannel) VALUES('Localhost', '127.0.0.1', 5250, '', '', '', '', 'No', 0, '', 0, 0)"))
            qFatal("Failed to execute sql query: %s, Error: %s", qPrintable(sql.lastQuery()), qPrintable(sql.lastError().text()));
#endif

        sql.prepare("UPDATE Configuration SET Value = :Value "
                    "WHERE Name = 'DatabaseVersion'");
        sql.bindValue(":Value", DATABASE_VERSION);

        if (!sql.exec())
            qFatal("Failed to execute sql query: %s, Error: %s", qPrintable(sql.lastQuery()), qPrintable(sql.lastError().text()));
    }
}

void DatabaseManager::upgradeDatabase()
{