| author | Julien Cristau <julien.cristau@logilab.fr> |
| Wed, 02 Apr 2014 12:44:57 +0200 | |
| changeset 9642 | 9a42eaeea263 |
| parent 9463 | d62e13eba033 |
| child 10200 | cceb2c7c02f4 |
| permissions | -rw-r--r-- |
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.cu 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)