From e1fa04e8ae60a8f35aefb147704f95b703fb8a42 Mon Sep 17 00:00:00 2001 From: olivier Date: Tue, 9 Jun 2009 15:44:31 +0000 Subject: [PATCH] migration: add collector_is_creator flag migrator git-svn-id: http://svn.parisson.org/svn/crem@92 3bf09e05-f825-4182-b9bc-eedd7160adf0 --- trunk/import/migration/tasks/collections.py | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/trunk/import/migration/tasks/collections.py b/trunk/import/migration/tasks/collections.py index 2d39782..999ccb5 100644 --- a/trunk/import/migration/tasks/collections.py +++ b/trunk/import/migration/tasks/collections.py @@ -453,3 +453,17 @@ class CollectionsYearConverter(DataMigrator): self.target_cursor.execute("UPDATE media_collections SET recorded_from_year = %s, " "recorded_to_year = %s WHERE old_code = %s", (from_year, to_year, old_code)) + +class CollectionsCollectorNormalizer(DataMigrator): + """Migrate collector_is_creator flag""" + + implements(IDataMigrator) + + def get_name(self): + return "collections:collector" + + def process(self): + self.target_cursor.execute("UPDATE media_collections SET collector_is_creator = 0") + self.target_cursor.execute("UPDATE media_collections SET collector_is_creator = (collector IN ('=', '=+N', 'ID' 'ID.' 'IDE.' 'IDEM'))") + self.stats['flagged'] = self.target_cursor.rowcount + -- 2.39.5