log4perl.rootLogger = TRACE, app_screen, app_db

# configuration for screen appender
log4perl.appender.app_screen = Log::Log4perl::Appender::Screen
log4perl.appender.app_screen.layout = Log::Log4perl::Layout::PatternLayout
log4perl.appender.app_screen.layout.ConversionPattern = [%p] %m{indent}%n

# configuration for database logging
log4perl.appender.app_db = Log::Log4perl::Appender::DBI
log4perl.appender.app_db.datasource = sub { \
   require DBI; \
   my $connect_info = "dbi:SQLite:uri=file:log4perl.sqlite"; \
   my $dbh = DBI->connect($connect_info); \
   $dbh->do(' \
		CREATE TABLE IF NOT EXISTS log ( \
			priority, \
			message, \
			my_key \
		)' \
	); \
	$connect_info; \
}
log4perl.appender.app_db.sql = \
insert into log \
(priority, my_key, message) \
values (?, ?, ? ) \

log4perl.appender.app_db.params.1 = %p
log4perl.appender.app_db.params.2 = %X{MDC_key}
log4perl.appender.app_db.usePreparedStm = 1
log4perl.appender.app_db.warp_message = 0
log4perl.appender.app_db.attrs.f_encoding = utf8
log4perl.appender.app_db.layout =  Log::Log4perl::Layout::NoopLayout