Python Forum
SQLAlchemy, log only one record from failed insert
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQLAlchemy, log only one record from failed insert
#1
Hello, sometimes I can find in logs following long tracebacks:

... (part of Traceback is skipped) ...
"/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py\", line 948, in execute\n    return meth(self, multiparams, params)\n
... (part of Traceback is skipped) ...
File \"/usr/local/lib/python3.6/site-packages/mysql/connector/connection.py\", line 396, in _handle_result\n    raise errors.get_exception(packet)\nsqlalchemy.exc.DataError: (mysql.connector.errors.DataError) 1264 (22003): Out of range value for column 'tlm_1' at row 722
... Then goes very long sql query with inserting hundreds of records ...
Structure of query:
INSERT INTO <table> <fields> VALUES (<row1>, <row2>, ... )
The question is: is there any possibility to log only record (row) which is failed and not whole query with almost 200 rows?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Record audio from the browser uppie83 1 4,109 Jun-04-2020, 11:20 AM
Last Post: Larz60+
  Flask-SqlAlchemy - Relationship failed to locate a name - Please Help howardrwb 0 5,148 Jan-31-2020, 08:38 PM
Last Post: howardrwb

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020