/src/libtomahawk/database/DatabaseCommand_CollectionStats.cpp

 1/* === This file is part of Tomahawk Player - <http://tomahawk-player.org> ===
 2 *
 3 *   Copyright 2010-2011, Christian Muehlhaeuser <muesli@tomahawk-player.org>
 4 *
 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.
 9 *
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.
14 *
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/>.
17 */
18
19#include "DatabaseCommand_CollectionStats.h"
20
21#include "DatabaseImpl.h"
22#include "Source.h"
23#include "utils/Logger.h"
24
25using namespace Tomahawk;
26
27
28DatabaseCommand_CollectionStats::DatabaseCommand_CollectionStats( const source_ptr& source, QObject* parent )
29    : DatabaseCommand( source, parent )
30{
31}
32
33
34void
35DatabaseCommand_CollectionStats::exec( DatabaseImpl* dbi )
36{
37    Q_ASSERT( source()->isLocal() || source()->id() >= 1 );
38    TomahawkSqlQuery query = dbi->newquery();
39
40    QVariantMap m;
41    if ( source()->isLocal() )
42    {
43        query.exec( "SELECT count(*), max(mtime), (SELECT guid FROM oplog WHERE source IS NULL ORDER BY id DESC LIMIT 1) "
44                    "FROM file "
45                    "WHERE source IS NULL" );
46    }
47    else
48    {
49        query.prepare( "SELECT count(*), max(mtime), (SELECT lastop FROM source WHERE id = ?) "
50                       "FROM file "
51                       "WHERE source = ?" );
52        query.addBindValue( source()->id() );
53        query.addBindValue( source()->id() );
54        query.exec();
55    }
56
57    if ( query.next() )
58    {
59        m.insert( "numfiles", query.value( 0 ).toInt() );
60        m.insert( "lastmodified", query.value( 1 ).toInt() );
61        m.insert( "lastop", query.value( 2 ).toString() );
62    }
63
64    emit done( m );
65}