*/
public static $defaultConnection;
+ /**
+ * @var callable
+ */
+ public static $defaultResolver;
+
+ /**
+ * @var \pq\Gateway\Table\CacheInterface
+ */
+ public static $defaultMetadataCache;
+
/**
* @var \pq\Connection
*/
* @var \pq\Query\ExecutorInterface
*/
protected $exec;
+
+ /**
+ * @var \pq\Gateway\Table\Identity
+ */
+ protected $identity;
+
+ /**
+ * @var \pq\Gateway\Table\Relations
+ */
+ protected $relations;
+
+ /**
+ * @var \pq\Gateway\Table\CacheInterface
+ */
+ protected $metadataCache;
+
+ /**
+ * @var \pq\Gateway\Table\LockInterface
+ */
+ protected $lock;
+
+ /**
+ * @param string $table
+ * @return \pq\Gateway\Table
+ */
+ public static function resolve($table) {
+ if ($table instanceof Table) {
+ return $table;
+ }
+ if (is_callable(static::$defaultResolver)) {
+ if (($resolved = call_user_func(static::$defaultResolver, $table))) {
+ return $resolved;
+ }
+ }
+ return new Table($table);
+ }
/**
* @param string $name
* @param \pq\Connection $conn
+ * @param array $dependents
*/
function __construct($name, \pq\Connection $conn = null) {
$this->name = $name;
$this->conn = $conn ?: static::$defaultConnection ?: new \pq\Connection;
}
+ /**
+ * Get the complete PostgreSQL connection string
+ * @return string
+ */
+ function __toString() {
+ return sprintf("postgresql://%s:%s@%s:%d/%s?%s#%s",
+ $this->conn->user,
+ $this->conn->pass,
+ $this->conn->host,
+ $this->conn->port,
+ $this->conn->db,
+ $this->conn->options,
+ $this->getName()
+ );
+ }
+
/**
* Set the rowset prototype
* @param mixed $rowset
return $this->exec;
}
+ /**
+ * Get the metadata cache
+ * @return \pq\Gateway\Table\CacheInterface
+ */
+ function getMetadataCache() {
+ if (!isset($this->metadatCache)) {
+ $this->metadataCache = static::$defaultMetadataCache ?: new Table\StaticCache;
+ }
+ return $this->metadataCache;
+ }
+
+ /**
+ * Set the metadata cache
+ * @param \pq\Gateway\Table\CacheInterface $cache
+ */
+ function setMetadataCache(Table\CacheInterface $cache) {
+ $this->metadataCache = $cache;
+ 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
+ * @return \pq\Gateway\Table\Relations|stdClass
+ */
+ function getRelations($to = null) {
+ if (!isset($this->relations)) {
+ $this->relations = new Table\Relations($this);
+ }
+ if (isset($to)) {
+ if (!isset($this->relations->$to)) {
+ return null;
+ }
+ return $this->relations->$to;
+ }
+ return $this->relations;
+ }
+
+ /**
+ * Check whether a certain relation exists
+ * @param string $name
+ * @param string $table
+ * @return bool
+ */
+ function hasRelation($name, $table = null) {
+ if (!($rel = $this->getRelations($name))) {
+ return false;
+ }
+ if (!isset($table)) {
+ return true;
+ }
+ return isset($rel->$table);
+ }
+
/**
* @return \pq\Connection
*/
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
* @param \pq\Result $result
* @return mixed
*/
- public function onResult(\pq\Result $result) {
- if ($result->status != \pq\Result::TUPLES_OK) {
+ public function onResult(\pq\Result $result = null) {
+ if ($result && $result->status != \pq\Result::TUPLES_OK) {
return $result;
}
* @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) {
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);
}
+
+ /**
+ * Get the child rows of a row by foreign key
+ * @param \pq\Gateway\Row $foreign
+ * @param string $name optional fkey name
+ * @param string $order
+ * @param int $limit
+ * @param int $offset
+ * @return mixed
+ */
+ function of(Row $foreign, $name = null, $order = null, $limit = 0, $offset = 0) {
+ // select * from $this where $this->$foreignColumn = $foreign->$referencedColumn
+
+ if (!isset($name)) {
+ $name = $foreign->getTable()->getName();
+ }
+
+ if (!$foreign->getTable()->hasRelation($name, $this->getName())) {
+ return $this->onResult(null);
+ }
+ $rel = $foreign->getTable()->getRelations($name)->{$this->getName()};
+
+ return $this->find(
+ array($rel->foreignColumn . "=" => $foreign->{$rel->referencedColumn}),
+ $order, $limit, $offset
+ );
+ }
+
+ /**
+ * Get the parent rows of a row by foreign key
+ * @param \pq\Gateway\Row $me
+ * @param string $foreign
+ * @param string $order
+ * @param int $limit
+ * @param int $offset
+ * @return mixed
+ */
+ function by(Row $me, $foreign, $order = null, $limit = 0, $offset = 0) {
+ // select * from $foreign where $foreign->$referencedColumn = $me->$foreignColumn
+
+ if (!$this->hasRelation($foreign, $this->getName())) {
+ return $this->onResult(null);
+ }
+ $rel = $this->getRelations($foreign)->{$this->getName()};
+
+ return static::resolve($rel->referencedTable)->find(
+ array($rel->referencedColumn . "=" => $me->{$rel->foreignColumn}),
+ $order, $limit, $offset
+ );
+ }
/**
* Insert a row into the table