cleanDb() Code for MySql systems only?

[HebisJC]

EBackJob->cleanDb() doesn't work for me on SQLite. The problem here seems to be the following line, uses code which is not fully compatible on other DB-Systems: $historyStart = "DATE_SUB(NOW(), INTERVAL :history DAY)";

This solution worked for me:

$driver = Yii::app()->getComponent($this->databaseComponent)->getDriverName();
       
 switch ($driver) {
     case 'sqlite':
         $historyStart = "datetime('now', '-' || :history || ' days')";
         break;
     case 'pgsql':
         $historyStart = "CURRENT_TIMESTAMP - (:history || ' days')::interval";
         break;
     default:
         $historyStart = "DATE_SUB(NOW(), INTERVAL :history DAY)";
 }

Version: v0.65.1