misc/migration/3.14.4_Any.py
author Pierre-Yves David <pierre-yves.david@logilab.fr>
Mon, 24 Jun 2013 11:59:45 +0200
changeset 9033 614bf73cc126
parent 8375 7d8979176bc0
child 9450 af4b93bc38a5
permissions -rw-r--r--
[service] drop the asynchronous execution possibility Call_service was able of both sync and sync execution making the API confusing. There is not user of the async case. We drop the async argument in favor of synchronous execution only. This makes call_service the official API to call server side code from the client side. This is a remplacement for the usual monkey patching of the repo object. The zmq notification bus is a solid alternative for codes that needs to start an async execution.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
8205
14c52c5ee706 [entities system table] change asource and source column size (closes #1951819)
Alexandre Richardson <alexandre.richardson@logilab.fr>
parents:
diff changeset
     1
from yams import schema2sql as y2sql
14c52c5ee706 [entities system table] change asource and source column size (closes #1951819)
Alexandre Richardson <alexandre.richardson@logilab.fr>
parents:
diff changeset
     2
14c52c5ee706 [entities system table] change asource and source column size (closes #1951819)
Alexandre Richardson <alexandre.richardson@logilab.fr>
parents:
diff changeset
     3
dbhelper = repo.system_source.dbhelper
14c52c5ee706 [entities system table] change asource and source column size (closes #1951819)
Alexandre Richardson <alexandre.richardson@logilab.fr>
parents:
diff changeset
     4
rdefdef = schema['CWSource'].rdef('name')
14c52c5ee706 [entities system table] change asource and source column size (closes #1951819)
Alexandre Richardson <alexandre.richardson@logilab.fr>
parents:
diff changeset
     5
attrtype = y2sql.type_from_constraints(dbhelper, rdefdef.object, rdefdef.constraints).split()[0]
14c52c5ee706 [entities system table] change asource and source column size (closes #1951819)
Alexandre Richardson <alexandre.richardson@logilab.fr>
parents:
diff changeset
     6
8263
a73ad255ff63 [migration/3.14.4] use the right API else we break sqlserver instances (closes #2211248)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8205
diff changeset
     7
cursor = session.cnxset['system']
8375
7d8979176bc0 fix an horrible typo
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8374
diff changeset
     8
sql('UPDATE entities SET asource = source WHERE asource is NULL')
8263
a73ad255ff63 [migration/3.14.4] use the right API else we break sqlserver instances (closes #2211248)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8205
diff changeset
     9
dbhelper.change_col_type(cursor, 'entities', 'asource', attrtype, False)
a73ad255ff63 [migration/3.14.4] use the right API else we break sqlserver instances (closes #2211248)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8205
diff changeset
    10
dbhelper.change_col_type(cursor, 'entities', 'source', attrtype, False)
a73ad255ff63 [migration/3.14.4] use the right API else we break sqlserver instances (closes #2211248)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8205
diff changeset
    11
dbhelper.change_col_type(cursor, 'deleted_entities', 'source', attrtype, False)