| author | Vincent Michel <vincent.michel@logilab.fr> |
| Tue, 10 Apr 2012 17:09:04 +0200 | |
| changeset 8352 | 0e3b41118631 |
| parent 8263 | a73ad255ff63 |
| child 8374 | 04054efc0a54 |
| 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'] |
|
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
|
8 |
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
|
9 |
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
|
10 |
dbhelper.change_col_type(cursor, 'deleted_entities', 'source', attrtype, False) |