[migration/3.14.4] prevent migration crash when there are NULLs in asource stable
authorAurelien Campeas <aurelien.campeas@logilab.fr>
Mon, 23 Apr 2012 18:01:30 +0200
branchstable
changeset 8374 04054efc0a54
parent 8360 9f155425da33
child 8375 7d8979176bc0
[migration/3.14.4] prevent migration crash when there are NULLs in asource
misc/migration/3.14.4_Any.py
--- a/misc/migration/3.14.4_Any.py	Wed Apr 11 09:40:11 2012 +0200
+++ b/misc/migration/3.14.4_Any.py	Mon Apr 23 18:01:30 2012 +0200
@@ -5,6 +5,7 @@
 attrtype = y2sql.type_from_constraints(dbhelper, rdefdef.object, rdefdef.constraints).split()[0]
 
 cursor = session.cnxset['system']
+rql('UPDATE entities SET asource = source WHERE asource is NULL')
 dbhelper.change_col_type(cursor, 'entities', 'asource', attrtype, False)
 dbhelper.change_col_type(cursor, 'entities', 'source', attrtype, False)
 dbhelper.change_col_type(cursor, 'deleted_entities', 'source', attrtype, False)