misc/migration/3.14.4_Any.py
author Julien Cristau <julien.cristau@logilab.fr>
Fri, 18 Apr 2014 14:25:36 +0200
changeset 9686 9a04e48e780b
parent 9463 d62e13eba033
child 10200 cceb2c7c02f4
permissions -rw-r--r--
[migration] set a cnxset before process_script() Not pretty, but I don't have a better idea right now and this at least ensures migration scripts get run in the expected environment and can access sql stuff as before.

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)