Changeset 3749:66047a2eda22

Timestamp:

04/04/18 11:58:36 (7 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

default

Message:

Add context property and behaviours

File:

• inc/core/class.dc.sql.statement.php (modified) (22 diffs)

inc/core/class.dc.sql.statement.php

@@ -8 +8 @@
  * @subpackage Core
  *
- * @copyright Bruno Hondelatte & Association Dotclear
+ * @copyright Olivier Meunier & Association Dotclear
  * @copyright GPL-2.0-only
  */
@@ -20 +20 @@
     protected $con;
 
+    protected $ctx; // Context (may be useful for behaviour's callback)
+
     protected $columns;
     protected $from;
@@ -30 +32 @@
      *
      * @param dcCore    $core   dcCore instance
-     * @param mixed     $from   optional from clause(s)
-     */
-    public function __construct(&$core, $from = null)
+     * @param mixed     $ctx    optional context
+     */
+    public function __construct(&$core, $ctx = null)
     {
         $this->core = &$core;
         $this->con  = &$core->con;
+        $this->ctx  = $ctx;
 
         $this->columns =
@@ -43 +46 @@
         $this->sql     =
         array();
-
-        if ($from !== null) {
-            if (is_array($from)) {
-                $this->froms($from);
-            } else {
-                $this->from($from);
-            }
-        }
     }
 
@@ -88 +83 @@
 
     /**
+     * Adds context
+     *
+     * @param mixed     $c      the context(s)
+     *
+     * @return dcSelectStatement self instance, enabling to chain calls
+     */
+    public function ctx($c)
+    {
+        $this->ctx = $c;
+        return $this;
+    }
+
+    /**
      * Adds column(s)
      *
@@ -135 +143 @@
         }
         if (is_array($c)) {
-            $filter = function($v) {
+            $filter = function ($v) {
                 return trim(ltrim($v, ','));
             };
@@ -280 +288 @@
         } else {
             $clause = "LIKE '" .
-                $sql->escape(preg_replace(array('%', '_', '!'), array('!%', '!_', '!!'), $value)) .
+            $sql->escape(preg_replace(array('%', '_', '!'), array('!%', '!_', '!!'), $value)) .
                 "%' ESCAPE '!'";
         }
@@ -303 +311 @@
     {
         $filter = function ($s) {
-            $s = strtoupper($s);
+            $s        = strtoupper($s);
             $patterns = array(
                 '\s+' => ' ', // Multiple spaces/tabs -> one space
@@ -336 +344 @@
      *
      * @param dcCore    $core   dcCore instance
-     * @param mixed     $from   optional from clause(s)
-     */
-    public function __construct(&$core, $from = null)
-    {
-        $this->join    =
-        $this->having  =
-        $this->order   =
-        $this->group   =
+     * @param mixed     $ctx    optional context
+     */
+    public function __construct(&$core, $ctx = null)
+    {
+        $this->join   =
+        $this->having =
+        $this->order  =
+        $this->group  =
         array();
 
@@ -350 +358 @@
         $this->distinct = false;
 
-        parent::__construct($core, $from);
+        parent::__construct($core, $ctx);
     }
 
@@ -496 +504 @@
     public function statement()
     {
+        # --BEHAVIOR-- coreBeforeSelectStatement
+        $this->core->callBehavior('coreBeforeSelectStatement', $this);
+
         // Check if source given
         if (!count($this->from)) {
@@ -563 +574 @@
         }
 
-        return trim($query);
+        $query = trim($query);
+
+        # --BEHAVIOR-- coreAfertSelectStatement
+        $this->core->callBehavior('coreAfterSelectStatement', $this, $query);
+
+        return $query;
     }
 }
@@ -579 +595 @@
     public function statement()
     {
+        # --BEHAVIOR-- coreBeforeDeleteStatement
+        $this->core->callBehavior('coreBeforeDeleteStatement', $this);
+
         // Check if source given
         if (!count($this->from)) {
@@ -609 +628 @@
         }
 
-        return trim($query);
+        $query = trim($query);
+
+        # --BEHAVIOR-- coreAfertDeleteStatement
+        $this->core->callBehavior('coreAfterDeleteStatement', $this, $query);
+
+        return $query;
     }
 }
@@ -624 +648 @@
      *
      * @param dcCore    $core   dcCore instance
-     * @param mixed     $from   optional from clause(s)
-     */
-    public function __construct(&$core, $from = null)
+     * @param mixed     $ctx    optional context
+     */
+    public function __construct(&$core, $ctx = null)
     {
         $this->set = array();
 
-        parent::__construct($core, $from);
+        parent::__construct($core, $ctx);
     }
 
@@ -700 +724 @@
     public function whereStatement()
     {
+        # --BEHAVIOR-- coreBeforeUpdateWhereStatement
+        $this->core->callBehavior('coreBeforeUpdateWhereStatement', $this);
+
         $query = '';
 
@@ -720 +747 @@
         }
 
-        return trim($query);
+        $query = trim($query);
+
+        # --BEHAVIOR-- coreAfertUpdateWhereStatement
+        $this->core->callBehavior('coreAfterUpdateWhereStatement', $this, $query);
+
+        return $query;
     }
 
@@ -730 +762 @@
     public function statement()
     {
+        # --BEHAVIOR-- coreBeforeUpdateStatement
+        $this->core->callBehavior('coreBeforeUpdateStatement', $this);
+
         // Check if source given
         if (!count($this->from)) {
@@ -765 +800 @@
         }
 
-        return trim($query);
+        $query = trim($query);
+
+        # --BEHAVIOR-- coreAfertUpdateStatement
+        $this->core->callBehavior('coreAfterUpdateStatement', $this, $query);
+
+        return $query;
     }
 }
@@ -780 +820 @@
      *
      * @param dcCore    $core   dcCore instance
-     * @param mixed     $into   optional into clause(s)
-     */
-    public function __construct(&$core, $into = null)
+     * @param mixed     $ctx    optional context
+     */
+    public function __construct(&$core, $ctx = null)
     {
         $this->lines = array();
 
-        parent::__construct($core, $into);
+        parent::__construct($core, $ctx);
     }
 
@@ -843 +883 @@
     public function statement()
     {
+        # --BEHAVIOR-- coreBeforeInsertStatement
+        $this->core->callBehavior('coreBeforeInsertStatement', $this);
+
         // Check if source given
         if (!count($this->from)) {
@@ -873 +916 @@
         }
 
-        return trim($query);
+        $query = trim($query);
+
+        # --BEHAVIOR-- coreAfertInsertStatement
+        $this->core->callBehavior('coreAfterInsertStatement', $this, $query);
+
+        return $query;
     }
 }