Account for new psycopg2 exception classes mapping From psycopg2 >= 2.8, specific exceptions are raised corresponding to postgresql errors. E.g. a CheckViolation exception is raised instead of a generic IntegrityError previously when a constraint violation occurs. The way we intercept database errors, especially for constraint violation, is not compliant with that because we do not catch subclasses of IntegrityError in native source's doexec() method. We fix this by checking for the presence of IntegrityError error in exception class's mro. This is still overcomplicated and clumsy, because we still use string comparison, but this is the best we can do as far as I know. (A better fix would be 'isinstance(ex, IntegrityError)' but we have no engine-independent error classes, so this is not possible. Something like sqlalchemy's DBAPI Errors [1] might help: https://docs.sqlalchemy.org/en/latest/errors.html#dbapi-errors)

     1

@echo off

     2

rem = """-*-Python-*- script

     3

rem -------------------- DOS section --------------------

     4

rem You could set PYTHONPATH or TK environment variables here

     5

python -x "%~f0" %*

     6

goto exit

     7

     8

"""

     9

# -------------------- Python section --------------------

    10

import sys

    11

from os.path import join, dirname, normpath

    12

sys.path.insert(0, normpath(join(dirname(__file__), '..', '..')))

    13

from cubicweb.cwctl import run

    14

run(sys.argv[1:])

    15

    16

DosExitLabel = """

    17

:exit

    18

rem """

    19

    20