misc/migration/3.14.4_Any.py
author Julien Cristau <julien.cristau@logilab.fr>
Wed, 05 Feb 2014 16:34:21 +0100
branchstable
changeset 9523 cd5738fc440f
parent 8375 7d8979176bc0
child 9450 af4b93bc38a5
permissions -rw-r--r--
[ajax] use a custom tag to handle dynamically loaded js Using <pre class="script"> makes it trivial for a malicious user to inject arbitrary javascript into a html or rest text element (because it looks innocent to the html sanitizer). Using a custom tag we can be sure that it actually comes from our code and not from untrusted user data. IE ignores custom tags, though, so we put it in its own namespace. https://extranet.logilab.fr/1530578
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)