/src/libtomahawk/database/DatabaseCommand_LoadOps.cpp
http://github.com/tomahawk-player/tomahawk · C++ · 80 lines · 51 code · 11 blank · 18 comment · 3 complexity · dcf571d07d2f0a7cc260361dd37e4b9e MD5 · raw file
- /* === This file is part of Tomahawk Player - <http://tomahawk-player.org> ===
- *
- * Copyright 2010-2011, Christian Muehlhaeuser <muesli@tomahawk-player.org>
- *
- * Tomahawk is free software: you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation, either version 3 of the License, or
- * (at your option) any later version.
- *
- * Tomahawk is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- * GNU General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with Tomahawk. If not, see <http://www.gnu.org/licenses/>.
- */
- #include "DatabaseCommand_LoadOps.h"
- #include "DatabaseImpl.h"
- #include "TomahawkSqlQuery.h"
- #include "Source.h"
- #include "utils/Logger.h"
- namespace Tomahawk
- {
- void
- DatabaseCommand_loadOps::exec( DatabaseImpl* dbi )
- {
- QList< dbop_ptr > ops;
- if ( !m_since.isEmpty() )
- {
- TomahawkSqlQuery query = dbi->newquery();
- query.prepare( QString( "SELECT id FROM oplog WHERE guid = ?" ) );
- query.addBindValue( m_since );
- query.exec();
- if ( !query.next() )
- {
- tLog() << "Unknown oplog guid, requested, not replying:" << m_since;
- Q_ASSERT( false );
- emit done( m_since, m_since, ops );
- return;
- }
- }
- TomahawkSqlQuery query = dbi->newquery();
- query.prepare( QString(
- "SELECT guid, command, json, compressed, singleton "
- "FROM oplog "
- "WHERE source %1 "
- "AND id > coalesce((SELECT id FROM oplog WHERE guid = ?),0) "
- "ORDER BY id ASC"
- ).arg( source()->isLocal() ? "IS NULL" : QString( "= %1" ).arg( source()->id() ) )
- );
- query.addBindValue( m_since );
- query.exec();
- QString lastguid = m_since;
- while( query.next() )
- {
- dbop_ptr op( new DBOp );
- op->guid = query.value( 0 ).toString();
- op->command = query.value( 1 ).toString();
- op->payload = query.value( 2 ).toByteArray();
- op->compressed = query.value( 3 ).toBool();
- op->singleton = query.value( 4 ).toBool();
- lastguid = op->guid;
- ops << op;
- }
- // qDebug() << "Loaded" << ops.length() << "ops from db";
- emit done( m_since, lastguid, ops );
- }
- }