HumHub Documentation (unofficial)

SqlTokenizer extends SqlTokenizer
in package

Application

SqlTokenizer splits SQLite query into individual SQL tokens.

It's used to obtain a CHECK constraint information from a CREATE TABLE SQL code.

Properties

$behaviors : array<string|int, Behavior>
$sql : string
$length : int
$offset : int
$_behaviors : array<string|int, Behavior>|null
$_buffer : string
$_currentToken : SqlToken
$_events : array<string|int, mixed>
$_eventWildcards : array<string|int, mixed>
$_substrings : array<string|int, string>
$_token : SqlToken
$_tokenStack : SplStack

Methods

__call() : mixed: Calls the named method which is not a class method.
__clone() : mixed: This method is called after the object is created by cloning an existing one.
__construct() : mixed: Constructor.
__get() : mixed: Returns the value of a component property.
__isset() : bool: Checks if a property is set, i.e. defined and not null.
__set() : mixed: Sets the value of a component property.
__unset() : mixed: Sets a component property to be null.
attachBehavior() : Behavior: Attaches a behavior to this component.
attachBehaviors() : mixed: Attaches a list of behaviors to the component.
behaviors() : array<string|int, mixed>: Returns a list of behaviors that this component should behave as.
canGetProperty() : bool: Returns a value indicating whether a property can be read.
canSetProperty() : bool: Returns a value indicating whether a property can be set.
className() : string: Returns the fully qualified name of this class.
detachBehavior() : Behavior|null: Detaches a behavior from the component.
detachBehaviors() : mixed: Detaches all behaviors from the component.
ensureBehaviors() : mixed: Makes sure that the behaviors declared in [[behaviors()]] are attached to this component.
getBehavior() : Behavior|null: Returns the named behavior object.
getBehaviors() : array<string|int, Behavior>: Returns all behaviors attached to this component.
hasEventHandlers() : bool: Returns a value indicating whether there is any handler attached to the named event.
hasMethod() : bool: Returns a value indicating whether a method is defined.
hasProperty() : bool: Returns a value indicating whether a property is defined for this component.
init() : mixed: Initializes the object.
off() : bool: Detaches an existing event handler from this component.
on() : mixed: Attaches an event handler to an event.
tokenize() : SqlToken: Tokenizes and returns a code type token.
trigger() : mixed: Triggers an event.
indexAfter() : int: Returns an index after the given string in the SQL code starting with the specified offset.
isComment() : bool: Returns whether there's a commentary at the current offset.
isIdentifier() : bool: Returns whether there's an identifier at the current offset.
isKeyword() : bool: Returns whether the given string is a keyword.
isOperator() : bool: Returns whether there's an operator at the current offset.
isStringLiteral() : bool: Returns whether there's a string literal at the current offset.
isWhitespace() : bool: Returns whether there's a whitespace at the current offset.
startsWithAnyLongest() : bool: Returns whether the longest common prefix equals to the SQL code of the same length at the current offset.
substring() : string: Returns a string of the given length starting with the specified offset.
addTokenFromBuffer() : mixed: Determines a type of text in the buffer, tokenizes it and adds it to the token children.
advance() : mixed: Adds the specified length to the current offset.
attachBehaviorInternal() : Behavior: Attaches a behavior to this component.
isEof() : bool: Returns whether the SQL code is completely traversed.
tokenizeDelimitedString() : bool: Determines whether there is a delimited string at the current offset and adds it to the token children.
tokenizeOperator() : bool: Determines whether there is an operator at the current offset and adds it to the token children.

$behaviors read-only


    public
        array<string|int, Behavior>
    $behaviors

List of behaviors attached to this component.

$sql


    public
        string
    $sql

SQL code.

$length


    protected
        int
    $length

SQL code string length.

$offset


    protected
        int
    $offset

SQL code string current offset.

$_behaviors


    private
        array<string|int, Behavior>|null
    $_behaviors

