Custom log format for datasource-proxy

[fbeaufume]

Thank you for this library.

I'm looking for a way to use a custom format for datasource-proxy instead of the default Name:dataSource, Connection:8, Time:7, Success:True, Type:Prepared, ....

In datasource-proxy I think that it requires a custom QueryLogEntryCreator implementation.

I'd like to see a way in spring-boot-data-source-decorator to plug such bean, for example with:

@Bean
public QueryLogEntryCreator queryLogEntryCreator() {
    return new MyQueryLogEntryCreator();
}

Could this be done ? Or is there already a solution to customize the logs format ?

[gavlyukovskiy]

@fbeaufume listeners are created inside the ProxyDataSourceBuilder, which doesn't allow configuring QueryLogEntryCreator, but you can disable the default listeners:

decorator.datasource.datasource-proxy.query.enable-logging=false
decorator.datasource.datasource-proxy.slow-query.enable-logging=false

and declare query / slowQuery listeners yourself:

@Bean
public SLF4JQueryLoggingListener queryExecutionListener() {
    var listener = new SLF4JQueryLoggingListener();
    listener.setQueryLogEntryCreator(new MyQueryLogEntryCreator());
    return listener;
}

@Bean
public SLF4JSlowQueryListener slowQueryExecutionListener() {
    var listener = new SLF4JSlowQueryListener(30, TimeUnit.SECONDS);
    listener.setQueryLogEntryCreator(new MyQueryLogEntryCreator());
    return listener;
}

[fbeaufume]

Thank you for the suggestion.