How to combine AR with DAO in Yii2?

Question

Yii

How to combine AR with DAO in Yii2?
Using ActiveRecord, I want to apply transactions that can only be done with DAO.
I learned what can be done, I don’t know how to do it.
Tell me how to register in the config and in the controller, so as not to hook AR.

Answer 1

I think this should help
https://github.com/yiisoft/yii2/blob/master/docs/g...

$db = Post::getDb();
$db->transaction(function($db) {
    $db->createCommand($sql1)->execute();
    $db->createCommand($sql2)->execute();
    // ... executing other SQL statements ...
});

Answer 2

If you want to use transactions when saving the model, then you need to override the transaction method in the model class

Answer 3

So you would have asked the one who said that you can.