From 23ab433b6b2db259d9c68b1e109b01b6275eed92 Mon Sep 17 00:00:00 2001
From: olivier <olivier@3bf09e05-f825-4182-b9bc-eedd7160adf0>
Date: Wed, 10 Feb 2010 12:58:09 +0000
Subject: [PATCH] add item title cleaner task

git-svn-id: http://svn.parisson.org/svn/crem@151 3bf09e05-f825-4182-b9bc-eedd7160adf0
---
 trunk/import/migration/tasks/items.py | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/trunk/import/migration/tasks/items.py b/trunk/import/migration/tasks/items.py
index 89961d2..ed07c59 100644
--- a/trunk/import/migration/tasks/items.py
+++ b/trunk/import/migration/tasks/items.py
@@ -330,6 +330,19 @@ class ItemsCollectorNormalizer(DataMigrator):
         self.step(2)
         self.end()
 
+class ItemsTitleCleaner(DataMigrator):
+    """Cleanup unsignificant items titles"""
+
+    implements(IDataMigrator)
+
+    def get_name(self):
+        return "items:title"
+
+    def process(self):
+        self.start()
+        self.target_cursor.execute("UPDATE media_items SET title = '' WHERE title REGEXP '^ *N *$'")
+        self.stats['emptied'] = self.target_cursor.rowcount
+        self.end()
 
             
         
-- 
2.39.5