| author | Alain Leufroy <alain.leufroy@logilab.fr> |
| Wed, 21 May 2014 16:14:17 +0200 | |
| branch | stable |
| changeset 9926 | 93a44cf0d030 |
| 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) |