Method Save

Src/Database/Database.cpp:756–814

}

bool CDatabaseFile::Save(const QString &szFile)
{
    bool bRet = true;
    if(szFile.isEmpty()) return false;
    QFile f(szFile);
    if(!f.open(QFile::ReadOnly | QFile::Text)) {
        SetError("Failed to open file: " + szFile
                 + "; Error: " + f.errorString());
        return false;
    }
    QByteArray content = f.readAll();
    f.close();
    QFileInfo fi(szFile);
    QSqlQuery query(GetDatabase());
    bRet = query.prepare(
        "SELECT content FROM " + m_szTableName + " "
        " WHERE file=:file"
        );
    if(!bRet) {
        SetError("Failed to prepare: " + query.executedQuery()
                 + "; Error: " + query.lastError().text());
        qCritical(log) << GetError();
        return false;
    }
    query.bindValue(":file", fi.fileName());
    bRet = query.exec();
    if(!bRet){
        SetError("Failed to exec: " + query.executedQuery()
                 + "; Error: " + query.lastError().text());
        qCritical(log) << GetError();
        return false;
    }
    if(query.next()) {
        query.prepare(
            "UPDATE " + m_szTableName + " "
            "SET content = :content "
            "WHERE file = :file"
            );
        query.bindValue(":file", fi.fileName());
        query.bindValue(":content", content);
    } else {
        query.prepare(
            "INSERT INTO " + m_szTableName + " "
            "(file, content) "
            "VALUES (:file, :content)"
            );
        query.bindValue(":file", fi.fileName());
        query.bindValue(":content", content);
    }
    bRet = query.exec();
    if (!bRet) {
        SetError("Failed to save file to:" + m_szTableName
                     + "; Error: " + query.lastError().text()
                     + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
        return false;
    }
    return bRet;