Method insertSavedataEntry

common/sqlitedb.cpp:805–848

}

uint SQLiteDB::insertSavedataEntry(const QString &path, const QString &name, int id_parent, int type)
{
    int ohfi;
    SfoReader reader;
    uint date_updated = 0;
    const char *title = NULL;
    const char *savedata_detail = NULL;
    const char *savedata_directory = NULL;

    QString file_name = QFileInfo(name).fileName();
    QByteArray utf8name = file_name.toUtf8();

    if(file_name.endsWith(".sfo", Qt::CaseInsensitive) && reader.load(path + "/" + name)) {
        title = reader.value("TITLE", utf8name.constData());
        savedata_detail = reader.value("SAVEDATA_DETAIL", "");
        savedata_directory = reader.value("SAVEDATA_DIRECTORY", utf8name.constData());
        date_updated = QFileInfo(path + "/" + name).lastModified().toUTC().toSecsSinceEpoch();
    }

    if((ohfi = insertDefaultEntry(path, name, title, id_parent, type)) == 0) {
        return 0;
    }

    if(!title) {
        return ohfi;
    }

    QSqlQuery query;
    query.prepare("REPLACE INTO savedata"
                  "(object_id, detail, dir_name, title, date_updated)"
                  "VALUES (:object_id, :detail, :dir_name, :title, :updated)");

    query.bindValue(0, id_parent);
    query.bindValue(1, savedata_detail);
    query.bindValue(2, savedata_directory);
    query.bindValue(3, title);
    query.bindValue(4, date_updated);

    if(!query.exec()) {
        return 0;
    }

    return ohfi;
}


bool SQLiteDB::insertApplicationEntry(const QString &name, int ohfi, int app_type)