diff options
| author | methodus <methodus@web.de> | 2012-10-22 01:27:07 +0200 |
|---|---|---|
| committer | methodus <methodus@web.de> | 2012-10-22 01:27:07 +0200 |
| commit | b419a39697be8257dfbdf26116ea022adf0da2e8 (patch) | |
| tree | 6e94c1021aeefa23f0d182dc77fdbd907dd69ad5 /media/mediaManager.cpp | |
| parent | 9709cd3325c3bc85013e3835324ce2bdeead3f51 (diff) | |
| download | vdr-plugin-upnp-b419a39697be8257dfbdf26116ea022adf0da2e8.tar.gz vdr-plugin-upnp-b419a39697be8257dfbdf26116ea022adf0da2e8.tar.bz2 | |
Further improvements to make seeking possible.
Diffstat (limited to 'media/mediaManager.cpp')
| -rw-r--r-- | media/mediaManager.cpp | 49 |
1 files changed, 34 insertions, 15 deletions
diff --git a/media/mediaManager.cpp b/media/mediaManager.cpp index 25e44f1..18f8255 100644 --- a/media/mediaManager.cpp +++ b/media/mediaManager.cpp @@ -797,26 +797,45 @@ bool cMediaManager::RefreshObject(cMetadata& metadata){ connection.beginTransaction(); - ss << "INSERT OR REPLACE INTO " << db::Metadata << " (" + ss << "INSERT OR IGNORE INTO " << db::Metadata << " (" << "`" << property::object::KEY_OBJECTID << "`," << "`" << property::object::KEY_PARENTID << "`," << "`" << property::object::KEY_TITLE << "`," << "`" << property::object::KEY_CLASS << "`," - << "`" << property::object::KEY_RESTRICTED << "`," - << "`" << property::object::KEY_CREATOR << "`," - << "`" << property::object::KEY_DESCRIPTION << "`," - << "`" << property::object::KEY_LONG_DESCRIPTION << "`," - << "`" << property::object::KEY_DATE << "`," - << "`" << property::object::KEY_LANGUAGE << "`," - << "`" << property::object::KEY_CHANNEL_NR << "`," - << "`" << property::object::KEY_CHANNEL_NAME << "`," - << "`" << property::object::KEY_SCHEDULED_START << "`," - << "`" << property::object::KEY_SCHEDULED_END << "`" + << "`" << property::object::KEY_RESTRICTED << "`" << ") VALUES (" - << ":objectID, :parentID, :title, :class, :restricted," - << ":creator, :description, :longDescription, :date," - << ":language, :channelNr, :channelName, :start, :end" - << ")"; + << ":objectID, :parentID, :title, :class, :restricted" + << "); "; + + tntdb::Statement insert = connection.prepare(ss.str()); + + insert.setString("objectID", objectID) + .setString("parentID", metadata.GetPropertyByKey(property::object::KEY_PARENTID).GetString()) + .setString("title", metadata.GetPropertyByKey(property::object::KEY_TITLE).GetString()) + .setString("class", metadata.GetPropertyByKey(property::object::KEY_CLASS).GetString()) + .setBool ("restricted", metadata.GetPropertyByKey(property::object::KEY_RESTRICTED).GetBoolean()) + .execute(); + + ss.str(string()); + + ss << "UPDATE " << db::Metadata << " SET " + << "`" << property::object::KEY_OBJECTID << "` = :objectID," + << "`" << property::object::KEY_PARENTID << "` = :parentID," + << "`" << property::object::KEY_TITLE << "` = :title," + << "`" << property::object::KEY_CLASS << "` = :class," + << "`" << property::object::KEY_RESTRICTED << "` = :restricted," + << "`" << property::object::KEY_CREATOR << "` = :creator," + << "`" << property::object::KEY_DESCRIPTION << "` = :description," + << "`" << property::object::KEY_LONG_DESCRIPTION << "` = :longDescription," + << "`" << property::object::KEY_DATE << "` = :date," + << "`" << property::object::KEY_LANGUAGE << "` = :language," + << "`" << property::object::KEY_CHANNEL_NR << "` = :channelNr," + << "`" << property::object::KEY_CHANNEL_NAME << "` = :channelName," + << "`" << property::object::KEY_SCHEDULED_START << "` = :start," + << "`" << property::object::KEY_SCHEDULED_END << "` = :end" + << " WHERE " + << "`" << property::object::KEY_OBJECTID << "` = :objectID" + << ";"; tntdb::Statement object = connection.prepare(ss.str()); |