migration/1.0.4_Any.py
author Julien Cristau <julien.cristau@logilab.fr>
Fri, 11 Jul 2014 16:51:03 +0200
changeset 1558 5446dd30aa14
parent 80 8abb3d6ee0a1
permissions -rw-r--r--
Added tag apycot-version-3.1.0, apycot-debian-version-3.1.0-1 for changeset a42ed51d1594

rql('DELETE CheckResultLog X')
checkpoint()
drop_attribute('CheckResultLog', 'severity')
add_attribute('CheckResultLog', 'severity')

sql('''CREATE FUNCTION severity_sort_value(text) RETURNS int
    AS 'return {"DEBUG": 0, "INFO": 10, "WARNING": 20, "ERROR": 30, "FATAL": 40}[args[0]]'
    LANGUAGE plpythonu;
''')
checkpoint()

synchronize_eschema('CheckResultLog')
synchronize_eschema('CheckResult')