没有命名空间的类 yii yii\base yii\behaviors yii\caching yii\captcha yii\console yii\console\controllers yii\console\widgets yii\data yii\db yii\db\conditions yii\db\cubrid yii\db\cubrid\conditions yii\db\mssql yii\db\mssql\conditions yii\db\mysql yii\db\oci yii\db\oci\conditions yii\db\pgsql yii\db\sqlite yii\db\sqlite\conditions yii\di yii\filters yii\filters\auth yii\grid yii\helpers yii\i18n yii\log yii\mail yii\mutex yii\rbac yii\rest yii\test yii\validators yii\web yii\widgets

Abstract Class yii\db\SqlTokenizer

继承yii\db\SqlTokenizer » yii\base\Component » yii\base\BaseObject
实现yii\base\Configurable
子类yii\db\sqlite\SqlTokenizer
可用版本自2.0.13
源码 https://github.com/yiichina/yii2/blob/api/framework/db/SqlTokenizer.php

SqlTokenizer splits an SQL query into individual SQL tokens.

It can be used to obtain an addition information from an SQL code.

Usage example:

$tokenizer = new SqlTokenizer("SELECT * FROM user WHERE id = 1");
$root = $tokeinzer->tokenize();
$sqlTokens = $root->getChildren();

Tokens are instances of yii\db\SqlToken.

公共属性

隐藏继承的属性

属性类型描述被定义在
$behaviors yii\base\Behavior[] List of behaviors attached to this component yii\base\Component
$sql string SQL code. yii\db\SqlTokenizer

受保护的属性

隐藏继承的属性

属性类型描述被定义在
$length integer SQL code string length. yii\db\SqlTokenizer
$offset integer SQL code string current offset. yii\db\SqlTokenizer

公共方法

隐藏继承的方法

方法描述被定义在
__call() Calls the named method which is not a class method. yii\base\Component
__clone() This method is called after the object is created by cloning an existing one. yii\base\Component
__construct() Constructor. yii\db\SqlTokenizer
__get() Returns the value of a component property. yii\base\Component
__isset() Checks if a property is set, i.e. defined and not null. yii\base\Component
__set() Sets the value of a component property. yii\base\Component
__unset() Sets a component property to be null. yii\base\Component
attachBehavior() Attaches a behavior to this component. yii\base\Component
attachBehaviors() Attaches a list of behaviors to the component. yii\base\Component
behaviors() Returns a list of behaviors that this component should behave as. yii\base\Component
canGetProperty() Returns a value indicating whether a property can be read. yii\base\Component
canSetProperty() Returns a value indicating whether a property can be set. yii\base\Component
className() Returns the fully qualified name of this class. yii\base\BaseObject
detachBehavior() Detaches a behavior from the component. yii\base\Component
detachBehaviors() Detaches all behaviors from the component. yii\base\Component
ensureBehaviors() Makes sure that the behaviors declared in behaviors() are attached to this component. yii\base\Component
getBehavior() Returns the named behavior object. yii\base\Component
getBehaviors() Returns all behaviors attached to this component. yii\base\Component
hasEventHandlers() Returns a value indicating whether there is any handler attached to the named event. yii\base\Component
hasMethod() Returns a value indicating whether a method is defined. yii\base\Component
hasProperty() Returns a value indicating whether a property is defined for this component. yii\base\Component
init() Initializes the object. yii\base\BaseObject
off() Detaches an existing event handler from this component. yii\base\Component
on() Attaches an event handler to an event. yii\base\Component
tokenize() Tokenizes and returns a code type token. yii\db\SqlTokenizer
trigger() Triggers an event. yii\base\Component

受保护的方法

隐藏继承的方法

方法描述被定义在
indexAfter() Returns an index after the given string in the SQL code starting with the specified offset. yii\db\SqlTokenizer
isComment() Returns whether there's a commentary at the current offset. yii\db\SqlTokenizer
isIdentifier() Returns whether there's an identifier at the current offset. yii\db\SqlTokenizer
isKeyword() Returns whether the given string is a keyword. yii\db\SqlTokenizer
isOperator() Returns whether there's an operator at the current offset. yii\db\SqlTokenizer
isStringLiteral() Returns whether there's a string literal at the current offset. yii\db\SqlTokenizer
isWhitespace() Returns whether there's a whitespace at the current offset. yii\db\SqlTokenizer
startsWithAnyLongest() Returns whether the longest common prefix equals to the SQL code of the same length at the current offset. yii\db\SqlTokenizer
substring() Returns a string of the given length starting with the specified offset. yii\db\SqlTokenizer

