misc/migration/3.9.5_Any.py
author Julien Cristau <julien.cristau@logilab.fr>
Mon, 06 Jul 2015 17:39:35 +0200
changeset 10490 76ab3c71aff2
parent 6105 a648c832da1f
permissions -rw-r--r--
[migration/3.21.0] performance and reliability fixes - use EXCEPT instead of NOT IN, seems to improve performance dramatically on postgresql - delete rows from cw_<etype> tables whose eid is unknown - deal with missing/dangling required inline relations (by deleting the subject entities) instead of asserting - fix/improve print statements - don't ask for confirmation before running pure select queries

if not rql('CWConstraintType X WHERE X name "RQLUniqueConstraint"',
           ask_confirm=False):
    rql('INSERT CWConstraintType X: X name "RQLUniqueConstraint"',
        ask_confirm=False)