Zapisywanie logów do bazy danych

0

Chciałbym zapisywać logi do bazy danych - MariaDB
W tym celu zastosowałem model:
plik models.py

import sqlalchemy
from sqlalchemy import Column
from sqlalchemy.types import DateTime, Integer, String
from sqlalchemy.sql import func
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, relationship
import datetime


SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://logger:[email protected]/satelite_data_downloader_logs'
engine = sqlalchemy.create_engine(SQLALCHEMY_DATABASE_URI, echo=True)
DBSession = sessionmaker(bind=engine)
DBSession = DBSession()

Base = declarative_base()


class Log(Base):
    __tablename__ = 'logs'
    id = Column(Integer, primary_key=True,autoincrement=True)  # auto incrementing
    logger = Column(String(1000), index=True)  # the name of the logger. (e.g. myapp.views)
    level = Column(String(1000), index=True)  # info, debug, or error?
    trace = Column(String(1000), index=True)  # the full traceback printout
    msg = Column(String(1000), index=True)  # any custom log you may have included
    created_at = Column(DateTime(timezone=False), server_default=func.now(),
                        default=datetime.datetime.utcnow)  # the current timestamp

    def __init__(self, logger=None, level=None, trace=None, msg=None):
        self.logger = logger
        self.level = level
        self.trace = trace
        self.msg = msg

    def __unicode__(self):
        return self.__repr__()

    def __repr__(self):
        return "<Log: %s - %s>" % (self.created_at.strftime('%m/%d/%Y-%H:%M:%S'), self.msg[:50])

Base.metadata.create_all(bind=engine)

Następnie zrobiłem własne nadpisanie obsługi logów z biblioteki logger:
plik handler.py

import logging
import traceback
import sqlalchemy

from sqlalchemy import sql
from sqlalchemy import Column, MetaData
from sqlalchemy.types import DateTime, Integer, String
from sqlalchemy.sql import func, expression
from sqlalchemy.sql.expression import insert
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, relationship

import transaction

from models import Log, DBSession, Base, engine

class SQLAlchemyHandler(logging.Handler):
    # A very basic logger that commits a LogRecord to the SQL Db
    def emit(self, record):
        trace = None
        exc = record.__dict__['exc_info']
        if exc:
            trace = traceback.format_exc()
        log = Log(
            logger=record.__dict__['name'],
            level=record.__dict__['levelname'],
            trace=trace,
            msg=record.__dict__['msg'],)
        DBSession.add(log)
        DBSession.commit()

Na koniec próbuję przetestować wykonując:
plik init.py:

import logging

import models
import handlers
import views
from pyramid.config import Configurator
from models import DBSession, Base, engine

def main():
    logging.basicConfig(filename='log_tessadt.log')
    logging.getLogger('').addHandler(handlers.SQLAlchemyHandler())

    # Register MY_LOGGER
    log = logging.getLogger('MY_LOGGER')
    # create console handler and set level to debug
    ch = logging.StreamHandler()
    ch.setLevel(logging.DEBUG)

    # create formatter
    formatter = logging.Formatter('%(asctime)s - %(name)s - %(levelname)s - %(message)s')
    # add formatter to ch
    ch.setFormatter(formatter)

    # add ch to logger
    log.addHandler(ch)

    log.setLevel("DEBUG")
    log.debug('debug message')
    log.info('info message')
    log.warning('warn message')
    log.error('error message')
    log.critical('critical message')
    Base.metadata.create_all(bind=engine)
if __name__ == "__main__":
    main()

Otrzymuję błąd:

/usr/bin/python3.8 /home/zoz/Desktop/myapp/__init__.py
2020-08-05 13:46:53,370 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE 'sql_mode'
2020-08-05 13:46:53,370 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,372 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE 'lower_case_table_names'
2020-08-05 13:46:53,372 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,373 INFO sqlalchemy.engine.base.Engine SELECT DATABASE()
2020-08-05 13:46:53,373 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,374 INFO sqlalchemy.engine.base.Engine show collation where `Charset` = 'utf8mb4' and `Collation` = 'utf8mb4_bin'
2020-08-05 13:46:53,374 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,375 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2020-08-05 13:46:53,375 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,376 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2020-08-05 13:46:53,376 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,376 INFO sqlalchemy.engine.base.Engine SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8mb4) COLLATE utf8mb4_bin AS anon_1
2020-08-05 13:46:53,376 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,378 INFO sqlalchemy.engine.base.Engine DESCRIBE `logs`
2020-08-05 13:46:53,378 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,378 INFO sqlalchemy.engine.base.Engine ROLLBACK
2020-08-05 13:46:53,379 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE logs (
	id INTEGER NOT NULL AUTO_INCREMENT, 
	logger VARCHAR(1000), 
	level VARCHAR(1000), 
	trace VARCHAR(1000), 
	msg VARCHAR(1000), 
	created_at DATETIME DEFAULT now(), 
	PRIMARY KEY (id)
)


