Swoole ?? ??: ???? ?? ?????? ??? ????? ?? ?? ??? ?????.

??:
??? ???? ??? ???? ??? ?? ???? ??? ??? ?????? ?? ? ?? ?????. Swoole? ???? ???? ???? ?? ?? ?????? ??? ???? ??? ???? ?????. ? ????? Swoole ???? ??? ?? ?????? ??? ???? ?? ? ?? ??? ???? ?? ?? ??? ?????.

1. ?? ? ??
?? ??? ?????? ?????? ??? ?? ???? ???? ?? ??? ??????. ??? ?? ??? ???? ?? ???? ??? ?????. ?? ?? ?? ?????? ??? ?????? ?????? ??? ???? ? ?? ?? ?? ? ?? ??? ???? ??? ?? ? ???? ?????.

??? Swoole? ???? ?????? ?? ?? ???? ?? ?????.

class ConnectionPool
{
    private static $instance;
    private $connections = [];

    private function __construct() {}
    private function __clone() {}

    public static function getInstance()
    {
        if (!self::$instance instanceof self) {
            self::$instance = new self();
        }
        return self::$instance;
    }

    public function getConnection()
    {
        if (!empty($this->connections)) {
            return array_pop($this->connections);
        } else {
            return $this->createConnection();
        }
    }

    public function releaseConnection($connection)
    {
        array_push($this->connections, $connection);
    }

    private function createConnection()
    {
        $connection = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
        return $connection;
    }
}

? ???? ConnectionPool ???? ??? ??? ???? ?? ?? ???? getInstance() ???? ???? ?????? ?? ?? ????? ????. ???. getConnection() ???? ?????? ??? ?? ? ?????. ?? ?? ?? ??? ??? ??? ??? ?? ????, ??? ??? ? ??? ?????. releaseConnection() ???? ??? ???? ?? ??? ?? ??? ?? ?? ?? ?? ? ?????.

2. ???
Swoole?? ???? ????? ???? ??? ??? ?? ?? ?? ??? ??? ? ?? ?? ??????. ?????? ??? ???? ???? ????? ??? ??? ???? ? ????.

??? Swoole? ???? ???? ?????? ??? ???? ?? ?????.

go(function() {
    $pdo = ConnectionPool::getInstance()->getConnection();
    $stmt = $pdo->prepare('SELECT * FROM users WHERE id = ?');
    $stmt->execute([1]);
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // 業(yè)務(wù)邏輯操作...
    
    ConnectionPool::getInstance()->releaseConnection($pdo);
});

? ???? go(function(){})? ???? ???? ????, ?????? ??? ??, ??? ??? ?? ??? ?????. , ?? ???? ?? ??? ?????. ????? releaseConnection() ???? ?? ??? ?? ?? ?? ?????.

3. ??? IO
?? ?????? ??? ?? ??? IO? ???? ??? ??? ?? ???? ? ????. Swoole? ?????? ??? ??? ??? ???? ??? ???? ???? ? ?? ??? IO ??? ?????.

??? Swoole? ??? IO? ???? ?????? ??? ???? ?? ?????.

go(function() {
    $mysql = new SwooleCoroutineMySQL();
    $pdo = ConnectionPool::getInstance()->getConnection();
    $mysql->connect([
        'host' => 'localhost',
        'user' => 'username',
        'password' => 'password',
        'database' => 'test'
    ]);
    $result = $mysql->query('SELECT * FROM users WHERE id = 1');

    // 業(yè)務(wù)邏輯操作...

    ConnectionPool::getInstance()->releaseConnection($pdo);
});

? ???? ?? SwooleCoroutineMySQL ????? ???? connect() ???? ?? ??????? ?????. ?? ?? query() ???? ???? ??? ?? ??? ???? ?? ??? ??? ? ?? ???? ?? ??? ?????. ????? releaseConnection() ???? ?? ??? ?? ?? ?? ?????.

??:
?? ? ??, ??? ? ??? IO? ?? ??? ??? ?? Swoole ???? ?? ??? ?????? ??? ???? ? ????. ? ???? ???? ?? ?? ??? ?? ??? ???? ????? ??? ??? ????. ??? ? ?? ??? ???? ????? ?? ??? ?? ???? ????? ???.

? ??? Swoole ?? ??: ?? ?????? ??? ???? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!