How to override log_time format of DbTarget (logging)

gvanto · June 22, 2016, 3:04am

I’d like to use MySQL DateTime format for storing log_time column in log table

(kind of agreeing with mike here: https://github.com/yiisoft/yii2/issues/7384#issuecomment-75506396 )

Is there a hook to override the format where the DbTarget ( http://www.yiiframework.com/doc-2.0/yii-log-dbtarget.html ) writes this value or should I create a child class and override some method?

Thanks for help,

gvanto

amnah · June 23, 2016, 1:29am

Looks like you have to create a child class, as there is no direct hook/variable to change.

github.com

yiisoft/yii2/blob/master/framework/log/DbTarget.php#L67-L83


if ($this->db->getTransaction()) {
    // create new database connection, if there is an open transaction
    // to ensure insert statement is not affected by a rollback
    $this->db = clone $this->db;
}


$tableName = $this->db->quoteTableName($this->logTable);
$sql = "INSERT INTO $tableName ([[level]], [[category]], [[log_time]], [[prefix]], [[message]])
        VALUES (:level, :category, :log_time, :prefix, :message)";
$command = $this->db->createCommand($sql);
foreach ($this->messages as $message) {
    list($text, $level, $category, $timestamp) = $message;
    if (!is_string($text)) {
        // exceptions may not be serializable if in the call stack somewhere is a Closure
        if ($text instanceof \Throwable || $text instanceof \Exception) {
            $text = (string) $text;
        } else {

gvanto · June 24, 2016, 5:29am

Cool thanks amnah, yeah I’ll look into this.

I don’t need micro-precision log timing - no yet anyway - so prefer easily-readable timestamp values!