Mercurial Mercurial > pub > hg > cubicweb / annotate
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc/migration/3.14.4_Any.py
author Sylvain Thénault <sylvain.thenault@logilab.fr>
Tue, 21 Jan 2014 17:34:31 +0100
changeset 9445 65d93a4fd11c
parent 8375 7d8979176bc0
child 9450 af4b93bc38a5
permissions -rw-r--r--
[multi-sources-removal] Drop pyrorql and zmqrql sources After a few years experementing "true" multi-sources, we're now moving to "copy-based" source à la datafeed. As pyro and zmq sources have no more known customers and the related code is in the way of future refactoring of cubicweb's core, we decided to drop support for those sources without backward compatibility. If you're still using a zmqrql or pyrorql source and you want to upgrade, ask support to move it to datafeed using a pre-3.19 version first. Related to #2919300 (first step)
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)














cubicweb