flush

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

diff --git a/lib/pq/Gateway/Cell.php b/lib/pq/Gateway/Cell.php
index 1955552c3858508672746b4f252e2c33fd3c3a7f..730efb07bc4a36c1058bd77a3878a5bd6e755d85 100644 (file)
--- a/lib/pq/Gateway/Cell.php
+++ b/lib/pq/Gateway/Cell.php
@@ -2,6 +2,95 @@
 
 namespace pq\Gateway;
 
+use \pq\Query\Expr;
+
 class Cell
 {
+       /**
+        * @var \pq\Gateway\Row
+        */
+       protected $row;
+       
+       /**
+        * @var string
+        */
+       protected $name;
+       
+       /**
+        * @var mixed
+        */
+       protected $data;
+       
+       /**
+        * @param \pq\Gateway\Row $row
+        * @param string $name
+        * @param mixed $data
+        */
+       function __construct(Row $row, $name, $data) {
+               $this->row = $row;
+               $this->name = $name;
+               $this->data = $data;
+       }
+       
+       /**
+        * Get value as string
+        * @return string
+        */
+       function __toString() {
+               return (string) $this->data;
+       }
+       
+       /**
+        * Test whether the value is an unevaluated expression
+        * @return bool
+        */
+       function isExpr() {
+               return $this->data instanceof Expr;
+       }
+       
+       /**
+        * Get value
+        * @return mixed
+        */
+       function get() {
+               return $this->data;
+       }
+       
+       /**
+        * Modify the value in this cell
+        * @param mixed $data
+        * @param string $op a specific operator
+        * @return \pq\Gateway\Cell
+        */
+       function mod($data, $op = null) {
+               if (!($this->data instanceof Expr)) {
+                       if (!isset($this->data)) {
+                               $this->data = new Expr($this->name);
+                       } elseif (is_numeric($this->data)) {
+                               $this->data = new Expr($this->data);
+                       } else {
+                               $this->data = new Expr("%s", $this->row->getTable()->getConnection()->quote($this->data));
+                       }
+               }
+               
+               if ($data instanceof Expr) {
+                       $this->data->add($data);
+               } elseif (!isset($op) && is_numeric($data)) {
+                       $this->data->add(new Expr("+ $data"));
+               } else {
+                       $data = $this->row->getTable()->getConnection()->quote($data);
+                       $this->data->add(new Expr("%s %s"), isset($op) ? $op : "||", $data);
+               }
+               return $this;
+       }
+       
+       /**
+        * Set the value in this cell
+        * @param mixed $data
+        * @return \pq\Gateway\Cell
+        */
+       function set($data) {
+               $this->data = $data;
+               return $this;
+       }
 }