public function save()
{
$sql = "SET FOREIGN_KEY_CHECKS = 0;\n";
$sql .= "";
foreach ($this->data_after_validor as $key => $value) {
$sql .= sqlBuilder::createTruncateTableCommand($key);
$sql .= sqlBuilder::createInsertFromArray($value, $key);
}
$sql .= "\n\nSET FOREIGN_KEY_CHECKS = 1;\n";
$connection = Yii::app()->db;
$transaction = $connection->beginTransaction();
try {
TimezoneWork::set('UTC');
$command = $connection->createCommand($sql);
$command->execute();
$transaction->commit();
$this->result_success = true;
return true;
} catch (Exeption $e) {
$transaction->rollback();
$this->result_success = false;
}
return false;
// try{
// $count = $command->execute();
// $this->_logger->log(__METHOD__, array('count' => $count));
// } catch (Exception $e) {
// $this->_logger->log(__METHOD__,array('err' => $e->getMessage()));
// }
}
