easyswoole事务mysql_easyswoole事务操作

easyswoole开启事务其实和原生sql一样,首先我们安装easyswoole的mysqli-pool组件:composer require easyswoole/mysqli-pool

在dev.php添加配置:&＃39;MYSQL&＃39;         &＃61;> [

&＃39;host&＃39;                 &＃61;> &＃39;&＃39;,

&＃39;port&＃39;                 &＃61;> 3306,

&＃39;user&＃39;                 &＃61;> &＃39;&＃39;,

&＃39;password&＃39;             &＃61;> &＃39;&＃39;,

&＃39;database&＃39;             &＃61;> &＃39;&＃39;,

&＃39;timeout&＃39;              &＃61;> 30,

&＃39;charset&＃39;              &＃61;> &＃39;utf8mb4&＃39;,

&＃39;connect_timeout&＃39;      &＃61;> &＃39;5&＃39;,//连接超时时间

],

主进程注册

一般的&＃xff0c;我们在EasySwoole的全局initialize 事件中&＃xff0c;进行注册use EasySwoole\EasySwoole\Config as GConfig;

use EasySwoole\MysqliPool\Mysql;

use EasySwoole\Mysqli\Config;

$configData &＃61; GConfig::getInstance()->getConf(&＃39;MYSQL&＃39;);

$config &＃61; new Config($configData);

/**

这里注册的名字叫mysql&＃xff0c;你可以注册多个&＃xff0c;比如mysql2,mysql3

*/

$poolConf &＃61; Mysql::getInstance()->register(&＃39;mysql&＃39;,$config);

//$poolConf->setMaxObjectNum($configData[&＃39;maxObjectNum&＃39;]);

//$poolConf->setMinObjectNum($configData[&＃39;minObjectNum&＃39;]);

调用mysqli操作事务$db &＃61; \EasySwoole\MysqliPool\Mysql::defer(&＃39;mysql&＃39;);

$db->startTransaction();

$db->commit();

$db->rollback();