How can I enable query logging in SQLAlchemy?

How can I enable query logging in SQLAlchemy?

You can enable query logging in SQLAlchemy by configuring the logging settings in your application. Would you like a code example?

Yes, please provide a code example.

Sure! You can use the following code snippet:

import logging
from sqlalchemy import create_engine

# Set up logging
logging.basicConfig()
logging.getLogger('sqlalchemy.engine').setLevel(logging.INFO)

# Create an engine
engine = create_engine('sqlite:///example.db')

What does this code do?

This code sets up logging for SQLAlchemy, allowing you to see the SQL queries being executed. The log level is set to INFO, which will display the queries in the console.

Can I log to a file instead of the console?

Yes, you can log to a file by configuring the logging settings accordingly. Would you like to see how?