misc/migration/2.42.1_Any.py
author Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
Tue, 17 Feb 2009 22:25:16 +0100
branchtls-sprint
changeset 711 f758b86cf484
parent 0 b97547f5f1fa
child 1398 5fe84a5f7035
permissions -rw-r--r--
Selector objects need to provide a `func_name` attribute for minimum (backward) compatibilit with selectors defined as functions

if confirm('remove deprecated database constraints?'):
    execute = session.system_sql
    session.set_pool()
    dbhelper = session.pool.source('system').dbhelper
    cu = session.pool['system']
    for table in dbhelper.list_tables(cu):
        if table.endswith('_relation'):
            try:
                execute('ALTER TABLE %s DROP CONSTRAINT %s_fkey1' % (table, table))
                execute('ALTER TABLE %s DROP CONSTRAINT %s_fkey2' % (table, table))
            except:
                continue
    checkpoint()

if 'inline_view' in schema:
    # inline_view attribute should have been deleted for a while now....
    drop_attribute('ENFRDef', 'inline_view')