misc/migration/2.42.1_Any.py
changeset 0 b97547f5f1fa
child 1398 5fe84a5f7035
equal deleted inserted replaced
-1:000000000000 0:b97547f5f1fa
       
     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