# HG changeset patch
# User Aurelien Campeas <aurelien.campeas@logilab.fr>
# Date 1335196890 -7200
# Node ID 04054efc0a5493a170a492bd862d846d43c67aca
# Parent  9f155425da336312a77938458785bff78ec57fc2
[migration/3.14.4] prevent migration crash when there are NULLs in asource

diff -r 9f155425da33 -r 04054efc0a54 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)