aliaspooryorik
coldbox.system.logging.appenders.DBAppender
from my ColdBox 6.5 app then the queries do not appear. I'm pretty sure this is due to cfdbinfo
use in DBAppender
. Our setup is MariaDB with ACF2018.cfdbinfo
that's doing it.DBAppender
as async so I don't know if that would cause that?rotatingDBAppender : {
levelMin : "FATAL",
levelMax : "DEBUG",
class : "coldbox.system.logging.appenders.DBAppender",
properties : {
async : true,
dsn : settings.dsn,
table : "tbllogbox",
autoCreate : false,
rotationDays : 7
}
},
DBAppender
uses cfdbinfo
to detect the DB engine and return the appropriate datatype.database_productName
be passed in as a property so the dialect doesn't need to be detected.wil-shiftinsert
03/15/2022, 12:43 PMaliaspooryorik
async
property is ignored. Must have got that from a doc / example somewhere.wil-shiftinsert
03/15/2022, 12:46 PMaliaspooryorik
component accessors="true" extends="coldbox.system.logging.appenders.DBAppender" {
private function getDateTimeDBType(){
return "cf_sql_timestamp";
}
private function getTextColumnType(){
return "LONGTEXT";
}
private function getDateTimeColumnType(){
return "DATETIME";
}
}
wil-shiftinsert
03/15/2022, 12:48 PMaliaspooryorik
dialect
property and then the cfdbinfo stuff can be largely skipped (it also uses it to create the table if missing but that can be done with a migration)wil-shiftinsert
03/15/2022, 12:57 PMaliaspooryorik
dialect
property would be nice to add to the one in ColdBox so it'll detect if that not set, else it'll use the dialect to get the appropriate datatype. I don't mind doing a PR if it's something that would be useful for others rather than just me!wil-shiftinsert
03/15/2022, 1:00 PMbdw429s
03/15/2022, 7:26 PMwil-shiftinsert
03/15/2022, 7:32 PMbdw429s
03/15/2022, 7:34 PMwil-shiftinsert
03/15/2022, 7:37 PM