Beispiel #1
0
 function _insert($object)
 {
     $db = $this->getDb();
     $sql = "INSERT INTO hordetest_turba_objects " . Horde_Sql::insertValues($db, $object) . ";";
     $result = $db->query($sql);
     $this->assertOk($result);
     return $result;
 }
Beispiel #2
0
 /**
  * Build a piece of an attribute query.
  *
  * @param string $glue     The glue to join the criteria (OR/AND).
  * @param array $criteria  The array of criteria.
  * @param boolean $join    Should we join on a clean attributes table?
  *
  * @return string  An SQL fragment.
  */
 function _buildAttributeQuery($glue, $criteria, $join = false)
 {
     /* Initialize the clause that we're building. */
     $clause = '';
     /* Get the table alias to use for this set of criteria. */
     if ($join) {
         $alias = $this->_getAlias(true);
     } else {
         $alias = $this->_getAlias();
     }
     foreach ($criteria as $key => $vals) {
         if (!empty($vals['OR']) || !empty($vals['AND'])) {
             if (!empty($clause)) {
                 $clause .= ' ' . $glue . ' ';
             }
             $clause .= '(' . $this->_buildAttributeQuery($glue, $vals) . ')';
         } elseif (!empty($vals['JOIN'])) {
             if (!empty($clause)) {
                 $clause .= ' ' . $glue . ' ';
             }
             $clause .= $this->_buildAttributeQuery($glue, $vals['JOIN'], true);
         } else {
             if (isset($vals['field'])) {
                 if (!empty($clause)) {
                     $clause .= ' ' . $glue . ' ';
                 }
                 $clause .= Horde_Sql::buildClause($this->_db, $alias . '.attribute_' . $vals['field'], $vals['op'], $vals['test']);
             } else {
                 foreach ($vals as $test) {
                     if (!empty($clause)) {
                         $clause .= ' ' . $key . ' ';
                     }
                     $clause .= Horde_Sql::buildClause($this->_db, $alias . '.attribute_' . $test['field'], $test['op'], $test['test']);
                 }
             }
         }
     }
     return $clause;
 }