3 require "./pq/Query/Expr.php";
4 require "./pq/Query/Writer.php";
5 require "./pq/Gateway/Table.php";
6 require "./pq/Gateway/Rowset.php";
7 require "./pq/Gateway/Row.php";
8 require "./pq/Gateway/Cell.php";
10 class FooModel
extends \pq\Gateway\Table
{
11 function __construct(\pq\Connection
$c) {
12 parent
::__construct($c, "foo", "FooCollection");
16 class Foo
extends \pq\Gateway\Row
{
20 class FooCollection
extends \pq\Gateway\Rowset
{
21 function __construct(\pq\Gateway\Table
$table, \pq\Result
$result) {
22 parent
::__construct($table, $result, "Foo");
26 $conn = new \pq\Connection
;
27 $types = new \pq\
Types($conn);
28 $table = new FooModel($conn);
29 print_r( $table->find(array("dt" => new \pq\Query\
Expr("between %s and %s", $conn->quote("2013-03-01"), $conn->quote("2013-03-04")))) );
31 print_r( $table->find(array("id>" => 1, "OR" => array(array("id=" => 1), array("id="=>2)))));
33 print_r( $table->find(array("OR" => array("id>" => 1, "OR" => array(array("id=" => 1), array("id="=>2))))));
35 print_r( $table->create(array("data" => "blabla")) );
37 print_r( $table->create(array("data" => new \pq\Query\
Expr("DEFAULT"))) );
39 print_r( $table->update(array("id=" => 4), array("data" => "die 4")) );
41 print_r( $table->delete(array(new \pq\Query\
Expr("data is null"))) );