Method insertPhotoEntry

common/sqlitedb.cpp:753–803

}

uint SQLiteDB::insertPhotoEntry(const QString &path, const QString &name, int id_parent, int type)
{
    int ohfi;
    //QImage img;
    uint date_created;
    int width, height, file_format, photo_codec;

    int cma_file_type = checkFileType(name, VITA_OHFI_PHOTO);
    if(cma_file_type < 0) {
        //qDebug() << "Excluding from database:" << path;
        return 0;
    }

    //if(!img.load(path + "/" + name)) {
    //    return 0;
    //}

    QDateTime date = QFileInfo(path + "/" + name).birthTime();
    date_created = date.toUTC().toSecsSinceEpoch();
    QString month_created = date.toString("yyyy/MM");

    width = 0; //img.width();
    height = 0; //img.height();
    file_format = 0; //photo_list[cma_file_type].file_format;
    photo_codec = 0; //photo_list[cma_file_type].file_codec;

    QByteArray basename = QFileInfo(name).baseName().toUtf8();

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

    QSqlQuery query;
    query.prepare("REPLACE INTO photos"
                  "(object_id, date_created, file_format, photo_codec, width, height, month_created)"
                  "VALUES (:object_id, :date_created, :file_format, :photo_codec, :width, :height, :month_created)");

    query.bindValue(0, ohfi);
    query.bindValue(1, date_created);
    query.bindValue(2, file_format);
    query.bindValue(3, photo_codec);
    query.bindValue(4, width);
    query.bindValue(5, height);
    query.bindValue(6, month_created);

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

    return ohfi;
}

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