php yii2 事物,yii2 多数据库 事务 跨数据库事务

1.配置：组件配置，db是默认的数据库库连接

'components' => [

'db' => [

'class' => 'yii\db\Connection',

'dsn' => 'mysql:host=localhost;dbname=erp',

'username' => 'root',

'password' => 'onfancy',

'charset' => 'utf8',

//'tablePrefix' => 'tbl_', 数据表前缀

],

'ebayDb' => [

'class' => 'yii\db\Connection',

'dsn' => 'mysql:host=localhost;dbname=erp_ebay',

'username' => 'root',

'password' => 'onfancy',

'charset' => 'utf8',

],

配置完成后，创建数据库  erp  erp_ebay

然后创建表：

erp.test

erp_ebay.test

2.创建activeRecord

namespace myapp\code\core\Erp\Sales\models;

use yii\db\ActiveRecord;

class Erptest extends ActiveRecord

{

public static function tableName()

{

return 'test';

}

}上面的代码，getDb默认使用db的配置

namespace myapp\code\core\Erp\Sales\models;

use yii\db\ActiveRecord;

class Ebaytest extends ActiveRecord

{

public static function getDb()

{

return \Yii::$app->ebayDb; // use the "db2" application component

}

public static function tableName()

{

return 'test';

}

}上面的代码：通过getDb获取上面配置的ebayDb的配置

然后就可以使用使用了

$innerTransaction = Yii::$app->db->beginTransaction();

try {

$erp_test = new Erptest();

$erp_test->class = 99;

$erp_test->age = 99;

$erp_test->live = 99;

$erp_test->save();

$Ebaytest = new Ebaytest();

$Ebaytest->age = 88;

$Ebaytest->name = 88;

$Ebaytest->live = 99;

$Ebaytest->save();

$data = Ebaytest::find()->asArray()->all();

foreach($data as $d){

var_dump($d);

}

$data = Erptest::find()->asArray()->all();

foreach($data as $d){

var_dump($d);

}

$innerTransaction->commit();

} catch (Exception $e) {

$innerTransaction->rollBack();

} 当第二条插入执行失败，mysql会回滚！