public function testExecute()
{
try {
$async_mysql = new \Jenner\Mysql\Async();
$async_mysql->attach(['host' => '127.0.0.1', 'user' => 'root', 'password' => '', 'database' => 'test', 'port' => 3306], 'select ID,NAME from async');
$async_mysql->attach(['host' => '127.0.0.1', 'user' => 'root', 'password' => '', 'database' => 'test', 'port' => 3306], 'select ID,NAME from async');
$result = $async_mysql->execute(true);
$sync_result = $temp_result = array();
$mysql = mysqli_connect('127.0.0.1', 'root', '', 'test', 3306);
$temp = $mysql->query("select ID,NAME from async");
while (($row = $temp->fetch_assoc()) && ($temp_result[] = $row)) {
}
$sync_result[] = $temp_result;
$temp_result = array();
$temp = $mysql->query("select ID,NAME from async");
while (($row = $temp->fetch_assoc()) && ($temp_result[] = $row)) {
}
$sync_result[] = $temp_result;
$this->assertEquals($result, $sync_result);
} catch (Exception $e) {
echo $e->getMessage();
}
}
<?php
/**
* Created by PhpStorm.
* User: Jenner
* Date: 2015/7/20
* Time: 17:40
*/
require dirname(dirname(__FILE__)) . '/vendor/autoload.php';
try {
$async_mysql = new \Jenner\Mysql\Async();
$async_mysql->attach(['host' => '127.0.0.1', 'user' => 'root', 'password' => '', 'database' => 'test'], 'select * from stu');
$async_mysql->attach(['host' => '127.0.0.1', 'user' => 'root', 'password' => '', 'database' => 'test'], 'select * from stu limit 0, 3');
$result = $async_mysql->execute();
print_r($result);
} catch (Exception $e) {
echo $e->getMessage();
}
<?php
/**
* Created by PhpStorm.
* User: Jenner
* Date: 2015/7/23
* Time: 9:37
*/
require dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'vendor' . DIRECTORY_SEPARATOR . 'autoload.php';
$timer = new \Jenner\Timer(\Jenner\Timer::UNIT_KB);
$timer->mark("start");
for ($i = 0; $i < 10; $i++) {
try {
$async_mysql = new \Jenner\Mysql\Async();
$async_mysql->attach(['host' => '127.0.0.1', 'user' => 'root', 'password' => '', 'database' => 'test', 'port' => 3306], 'select ID, NAME from async');
$async_mysql->attach(['host' => '127.0.0.1', 'user' => 'root', 'password' => '', 'database' => 'test', 'port' => 3306], 'select ID, NAME from async');
$result = $async_mysql->execute();
} catch (Exception $e) {
echo $e->getMessage();
}
}
$timer->mark("stop");
$timer->printDiffReport();
