Method insertSourceEntry

common/sqlitedb.cpp:517–545

}

bool SQLiteDB::insertSourceEntry(uint object_id, const QString &path, const QString &name)
{
    QVariant size, date_created, date_modified;

    QFileInfo info(path, name);
    if(info.isFile()) {
        size = QVariant(info.size());
        date_created = QVariant(info.birthTime().toUTC().toSecsSinceEpoch());
    } else {
        size = QVariant(static_cast<qint64>(0));
        date_created = QVariant(static_cast<qint64>(0));
    }

    date_modified = QVariant(info.lastModified().toUTC().toSecsSinceEpoch());

    QSqlQuery query;
    query.prepare("REPLACE INTO sources (object_id, path, size, date_created, date_modified)"
                  "VALUES (:object_id, :path, :size, :date_created, :date_modified)");
    query.bindValue(0, object_id);
    query.bindValue(1, name);
    query.bindValue(2, size);
    query.bindValue(3, date_created);
    query.bindValue(4, date_modified);
    bool ret = query.exec();
    if(!ret) {
        qDebug() << query.lastError();
    }
    return ret;
}

uint SQLiteDB::insertMusicEntry(const QString &path, const QString &name, int id_parent, int type)
{