nepomuk get videos rating

Database

Source i (link to git-repo or to original if based on someone elses unmodified work):

Add the source-code for this project on opencode.net

2
Become a Fan
5.7

Available as/for:
Description:
This script will search all the tv episodes and movies known to Nepomuk on your system, and update their rating property from either tvdb or tmdb

this script is an adaptation of the work done by Joerg Ehrichs (missingepisodechecker.py) as part of the webminer

I am new to python and sparql
improvements are very welcome

Enjoy,
Yehiel
Last changelog:

0.2 minor improvement in Nepomuk query.
when not forcing ratings update filter entries with rating property.

0.1 first release
update movies from tmdb
update tv episodes from tvdb


Ratings & Comments

12 Comments

bitcrazy

After running your script against 32 movies, no ratings were added, although your script states so. I guess, it should manipulate the star rating?

yehielb

yes it should. please attach the output if you can. in the mean time try to run the following query to see if the are rating values to your movies: 'select ?url ?rating where {?e a nmm:Movie. ?e nao:rating ?rating.?e nie:url ?url}'

bitcrazy

select ?e ?ShowName ?SeasonNumer ?EpisodeNumber ?url where {?e a nmm:TVShow.?e nie:url ?url .?e nmm:series ?series .?series nie:title ?ShowName .?e nmm:episodeNumber ?EpisodeNumber .?e nmm:season ?SeasonNumer .} 0 episodes were updated nepomukcmd query 'select ?e ?Title ?url where {?e a nmm:Movie.?e nie:url ?url .?e nie:title ?Title .}' searching for: Pink Floyd: Live at Pompeii url=file:///home/ds/MyVideos/Musik/Pink Floyd - Live At Pompeji.avi rating=0 title = Pink Floyd: Live at Pompeii online score = 8.9 unnamed app(2727)/nepomuk (library) Nepomuk::ResourceData::setProperty: "The name org.kde.nepomuk.DataManagement was not provided by any .service files" ---snip--- ---snap--- 32 movies were updated Same here: 32 movies are known to nepomuk and none gets a rating. Maybe I'm missing something from nepomuk? And I have webminer installed.

bitcrazy

nepomukcmd query 'select ?url ?rating where {?e a nmm:Movie. ?e nao:rating ?rating.?e nie:url ?url}' Total Results: 0 Execution Time: 00:00:00.11 Total Time: 00:00:00.22

yehielb

it seems like the line responsible for the error is: resource.setRating(int(round(score))) I don't know to tell you why it is not working. but please try the following in console: qdbus org.kde.NepomukStorage /datamanagement

bitcrazy

#>qdbus org.kde.NepomukStorage /datamanagement method void org.kde.nepomuk.DataManagement.addProperty(QString resource, QString property, QDBusVariant value, QString app) method void org.kde.nepomuk.DataManagement.addProperty(QStringList resources, QString property, QVariantList values, QString app) method void org.kde.nepomuk.DataManagement.clearCache() method QString org.kde.nepomuk.DataManagement.createResource(QString type, QString label, QString description, QString app) method QString org.kde.nepomuk.DataManagement.createResource(QStringList types, QString label, QString description, QString app) method QDBusRawType::a(sa{sv}) org.kde.nepomuk.DataManagement.describeResources(QStringList resources, int flags, QStringList targetParties) method QString org.kde.nepomuk.DataManagement.exportResources(QStringList resources, QString mimeType, int flags, QStringList targetParties) method void org.kde.nepomuk.DataManagement.importResources(QString url, QString serialization, int identificationMode, int flags, QString app) method void org.kde.nepomuk.DataManagement.importResources(QString url, QString serialization, int identificationMode, int flags, QVariantMap additionalMetadata, QString app) method void org.kde.nepomuk.DataManagement.mergeResources(QString resource1, QString resource2, QString app) method void org.kde.nepomuk.DataManagement.mergeResources(QStringList resources, QString app) method void org.kde.nepomuk.DataManagement.removeDataByApplication(QStringList resources, int flags, QString app) method void org.kde.nepomuk.DataManagement.removeDataByApplication(int flags, QString app) method void org.kde.nepomuk.DataManagement.removeProperties(QString resource, QString property, QString app) method void org.kde.nepomuk.DataManagement.removeProperties(QStringList resources, QStringList properties, QString app) method void org.kde.nepomuk.DataManagement.removeProperty(QString resource, QString property, QDBusVariant value, QString app) method void org.kde.nepomuk.DataManagement.removeProperty(QStringList resources, QString property, QVariantList values, QString app) method void org.kde.nepomuk.DataManagement.removeResources(QString resource, int flags, QString app) method void org.kde.nepomuk.DataManagement.removeResources(QStringList resources, int flags, QString app) method void org.kde.nepomuk.DataManagement.setProperty(QString resource, QString property, QDBusVariant value, QString app) method void org.kde.nepomuk.DataManagement.setProperty(QStringList resources, QString property, QVariantList values, QString app) method QDBusVariant org.freedesktop.DBus.Properties.Get(QString interface_name, QString property_name) method QVariantMap org.freedesktop.DBus.Properties.GetAll(QString interface_name) method void org.freedesktop.DBus.Properties.Set(QString interface_name, QString property_name, QDBusVariant value) method QString org.freedesktop.DBus.Introspectable.Introspect() method QString org.freedesktop.DBus.Peer.GetMachineId() method void org.freedesktop.DBus.Peer.Ping()

bitcrazy

Hello, take a look at the sql queries in the script. They are messed up, I guess

bitcrazy

Forget it. It is sparql. My fault.

yehielb

you remind me off my first response :) that was not so long ago...

yehielb

you remind me of my first response :) that was not so long ago...

overmind88

Which icontheme?

yehielb

Neon by FRUiT

Pling
0 Affiliates
Details
license
version 0.2
updated
added
downloads 24h 0
mediaviews 24h 0
pageviews 24h 1

More Database from yehielb:

Nepomuk set videos Duration
yehielb
last update date: 12 years ago

Score 5.7

Other Database:

Navicat (MySQL Manager)
navicat
last update date: 17 years ago

Score 4.7

Navicat (MySQL Manager)
navicat
last update date: 17 years ago

Score 4.7

konsultant
umeboshi
last update date: 20 years ago

Score 5.0

[idea] KRestaurantDB
pandarsson
last update date: 17 years ago

Score 5.0

LogMiles
vafada
last update date: 17 years ago

Score 5.0

PorDB3
hwm
last update date: 3 years ago

Score 5.7



System Tags