author | Sylvain Thénault <sylvain.thenault@logilab.fr> |
Tue, 15 May 2012 14:44:45 +0200 | |
changeset 8409 | 79534887943e |
parent 8375 | 7d8979176bc0 |
child 9450 | af4b93bc38a5 |
permissions | -rw-r--r-- |
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) |