属性详情

$length 受保护 属性

SQL code string length.

protected integer $length null
$offset 受保护 属性

SQL code string current offset.

protected integer $offset null
$sql 公共 属性

SQL code.

public string $sql null

方法详情

__construct() 公共 方法

Constructor.

public void __construct($sql, $config = [])
$sql string

SQL code to be tokenized.

$config array

Name-value pairs that will be used to initialize the object properties

indexAfter() 受保护 方法

Returns an index after the given string in the SQL code starting with the specified offset.

protected integer indexAfter($string, $offset null)
$string string

String to be found.

$offset integer|null

SQL code offset, defaults to current if null is passed.

return integer

Index after the given string or end of string index.

isComment() 受保护 抽象 方法

Returns whether there's a commentary at the current offset.

If this methos returns true, it has to set the $length parameter to the length of the matched string.

protected abstract boolean isComment(&$length)
$length integer

Length of the matched string.

return boolean

Whether there's a commentary at the current offset.

isIdentifier() 受保护 抽象 方法

Returns whether there's an identifier at the current offset.

If this methos returns true, it has to set the $length parameter to the length of the matched string. It may also set $content to a string that will be used as a token content.

protected abstract boolean isIdentifier(&$length, &$content)
$length integer

Length of the matched string.

$content string

Optional content instead of the matched string.

return boolean

Whether there's an identifier at the current offset.

isKeyword() 受保护 抽象 方法

Returns whether the given string is a keyword.

The method may set $content to a string that will be used as a token content.

protected abstract boolean isKeyword($string, &$content)
$string string

String to be matched.

$content string

Optional content instead of the matched string.

return boolean

Whether the given string is a keyword.

isOperator() 受保护 抽象 方法

Returns whether there's an operator at the current offset.

If this methos returns true, it has to set the $length parameter to the length of the matched string. It may also set $content to a string that will be used as a token content.

protected abstract boolean isOperator(&$length, &$content)
$length integer

Length of the matched string.

$content string

Optional content instead of the matched string.

return boolean

Whether there's an operator at the current offset.

isStringLiteral() 受保护 抽象 方法

Returns whether there's a string literal at the current offset.

If this methos returns true, it has to set the $length parameter to the length of the matched string. It may also set $content to a string that will be used as a token content.

protected abstract boolean isStringLiteral(&$length, &$content)
$length integer

Length of the matched string.

$content string

Optional content instead of the matched string.

return boolean

Whether there's a string literal at the current offset.

isWhitespace() 受保护 抽象 方法

Returns whether there's a whitespace at the current offset.

If this methos returns true, it has to set the $length parameter to the length of the matched string.

protected abstract boolean isWhitespace(&$length)
$length integer

Length of the matched string.

return boolean

Whether there's a whitespace at the current offset.

startsWithAnyLongest() 受保护 方法

Returns whether the longest common prefix equals to the SQL code of the same length at the current offset.

protected boolean startsWithAnyLongest(array &$with, $caseSensitive, &$length null, &$content null)
$with string[]

Strings to be tested. The method will modify this parameter to speed up lookups.

$caseSensitive boolean

Whether to perform a case sensitive comparison.

$length integer|null

Length of the matched string.

$content string|null

Matched string.

return boolean

Whether a match is found.

substring() 受保护 方法

Returns a string of the given length starting with the specified offset.

protected string substring($length, $caseSensitive true, $offset null)
$length integer

String length to be returned.

$caseSensitive boolean

If it's false, the string will be uppercased.

$offset integer|null

SQL code offset, defaults to current if null is passed.

return string

Result string, it may be empty if there's nothing to return.

tokenize() 公共 方法

Tokenizes and returns a code type token.

public yii\db\SqlToken tokenize()
return yii\db\SqlToken

Code type token.