# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1278505312 -7200
# Node ID d9936c39d478b6701a4adef17bc28888ffa011c6
# Parent  654a34e4eb2e671115982c2dbc4532964588ea2e
[migration] new migration command to change fti weight for an entity t ype

diff -r 654a34e4eb2e -r d9936c39d478 server/migractions.py
--- a/server/migractions.py	Wed Jul 07 14:18:28 2010 +0200
+++ b/server/migractions.py	Wed Jul 07 14:21:52 2010 +0200
@@ -1246,6 +1246,13 @@
             self.commit()
         return entity
 
+    def cmd_update_etype_fti_weight(self, etype, weight):
+        if self.repo.system_source.dbdriver == 'postgres':
+            self.sqlexec('UPDATE appears SET weight=%(weight)s '
+                         'FROM entities as X '
+                         'WHERE X.eid=appears.uid AND X.type=%(type)s',
+                         {'type': etype, 'weight': weight}, ask_confirm=False)
+
     def cmd_reindex_entities(self, etypes=None):
         """force reindexaction of entities of the given types or of all
         indexable entity types