/src/libtomahawk/database/DatabaseCommand_LoadAllSources.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_LoadAllSources.h"
20
21#include "DatabaseImpl.h"
22#include "Source.h"
23
24using namespace Tomahawk;
25
26
27DatabaseCommand_LoadAllSources::DatabaseCommand_LoadAllSources( QObject* parent )
28    : DatabaseCommand( parent )
29{
30}
31
32
33void
34DatabaseCommand_LoadAllSources::exec( DatabaseImpl* dbi )
35{
36    TomahawkSqlQuery query = dbi->newquery();
37
38    query.exec( QString( "SELECT id, name, friendlyname, lastop "
39                         "FROM source" ) );
40
41    QList<source_ptr> sources;
42    while ( query.next() )
43    {
44        source_ptr src( new Source( query.value( 0 ).toUInt(), query.value( 1 ).toString() ) );
45        src->setDbFriendlyName( query.value( 2 ).toString() );
46        src->setLastCmdGuid( query.value( 3 ).toString() );
47        sources << src;
48    }
49
50    emit done( sources );
51}
52