PHP JDatabaseDriver::qn方法代码示例

	/**
	 * Test for the JDatabaseDriver::__call method.
	 *
	 * @return  void
	 *
	 * @since   12.1
	 */
	public function test__callQuoteName()
	{
		$this->assertThat(
			$this->db->qn('foo'),
			$this->equalTo($this->db->quoteName('foo')),
			'Tests the qn alias of quoteName.'
		);
	}

 /**
  * Method to provide a shortcut to binding, checking and storing a FOFTable
  * instance to the database table.  The method will check a row in once the
  * data has been stored and if an ordering filter is present will attempt to
  * reorder the table rows based on the filter.  The ordering filter is an instance
  * property name.  The rows that will be reordered are those whose value matches
  * the FOFTable instance for the property specified.
  *
  * @param   mixed   $src             An associative array or object to bind to the FOFTable instance.
  * @param   string  $orderingFilter  Filter for the order updating
  * @param   mixed   $ignore          An optional array or space separated list of properties
  *                                   to ignore while binding.
  *
  * @return  boolean  True on success.
  */
 public function save($src, $orderingFilter = '', $ignore = '')
 {
     // Attempt to bind the source to the instance.
     if (!$this->bind($src, $ignore)) {
         return false;
     }
     // Run any sanity checks on the instance and verify that it is ready for storage.
     if (!$this->check()) {
         return false;
     }
     // Attempt to store the properties to the database table.
     if (!$this->store()) {
         return false;
     }
     // Attempt to check the row in, just in case it was checked out.
     if (!$this->checkin()) {
         return false;
     }
     // If an ordering filter is set, attempt reorder the rows in the table based on the filter and value.
     if ($orderingFilter) {
         $filterValue = $this->{$orderingFilter};
         $this->reorder($orderingFilter ? $this->_db->qn($orderingFilter) . ' = ' . $this->_db->q($filterValue) : '');
     }
     // Set the error to empty and return true.
     $this->setError('');
     return true;
 }

 /**
  * Method to store mapped rows in the database from the JTable instance properties.
  *
  * @param   array    $filter  Touch only these filtered items.
  *
  * @return  boolean  True on success.
  *
  * @link    http://docs.joomla.org/JTable/store
  * @throws  UnexpectedValueException
  */
 public function store(array $filter = null)
 {
     $k = $this->_tbl_key;
     $m = $this->_tbl_mapped;
     if (0 == $this->{$k}) {
         throw new UnexpectedValueException(sprintf('No key specified: %s.', get_class($this)));
     }
     $id = $this->{$k};
     $items = $this->{$m};
     if (!empty($items)) {
         // Load currently mapped variables from database.
         $this->load();
         $filtered = !is_null($filter) ? array_intersect($this->{$m}, $filter) : $this->{$m};
         // Calculate difference (added and deleted items).
         $added = array_diff($items, $filtered);
         $deleted = array_diff($filtered, $items);
         // Create all added items.
         if ($added) {
             $values = array();
             foreach ($added as $var) {
                 $values[] = (int) $id . ',' . (int) $var;
             }
             $query = $this->_db->getQuery(true);
             $query->insert($this->_db->qn($this->_tbl));
             $query->columns(array($this->_db->qn($this->_tbl_key), $this->_db->qn($this->_tbl_mapped)));
             $query->values($values);
             $this->_db->setQuery($query);
             $this->_db->execute();
         }
         // Remove all deleted items.
         if ($deleted) {
             $query = $this->_db->getQuery(true);
             $query->delete($this->_db->qn($this->_tbl));
             $query->where($this->_db->qn($this->_tbl_key) . '=' . (int) $id);
             $query->where($this->_db->qn($this->_tbl_mapped) . ' IN (' . implode(',', $deleted) . ')');
             $this->_db->setQuery($query);
             $this->_db->execute();
         }
     } else {
         $this->delete();
     }
     $this->{$m} = $items;
     if ($this->_locked) {
         $this->_unlock();
     }
     return true;
 }

 /**
  * Method to get the next ordering value for a group of rows defined by an SQL WHERE clause.
  * This is useful for placing a new item last in a group of items in the table.
  *
  * @param   string  $where  WHERE clause to use for selecting the MAX(ordering) for the table.
  *
  * @return  mixed  Boolean false an failure or the next ordering value as an integer.
  */
 public function getNextOrder($where = '')
 {
     // If there is no ordering field set an error and return false.
     $ordering = $this->getColumnAlias('ordering');
     if (!in_array($ordering, $this->getKnownFields())) {
         throw new UnexpectedValueException(sprintf('%s does not support ordering.', get_class($this)));
     }
     // Get the largest ordering value for a given where clause.
     $query = $this->_db->getQuery(true);
     $query->select('MAX(' . $this->_db->qn($ordering) . ')');
     $query->from($this->_tbl);
     if ($where) {
         $query->where($where);
     }
     $this->_db->setQuery($query);
     $max = (int) $this->_db->loadResult();
     // Return the largest ordering value + 1.
     return $max + 1;
 }