1 from yams import schema2sql as y2sql

     2 

     3 dbhelper = repo.system_source.dbhelper

     4 rdefdef = schema['CWSource'].rdef('name')

     5 attrtype = y2sql.type_from_constraints(dbhelper, rdefdef.object, rdefdef.constraints).split()[0]

     6 

     7 cursor = session.cnxset.cu

     8 sql('UPDATE entities SET asource = source WHERE asource is NULL')

     9 dbhelper.change_col_type(cursor, 'entities', 'asource', attrtype, False)

    10 dbhelper.change_col_type(cursor, 'entities', 'source', attrtype, False)