DBSqlBuilderWhereSphinx Class Reference
[Sphinx]

Where Clause Query Builder for Sphinx. More...

Inheritance diagram for DBSqlBuilderWhereSphinx:

List of all members.

Public Member Functions
	get_sql ()
	Return SQL fragment.
Protected Member Functions
	prefix_column ($column, $table)
	Prefix column with table alias.
	process_as_filter ($columm, $operator, $value)
	Create a filter from WHERE.
	process_as_query ($column, $operator, $value, $table)
	Create a query from WHERE.

---

Detailed Description

Where Clause Query Builder for Sphinx.

Author:

Gerd Riesselmann

Definition at line 8 of file dbsqlbuilder.where.sphinx.cls.php.

---

Member Function Documentation

DBSqlBuilderWhereSphinx::get_sql

(

)

Return SQL fragment.

Returns:

array Array with two members "filter" and "query"

Reimplemented from DBSqlBuilderWhere.

Definition at line 14 of file dbsqlbuilder.where.sphinx.cls.php.

                                  {             
                $operator =  $this->where->get_operator();
                $column = $this->where->get_column();
                /* @var $table DBTable */
                $value = $this->where->get_value();
                $table = $this->where->get_table();
                $dbfield = $table->get_table_field($column);
                
                $ret = array('filter' => array(), 'query' => '');
                if ($dbfield && $dbfield->has_policy(DBDriverSphinx::SPHINX_ATTRIBUTE)) {
                        // Attributes must be filtered 
                        $ret['filter'][] = $this->process_as_filter($column, $operator, $value, $table);
                }
                else {
                        $ret['query'] = $this->process_as_query($column, $operator, $value, $table);
                }
                return $ret;
        }

DBSqlBuilderWhereSphinx::prefix_column	(	$	column,
		$	table
	)			[protected]

Prefix column with table alias.

Parameters:

	string	$column
	IDBTable	| string $table

Returns:

string

Reimplemented from DBSqlBuilderWhere.

Definition at line 110 of file dbsqlbuilder.where.sphinx.cls.php.

                                                          {
                return '@' . DB::escape_database_entity($column, $table->get_table_driver(), IDBDriver::FIELD);
        }

DBSqlBuilderWhereSphinx::process_as_filter	(	$	columm,
		$	operator,
		$	value
	)			[protected]

Create a filter from WHERE.

Parameters:

	string	$column
	string	$operator
	mixed	$value
	IDTable	$table

Definition at line 79 of file dbsqlbuilder.where.sphinx.cls.php.

                                                                         {
                $exclude = false;
                $values = Arr::force($value, true);
                switch ($operator) {
                        case '=':
                        case DBWhere::OP_IN:
                                $exclude = false;
                                break;
                        case '!=':
                        case '<>':
                        case DBWhere::OP_NOT_IN:
                                $exclude = true;
                                break;
                        default:
                                throw new Exception('Only =, != and IN, NOT IN operator supported with sphinx attributes at this time');
                                break;
                }
                return array(
                        'attribute' => $columm,
                        'exclude' => $exclude,
                        'values' => $values
                );
        }

DBSqlBuilderWhereSphinx::process_as_query	(	$	column,
		$	operator,
		$	value,
		$	table
	)			[protected]

Create a query from WHERE.

Parameters:

	string	$column
	string	$operator
	mixed	$value
	IDTable	$table

Definition at line 41 of file dbsqlbuilder.where.sphinx.cls.php.

                                                                                {
                if (empty($operator)) {
                        return $column;
                }
                
                /* @var $table DBTable */
                $field = $this->prefix_column($column, $table);
                switch ($operator) {
                        case '=':
                                $value = DB::escape($value, $table->get_table_driver());
                                break;
                        default:
                                throw new Exception('Only = operator supported with sphinx queries at this time');
                                break;
                }
                $ret = $field . ' ' . $value;
                // There is a bug in Sphinx 0.9.9 that if query ends on some escaped characters, query fails.. 
                // strip them off
                while (substr($ret, -2, -1) === "\\") {
                        $str_failures = '-!()|@~"/^&';
                        if (strpos($str_failures, substr($ret, -1)) !== false) {
                                $ret = substr($ret, 0, -2);
                        }
                        else {
                                break;
                        }
                }
                return $ret;
        }

---

The documentation for this class was generated from the following file:

• contributions/sphinx/model/drivers/sphinx/sqlbuilder/dbsqlbuilder.where.sphinx.cls.php