История изменений
Исправление 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]