/src/libtomahawk/database/DatabaseCommand_CollectionStats.cpp

http://github.com/tomahawk-player/tomahawk · C++ · 65 lines · 38 code · 10 blank · 17 comment · 3 complexity · 88902a2064b79baeb75c431ede2e5b21 MD5 · raw file

  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. #include "DatabaseCommand_CollectionStats.h"
  19. #include "DatabaseImpl.h"
  20. #include "Source.h"
  21. #include "utils/Logger.h"
  22. using namespace Tomahawk;
  23. DatabaseCommand_CollectionStats::DatabaseCommand_CollectionStats( const source_ptr& source, QObject* parent )
  24. : DatabaseCommand( source, parent )
  25. {
  26. }
  27. void
  28. DatabaseCommand_CollectionStats::exec( DatabaseImpl* dbi )
  29. {
  30. Q_ASSERT( source()->isLocal() || source()->id() >= 1 );
  31. TomahawkSqlQuery query = dbi->newquery();
  32. QVariantMap m;
  33. if ( source()->isLocal() )
  34. {
  35. query.exec( "SELECT count(*), max(mtime), (SELECT guid FROM oplog WHERE source IS NULL ORDER BY id DESC LIMIT 1) "
  36. "FROM file "
  37. "WHERE source IS NULL" );
  38. }
  39. else
  40. {
  41. query.prepare( "SELECT count(*), max(mtime), (SELECT lastop FROM source WHERE id = ?) "
  42. "FROM file "
  43. "WHERE source = ?" );
  44. query.addBindValue( source()->id() );
  45. query.addBindValue( source()->id() );
  46. query.exec();
  47. }
  48. if ( query.next() )
  49. {
  50. m.insert( "numfiles", query.value( 0 ).toInt() );
  51. m.insert( "lastmodified", query.value( 1 ).toInt() );
  52. m.insert( "lastop", query.value( 2 ).toString() );
  53. }
  54. emit done( m );
  55. }