void AudioStreamListEngine::run()
{
QThread::setTerminationEnabled(true);
m_stop = false;
if (m_updateSourceInfo || m_removeSourceInfo) {
NepomukListEngine::run();
return;
}
//Create media list based on engine argument and filter
QList<MediaItem> mediaList;
MediaVocabulary mediaVocabulary = MediaVocabulary();
QString engineArg = m_mediaListProperties.engineArg();
QString engineFilter = m_mediaListProperties.engineFilter();
if (m_nepomukInited) {
if (engineArg.isEmpty()) {
MediaQuery query;
QStringList bindings;
bindings.append(mediaVocabulary.mediaResourceBinding());
bindings.append(mediaVocabulary.mediaResourceUrlBinding());
bindings.append(mediaVocabulary.titleBinding());
bindings.append(mediaVocabulary.ratingBinding());
bindings.append(mediaVocabulary.descriptionBinding());
bindings.append(mediaVocabulary.artworkBinding());
//bindings.append(mediaVocabulary.genreBinding());
query.select(bindings, MediaQuery::Distinct);
query.startWhere();
query.addCondition(mediaVocabulary.hasTypeAudioStream(MediaQuery::Required));
query.addCondition(mediaVocabulary.hasTitle(MediaQuery::Required));
query.addCondition(mediaVocabulary.hasRating(MediaQuery::Optional));
query.addCondition(mediaVocabulary.hasDescription(MediaQuery::Optional));
query.addCondition(mediaVocabulary.hasArtwork(MediaQuery::Optional));
query.endWhere();
QStringList orderByBindings;
orderByBindings.append(mediaVocabulary.titleBinding());
query.orderBy(orderByBindings);
Soprano::QueryResultIterator it = query.executeSelect(m_mainModel);
//Build media list from results
while( it.next() ) {
if (m_stop) {
return;
}
MediaItem mediaItem = Utilities::mediaItemFromIterator(it, QString("Audio Stream"), m_mediaListProperties.lri);
if (!mediaItem.url.startsWith(QLatin1String("nepomuk:/"))) {
mediaList.append(mediaItem);
}
}
m_mediaListProperties.summary = i18np("1 stream", "%1 streams", mediaList.count());
MediaItem mediaItem;
mediaItem.type = "Audio";
mediaItem.url.clear();
mediaItem.title = i18n("New Audio Stream");
mediaItem.subTitle = i18n("Edit info to create new audio stream");
mediaItem.artwork = KIcon("text-html");
mediaItem.fields["title"] = i18n("Untitled");
mediaItem.fields["audioType"] = "Audio Stream";
mediaItem.fields["isTemplate"] = true;
mediaList.append(mediaItem);
m_mediaListProperties.type = QString("Sources");
} else if (engineArg.toLower() == "search") {
MediaQuery query;
QStringList bindings;
bindings.append(mediaVocabulary.mediaResourceBinding());
bindings.append(mediaVocabulary.mediaResourceUrlBinding());
bindings.append(mediaVocabulary.titleBinding());
bindings.append(mediaVocabulary.ratingBinding());
bindings.append(mediaVocabulary.descriptionBinding());
bindings.append(mediaVocabulary.artworkBinding());
//bindings.append(mediaVocabulary.genreBinding());
query.select(bindings, MediaQuery::Distinct);
query.startWhere();
query.addCondition(mediaVocabulary.hasTypeAudioStream(MediaQuery::Required));
query.addCondition(mediaVocabulary.hasTitle(MediaQuery::Required));
query.addCondition(mediaVocabulary.hasRating(MediaQuery::Optional));
query.addCondition(mediaVocabulary.hasDescription(MediaQuery::Optional));
query.addCondition(mediaVocabulary.hasArtwork(MediaQuery::Optional));
query.startFilter();
query.addFilterConstraint(mediaVocabulary.titleBinding(), engineFilter, MediaQuery::Contains);
query.addFilterOr();
query.addFilterConstraint(mediaVocabulary.descriptionBinding(), engineFilter, MediaQuery::Contains);
query.endFilter();
query.endWhere();
QStringList orderByBindings;
orderByBindings.append(mediaVocabulary.titleBinding());
query.orderBy(orderByBindings);
Soprano::QueryResultIterator it = query.executeSelect(m_mainModel);
//Build media list from results
while( it.next() ) {
MediaItem mediaItem = Utilities::mediaItemFromIterator(it, QString("Audio Stream"), m_mediaListProperties.lri);
if (!mediaItem.url.startsWith(QLatin1String("nepomuk:/"))) {
mediaList.append(mediaItem);
}
}
m_mediaListProperties.summary = i18np("1 stream", "%1 streams", mediaList.count());
m_mediaListProperties.type = QString("Sources");
}
}
emit results(m_requestSignature, mediaList, m_mediaListProperties, true, m_subRequestSignature);
m_requestSignature.clear();
m_subRequestSignature.clear();
}
void SemanticsListEngine::run()
{
QThread::setTerminationEnabled(true);
m_stop = false;
if (m_updateSourceInfo || m_removeSourceInfo) {
NepomukListEngine::run();
return;
}
//Create media list based on engine argument and filter
QList<MediaItem> mediaList;
MediaVocabulary mediaVocabulary = MediaVocabulary();
QString engineArg = m_mediaListProperties.engineArg();
QString engineFilter = m_mediaListProperties.engineFilter();
QStringList engineFilterList = m_mediaListProperties.engineFilterList();
//Parse filter
QString mediaType;
QString groupByCategoryType;
QString groupByField;
QString limitFilter;
int originalGenreLimit = 0;
if (engineFilterList.count() != 0) {
mediaType = engineFilterList.at(0);
if (engineFilterList.filter("groupBy=").count() != 0) {
QString groupByFilter = engineFilterList.filter("groupBy=").at(0);
groupByField = groupByFilter.remove("groupBy=").trimmed();
if (groupByField == "artist") {
groupByCategoryType = "Artist";
} else if (groupByField == "album") {
groupByCategoryType = "Album";
} else if (groupByField == "genre") {
if (mediaType == "audio") {
groupByCategoryType = "AudioGenre";
} else if (mediaType == "video") {
groupByCategoryType = "VideoGenre";
}
} else if (groupByField == "seriesName") {
groupByCategoryType = "TV Series";
} else if (groupByField == "actor") {
groupByCategoryType = "Actor";
} else if (groupByField == "director") {
groupByCategoryType = "Director";
} else if (groupByField == "tag") {
if (mediaType == "audio") {
groupByCategoryType = "AudioTag";
} else if (mediaType == "video") {
groupByCategoryType = "VideoTag";
}
}
}
if (engineFilterList.filter("limit=").count() !=0) {
limitFilter = engineFilterList.filter("limit=").at(0);
if (groupByField == "genre") {
originalGenreLimit = m_mediaListProperties.filterValue(limitFilter).trimmed().toInt();
int originalFilterIndex = engineFilterList.indexOf(limitFilter);
limitFilter = QString("%1%2%3").arg(m_mediaListProperties.filterField(limitFilter))
.arg(m_mediaListProperties.filterOperator(limitFilter))
.arg(m_mediaListProperties.filterValue(limitFilter).trimmed().toInt()*3);
engineFilterList.replace(originalFilterIndex, limitFilter);
}
}
}
if (m_nepomukInited) {
if (engineArg.toLower() == "frequent") {
mediaList.clear();
if (mediaType == "audio" || mediaType == "video") {
MediaQuery query;
bool ignoreZeros = false;
if (groupByCategoryType.isEmpty()) {
QStringList bindings;
bindings.append(mediaVocabulary.mediaResourceBinding());
bindings.append(mediaVocabulary.mediaResourceUrlBinding());
bindings.append(mediaVocabulary.playCountBinding());
query.select(bindings, MediaQuery::Distinct);
query.startWhere();
if (mediaType == "audio") {
query.addCondition(mediaVocabulary.hasTypeAnyAudio(MediaQuery::Required));
} else if (mediaType == "video") {
query.addCondition(mediaVocabulary.hasTypeAnyVideo(MediaQuery::Required));
}
query.addLRIFilterConditions(engineFilterList, mediaVocabulary);
if (m_mediaListProperties.filterForField("playCount").isEmpty()) {
query.addCondition(mediaVocabulary.hasPlayCount(MediaQuery::Required, 0, MediaQuery::GreaterThan));
ignoreZeros = true;
}
query.addCondition(mediaVocabulary.hasLastPlayed(MediaQuery::Optional));
query.endWhere();
QStringList orderByBindings;
QList<MediaQuery::Order> order;
orderByBindings.append(mediaVocabulary.playCountBinding());
order.append(MediaQuery::Descending);
orderByBindings.append(mediaVocabulary.lastPlayedBinding());
order.append(MediaQuery::Descending);
query.orderBy(orderByBindings, order);
} else {
QStringList bindings;
//NOTE:query.addLRIFilterConditions will automatically add
//the groupBy field name to the binding list.
QString groupByResourceBinding = MediaVocabulary::resourceBindingForCategory(groupByCategoryType);
if (!groupByResourceBinding.isEmpty()) {
bindings.append(groupByResourceBinding);
}
bindings.append(query.fieldBindingDictionary[groupByField]);
bindings.append(MediaQuery::aggregateBinding(mediaVocabulary.playCountBinding(), MediaQuery::Sum));
query.select(bindings, MediaQuery::Distinct);
query.startWhere();
MediaQuery subQuery;
QStringList subBindings;
subBindings.append(mediaVocabulary.playCountBinding());
subBindings.append(mediaVocabulary.mediaResourceBinding());
subQuery.select(subBindings, MediaQuery::Distinct);
subQuery.startWhere();
if (mediaType == "audio") {
subQuery.addCondition(mediaVocabulary.hasTypeAnyAudio(MediaQuery::Required));
} else if (mediaType == "video") {
subQuery.addCondition(mediaVocabulary.hasTypeAnyVideo(MediaQuery::Required));
}
if (m_mediaListProperties.filterForField("playCount").isEmpty()) {
subQuery.addCondition(mediaVocabulary.hasPlayCount(MediaQuery::Required, 0, MediaQuery::GreaterThan));
ignoreZeros = true;
}
QStringList subQueryLRIFilterList = engineFilterList;
subQueryLRIFilterList.removeAll(limitFilter);
subQuery.addLRIFilterConditions(subQueryLRIFilterList, mediaVocabulary);
subQuery.endWhere();
query.addSubQuery(subQuery);
query.endWhere();
query.addLRIFilterCondition(limitFilter, mediaVocabulary);
QStringList orderByBindings;
QList<MediaQuery::Order> order;
orderByBindings.append(QString("%1_sum").arg(mediaVocabulary.playCountBinding()));
order.append(MediaQuery::Descending);
query.orderBy(orderByBindings, order);
}
Soprano::QueryResultIterator it = query.executeSelect(m_mainModel);
//Build media list from results
while( it.next() ) {
if (m_stop) {
return;
}
MediaItem mediaItem;
if (groupByCategoryType.isEmpty()) {
Nepomuk::Resource res = Nepomuk::Resource(it.binding(mediaVocabulary.mediaResourceBinding()).uri());
mediaItem = Utilities::mediaItemFromNepomuk(res, m_mediaListProperties.lri);
mediaItem.semanticComment = i18np("played once", "played %1 times", mediaItem.fields["playCount"].toInt());
} else {
mediaItem = Utilities::categoryMediaItemFromIterator(it, groupByCategoryType, m_mediaListProperties.lri);
int playCount = it.binding(QString("%1_sum").arg(mediaVocabulary.playCountBinding())).literal().toInt();
mediaItem.semanticComment = i18np("played once", "played %1 times", playCount);
mediaItem.fields["playCount"] = playCount;
}
if (!mediaItem.url.startsWith("nepomuk:/")) {
if ((ignoreZeros && mediaItem.fields["playCount"].toInt() > 0) ||
!ignoreZeros) {
if (groupByCategoryType == "AudioGenre") {
addUniqueGenreGroup("playCount", mediaItem, &mediaList, originalGenreLimit);
} else {
mediaList.append(mediaItem);
}
}
}
}
m_mediaListProperties.name = i18n("Frequently Played");
m_mediaListProperties.type = QString("Sources");
}
}
if (engineArg.toLower() == "recent") {
mediaList.clear();
if (!mediaType.isEmpty()) {
MediaQuery query;
QStringList bindings;
if (groupByCategoryType.isEmpty()) {
bindings.append(mediaVocabulary.mediaResourceBinding());
bindings.append(mediaVocabulary.mediaResourceUrlBinding());
bindings.append(mediaVocabulary.lastPlayedBinding());
} else {
//NOTE:query.addLRIFilterConditions will automatically add
//the groupBy field name to the binding list.
QString groupByResourceBinding = MediaVocabulary::resourceBindingForCategory(groupByCategoryType);
if (!groupByResourceBinding.isEmpty()) {
bindings.append(groupByResourceBinding);
}
bindings.append(MediaQuery::aggregateBinding(mediaVocabulary.lastPlayedBinding(), MediaQuery::Max));
}
query.select(bindings, MediaQuery::Distinct);
query.startWhere();
if (mediaType == "audio") {
query.addCondition(mediaVocabulary.hasTypeAnyAudio(MediaQuery::Required));
} else if (mediaType == "video") {
query.addCondition(mediaVocabulary.hasTypeAnyVideo(MediaQuery::Required));
}
query.addLRIFilterConditions(engineFilterList, mediaVocabulary);
query.addCondition(mediaVocabulary.hasLastPlayed(MediaQuery::Required));
query.endWhere();
QStringList orderByBindings;
QList<MediaQuery::Order> order;
if (groupByCategoryType.isEmpty()) {
orderByBindings.append(mediaVocabulary.lastPlayedBinding());
} else {
orderByBindings.append(QString("%1_max").arg(mediaVocabulary.lastPlayedBinding()));
}
order.append(MediaQuery::Descending);
query.orderBy(orderByBindings, order);
Soprano::QueryResultIterator it = query.executeSelect(m_mainModel);
//Build media list from results
while( it.next() ) {
if (m_stop) {
return;
}
MediaItem mediaItem;
if (groupByCategoryType.isEmpty()) {
Nepomuk::Resource res = Nepomuk::Resource(it.binding(mediaVocabulary.mediaResourceBinding()).uri());
mediaItem = Utilities::mediaItemFromNepomuk(res, m_mediaListProperties.lri);
mediaItem.fields["lastPlayed"] = it.binding(mediaVocabulary.lastPlayedBinding()).literal().toDateTime();
} else {
mediaItem = Utilities::categoryMediaItemFromIterator(it, groupByCategoryType, m_mediaListProperties.lri);
mediaItem.fields["lastPlayed"] = it.binding(QString("%1_max").arg(mediaVocabulary.lastPlayedBinding())).literal().toDateTime();
}
mediaItem.semanticComment = Utilities::wordsForTimeSince(mediaItem.fields["lastPlayed"].toDateTime());
if (!mediaItem.url.startsWith("nepomuk:/")) {
if (groupByCategoryType == "AudioGenre") {
addUniqueGenreGroup("lastPlayed", mediaItem, &mediaList, originalGenreLimit);
} else {
mediaList.append(mediaItem);
}
}
}
m_mediaListProperties.name = i18n("Recently Played");
m_mediaListProperties.type = QString("Sources");
}
}
if (engineArg.toLower() == "highest") {
mediaList.clear();
if (!mediaType.isEmpty()) {
bool ignoreZeros = false;
MediaQuery query;
QStringList bindings;
if (groupByCategoryType.isEmpty()) {
bindings.append(mediaVocabulary.mediaResourceBinding());
bindings.append(mediaVocabulary.mediaResourceUrlBinding());
bindings.append(mediaVocabulary.ratingBinding());
} else {
//NOTE:query.addLRIFilterConditions will automatically add
//the groupBy field name to the binding list.
QString groupByResourceBinding = MediaVocabulary::resourceBindingForCategory(groupByCategoryType);
if (!groupByResourceBinding.isEmpty()) {
bindings.append(groupByResourceBinding);
}
bindings.append(MediaQuery::aggregateBinding(mediaVocabulary.ratingBinding(), MediaQuery::Sum));
bindings.append(MediaQuery::aggregateBinding(mediaVocabulary.ratingBinding(), MediaQuery::Count));
}
query.select(bindings, MediaQuery::Distinct);
query.startWhere();
if (mediaType == "audio") {
query.addCondition(mediaVocabulary.hasTypeAnyAudio(MediaQuery::Required));
} else if (mediaType == "video") {
query.addCondition(mediaVocabulary.hasTypeAnyVideo(MediaQuery::Required));
}
query.addLRIFilterConditions(engineFilterList, mediaVocabulary);
if (m_mediaListProperties.filterForField("rating").isEmpty()) {
query.addCondition(mediaVocabulary.hasRating(MediaQuery::Required, 0, MediaQuery::GreaterThan));
ignoreZeros = true;
}
query.addCondition(mediaVocabulary.hasPlayCount(MediaQuery::Optional));
query.endWhere();
QStringList orderByBindings;
QList<MediaQuery::Order> order;
if (groupByCategoryType.isEmpty()) {
orderByBindings.append(mediaVocabulary.ratingBinding());
order.append(MediaQuery::Descending);
orderByBindings.append(mediaVocabulary.playCountBinding());
order.append(MediaQuery::Descending);
} else {
orderByBindings.append(QString("%1_sum").arg(mediaVocabulary.ratingBinding()));
order.append(MediaQuery::Descending);
order.append(MediaQuery::Descending);
}
query.orderBy(orderByBindings, order);
Soprano::QueryResultIterator it = query.executeSelect(m_mainModel);
//Build media list from results
while( it.next() ) {
if (m_stop) {
return;
}
MediaItem mediaItem;
if (groupByCategoryType.isEmpty()) {
Nepomuk::Resource res = Nepomuk::Resource(it.binding(mediaVocabulary.mediaResourceBinding()).uri());
mediaItem = Utilities::mediaItemFromNepomuk(res, m_mediaListProperties.lri);
} else {
mediaItem = Utilities::categoryMediaItemFromIterator(it, groupByCategoryType, m_mediaListProperties.lri);
int sum = it.binding(QString("%1_sum").arg(mediaVocabulary.ratingBinding())).literal().toInt();
int count = it.binding(QString("%1_count").arg(mediaVocabulary.ratingBinding())).literal().toInt();
int rating = sum/count;
mediaItem.fields["rating"] = rating;
}
if (!mediaItem.url.startsWith("nepomuk:/")) {
if ((ignoreZeros && mediaItem.fields["rating"].toInt() > 0) ||
!ignoreZeros) {
if (groupByCategoryType == "AudioGenre") {
addUniqueGenreGroup("rating", mediaItem, &mediaList, originalGenreLimit);
} else {
mediaList.append(mediaItem);
}
}
}
}
m_mediaListProperties.name = i18n("Highest Rated");
m_mediaListProperties.type = QString("Sources");
}
}
if (engineArg.toLower() == "recentlyadded") {
mediaList.clear();
if (!mediaType.isEmpty()) {
MediaQuery query;
QStringList bindings;
bindings.append(mediaVocabulary.mediaResourceBinding());
bindings.append("added");
query.select(bindings, MediaQuery::Distinct);
query.startWhere();
query.addCondition("graph ?g { ");
if (mediaType == "audio") {
query.addCondition(mediaVocabulary.hasTypeAnyAudio(MediaQuery::Required));
} else if (mediaType == "video") {
query.addCondition(mediaVocabulary.hasTypeAnyVideo(MediaQuery::Required));
}
query.addLRIFilterConditions(engineFilterList, mediaVocabulary);
query.addCondition("} ");
query.addCondition("?g nao:created ?added . ");
query.endWhere();
QStringList orderByBindings;
QList<MediaQuery::Order> order;
orderByBindings.append("added");
order.append(MediaQuery::Descending);
query.orderBy(orderByBindings, order);
Soprano::QueryResultIterator it = query.executeSelect(m_mainModel);
//Build media list from results
while( it.next() ) {
if (m_stop) {
return;
}
MediaItem mediaItem;
QDateTime added = it.binding("added").literal().toDateTime();
Nepomuk::Resource res = Nepomuk::Resource(it.binding(mediaVocabulary.mediaResourceBinding()).uri());
mediaItem = Utilities::mediaItemFromNepomuk(res, m_mediaListProperties.lri);
mediaItem.semanticComment = i18nc("for example, added 3 days ago", "added %1", Utilities::wordsForTimeSince(added));
if (!mediaItem.url.startsWith("nepomuk:/")) {
mediaList.append(mediaItem);
}
}
m_mediaListProperties.name = i18n("Recently Added");
m_mediaListProperties.type = QString("Sources");
}
}
}
emit results(m_requestSignature, mediaList, m_mediaListProperties, true, m_subRequestSignature);
//Check if MediaItems in mediaList exist
QList<MediaItem> mediaItems = Utilities::mediaItemsDontExist(mediaList);
if (mediaItems.count() > 0) {
emit updateMediaItems(mediaItems);
} else {
//Get any remaining metadata for mediaItems
if (mediaType == "video") {
for (int i = 0; i < mediaList.count(); i++) {
if (m_stop) {
return;
}
MediaItem mediaItem = Utilities::completeMediaItem(mediaList.at(i));
emit updateMediaItem(mediaItem);
}
}
}
m_requestSignature = QString();
m_subRequestSignature = QString();
}