<?php require_once __DIR__ . '/bootstrap.php'; $client = new PgAsync\Client(["host" => "127.0.0.1", "port" => "5432", "user" => "matt", "database" => "matt"]); $jsonObserverFactory = function () { return new \Rx\Observer\CallbackObserver(function ($row) { echo json_encode($row) . "\n"; }, function ($err) { echo "ERROR: " . $err . "\n"; }, function () { echo "Complete."; }); }; $statement = $client->executeStatement("SELECT * FROM channel WHERE id = \$1", ['2', '3']); $statement->subscribe($jsonObserverFactory()); $insertStatement = $client->executeStatement("InSErT INTO channel(name, description) VALUES(\$1, \$2)", ['The name', null]); $insertStatement->subscribe($jsonObserverFactory()); $statement->subscribe($jsonObserverFactory());
<?php require_once __DIR__ . '/bootstrap.php'; $client = new \PgAsync\Client(["user" => "matt", "database" => "matt"]); $insert = $client->query("INSERT INTO channel(name, description) VALUES('SQ', 'SQ Insert')"); $select = $client->executeStatement("SELECT * FROM channel WHERE name = \$1", ['SQ']); $insert->concat($select)->count()->subscribe(new \Rx\Observer\CallbackObserver(function ($x) { echo json_encode($x) . "\n"; }));
<?php require_once __DIR__ . '/bootstrap.php'; $client = new PgAsync\Client(["host" => "127.0.0.1", "port" => "5432", "user" => "matt", "database" => "matt"]); $insert = $client->query("INSERT INTO channel(name, description) VALUES('Test Name', 'This was inserted using the PgAsync thing')"); $insert->subscribe(new \Rx\Observer\CallbackObserver(function ($row) { echo "Row on insert?\n"; var_dump($row); }, function ($e) { echo "Failed.\n"; }, function () { echo "INSERT Complete.\n"; })); $select = $client->query('SELECT * FROM channel'); $select->subscribe(new \Rx\Observer\CallbackObserver(function ($row) { var_dump($row); }, function ($e) { echo "Failed.\n"; }, function () { echo "SELECT complete.\n"; })); $timerCount = 0; \EventLoop\addPeriodicTimer(1, function ($timer) use($client, $select, &$timerCount) { echo "There are " . $client->getConnectionCount() . " connections. ({$timerCount})\n"; if ($timerCount < 3) { $select->subscribe(new \Rx\Observer\CallbackObserver(function ($row) { var_dump($row); }, function ($e) { echo "Failed.\n"; }, function () { echo "SELECT complete.\n";