diff -r 1bb43e31032d -r a14b6562082b misc/migration/3.14.4_Any.py --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/misc/migration/3.14.4_Any.py Tue Jul 10 15:07:23 2012 +0200 @@ -0,0 +1,11 @@ +from yams import schema2sql as y2sql + +dbhelper = repo.system_source.dbhelper +rdefdef = schema['CWSource'].rdef('name') +attrtype = y2sql.type_from_constraints(dbhelper, rdefdef.object, rdefdef.constraints).split()[0] + +cursor = session.cnxset['system'] +sql('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)