void PictureDao::update (Picture picture)
{
    m_database->open();

    PictureProperties properties = picture.pictureProperties();

    QString query ("UPDATE pictures SET ");

    query += "name='" + picture.name() + "',";
    query += "path=" + m_database->formatString( picture.path() ) + ",";

    query += "brightness=" + QString::number(properties.brightness) + ",";
    query += "contrast=" + QString::number(properties.contrast) + ",";
    query += "gamma=" + QString::number(properties.gamma) + ",";

    query += "wb_red=" + QString::number(properties.wb_red) + ",";
    query += "wb_green=" + QString::number(properties.wb_green) + ",";
    query += "wb_blue=" + QString::number(properties.wb_blue);

    query += " WHERE id=" + QString::number(picture.id()) + ";";

    qDebug() << query;

    m_database->exec( query );

    m_database->close();
}
void PictureDao::create (Picture picture)
{
    m_database->open();

    QString query ("INSERT INTO pictures (name,path,brightness,contrast,gamma,wb_red,wb_green,wb_blue) VALUES (");

    PictureProperties properties = picture.pictureProperties();

    query += "'" + picture.name() + "',";
    query += m_database->formatString( picture.path() ) +",";
    query += QString::number(properties.brightness) +",";
    query += QString::number(properties.contrast) +",";
    query += QString::number(properties.gamma) +",";
    query += QString::number(properties.wb_red) +",";
    query += QString::number(properties.wb_green) +",";
    query += QString::number(properties.wb_blue) +");";

    m_database->exec( query );

    m_database->close();
}