2020-08-05 13:46:53,379 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,397 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,398 INFO sqlalchemy.engine.base.Engine CREATE INDEX ix_logs_level ON logs (level)
2020-08-05 13:46:53,398 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,409 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,410 INFO sqlalchemy.engine.base.Engine CREATE INDEX ix_logs_logger ON logs (logger)
2020-08-05 13:46:53,410 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,422 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,423 INFO sqlalchemy.engine.base.Engine CREATE INDEX ix_logs_trace ON logs (trace)
2020-08-05 13:46:53,423 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,433 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,433 INFO sqlalchemy.engine.base.Engine CREATE INDEX ix_logs_msg ON logs (msg)
2020-08-05 13:46:53,433 INFO sqlalchemy.engine.base.Engine {}
2020-08-05 13:46:53,445 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,729 - MY_LOGGER - DEBUG - debug message
/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py:2528: SAWarning: Usage of the 'Session.add()' operation is not currently supported within the execution stage of the flush process. Results may not be consistent.  Consider using alternative event listeners or connection-level operations instead.
  util.warn(
2020-08-05 13:46:53,731 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2020-08-05 13:46:53,732 INFO sqlalchemy.engine.base.Engine INSERT INTO logs (logger, level, trace, msg, created_at) VALUES (%(logger)s, %(level)s, %(trace)s, %(msg)s, %(created_at)s)
2020-08-05 13:46:53,733 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,733 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,733 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,733 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,733 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,733 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,733 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,733 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,734 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,735 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,736 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,737 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,738 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,739 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,740 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,741 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,741 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,741 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,741 INFO sqlalchemy.engine.base.Engine COMMIT
2020-08-05 13:46:53,741 INFO sqlalchemy.engine.base.Engine COMMIT
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2624, in _flush
    flush_context.execute()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
    rec.execute(self)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/unitofwork.py", line 586, in execute
    persistence.save_obj(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/persistence.py", line 239, in save_obj
    _emit_insert_statements(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/persistence.py", line 1135, in _emit_insert_statements
    result = cached_connections[connection].execute(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1127, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1235, in _execute_context
    self.engine.logger.info(statement)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 508, in commit
    t[1].commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1765, in commit
    self._do_commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1796, in _do_commit
    self.connection._commit_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 772, in _commit_impl
    self.engine.logger.info("COMMIT")
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 110, in info
    self.log(logging.INFO, msg, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/log.py", line 156, in log
    self.logger._log(level, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1575, in _log
    record = self.makeRecord(self.name, level, fn, lno, msg, args,
  File "/usr/lib/python3.8/logging/__init__.py", line 1544, in makeRecord
    rv = _logRecordFactory(name, level, fn, lno, msg, args, exc_info, func,
  File "/usr/lib/python3.8/logging/__init__.py", line 314, in __init__
    self.levelname = getLevelName(level)
  File "/usr/lib/python3.8/logging/__init__.py", line 134, in getLevelName
    result = _levelToName.get(level)
RecursionError: maximum recursion depth exceeded while calling a Python object

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/zoz/Desktop/myapp/__init__.py", line 35, in <module>
    main()
  File "/home/zoz/Desktop/myapp/__init__.py", line 28, in main
    log.debug('debug message')
  File "/usr/lib/python3.8/logging/__init__.py", line 1422, in debug
    self._log(DEBUG, msg, args, **kwargs)
  File "/usr/lib/python3.8/logging/__init__.py", line 1577, in _log
    self.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1587, in handle
    self.callHandlers(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 1649, in callHandlers
    hdlr.handle(record)
  File "/usr/lib/python3.8/logging/__init__.py", line 950, in handle
    self.emit(record)
  File "/home/zoz/Desktop/myapp/handlers.py", line 30, in emit
    DBSession.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 504, in commit
    self._prepare_impl()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 483, in _prepare_impl
    self.session.flush()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2523, in flush
    self._flush(objects)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2664, in _flush
    transaction.rollback(_capture_exception=True)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/langhelpers.py", line 81, in __exit__
    compat.raise_(value, with_traceback=traceback)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 178, in raise_
    raise exception
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 2664, in _flush
    transaction.rollback(_capture_exception=True)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 520, in rollback
    self._assert_active(prepared_ok=True, rollback_ok=True)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 305, in _assert_active
    raise sa_exc.ResourceClosedError(closed_msg)
sqlalchemy.exc.ResourceClosedError: This transaction is closed

Process finished with exit code 1

Korzystałem z poradnika:
https://docs.pylonsproject.org/projects/pyramid-cookbook/en/latest/logging/sqlalchemy_logger.html

0

A co tam mówi debugger?

0

Zależy jaki kryteria przykładasz do logów. Np wg wielu powinny być nie-do zarypania. Bazodanowy ze skomplikowaną algorytmiką moze taki nie być.
Np, jak "swój" żołnierz na filmie KRLD: CAŁY PODZIURAWIONY, ALE wykonał zadanie, zanim padł.

Ale to jak cchesz.

0

Unable to get repr for <class 'models.Log'>

Jaja, nawet debugować nie można. Sprawdź no tę nadpisana __repr__, czy to na pewno zwraca stringa (*Utwórz obiekt w konsoli). Na pewno tak Chcesz to robić? Jest cos takiego jak feather:
https://github.com/wesm/feather

0

Może jakaś walidacja na długość code snippetu ? :D Z godzinę skrolowałem.

0

from models import Log p = Log() print(p.repr()) Traceback (most recent call last): File "/opt/pycharm-2020.1.1/plugins/python/helpers/pydev/_pydevd_bundle/pydevd_exec2.py", line 3, in Exec exec(exp, >global_vars, local_vars) File "<input>", line 1, in <module> File "/home/zoz/Desktop/myapp/models.py", line 38, in repr return "<Log: %s - %s>" % (self.created_at.strftime('%m/%d/%Y-%H:%M:%S'), >self.msg[:50]) AttributeError: 'NoneType' object has no attribute 'strftime

Widzisz, poleciał null, Zmień ten __repr__, na cokolwiek użytecznego do debugu, żeby działało i wtedy debuguj, czemu to created_at jest nullem.

0

Dodałem w init self.created_at = datetime.datetime.now() nadal null

Nie, Zostaw jak było i to właśnie zdebuguj, co tam zwraca nulla.

1

Po dłubaniu tydzień nad tym zastanawiam się nad hodowlą owiec

Nie dziwne, skoiowałeś jakiś kod, którego nie rozumiesz, nie napisałeś żadnych testów do tego. Ale jest pdb, ustaw stack trace, tak, żeby zobaczyć co tam się dzieje w Log i napraw, to powinno zająć kilkanaście/dziesiąt minut, możliwe, że ten error z nieskończoną rekurencją zniknie.

0

Nie dziwne, skoiowałeś jakiś kod, którego nie rozumiesz, nie napisałeś żadnych testów do tego.

Skopiwałem bo chciałem szybko osiągnąć efekt.
Próbowałem go zrozumieć.
Testów napisać do tego nie umiem. Jedyne jakie mi przychodziły to po zapisaniu logu do bazy danych napisać sprawdzenie czy się dodał.

Ale jest pdb, ustaw stack trace, tak, żeby zobaczyć co tam się dzieje w Log i napraw, to powinno zająć kilkanaście/dziesiąt minut, możliwe, że ten error z nieskończoną rekurencją zniknie.

Do konstruktora przypisują się nulle

0

Testów napisać do tego nie umiem. Jedyne jakie mi przychodziły to po zapisaniu logu do bazy danych napisać sprawdzenie czy się dodał.

Jest co testować, np. czy obiekt się poprawnie utworzył.

Do konstruktora przypisują się nulle

Nic dziwnego skoro taki konstruktor:

    def __init__(self, logger=None, level=None, trace=None, msg=None):
        self.logger = logger
        self.level = level
        self.trace = trace
        self.msg = msg

Wołasz z domyślnymi nulami tak:

logging.getLogger('').addHandler(handlers.SQLAlchemyHandler())

Dlatego się właśnie testuje, chodziaż ręcznie czy wszystko OK. Co jednak nie wyjasnia dlaczego created_at też jest nullem, zdebuguj to właśnie, a potem się zastanów, co z tym initem.

1 użytkowników online, w tym zalogowanych: 0, gości: 1