author | Sylvain Thénault <sylvain.thenault@logilab.fr> |
Mon, 18 May 2009 19:50:54 +0200 | |
branch | stable |
changeset 1853 | b1e3d8355d65 |
parent 1802 | d628defebc17 |
child 1977 | 606923dff11b |
permissions | -rw-r--r-- |
0 | 1 |
if confirm('remove deprecated database constraints?'): |
2 |
execute = session.system_sql |
|
3 |
session.set_pool() |
|
4 |
dbhelper = session.pool.source('system').dbhelper |
|
5 |
cu = session.pool['system'] |
|
6 |
for table in dbhelper.list_tables(cu): |
|
7 |
if table.endswith('_relation'): |
|
8 |
try: |
|
9 |
execute('ALTER TABLE %s DROP CONSTRAINT %s_fkey1' % (table, table)) |
|
10 |
execute('ALTER TABLE %s DROP CONSTRAINT %s_fkey2' % (table, table)) |
|
11 |
except: |
|
12 |
continue |
|
13 |
checkpoint() |
|
14 |
||
15 |
if 'inline_view' in schema: |
|
16 |
# inline_view attribute should have been deleted for a while now.... |
|
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
0
diff
changeset
|
17 |
drop_attribute('CWRelation', 'inline_view') |
1802
d628defebc17
delete-trailing-whitespace + some copyright update
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
1398
diff
changeset
|
18 |