| Inheritance | yii\sphinx\Schema » yii\base\Object |
|---|---|
| Implements | yii\base\Configurable |
| Available since version | 2.0 |
| Source Code | https://github.com/yiisoft/yii2-sphinx/blob/master/Schema.php |
Schema represents the Sphinx schema information.
| Property | Type | Description | Defined By |
|---|---|---|---|
| $db | yii\sphinx\Connection | The Sphinx connection | yii\sphinx\Schema |
| $indexNames | string[] | All index names in the Sphinx. | yii\sphinx\Schema |
| $indexSchemas | yii\sphinx\IndexSchema[] | The metadata for all indexes in the Sphinx. | yii\sphinx\Schema |
| $indexTypes | array | All index types in the Sphinx in format: index name => index type. | yii\sphinx\Schema |
| $queryBuilder | yii\sphinx\QueryBuilder | The query builder for this connection. | yii\sphinx\Schema |
| $typeMap | array | Mapping from physical column types (keys) to abstract column types (values) | yii\sphinx\Schema |
| Method | Description | Defined By |
|---|---|---|
| __call() | Calls the named method which is not a class method. | yii\base\Object |
| __construct() | Constructor. | yii\base\Object |
| __get() | Returns the value of an object property. | yii\base\Object |
| __isset() | Checks if a property is set, i.e. defined and not null. | yii\base\Object |
| __set() | Sets value of an object property. | yii\base\Object |
| __unset() | Sets an object property to null. | yii\base\Object |
| canGetProperty() | Returns a value indicating whether a property can be read. | yii\base\Object |
| canSetProperty() | Returns a value indicating whether a property can be set. | yii\base\Object |
| className() | Returns the fully qualified name of this class. | yii\base\Object |
| convertException() | Converts a DB exception to a more concrete one if possible. | yii\sphinx\Schema |
| createQueryBuilder() | Creates a query builder for the Sphinx. | yii\sphinx\Schema |
| getIndexNames() | Returns all index names in the Sphinx. | yii\sphinx\Schema |
| getIndexSchema() | Obtains the metadata for the named index. | yii\sphinx\Schema |
| getIndexSchemas() | Returns the metadata for all indexes in the database. | yii\sphinx\Schema |
| getIndexTypes() | Returns all index types in the Sphinx. | yii\sphinx\Schema |
| getPdoType() | Determines the PDO type for the given PHP data value. | yii\sphinx\Schema |
| getQueryBuilder() | yii\sphinx\Schema | |
| getRawIndexName() | Returns the actual name of a given index name. | yii\sphinx\Schema |
| hasMethod() | Returns a value indicating whether a method is defined. | yii\base\Object |
| hasProperty() | Returns a value indicating whether a property is defined. | yii\base\Object |
| init() | Initializes the object. | yii\base\Object |
| isReadQuery() | Returns a value indicating whether a SQL statement is for read purpose. | yii\sphinx\Schema |
| quoteColumnName() | Quotes a column name for use in a query. | yii\sphinx\Schema |
| quoteIndexName() | Quotes a index name for use in a query. | yii\sphinx\Schema |
| quoteSimpleColumnName() | Quotes a column name for use in a query. | yii\sphinx\Schema |
| quoteSimpleIndexName() | Quotes a index name for use in a query. | yii\sphinx\Schema |
| quoteValue() | Quotes a string value for use in a query. | yii\sphinx\Schema |
| refresh() | Refreshes the schema. | yii\sphinx\Schema |
| Method | Description | Defined By |
|---|---|---|
| applyDefaultColumns() | Sets up the default columns for given index. | yii\sphinx\Schema |
| findColumns() | Collects the metadata of index columns. | yii\sphinx\Schema |
| findIndexes() | Returns all index names in the Sphinx. | yii\sphinx\Schema |
| getCacheKey() | Returns the cache key for the specified index name. | yii\sphinx\Schema |
| getCacheTag() | Returns the cache tag name. | yii\sphinx\Schema |
| getColumnPhpType() | Extracts the PHP type from abstract DB type. | yii\sphinx\Schema |
| initIndexesInfo() | Initializes information about name and type of all index in the Sphinx. | yii\sphinx\Schema |
| loadColumnSchema() | Loads the column information into a yii\sphinx\ColumnSchema object. | yii\sphinx\Schema |
| loadIndexSchema() | Loads the metadata for the specified index. | yii\sphinx\Schema |
| resolveIndexNames() | Resolves the index name. | yii\sphinx\Schema |
| resolveIndexType() | Resolves the index name. | yii\sphinx\Schema |
| Constant | Value | Description | Defined By |
|---|---|---|---|
| TYPE_BIGINT | 'bigint' | yii\sphinx\Schema | |
| TYPE_BOOLEAN | 'boolean' | yii\sphinx\Schema | |
| TYPE_FLOAT | 'float' | yii\sphinx\Schema | |
| TYPE_INTEGER | 'integer' | yii\sphinx\Schema | |
| TYPE_PK | 'pk' | The following are the supported abstract column data types. | yii\sphinx\Schema |
| TYPE_STRING | 'string' | yii\sphinx\Schema | |
| TYPE_TIMESTAMP | 'timestamp' | yii\sphinx\Schema |
The Sphinx connection
public yii\sphinx\Connection $db = null
All index names in the Sphinx.
public string[] getIndexNames ( $refresh = false )
The metadata for all indexes in the Sphinx. Each array element is an instance of yii\sphinx\IndexSchema or its child class.
public yii\sphinx\IndexSchema[] getIndexSchemas ( $refresh = false )
All index types in the Sphinx in format: index name => index type.
public array getIndexTypes ( $refresh = false )
The query builder for this connection.
public yii\sphinx\QueryBuilder getQueryBuilder ( )
Mapping from physical column types (keys) to abstract column types (values)
public array $typeMap = ['field' => self::TYPE_STRING, 'string' => self::TYPE_STRING, 'ordinal' => self::TYPE_STRING, 'integer' => self::TYPE_INTEGER, 'int' => self::TYPE_INTEGER, 'uint' => self::TYPE_INTEGER, 'bigint' => self::TYPE_BIGINT, 'timestamp' => self::TYPE_TIMESTAMP, 'bool' => self::TYPE_BOOLEAN, 'float' => self::TYPE_FLOAT, 'mva' => self::TYPE_INTEGER]
Sets up the default columns for given index.
This method should be used in case there is no way to find actual columns, like in some distributed indexes.
| protected void applyDefaultColumns ( $index ) | ||
|---|---|---|
| $index | yii\sphinx\IndexSchema |
The index metadata |
Converts a DB exception to a more concrete one if possible.
| public yii\db\Exception convertException ( Exception $e, $rawSql ) | ||
|---|---|---|
| $e | Exception | |
| $rawSql | string |
SQL that produced exception |
Creates a query builder for the Sphinx.
| public yii\sphinx\QueryBuilder createQueryBuilder ( ) | ||
|---|---|---|
| return | yii\sphinx\QueryBuilder |
Query builder instance |
Collects the metadata of index columns.
| protected boolean findColumns ( $index ) | ||
|---|---|---|
| $index | yii\sphinx\IndexSchema |
The index metadata |
| return | boolean |
Whether the index exists in the database |
| throws | Exception |
if DB query fails |
Returns all index names in the Sphinx.
| protected array findIndexes ( ) | ||
|---|---|---|
| return | array |
All index names in the Sphinx. |
Returns the cache key for the specified index name.
| protected mixed getCacheKey ( $name ) | ||
|---|---|---|
| $name | string |
The index name |
| return | mixed |
The cache key |
Returns the cache tag name.
This allows refresh() to invalidate all cached index schemas.
| protected string getCacheTag ( ) | ||
|---|---|---|
| return | string |
The cache tag name |
Extracts the PHP type from abstract DB type.
| protected string getColumnPhpType ( $column ) | ||
|---|---|---|
| $column | yii\sphinx\ColumnSchema |
The column schema information |
| return | string |
PHP type name |
Returns all index names in the Sphinx.
| public string[] getIndexNames ( $refresh = false ) | ||
|---|---|---|
| $refresh | boolean |
Whether to fetch the latest available index names. If this is false, index names fetched previously (if available) will be returned. |
| return | string[] |
All index names in the Sphinx. |
Obtains the metadata for the named index.
| public yii\sphinx\IndexSchema|null getIndexSchema ( $name, $refresh = false ) | ||
|---|---|---|
| $name | string |
Index name. The index name may contain schema name if any. Do not quote the index name. |
| $refresh | boolean |
Whether to reload the index schema even if it is found in the cache. |
| return | yii\sphinx\IndexSchema|null |
Index metadata. |
Returns the metadata for all indexes in the database.
| public yii\sphinx\IndexSchema[] getIndexSchemas ( $refresh = false ) | ||
|---|---|---|
| $refresh | boolean |
Whether to fetch the latest available index schemas. If this is false, cached data may be returned if available. |
| return | yii\sphinx\IndexSchema[] |
The metadata for all indexes in the Sphinx. Each array element is an instance of yii\sphinx\IndexSchema or its child class. |
Returns all index types in the Sphinx.
| public array getIndexTypes ( $refresh = false ) | ||
|---|---|---|
| $refresh | boolean |
Whether to fetch the latest available index types. If this is false, index types fetched previously (if available) will be returned. |
| return | array |
All index types in the Sphinx in format: index name => index type. |
Determines the PDO type for the given PHP data value.
See also http://www.php.net/manual/en/pdo.constants.php.
| public integer getPdoType ( $data ) | ||
|---|---|---|
| $data | mixed |
The data whose PDO type is to be determined |
| return | integer |
The PDO type |
| public yii\sphinx\QueryBuilder getQueryBuilder ( ) | ||
|---|---|---|
| return | yii\sphinx\QueryBuilder |
The query builder for this connection. |
Returns the actual name of a given index name.
This method will strip off curly brackets from the given index name and replace the percentage character '%' with yii\sphinx\Connection::indexPrefix.
| public string getRawIndexName ( $name ) | ||
|---|---|---|
| $name | string |
The index name to be converted |
| return | string |
The real name of the given index name |
Initializes information about name and type of all index in the Sphinx.
| protected void initIndexesInfo ( ) |
|---|
Returns a value indicating whether a SQL statement is for read purpose.
| public boolean isReadQuery ( $sql ) | ||
|---|---|---|
| $sql | string |
The SQL statement |
| return | boolean |
Whether a SQL statement is for read purpose. |
Loads the column information into a yii\sphinx\ColumnSchema object.
| protected yii\sphinx\ColumnSchema loadColumnSchema ( $info ) | ||
|---|---|---|
| $info | array |
Column information |
| return | yii\sphinx\ColumnSchema |
The column schema object |
Loads the metadata for the specified index.
| protected yii\sphinx\IndexSchema|null loadIndexSchema ( $name ) | ||
|---|---|---|
| $name | string |
Index name |
| return | yii\sphinx\IndexSchema|null |
Driver dependent index metadata. |
Quotes a column name for use in a query.
If the column name contains prefix, the prefix will also be properly quoted. If the column name is already quoted or contains '(', '[[' or '{{', then this method will do nothing.
See also quoteSimpleColumnName().
| public string quoteColumnName ( $name ) | ||
|---|---|---|
| $name | string |
Column name |
| return | string |
The properly quoted column name |
Quotes a index name for use in a query.
If the index name contains schema prefix, the prefix will also be properly quoted. If the index name is already quoted or contains '(' or '{{', then this method will do nothing.
See also \yii\sphinx\quoteSimpleTableName.
| public string quoteIndexName ( $name ) | ||
|---|---|---|
| $name | string |
Index name |
| return | string |
The properly quoted index name |
Quotes a column name for use in a query.
A simple column name has no prefix.
| public string quoteSimpleColumnName ( $name ) | ||
|---|---|---|
| $name | string |
Column name |
| return | string |
The properly quoted column name |
Quotes a index name for use in a query.
A simple index name has no schema prefix.
| public string quoteSimpleIndexName ( $name ) | ||
|---|---|---|
| $name | string |
Index name |
| return | string |
The properly quoted index name |
Quotes a string value for use in a query.
Note that if the parameter is not a string, it will be returned without change.
See also http://www.php.net/manual/en/function.PDO-quote.php.
| public string quoteValue ( $str ) | ||
|---|---|---|
| $str | string |
String to be quoted |
| return | string |
The properly quoted string |
Refreshes the schema.
This method cleans up all cached index schemas so that they can be re-created later to reflect the Sphinx schema change.
| public void refresh ( ) |
|---|
Resolves the index name.
| protected void resolveIndexNames ( $index, $name ) | ||
|---|---|---|
| $index | yii\sphinx\IndexSchema |
The index metadata object |
| $name | string |
The index name |
Resolves the index name.
| protected void resolveIndexType ( $index ) | ||
|---|---|---|
| $index | yii\sphinx\IndexSchema |
The index metadata object |
© 2008–2017 by Yii Software LLC
Licensed under the three clause BSD license.
http://www.yiiframework.com/doc-2.0/yii-sphinx-schema.html