1
/* === This file is part of Tomahawk Player - <http://tomahawk-player.org> ===
3
* Copyright 2010-2011, Christian Muehlhaeuser <muesli@tomahawk-player.org>
5
* Tomahawk is free software: you can redistribute it and/or modify
6
* it under the terms of the GNU General Public License as published by
7
* the Free Software Foundation, either version 3 of the License, or
8
* (at your option) any later version.
10
* Tomahawk is distributed in the hope that it will be useful,
11
* but WITHOUT ANY WARRANTY; without even the implied warranty of
12
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13
* GNU General Public License for more details.
15
* You should have received a copy of the GNU General Public License
16
* along with Tomahawk. If not, see <http://www.gnu.org/licenses/>.
19
#include "DatabaseCommand_CollectionStats.h"
21
#include "DatabaseImpl.h"
23
#include "utils/Logger.h"
25
using namespace Tomahawk;
28
DatabaseCommand_CollectionStats::DatabaseCommand_CollectionStats( const source_ptr& source, QObject* parent )
29
: DatabaseCommand( source, parent )
35
DatabaseCommand_CollectionStats::exec( DatabaseImpl* dbi )
37
Q_ASSERT( source()->isLocal() || source()->id() >= 1 );
38
TomahawkSqlQuery query = dbi->newquery();
41
if ( source()->isLocal() )
43
query.exec( "SELECT count(*), max(mtime), (SELECT guid FROM oplog WHERE source IS NULL ORDER BY id DESC LIMIT 1) "
45
"WHERE source IS NULL" );
49
query.prepare( "SELECT count(*), max(mtime), (SELECT lastop FROM source WHERE id = ?) "
52
query.addBindValue( source()->id() );
53
query.addBindValue( source()->id() );
59
m.insert( "numfiles", query.value( 0 ).toInt() );
60
m.insert( "lastmodified", query.value( 1 ).toInt() );
61
m.insert( "lastop", query.value( 2 ).toString() );