| author | Dimitri Papadopoulos <dimitri.papadopoulos@cea.fr> |
| Fri, 14 Feb 2014 12:03:20 +0100 | |
| changeset 9551 | cbc46f94081d |
| 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)