From 14770c5d3de7a68a444e8ab47f369b06d92a2b5e Mon Sep 17 00:00:00 2001 From: Jens Georg Date: Sun, 15 Aug 2010 18:08:13 +0300 Subject: [PATCH] media-export: Fix database upgrade to v10 --- .../media-export/rygel-media-export-media-cache-upgrader.vala | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala b/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala index 2c51ac1..bada741 100644 --- a/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala +++ b/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala @@ -283,6 +283,8 @@ internal class Rygel.MediaExport.MediaCacheUpgrader { try { var queue = new LinkedList (); this.database.begin (); + this.database.exec ("DELETE FROM Object WHERE upnp_id LIKE '" + + QueryContainer.PREFIX + "%'"); this.database.exec ("DROP TRIGGER trgr_update_closure"); this.database.exec ("DROP TRIGGER trgr_delete_closure"); this.database.exec ("DROP INDEX idx_parent"); @@ -312,6 +314,8 @@ internal class Rygel.MediaExport.MediaCacheUpgrader { this.database.exec ("DELETE FROM Object"); this.database.exec (this.sql.make (SQLString.TABLE_CLOSURE)); this.database.exec (this.sql.make (SQLString.TRIGGER_CLOSURE)); + this.database.exec ("INSERT INTO Closure (ancestor, descendant, " + + "depth) VALUES ('0','0',0)"); queue.offer ("0"); while (!queue.is_empty) { GLib.Value[] args = { queue.poll () }; @@ -331,6 +335,7 @@ internal class Rygel.MediaExport.MediaCacheUpgrader { this.database.exec ("ALTER TABLE _Object RENAME TO Object"); database.exec (this.sql.make (SQLString.INDEX_COMMON)); database.exec (this.sql.make (SQLString.TRIGGER_COMMON)); + this.database.exec (this.sql.make (SQLString.TRIGGER_CLOSURE)); database.exec ("UPDATE schema_info SET version = '10'"); database.commit (); database.exec ("VACUUM"); -- 2.7.4