equal
deleted
inserted
replaced
|
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.... |
|
17 drop_attribute('ENFRDef', 'inline_view') |
|
18 |