LINUX.ORG.RU

История изменений

Исправление scientistpython, (текущая версия) :

фигня какая то - не ловиться исключение, ни большое, ни маленькое:

from sqlalchemy.exc import IntegrityError

def insert(myTable: MyTable) -> None:
    with sessionScope() as session:
        try:
            session.add(myTable)
        except IntegrityError as e:
            print('pass duplicate')
        except Exception as e:
            print(e)
            raise

# ...
    myTable = MyTable(name='x', date='2021-04-30', count=22)
    insert(myTable)
IntegrityError: (psycopg2.IntegrityError) duplicate key value violates unique constraint "uniq_idx_1"
DETAIL:  Key (name, date)=(x, 2021-04-30) already exists.

Исходная версия scientistpython, :

фигня какая то - не ловиться исключение, ни большое, ни маленькое: [code=Python] from sqlalchemy.exc import IntegrityError

def insert(myTable: MyTable) -> None: with sessionScope() as session: try: session.add(myTable) except IntegrityError as e: print(‘pass duplicate’) except Exception as e: print(e) raise

myTable = MyTable(name='x', date='2021-04-30', count=22)
insert(myTable)

[/code]

[code] IntegrityError: (psycopg2.IntegrityError) duplicate key value violates unique constraint «uniq_idx_1» DETAIL: Key (name, date)=(x, 2021-04-30) already exists. [/code]