the attached behaviors (behavior name => behavior). This is null when not initialized.

$_buffer


    private
        string
    $_buffer
     = ''

current buffer value.

$_currentToken


    private
        SqlToken
    $_currentToken

active token. It's usually a top of the token stack.

$_events


    private
        array<string|int, mixed>
    $_events
     = []

the attached event handlers (event name => handlers)

$_eventWildcards


    private
        array<string|int, mixed>
    $_eventWildcards
     = []

the event handlers attached for wildcard patterns (event name wildcard => handlers)

$_substrings


    private
        array<string|int, string>
    $_substrings

cached substrings.

$_token


    private
        SqlToken
    $_token

resulting token of a last [[tokenize()]] call.

$_tokenStack


    private
        SplStack
    $_tokenStack

stack of active tokens.

__call()

Calls the named method which is not a class method.


    public
                    __call(string $name, array<string|int, mixed> $params) : mixed

This method will check if any attached behavior has the named method and will execute it if available.

Do not call this method directly as it is a PHP magic method that will be implicitly called when an unknown method is being invoked.

Parameters

$name : string: the method name
$params : array<string|int, mixed>: method parameters

Return values

mixed —

the method return value

__clone()

This method is called after the object is created by cloning an existing one.


    public
                    __clone() : mixed

It removes all behaviors because they are attached to the old object.

__construct()

Constructor.


    public
                    __construct(string $sql[, array<string|int, mixed> $config = [] ]) : mixed

Parameters

$sql : string: SQL code to be tokenized.
$config : array<string|int, mixed> = []: name-value pairs that will be used to initialize the object properties

__get()

Returns the value of a component property.


    public
                    __get(string $name) : mixed

This method will check in the following order and act accordingly:

a property defined by a getter: return the getter result
a property of a behavior: return the behavior property value

Do not call this method directly as it is a PHP magic method that will be implicitly called when executing $value = $component->property;.

Parameters

$name : string: the property name

Return values

mixed —

the property value or the value of a behavior's property

__isset()

Checks if a property is set, i.e. defined and not null.


    public
                    __isset(string $name) : bool

This method will check in the following order and act accordingly:

a property defined by a setter: return whether the property is set
a property of a behavior: return whether the property is set
return false for non existing properties

Do not call this method directly as it is a PHP magic method that will be implicitly called when executing isset($component->property).

Parameters

$name : string: the property name or the event name

Return values

bool —

whether the named property is set

__set()

Sets the value of a component property.


    public
                    __set(string $name, mixed $value) : mixed

This method will check in the following order and act accordingly:

a property defined by a setter: set the property value
an event in the format of "on xyz": attach the handler to the event "xyz"
a behavior in the format of "as xyz": attach the behavior named as "xyz"
a property of a behavior: set the behavior property value

Do not call this method directly as it is a PHP magic method that will be implicitly called when executing $component->property = $value;.

Parameters

$name : string: the property name or the event name
$value : mixed: the property value

__unset()

Sets a component property to be null.


    public
                    __unset(string $name) : mixed

This method will check in the following order and act accordingly:

a property defined by a setter: set the property value to be null
a property of a behavior: set the property value to be null

Do not call this method directly as it is a PHP magic method that will be implicitly called when executing unset($component->property).

Parameters

$name : string: the property name

attachBehavior()

Attaches a behavior to this component.


    public
                    attachBehavior(string $name, string|array<string|int, mixed>|Behavior $behavior) : Behavior

This method will create the behavior object based on the given configuration. After that, the behavior object will be attached to this component by calling the [[Behavior::attach()]] method.

Parameters

$name : string

the name of the behavior.

$behavior : string|array<string|int, mixed>|Behavior

the behavior configuration. This can be one of the following:

a [[Behavior]] object
a string specifying the behavior class
an object configuration array that will be passed to [[Yii::createObject()]] to create the behavior object.

Return values

Behavior —

the behavior object

