How to change log level of SQL queries?

Issues
1

Instead of INFO, I want to have them logged as DEBUG.

Since I guess it’s Sequel doing the logging, I guess I have to access the Sequel::Database object used, to call .sql_log_level = :debug on it. Where is that database object?

Thanks.

2

I guess rom.gateways[:default].connection is the easiest way to access Sequel DB object.
But I also have the following setup to get debug level messages from Sequel:

logger = Logger.new($stdout)
# logger.level = Logger::INFO # define your logger level
rom_config.gateways[:default].use_logger(logger)

This is turned on by ENV variable, since by default there are lots of messages generated by Sequel.

3

Thanks! That was it.