本文整理汇总了C++中QueryBuilder::groupBy方法的典型用法代码示例。如果您正苦于以下问题：C++ QueryBuilder::groupBy方法的具体用法？C++ QueryBuilder::groupBy怎么用？C++ QueryBuilder::groupBy使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类QueryBuilder的用法示例。
在下文中一共展示了QueryBuilder::groupBy方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C++代码示例。
示例1: statisticsData
const QStringList TagDialog::statisticsData() {
QStringList data, values;
const uint artist_id = CollectionDB::instance()->artistID( m_bundle.artist() );
const uint album_id = CollectionDB::instance()->albumID ( m_bundle.album() );
QueryBuilder qb;
if ( !m_bundle.artist().isEmpty() ) {
// tracks by this artist
qb.clear();
qb.addReturnFunctionValue( QueryBuilder::funcCount, QueryBuilder::tabSong, QueryBuilder::valTitle );
qb.addMatch( QueryBuilder::tabSong, QueryBuilder::valArtistID, QString::number( artist_id ) );
values = qb.run();
data += i18n( "Tracks by this Artist" );
data += values[0];
// albums by this artist
qb.clear();
qb.addReturnFunctionValue( QueryBuilder::funcCount, QueryBuilder::tabAlbum, QueryBuilder::valID );
qb.addMatch( QueryBuilder::tabSong, QueryBuilder::valArtistID, QString::number( artist_id ) );
qb.groupBy( QueryBuilder::tabSong, QueryBuilder::valAlbumID );
qb.excludeMatch( QueryBuilder::tabAlbum, i18n( "Unknown" ) );
qb.setOptions( QueryBuilder::optNoCompilations );
values = qb.run();
data += i18n( "Albums by this Artist" );
data += QString::number( values.count() );
// Favorite track by this artist
qb.clear();
qb.addReturnValue( QueryBuilder::tabSong, QueryBuilder::valTitle );
qb.addReturnValue( QueryBuilder::tabStats, QueryBuilder::valScore );
qb.addMatch( QueryBuilder::tabSong, QueryBuilder::valArtistID, QString::number( artist_id ) );
qb.sortBy( QueryBuilder::tabStats, QueryBuilder::valPercentage, true );
qb.setLimit( 0, 1 );
values = qb.run();
data += i18n( "Favorite by this Artist" );
data += values[0];
if ( !m_bundle.album().isEmpty() ) {
// Favorite track on this album
qb.clear();
qb.addReturnValue( QueryBuilder::tabSong, QueryBuilder::valTitle );
qb.addReturnValue( QueryBuilder::tabStats, QueryBuilder::valScore );
qb.addMatch( QueryBuilder::tabSong, QueryBuilder::valAlbumID, QString::number( album_id ) );
qb.sortBy( QueryBuilder::tabStats, QueryBuilder::valPercentage, true );
qb.setLimit( 0, 1 );
values = qb.run();
data += i18n( "Favorite on this Album" );
data += values[0];
}
// Related Artists
const QString sArtists = CollectionDB::instance()->similarArtists( m_bundle.artist(), 4 ).join(", ");
if ( !sArtists.isEmpty() ) {
data += i18n( "Related Artists" );
data += sArtists;
}
}
return data;
}