added Table::with()

[m6w6/pq-gateway] / lib / pq / Gateway / Table.php

diff --git a/lib/pq/Gateway/Table.php b/lib/pq/Gateway/Table.php
index 8fc85d7ad748ff68d816aa607afdf9fdfbc8cec1..a25b2ad3fd6e07008bf59f27caa56239293756ac 100644 (file)
--- a/lib/pq/Gateway/Table.php
+++ b/lib/pq/Gateway/Table.php
@@ -2,6 +2,7 @@
 
 namespace pq\Gateway;
 
+use \pq\Query\Expr as QueryExpr;
 use \pq\Query\Writer as QueryWriter;
 use \pq\Query\Executor as QueryExecutor;
 
@@ -47,6 +48,11 @@ class Table
         */
        protected $exec;
        
+       /**
+        * @var \pq\Gateway\Table\Identity
+        */
+       protected $identity;
+       
        /**
         * @var \pq\Gateway\Table\Relations
         */
@@ -57,6 +63,11 @@ class Table
         */
        protected $metadataCache;
        
+       /**
+        * @var \pq\Gateway\Table\LockInterface
+        */
+       protected $lock;
+       
        /**
         * @param string $table
         * @return \pq\Gateway\Table
@@ -78,8 +89,12 @@ class Table
         * @param \pq\Connection $conn
         * @param array $dependents
         */
-       function __construct($name, \pq\Connection $conn = null) {
-               $this->name = $name;
+       function __construct($name = null, \pq\Connection $conn = null) {
+               if (isset($name)) {
+                       $this->name = $name;
+               } elseif (!isset($this->name)) {
+                       throw new \InvalidArgumentException("Table must have a name");
+               }
                $this->conn = $conn ?: static::$defaultConnection ?: new \pq\Connection;
        }
        
@@ -179,6 +194,17 @@ class Table
                return $this;
        }
        
+       /**
+        * Get the primary key
+        * @return \pq\Gateway\Table\Identity
+        */
+       function getIdentity() {
+               if (!isset($this->identity)) {
+                       $this->identity = new Table\Identity($this);
+               }
+               return $this->identity;
+       }
+       
        /**
         * Get foreign key relations
         * @param string $to fkey
@@ -227,6 +253,24 @@ class Table
                return $this->name;
        }
 
+       /**
+        * Set a lock provider
+        * @param \pq\Gateway\Table\LockInterface $lock
+        * @return \pq\Gateway\Table
+        */
+       function setLock(Table\LockInterface $lock) {
+               $this->lock = $lock;
+               return $this;
+       }
+       
+       /**
+        * Get any set lock provider
+        * @return \pq\Gateway\Table\LockIntferace
+        */
+       function getLock() {
+               return $this->lock;
+       }
+       
        /**
         * Execute the query
         * @param \pq\Query\WriterInterface $query
@@ -262,9 +306,10 @@ class Table
         * @param array|string $order
         * @param int $limit
         * @param int $offset
+        * @param string $lock
         * @return mixed
         */
-       function find(array $where = null, $order = null, $limit = 0, $offset = 0) {
+       function find(array $where = null, $order = null, $limit = 0, $offset = 0, $lock = null) {
                $query = $this->getQueryWriter()->reset();
                $query->write("SELECT * FROM", $this->conn->quoteName($this->name));
                if ($where) {
@@ -276,7 +321,12 @@ class Table
                if ($limit) {
                        $query->write("LIMIT", $limit);
                }
-               $query->write("OFFSET", $offset);
+               if ($offset) {
+                       $query->write("OFFSET", $offset);
+               }
+               if ($lock) {
+                       $query->write("FOR", $lock);
+               }
                return $this->execute($query);
        }
        
@@ -293,7 +343,7 @@ class Table
                // select * from $this where $this->$foreignColumn = $foreign->$referencedColumn
                
                if (!isset($name)) {
-                       $name = $this->getName();
+                       $name = $foreign->getTable()->getName();
                }
                
                if (!$foreign->getTable()->hasRelation($name, $this->getName())) {
@@ -329,6 +379,42 @@ class Table
                        $order, $limit, $offset
                );
        }
+       
+       /**
+        * Get rows dependent on other rows by foreign keys
+        * @param array $relations
+        * @param array $where
+        * @param string $order
+        * @param int $limit
+        * @param int $offset
+        * @return mixed
+        */
+       function with(array $relations, array $where = null, $order = null, $limit = 0, $offset = 0) {
+               $qthis = $this->conn->quoteName($this->getName());
+               $query = $this->getQueryWriter()->reset();
+               $query->write("SELECT", "$qthis.*", "FROM", $qthis);
+               foreach ($relations as $relation) {
+                       $query->write("JOIN", $relation->foreignTable)->write("ON")->criteria(
+                               array(
+                                       "{$relation->referencedTable}.{$relation->referencedColumn}=" => 
+                                               new QueryExpr("{$relation->foreignTable}.{$relation->foreignColumn}")
+                               )
+                       );
+               }
+               if ($where) {
+                       $query->write("WHERE")->criteria($where);
+               }
+               if ($order) {
+                       $query->write("ORDER BY", $order);
+               }
+               if ($limit) {
+                       $query->write("LIMIT", $limit);
+               }
+               if ($offset) {
+                       $query->write("OFFSET", $offset);
+               }
+               return $this->execute($query);
+       }
 
        /**
         * Insert a row into the table