DBSqlBuilderSelectSphinx Class Reference
[Sphinx]

Select Query Builder for Sphinx. More...

Inheritance diagram for DBSqlBuilderSelectSphinx:

List of all members.

Public Member Functions
	get_sql ()
	Return SQL fragment.
Protected Member Functions
	get_features ($query)
	returns features
	get_fieldnames ($arr_fields, IDBTable $table)
	Returns names of fields to select as string.
	get_limit ($arr_limit)
	Return limit as string.
	get_order_by ($arr_orders)
	returns order by clause
	get_where (IDBWhere $where)
	Returns al whers transformed to a string.
	prefix_column ($column, $table)
	Prefix column with table alias.

---

Detailed Description

Select Query Builder for Sphinx.

Author:

Gerd Riesselmann

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

---

Member Function Documentation

DBSqlBuilderSelectSphinx::get_features

(

$

query

)

[protected]

returns features

Returns:

array

Reimplemented in DBSqlBuilderCountSphinx.

Definition at line 103 of file dbsqlbuilder.select.sphinx.cls.php.

                                                {
                $ret = array();
                if (isset($query->sphinx_features)) {
                        $ret = $query->sphinx_features;
                }
                return $ret;
        }

DBSqlBuilderSelectSphinx::get_fieldnames	(	$	arr_fields,
		IDBTable $	table
	)			[protected]

Returns names of fields to select as string.

Reimplemented from DBSqlBuilderSelect.

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

                                                                        {
                $ret = '';
                $fieldnames = array();
                foreach($arr_fields as $key => $name) {
                        $has_alias = !is_numeric($key);
                        $fieldname = $has_alias ? $key : $name;
                        $fieldalias = $name;

                        $statement = $this->prefix_column($fieldname, $table);
                        if ($fieldalias != '*') {
                                $statement .=  ' AS ' . DB::escape_database_entity($fieldalias, $table->get_table_driver(), IDBDriver::ALIAS);
                        }
                        
                        $fieldnames[] = $statement;
                }
                if (count($fieldnames)) {
                        $ret = implode(', ', $fieldnames);
                }
                else {
                        $ret = $this->prefix_column('*', $table);
                }
                return $ret;
        }

DBSqlBuilderSelectSphinx::get_limit

(

$

arr_limit

)

[protected]

Return limit as string.

Reimplemented from DBSqlBuilderBase.

Reimplemented in DBSqlBuilderCountSphinx.

Definition at line 68 of file dbsqlbuilder.select.sphinx.cls.php.

                                                 {
                $arr_limit = array_map('intval', $arr_limit);
                $ret = '';
                if ($arr_limit[1] > 0) {
                        $ret = $arr_limit[0] . ';' . $arr_limit[1];
                }
                return $ret;
        }

DBSqlBuilderSelectSphinx::get_order_by

(

$

arr_orders

)

[protected]

returns order by clause

Reimplemented from DBSqlBuilderBase.

Definition at line 80 of file dbsqlbuilder.select.sphinx.cls.php.

                                                     {
                $ret = '';
                if (count($arr_orders) > 0) {
                        $items = array();
                        foreach($arr_orders as $order) {
                                $column = Arr::get_item($order, 'field', '');
                                if (empty($column)) {
                                        continue;
                                }
                                $table =  Arr::get_item($order, 'table', null);
                                $direction = Arr::get_item($order, 'direction', 'ASC');
                                $items[] = $column. ' ' . $direction;
                        }
                        $ret .= implode(', ', $items);
                }
                return $ret;
        }

DBSqlBuilderSelectSphinx::get_sql

(

)

Return SQL fragment.

Returns:

string

Reimplemented from DBSqlBuilderBase.

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

                                  {
                $table = $this->query->get_table();
                return serialize(
                        array(
                                'conditions' => $this->get_where($this->query->get_wheres()),
                                'fields' => $this->get_fieldnames($this->fields, $table),
                                'from' => $this->get_table($table),
                                'limit' => $this->get_limit(Arr::get_item($this->params, 'limit', array(0,0))),
                                'order' => $this->get_order_by(Arr::get_item($this->params, 'order_by', array())),
                                'features' => $this->get_features($this->query)
                        )
                ); 
                // 'SELECT%distinct %!fields FROM %!from%join%where%group_by%having%order_by%limit%for_update';
        }

DBSqlBuilderSelectSphinx::get_where

(

IDBWhere $

where

)

[protected]

Returns al whers transformed to a string.

See also:

core/model/base/DBSqlBuilderBaseget_where($where)

Reimplemented from DBSqlBuilderBase.

Definition at line 34 of file dbsqlbuilder.select.sphinx.cls.php.

                                                      {
                return $where->get_sql();
        }

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

Prefix column with table alias.

Parameters:

	string	$column
	IDBTable	| string $table

Returns:

string

Reimplemented from DBSqlBuilderBase.

Definition at line 118 of file dbsqlbuilder.select.sphinx.cls.php.

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

---

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

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