attachBehaviors()

Attaches a list of behaviors to the component.


    public
                    attachBehaviors(array<string|int, mixed> $behaviors) : mixed

Each behavior is indexed by its name and should be a [[Behavior]] object, a string specifying the behavior class, or an configuration array for creating the behavior.

Parameters

$behaviors : array<string|int, mixed>: list of behaviors to be attached to the component

behaviors()

Returns a list of behaviors that this component should behave as.


    public
                    behaviors() : array<string|int, mixed>

Child classes may override this method to specify the behaviors they want to behave as.

The return value of this method should be an array of behavior objects or configurations indexed by behavior names. A behavior configuration can be either a string specifying the behavior class or an array of the following structure:

'behaviorName' => [
    'class' => 'BehaviorClass',
    'property1' => 'value1',
    'property2' => 'value2',
]

Note that a behavior class must extend from [[Behavior]]. Behaviors can be attached using a name or anonymously. When a name is used as the array key, using this name, the behavior can later be retrieved using [[getBehavior()]] or be detached using [[detachBehavior()]]. Anonymous behaviors can not be retrieved or detached.

Behaviors declared in this method will be attached to the component automatically (on demand).

Return values

array<string|int, mixed> —

the behavior configurations.

canGetProperty()

Returns a value indicating whether a property can be read.


    public
                    canGetProperty(string $name[, bool $checkVars = true ][, bool $checkBehaviors = true ]) : bool

A property can be read if:

the class has a getter method associated with the specified name (in this case, property name is case-insensitive);
the class has a member variable with the specified name (when $checkVars is true);
an attached behavior has a readable property of the given name (when $checkBehaviors is true).

Parameters

$name : string: the property name
$checkVars : bool = true: whether to treat member variables as properties
$checkBehaviors : bool = true: whether to treat behaviors' properties as properties of this component

Return values

bool —

whether the property can be read

canSetProperty()

Returns a value indicating whether a property can be set.


    public
                    canSetProperty(string $name[, bool $checkVars = true ][, bool $checkBehaviors = true ]) : bool

A property can be written if:

the class has a setter method associated with the specified name (in this case, property name is case-insensitive);
the class has a member variable with the specified name (when $checkVars is true);
an attached behavior has a writable property of the given name (when $checkBehaviors is true).

Parameters

$name : string: the property name
$checkVars : bool = true: whether to treat member variables as properties
$checkBehaviors : bool = true: whether to treat behaviors' properties as properties of this component

Return values

bool —

whether the property can be written

className()

Returns the fully qualified name of this class.


    public
            static        className() : string

Return values

string —

the fully qualified name of this class.

detachBehavior()

Detaches a behavior from the component.


    public
                    detachBehavior(string $name) : Behavior|null

The behavior's [[Behavior::detach()]] method will be invoked.

Parameters

$name : string: the behavior's name.

Return values

Behavior|null —

the detached behavior. Null if the behavior does not exist.

detachBehaviors()

Detaches all behaviors from the component.


    public
                    detachBehaviors() : mixed

ensureBehaviors()

Makes sure that the behaviors declared in [[behaviors()]] are attached to this component.


    public
                    ensureBehaviors() : mixed

getBehavior()

Returns the named behavior object.


    public
                    getBehavior(string $name) : Behavior|null

Parameters

$name : string: the behavior name

Return values

Behavior|null —

the behavior object, or null if the behavior does not exist

getBehaviors()

Returns all behaviors attached to this component.


    public
                    getBehaviors() : array<string|int, Behavior>

Return values

array<string|int, Behavior> —

list of behaviors attached to this component

hasEventHandlers()

Returns a value indicating whether there is any handler attached to the named event.


    public
                    hasEventHandlers(string $name) : bool

Parameters

$name : string: the event name

Return values

bool —

whether there is any handler attached to the event.

hasMethod()

