时间戳

首页 > 解决方案 > 从 sqlalchemy 完全禁用日志

python - 从 sqlalchemy 完全禁用日志

问题描述

我正在尝试完全关闭 sqlalchemy 的注销。我正在为 Flask 创建一个自定义日志记录框架，并且来自 sqlalchemy/engine/base.py、sqlalchemy/engine/impl.py 的错误不断出现。我尝试这样做：logging.getLogger('SQLAlchemy.pool.base').addHandler(logging.NullHandler()) 和 logging.getLogger('SQLAlchemy.pool.impl').addHandler(logging.NullHandler())

但它们没有起作用，因为它们传统上没有利用 python 日志记录。而不是让logger=logging.getLogger(__name__)他们从库中的日志文件导入，所以我然后尝试：

logging.getLogger('sqlalchemy.log').addHandler(logging.NullHandler())相反，但这也不起作用。

我尝试了以下方法，但也没有成功：

如何完全关闭 sqlalchemy 注销

https://docs.sqlalchemy.org/en/14/core/engines.html#more-on-the-echo-flag

这是代码：

from sqlalchemy import create_engine
from snowflake.sqlalchemy import URL

@app.route("/")
@app.route("/home")
def home():
    engine = create_engine('snowflake://{user}:{password}@{account}/'.format(user='user-name', password='password', account='account'), echo=False, echo_pool=False)

    try:
        connection = engine.connect()
        results = connection.execute('select current_version()').fetchone()
        print(results[0])
        connection.close()
    finally:
        engine.dispose()

    return render_template('home.html', posts=posts)

这是错误：

raceback (most recent call last):
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 606, in __connect
    pool.logger.debug("Created new connection %r", connection)
TypeError: debug() takes 1 positional argument but 3 were given

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "sample_projects/app.py", line 69, in home
    connection = engine.connect()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3165, in connect
    return self._connection_cls(self, close_with_result=close_with_result)
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
    else engine.raw_connection()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3244, in raw_connection
    return self._wrap_pool_connect(self.pool.connect, _connection)
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
    return fn()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
    return _ConnectionFairy._checkout(self)
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 425, in checkout
    rec = pool._do_get()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
    self._dec_overflow()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
    return self._create_connection()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 253, in _create_connection
    return _ConnectionRecord(self)
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 368, in __init__
    self.__connect()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 84, in __exit__
    compat.raise_(value, with_traceback=traceback)
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
    pool.logger.debug("Error on connect(): %s", e)
TypeError: debug() takes 1 positional argument but 3 were given

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "sample_projects/env/lib/python3.8/site-packages/flask/app.py", line 2088, in __call__
    return self.wsgi_app(environ, start_response)
  File "sample_projects/env/lib/python3.8/site-packages/flask/app.py", line 2073, in wsgi_app
    response = self.handle_exception(e)
  File "sample_projects/env/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
    response = self.full_dispatch_request()
  File "sample_projects/env/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "sample_projects/env/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
    rv = self.dispatch_request()
  File "sample_projects/env/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
  File "sample_projects/app.py", line 76, in home
    engine.dispose()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2920, in dispose
    self.pool.dispose()
  File "sample_projects/env/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 195, in dispose
    self.logger.info("Pool disposed. %s", self.status())
TypeError: info() takes 1 positional argument but 3 were given

我将不胜感激您可能拥有的任何见解。如果我忘记解决某些问题，请向我提问。谢谢你读到这里哈哈！

标签： pythonloggingsqlalchemy

解决方案

以下内容不起作用，因为您要在现有处理程序之上添加处理程序。

logger = logging.getLogger('sqlalchemy')
logger.addHandler(logging.NullHandler())  # creates an additional log handler

您真正想要做的是修改现有的处理程序。

logger = logging.getLogger('sqlalchemy')
logger.setLevel(logging.ERROR)  # modifies the current log handler

推荐阅读