Returns a value indicating whether a method is defined.


    public
                    hasMethod(string $name[, bool $checkBehaviors = true ]) : bool

A method is defined if:

the class has a method with the specified name
an attached behavior has a method with the given name (when $checkBehaviors is true).

Parameters

$name : string: the property name
$checkBehaviors : bool = true: whether to treat behaviors' methods as methods of this component

Return values

bool —

whether the method is defined

hasProperty()

Returns a value indicating whether a property is defined for this component.


    public
                    hasProperty(string $name[, bool $checkVars = true ][, bool $checkBehaviors = true ]) : bool

A property is defined if:

the class has a getter or setter method associated with the specified name (in this case, property name is case-insensitive);
the class has a member variable with the specified name (when $checkVars is true);
an attached behavior has a property of the given name (when $checkBehaviors is true).

Parameters

$name : string: the property name
$checkVars : bool = true: whether to treat member variables as properties
$checkBehaviors : bool = true: whether to treat behaviors' properties as properties of this component

Return values

bool —

whether the property is defined

init()

Initializes the object.


    public
                    init() : mixed

This method is invoked at the end of the constructor after the object is initialized with the given configuration.

off()

Detaches an existing event handler from this component.


    public
                    off(string $name[, callable|null $handler = null ]) : bool

This method is the opposite of [[on()]].

Note: in case wildcard pattern is passed for event name, only the handlers registered with this wildcard will be removed, while handlers registered with plain names matching this wildcard will remain.

Parameters

$name : string: event name
$handler : callable|null = null: the event handler to be removed. If it is null, all handlers attached to the named event will be removed.

Return values

bool —

if a handler is found and detached

on()

Attaches an event handler to an event.


    public
                    on(string $name, callable $handler[, mixed $data = null ][, bool $append = true ]) : mixed

The event handler must be a valid PHP callback. The following are some examples:

function ($event) { ... }         // anonymous function
[$object, 'handleClick']          // $object->handleClick()
['Page', 'handleClick']           // Page::handleClick()
'handleClick'                     // global function handleClick()

The event handler must be defined with the following signature,

function ($event)

where $event is an [[Event]] object which includes parameters associated with the event.

Since 2.0.14 you can specify event name as a wildcard pattern:

$component->on('event.group.*', function ($event) {
    Yii::trace($event->name . ' is triggered.');
});

Parameters

$name : string: the event name
$handler : callable: the event handler
$data : mixed = null: the data to be passed to the event handler when the event is triggered. When the event handler is invoked, this data can be accessed via [[Event::data]].
$append : bool = true: whether to append new event handler to the end of the existing handler list. If false, the new handler will be inserted at the beginning of the existing handler list.

tokenize()

Tokenizes and returns a code type token.


    public
                    tokenize() : SqlToken

Return values

SqlToken —

code type token.

trigger()

Triggers an event.


    public
                    trigger(string $name[, Event|null $event = null ]) : mixed

This method represents the happening of an event. It invokes all attached handlers for the event including class-level handlers.

Parameters

$name : string: the event name
$event : Event|null = null: the event instance. If not set, a default [[Event]] object will be created.

indexAfter()

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


    protected
                    indexAfter(string $string[, int|null $offset = null ]) : int

Parameters

$string : string: string to be found.
$offset : int|null = null: SQL code offset, defaults to current if null is passed.

Return values

int —

index after the given string or end of string index.

isComment()

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


    protected
                    isComment(mixed &$length) : bool

Parameters

$length : mixed: length of the matched string.

Return values

bool —

whether there's a commentary at the current offset.

isIdentifier()

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


    protected
                    isIdentifier(mixed &$length, mixed &$content) : bool

Parameters

$length : mixed: length of the matched string.
$content : mixed: optional content instead of the matched string.

Return values

bool —

whether there's an identifier at the current offset.

isKeyword()

Returns whether the given string is a keyword.


    protected
                    isKeyword(mixed $string, mixed &$content) : bool

Parameters

$string : mixed: string to be matched.
$content : mixed: optional content instead of the matched string.

Return values

bool —

whether the given string is a keyword.

isOperator()

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


    protected
                    isOperator(mixed &$length, mixed &$content) : bool

Parameters

$length : mixed: length of the matched string.
$content : mixed: optional content instead of the matched string.

Return values

bool —

whether there's an operator at the current offset.

isStringLiteral()

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


    protected
                    isStringLiteral(mixed &$length, mixed &$content) : bool

Parameters

$length : mixed: length of the matched string.
$content : mixed: optional content instead of the matched string.

Return values

bool —

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

isWhitespace()

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


    protected
                    isWhitespace(mixed &$length) : bool

Parameters

$length : mixed: length of the matched string.

Return values

bool —

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
                    startsWithAnyLongest(array<string|int, string> &$with, bool $caseSensitive[, int|null &$length = null ][, string|null &$content = null ]) : bool

Parameters

$with : array<string|int, string>: strings to be tested. The method will modify this parameter to speed up lookups.
$caseSensitive : bool: whether to perform a case sensitive comparison.
$length : int|null = null: length of the matched string.
$content : string|null = null: matched string.

Return values

bool —

whether a match is found.

substring()

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


    protected
                    substring(int $length[, bool $caseSensitive = true ][, int|null $offset = null ]) : string

Parameters

$length : int: string length to be returned.
$caseSensitive : bool = true: if it's false, the string will be uppercased.
$offset : int|null = null: SQL code offset, defaults to current if null is passed.

Return values

string —

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

addTokenFromBuffer()

Determines a type of text in the buffer, tokenizes it and adds it to the token children.


    private
                    addTokenFromBuffer() : mixed

advance()

Adds the specified length to the current offset.


    private
                    advance(int $length) : mixed

Parameters

$length : int

attachBehaviorInternal()

Attaches a behavior to this component.


    private
                    attachBehaviorInternal(string|int $name, string|array<string|int, mixed>|Behavior $behavior) : Behavior

Parameters

$name : string|int: the name of the behavior. If this is an integer, it means the behavior is an anonymous one. Otherwise, the behavior is a named one and any existing behavior with the same name will be detached first.
$behavior : string|array<string|int, mixed>|Behavior: the behavior to be attached

Return values

Behavior —

the attached behavior.

isEof()

Returns whether the SQL code is completely traversed.


    private
                    isEof() : bool

Return values

bool

tokenizeDelimitedString()

Determines whether there is a delimited string at the current offset and adds it to the token children.


    private
                    tokenizeDelimitedString(int &$length) : bool

Parameters

$length : int

Return values

bool

tokenizeOperator()

Determines whether there is an operator at the current offset and adds it to the token children.


    private
                    tokenizeOperator(int &$length) : bool

Parameters

$length : int

Return values

bool

SqlTokenizer extends SqlTokenizer in package Application

Tags

Table of Contents

Properties

Methods

Properties

$behaviors read-only

$sql

$length

$offset

$_behaviors

$_buffer

$_currentToken

$_events

$_eventWildcards

Tags

$_substrings

$_token

$_tokenStack

Methods

__call()

Parameters

Tags

Return values

__clone()

__construct()

Parameters

__get()

Parameters

Tags

Return values

__isset()

Parameters

Tags

Return values

__set()

Parameters

Tags

__unset()

Parameters

Tags

attachBehavior()

Parameters

Tags

Return values

attachBehaviors()

Parameters

Tags

behaviors()

Return values

canGetProperty()

Parameters

Tags

Return values

canSetProperty()

Parameters

Tags

Return values

className()

Tags

Return values

detachBehavior()

Parameters

Return values

detachBehaviors()

ensureBehaviors()

getBehavior()

Parameters

Return values

getBehaviors()

Return values

hasEventHandlers()

Parameters

SqlTokenizer extends SqlTokenizer
in package

Application