Index
A
- AlterOperation — Class in namespace PhpMyAdmin\SqlParser\Components
Parses an alter operation.
- ArrayObj — Class in namespace PhpMyAdmin\SqlParser\Components
Parses an array.
- $ CaseExpression#alias — Property in class CaseExpression
The alias of this CASE statement.
- $ Expression#alias — Property in class Expression
The alias of this expression.
- AlterOperations — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses an alter operation.
- Array2d — Class in namespace PhpMyAdmin\SqlParser\Parsers
VALUES
keyword parser.- ArrayObjs — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses an array.
- Statement::after() — Method in class Statement
Function called after the token was processed.
- AlterStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
ALTER
statement.- $ AlterStatement#altered — Property in class AlterStatement
Column affected by this statement.
- AnalyzeStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
ANALYZE
statement.- MaintenanceStatement::after() — Method in class MaintenanceStatement
Function called after the token was processed.
- UpdateStatement::after() — Method in class UpdateStatement
Function called after the token was processed.
- TokensList::add() — Method in class TokensList
Adds a new token.
B
- Component::build() — Method in class Component
Builds the string representation of a component of this type.
- AlterOperation::build() — Method in class AlterOperation
Builds the string representation of a component of this type.
- ArrayObj::build() — Method in class ArrayObj
Builds the string representation of a component of this type.
- CaseExpression::build() — Method in class CaseExpression
Builds the string representation of a component of this type.
- Condition::build() — Method in class Condition
Builds the string representation of a component of this type.
- CreateDefinition::build() — Method in class CreateDefinition
Builds the string representation of a component of this type.
- DataType::build() — Method in class DataType
Builds the string representation of a component of this type.
- Expression::build() — Method in class Expression
Builds the string representation of a component of this type.
- FunctionCall::build() — Method in class FunctionCall
Builds the string representation of a component of this type.
- GroupKeyword::build() — Method in class GroupKeyword
Builds the string representation of a component of this type.
- IndexHint::build() — Method in class IndexHint
Builds the string representation of a component of this type.
- IntoKeyword::build() — Method in class IntoKeyword
Builds the string representation of a component of this type.
- JoinKeyword::build() — Method in class JoinKeyword
Builds the string representation of a component of this type.
- Key::build() — Method in class Key
Builds the string representation of a component of this type.
- Limit::build() — Method in class Limit
Builds the string representation of a component of this type.
- LockExpression::build() — Method in class LockExpression
Builds the string representation of a component of this type.
- LockExpression::buildAll() — Method in class LockExpression
- OptionsArray::build() — Method in class OptionsArray
Builds the string representation of a component of this type.
- OrderKeyword::build() — Method in class OrderKeyword
Builds the string representation of a component of this type.
- ParameterDefinition::build() — Method in class ParameterDefinition
Builds the string representation of a component of this type.
- PartitionDefinition::build() — Method in class PartitionDefinition
Builds the string representation of a component of this type.
- Reference::build() — Method in class Reference
Builds the string representation of a component of this type.
- RenameOperation::build() — Method in class RenameOperation
Builds the string representation of a component of this type.
- SetOperation::build() — Method in class SetOperation
Builds the string representation of a component of this type.
- WithKeyword::build() — Method in class WithKeyword
Builds the string representation of a component of this type.
- $ Parser#brackets — Property in class Parser
The number of opened brackets.
- ArrayObjs::buildAll() — Method in class ArrayObjs
- Conditions::buildAll() — Method in class Conditions
- CreateDefinitions::buildAll() — Method in class CreateDefinitions
- ExpressionArray::buildAll() — Method in class ExpressionArray
- Expressions::buildAll() — Method in class Expressions
- GroupKeywords::buildAll() — Method in class GroupKeywords
- IndexHints::buildAll() — Method in class IndexHints
- JoinKeywords::buildAll() — Method in class JoinKeywords
- OrderKeywords::buildAll() — Method in class OrderKeywords
- ParameterDefinitions::buildAll() — Method in class ParameterDefinitions
- PartitionDefinitions::buildAll() — Method in class PartitionDefinitions
- RenameOperations::buildAll() — Method in class RenameOperations
- SetOperations::buildAll() — Method in class SetOperations
- UnionKeywords::buildAll() — Method in class UnionKeywords
- Statement::build() — Method in class Statement
Builds the string representation of this statement.
- Statement::before() — Method in class Statement
Function called before the token is processed.
- AlterStatement::build() — Method in class AlterStatement
Builds the string representation of this statement.
- BackupStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
BACKUP
statement.- CallStatement::build() — Method in class CallStatement
Build statement for CALL.
- $ CreateStatement#body — Property in class CreateStatement
The body of this function or procedure.
- CreateStatement::build() — Method in class CreateStatement
Builds the string representation of this statement.
- DeleteStatement::build() — Method in class DeleteStatement
Builds the string representation of this statement.
- $ ExplainStatement#bodyParser — Property in class ExplainStatement
The parser of the statement to be explained
- ExplainStatement::build() — Method in class ExplainStatement
Builds the string representation of this statement.
- InsertStatement::build() — Method in class InsertStatement
Builds the string representation of this statement.
- KillStatement::build() — Method in class KillStatement
Builds the string representation of this statement.
- LoadStatement::build() — Method in class LoadStatement
Builds the string representation of this statement.
- LockStatement::build() — Method in class LockStatement
Builds the string representation of this statement.
- NotImplementedStatement::build() — Method in class NotImplementedStatement
Builds the string representation of this statement.
- PurgeStatement::build() — Method in class PurgeStatement
Builds the string representation of this statement.
- RenameStatement::before() — Method in class RenameStatement
Function called before the token is processed.
- RenameStatement::build() — Method in class RenameStatement
Builds the string representation of this statement.
- ReplaceStatement::build() — Method in class ReplaceStatement
Builds the string representation of this statement.
- SetStatement::build() — Method in class SetStatement
Builds the string representation of this statement.
- TransactionStatement::build() — Method in class TransactionStatement
Builds the string representation of this statement.
- TruncateStatement::build() — Method in class TruncateStatement
Special build method for truncate statement as Statement::build would return empty string.
- WithStatement::build() — Method in class WithStatement
Builds the string representation of this statement.
- TokensList::build() — Method in class TokensList
Builds an array of tokens by merging their raw value.
- TokensList::buildFromArray() — Method in class TokensList
Builds an array of tokens by merging their raw value.
- ContextGenerator::build() — Method in class ContextGenerator
Builds a test.
- ContextGenerator::buildAll() — Method in class ContextGenerator
Generates recursively all tests preserving the directory structure.
- TestGenerator::build() — Method in class TestGenerator
Builds a test.
- TestGenerator::buildAll() — Method in class TestGenerator
Generates recursively all tests preserving the directory structure.
- BufferedQuery — Class in namespace PhpMyAdmin\SqlParser\Utils
Buffer query utilities.
C
- Component — Class in namespace PhpMyAdmin\SqlParser
Defines a component that is later extended to parse specialized components or keywords.
- CaseExpression — Class in namespace PhpMyAdmin\SqlParser\Components
Parses a reference to a CASE expression.
- $ CaseExpression#conditions — Property in class CaseExpression
The conditions in WHEN clauses.
- $ CaseExpression#compareValues — Property in class CaseExpression
The values to be compared against.
- Condition — Class in namespace PhpMyAdmin\SqlParser\Components
- CreateDefinition — Class in namespace PhpMyAdmin\SqlParser\Components
Parses the create definition of a column or a key.
- $ Expression#column — Property in class Expression
The name of the column.
- $ IntoKeyword#columns — Property in class IntoKeyword
The name of the columns.
- $ Key#columns — Property in class Key
The key columns
- $ Reference#columns — Property in class Reference
The referenced columns.
- $ SetOperation#column — Property in class SetOperation
The name of the column that is being updated.
- $ WithKeyword#columns — Property in class WithKeyword
- Context — Class in namespace PhpMyAdmin\SqlParser
Defines a context class that is later extended to define other contexts.
- ContextMariaDb100000 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.0.
- ContextMariaDb100100 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.1.
- ContextMariaDb100200 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.2.
- ContextMariaDb100300 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.3.
- ContextMariaDb100400 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.4.
- ContextMariaDb100500 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.5.
- ContextMariaDb100600 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.6.
- ContextMariaDb100700 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.7.
- ContextMariaDb100800 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.8.
- ContextMariaDb100900 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.9.
- ContextMariaDb101000 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.10.
- ContextMariaDb101100 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 10.11.
- ContextMariaDb110000 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 11.0.
- ContextMariaDb110100 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 11.1.
- ContextMariaDb110200 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 11.2.
- ContextMariaDb110300 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 11.3.
- ContextMariaDb110400 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 11.4.
- ContextMariaDb110500 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 11.5.
- ContextMariaDb110600 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 11.6.
- ContextMariaDb110700 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MariaDB 11.7.
- ContextMySql50000 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 5.0.
- ContextMySql50100 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 5.1.
- ContextMySql50500 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 5.5.
- ContextMySql50600 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 5.6.
- ContextMySql50700 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 5.7.
- ContextMySql80000 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 8.0.
- ContextMySql80100 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 8.1.
- ContextMySql80200 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 8.2.
- ContextMySql80300 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 8.3.
- ContextMySql80400 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 8.4.
- ContextMySql90000 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 9.0.
- ContextMySql90100 — Class in namespace PhpMyAdmin\SqlParser\Contexts
Context for MySQL 9.1.
- $ LexerException#ch — Property in class LexerException
The character that produced this error.
- CaseExpressions — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses a reference to a CASE expression.
- Conditions — Class in namespace PhpMyAdmin\SqlParser\Parsers
WHERE
keyword parser.- CreateDefinitions — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses the create definition of a column or a key.
- $ Statement#clauses — Property in class Statement
The clauses of this statement, in order.
- CallStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
CALL
statement.- $ CallStatement#call — Property in class CallStatement
The name of the function and its parameters.
- CheckStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
CHECK
statement.- ChecksumStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
CHECKSUM
statement.- CreateStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
CREATE
statement.- $ DeleteStatement#clauses — Property in class DeleteStatement
The clauses of this statement, in order.
- $ DeleteStatement#columns — Property in class DeleteStatement
Columns used in this statement.
- $ DropStatement#clauses — Property in class DropStatement
The clauses of this statement, in order.
- $ ExplainStatement#connectionId — Property in class ExplainStatement
The connection identifier, if used.
- $ LoadStatement#charsetName — Property in class LoadStatement
Character set used in this statement.
- $ LoadStatement#columnNamesOrUserVariables — Property in class LoadStatement
Column names or user variables.
- $ SelectStatement#clauses — Property in class SelectStatement
The clauses of this statement, in order.
- $ SetStatement#clauses — Property in class SetStatement
The clauses of this statement, in order.
- $ UpdateStatement#clauses — Property in class UpdateStatement
The clauses of this statement, in order.
- $ WithStatement#clauses — Property in class WithStatement
The clauses of this statement, in order.
- $ WithStatement#cteStatementParser — Property in class WithStatement
holds the CTE parser.
- $ TokensList#count — Property in class TokensList
The count of tokens.
- ContextGenerator — Class in namespace PhpMyAdmin\SqlParser\Tools
Used for context generation.
- CustomJsonSerializer — Class in namespace PhpMyAdmin\SqlParser\Tools
Used for .out files generation
- $ UtfString#characters — Property in class UtfString
The multi-byte characters.
- $ BufferedQuery#current — Property in class BufferedQuery
The last incomplete query that was extracted.
- CLI — Class in namespace PhpMyAdmin\SqlParser\Utils
CLI interface.
D
- DataType — Class in namespace PhpMyAdmin\SqlParser\Components
Parses a data type.
- $ Expression#database — Property in class Expression
The name of this database.
- $ IntoKeyword#dest — Property in class IntoKeyword
The destination, which can be a table or a file.
- $ Lexer#defaultDelimiter — Property in class Lexer
The default delimiter. This is used, by default, in all new instances.
- $ Lexer#delimiter — Property in class Lexer
Statements delimiter.
- $ Lexer#delimiterLen — Property in class Lexer
The length of the delimiter.
- DataTypes — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses a data type.
- DeleteStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
DELETE
statement.- DropStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
DROP
statement.- $ BufferedQuery#delimiter — Property in class BufferedQuery
The last delimiter used.
- $ BufferedQuery#delimiterLen — Property in class BufferedQuery
The length of the delimiter.
- $ StatementFlags#distinct — Property in class StatementFlags
select ... DISTINCT .
- $ StatementFlags#dropDatabase — Property in class StatementFlags
drop ... DATABASE .
E
- $ CaseExpression#elseResult — Property in class CaseExpression
The result in ELSE section of expr.
- $ CaseExpression#expr — Property in class CaseExpression
The sub-expression.
- $ Condition#expr — Property in class Condition
The condition.
- Expression — Class in namespace PhpMyAdmin\SqlParser\Components
Parses a reference to an expression (column, table or database name, function call, mathematical expression, etc.).
- $ Expression#expr — Property in class Expression
The sub-expression.
- $ GroupKeyword#expr — Property in class GroupKeyword
The expression that is used for grouping.
- $ JoinKeyword#expr — Property in class JoinKeyword
Join expression.
- $ Key#expr — Property in class Key
The expression if the Key is not using column names
- $ OrderKeyword#expr — Property in class OrderKeyword
The expression that is used for ordering.
- $ PartitionDefinition#expr — Property in class PartitionDefinition
The expression used to defined this partition.
- Context::escape() — Method in class Context
Escapes the symbol by adding surrounding backticks.
- Context::escapeAll() — Method in class Context
Escapes the symbol by adding surrounding backticks.
- $ Lexer#errors — Property in class Lexer
List of errors that occurred during lexing.
- Lexer::error() — Method in class Lexer
Creates a new error log.
- $ Parser#errors — Property in class Parser
List of errors that occurred during lexing.
- Parser::error() — Method in class Parser
Creates a new error log.
- ExpressionArray — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses a list of expressions delimited by a comma.
- Expressions — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses a reference to an expression (column, table or database name, function call, mathematical expression, etc.).
- $ CreateStatement#entityOptions — Property in class CreateStatement
The options of the entity (table, procedure, function, etc.).
- ExplainStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
EXPLAIN
statement.- $ ExplainStatement#explainedDatabase — Property in class ExplainStatement
The explained database for the table's name, if used.
- $ ExplainStatement#explainedTable — Property in class ExplainStatement
The explained table's name, if used.
- $ ExplainStatement#explainedColumn — Property in class ExplainStatement
The explained column's name, if used.
- $ PurgeStatement#endOption — Property in class PurgeStatement
The end option of this query.
- $ PurgeStatement#endExpr — Property in class PurgeStatement
The end expr of this query.
- $ SelectStatement#expr — Property in class SelectStatement
Expressions that are being selected by this statement.
- $ SelectStatement#endOptions — Property in class SelectStatement
The end options of this query.
- $ SetStatement#endOptions — Property in class SetStatement
The end options of this query.
- $ TransactionStatement#end — Property in class TransactionStatement
The ending transaction statement which may be a
COMMIT
or aROLLBACK
.- Token::extract() — Method in class Token
Does a little processing to the token to extract a value.
- CustomJsonSerializer::extractObjectData() — Method in class CustomJsonSerializer
Extract the object data
- BufferedQuery::extract() — Method in class BufferedQuery
Extracts a statement from the buffer.
- Error — Class in namespace PhpMyAdmin\SqlParser\Utils
Error related utilities.
- Formatter::escapeConsole() — Method in class Formatter
F
- $ AlterOperation#field — Property in class AlterOperation
The altered field.
- $ Expression#function — Property in class Expression
The name of the function.
- FunctionCall — Class in namespace PhpMyAdmin\SqlParser\Components
Parses a function call.
- $ IndexHint#for — Property in class IndexHint
The clause for which this hint is (JOIN/ORDER BY/GROUP BY)
- $ IntoKeyword#fieldsOptions — Property in class IntoKeyword
Options for FIELDS/COLUMNS keyword.
- $ IntoKeyword#fieldsKeyword — Property in class IntoKeyword
Whether to use
FIELDS
orCOLUMNS
while building.- FunctionCalls — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses a function call.
- $ Statement#first — Property in class Statement
The index of the first token used in this statement.
- $ CreateStatement#fields — Property in class CreateStatement
If
CREATE TABLE
, a list of columns and keys.- $ DeleteStatement#from — Property in class DeleteStatement
Table(s) used as sources for this statement.
- $ DropStatement#fields — Property in class DropStatement
Dropped elements.
- $ LoadStatement#fileName — Property in class LoadStatement
File name being used to load data.
- $ LoadStatement#fieldsOptions — Property in class LoadStatement
Options for FIELDS/COLUMNS keyword.
- $ LoadStatement#fieldsKeyword — Property in class LoadStatement
Whether to use
FIELDS
orCOLUMNS
while building.- $ SelectStatement#from — Property in class SelectStatement
Tables used as sources for this statement.
- $ Token#flags — Property in class Token
The flags of this token.
- ContextGenerator::formatName() — Method in class ContextGenerator
Formats context name.
- Error::format() — Method in class Error
Formats the specified errors.
- ForeignKey — Class in namespace PhpMyAdmin\SqlParser\Utils
- Formatter — Class in namespace PhpMyAdmin\SqlParser\Utils
Utilities that are used for formatting queries.
- Formatter::formatList() — Method in class Formatter
Formats the given list of tokens.
- Formatter::format() — Method in class Formatter
Formats a query.
- $ Query#functions — Property in class Query
Functions that set the flag
is_func
.
G
- GroupKeyword — Class in namespace PhpMyAdmin\SqlParser\Components
GROUP BY
keyword parser.- OptionsArray::get() — Method in class OptionsArray
Checks if it has the specified option and returns its value.
- Context::getMode() — Method in class Context
Gets the SQL mode.
- GroupKeywords — Class in namespace PhpMyAdmin\SqlParser\Parsers
GROUP BY
keyword parser.- Statement::getClauses() — Method in class Statement
Gets the clauses of this statement.
- Statement::getClauseOrder() — Method in class Statement
Gets the clause order of this statement as an array with clause as key and index as value.
- CreateStatement::getForeignKeys() — Method in class CreateStatement
- $ SelectStatement#group — Property in class SelectStatement
Conditions used for grouping the result set.
- $ SelectStatement#groupOptions — Property in class SelectStatement
List of options available for the GROUP BY component.
- SelectStatement::getClauses() — Method in class SelectStatement
Gets the clauses of this statement.
- SelectStatement::getAliases() — Method in class SelectStatement
Gets a list of all aliases and their original names.
- Token::getInlineToken() — Method in class Token
Converts the token into an inline token by replacing tabs and new lines.
- TokensList::getNext() — Method in class TokensList
Gets the next token. Skips any irrelevant token (whitespaces and comments).
- TokensList::getPrevious() — Method in class TokensList
Gets the previous token. Skips any irrelevant token (whitespaces and comments).
- TokensList::getPreviousOfType() — Method in class TokensList
Gets the previous token.
- TokensList::getNextOfType() — Method in class TokensList
Gets the next token.
- TokensList::getNextOfTypeAndValue() — Method in class TokensList
Gets the next token.
- TokensList::getNextOfTypeAndFlag() — Method in class TokensList
Gets the next token.
- ContextGenerator::generate() — Method in class ContextGenerator
Generates a context's class.
- TestGenerator::generate() — Method in class TestGenerator
Generates a test's data.
- Translator::gettext() — Method in class Translator
Translates a string.
- Translator::getLocale() — Method in class Translator
- CLI::getopt() — Method in class CLI
- Error::get() — Method in class Error
Gets the errors of a lexer and a parser.
- Formatter::getMergedOptions() — Method in class Formatter
The specified formatting options are merged with the default values.
- Formatter::getDefaultOptions() — Method in class Formatter
The default formatting options.
- Formatter::getDefaultFormats() — Method in class Formatter
The styles used for HTML formatting.
- Formatter::getGroupLength() — Method in class Formatter
Computes the length of a group.
- Query::getFlags() — Method in class Query
Gets an array with flags this statement has.
- Query::getAll() — Method in class Query
Parses a query and gets all information about it.
- Query::getTables() — Method in class Query
Gets a list of all tables used in this statement.
- Query::getClause() — Method in class Query
Gets a specific clause.
- Query::getFirstStatement() — Method in class Query
Gets the first full statement in the query.
- Query::getClauseStartOffset() — Method in class Query
Gets a starting offset of a specific clause.
- $ StatementFlags#group — Property in class StatementFlags
- Table::getFields() — Method in class Table
Gets fields of the table.
H
- OptionsArray::has() — Method in class OptionsArray
- Context::hasMode() — Method in class Context
Function verifies that given SQL Mode constant is currently set
- $ SelectStatement#having — Property in class SelectStatement
Conditions used for filtering the result set.
- $ StatementFlags#having — Property in class StatementFlags
I
- $ Condition#identifiers — Property in class Condition
Identifiers recognized.
- $ Condition#isOperator — Property in class Condition
Whether this component is an operator.
- $ CreateDefinition#isConstraint — Property in class CreateDefinition
Whether this field is a constraint or not.
- IndexHint — Class in namespace PhpMyAdmin\SqlParser\Components
Parses an Index hint.
- $ IndexHint#indexOrKey — Property in class IndexHint
What the hint is for (INDEX/KEY)
- $ IndexHint#indexes — Property in class IndexHint
List of indexes in this hint
- IntoKeyword — Class in namespace PhpMyAdmin\SqlParser\Components
INTO
keyword parser.- OptionsArray::isEmpty() — Method in class OptionsArray
Checks tf there are no options set.
- $ ParameterDefinition#inOut — Property in class ParameterDefinition
Parameter's direction (IN, OUT or INOUT).
- $ PartitionDefinition#isSubpartition — Property in class PartitionDefinition
Whether this entry is a subpartition or a partition.
- Context::isKeyword() — Method in class Context
Checks if the given string is a keyword.
- Context::isOperator() — Method in class Context
Checks if the given string is an operator and returns the appropriate flag for the operator.
- Context::isWhitespace() — Method in class Context
Checks if the given character is a whitespace.
- Context::isComment() — Method in class Context
Checks if the given string is the beginning of a whitespace.
- Context::isBool() — Method in class Context
Checks if the given string is a boolean value.
- Context::isNumber() — Method in class Context
Checks if the given character can be a part of a number.
- Context::isSymbol() — Method in class Context
Checks if the given character is the beginning of a symbol. A symbol can be either a variable or a field name.
- Context::isString() — Method in class Context
Checks if the given character is the beginning of a string.
- Context::isSeparator() — Method in class Context
Checks if the given character can be a separator for two lexeme.
- IndexHints — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses an Index hint.
- IntoKeywords — Class in namespace PhpMyAdmin\SqlParser\Parsers
INTO
keyword parser.- InsertStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
INSERT
statement.- $ InsertStatement#into — Property in class InsertStatement
Tables used as target for this statement.
- $ KillStatement#identifier — Property in class KillStatement
Holds the identifier if explicitly set
- $ KillStatement#idKeywordUsed — Property in class KillStatement
Whether MariaDB ID keyword is used or not.
- $ LoadStatement#ignoreNumber — Property in class LoadStatement
Ignore 'number' LINES/ROWS.
- $ LockStatement#isLock — Property in class LockStatement
Whether it's a LOCK statement if false, it's an UNLOCK statement
- $ ReplaceStatement#into — Property in class ReplaceStatement
Tables used as target for this statement.
- $ SelectStatement#indexHints — Property in class SelectStatement
Index hints
- $ SelectStatement#into — Property in class SelectStatement
Destination of this result set.
- $ TokensList#idx — Property in class TokensList
The index of the next token to be returned.
- $ Formatter#inlineClauses — Property in class Formatter
Clauses that must be inlined.
- Formatter::isClause() — Method in class Formatter
Checks if a token is a statement or a clause inside a statement.
- $ StatementFlags#isAffected — Property in class StatementFlags
INSERT ... or REPLACE ... or DELETE .
- $ StatementFlags#isAnalyse — Property in class StatementFlags
select ... PROCEDURE ANALYSE( ... ) .
- $ StatementFlags#isCount — Property in class StatementFlags
select COUNT( ... ) .
- $ StatementFlags#isDelete — Property in class StatementFlags
DELETE .
- $ StatementFlags#isExplain — Property in class StatementFlags
EXPLAIN .
- $ StatementFlags#isExport — Property in class StatementFlags
select ... INTO OUTFILE .
- $ StatementFlags#isFunc — Property in class StatementFlags
select FUNC( ... ) .
- $ StatementFlags#isGroup — Property in class StatementFlags
select ... GROUP BY ... or select ... HAVING .
- $ StatementFlags#isInsert — Property in class StatementFlags
INSERT ... or REPLACE ... or LOAD DATA .
- $ StatementFlags#isMaint — Property in class StatementFlags
ANALYZE ... or CHECK ... or CHECKSUM ... or OPTIMIZE ... or REPAIR .
- $ StatementFlags#isProcedure — Property in class StatementFlags
CALL .
- $ StatementFlags#isReplace — Property in class StatementFlags
REPLACE .
- $ StatementFlags#isSelect — Property in class StatementFlags
SELECT .
- $ StatementFlags#isShow — Property in class StatementFlags
SHOW .
- $ StatementFlags#isSubQuery — Property in class StatementFlags
Contains a subquery.
J
- JoinKeyword — Class in namespace PhpMyAdmin\SqlParser\Components
JOIN
keyword parser.- JoinKeywords — Class in namespace PhpMyAdmin\SqlParser\Parsers
JOIN
keyword parser.- $ DeleteStatement#join — Property in class DeleteStatement
- Joins.
- $ SelectStatement#join — Property in class SelectStatement
- Joins.
- $ UpdateStatement#join — Property in class UpdateStatement
- Joins.
- $ StatementFlags#join — Property in class StatementFlags
K
- $ CreateDefinition#key — Property in class CreateDefinition
The key.
- Key — Class in namespace PhpMyAdmin\SqlParser\Components
Parses the definition of a key.
- $ Context#keywords — Property in class Context
List of keywords.
- Keys — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses the definition of a key.
- KillStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
KILL [HARD|SOFT] { {CONNECTION|QUERY} id | QUERY ID query_id | USER user_name }
- $ Token#keyword — Property in class Token
The keyword value this token contains, always uppercase.
L
- $ Condition#leftOperand — Property in class Condition
- $ DataType#lowercase — Property in class DataType
- $ IntoKeyword#linesOptions — Property in class IntoKeyword
Options for OPTIONS keyword.
- Limit — Class in namespace PhpMyAdmin\SqlParser\Components
LIMIT
keyword parser.- LockExpression — Class in namespace PhpMyAdmin\SqlParser\Components
Parses a reference to a LOCK expression.
- $ Context#loadedContext — Property in class Context
The name of the loaded context.
- Context::load() — Method in class Context
Loads the specified context.
- Context::loadClosest() — Method in class Context
Loads the context with the closest version to the one specified.
- LexerException — Class in namespace PhpMyAdmin\SqlParser\Exceptions
Exception thrown by the lexer.
- Lexer — Class in namespace PhpMyAdmin\SqlParser
Defines the lexer of the library.
- $ Lexer#len — Property in class Lexer
The length of
$str
.- $ Lexer#last — Property in class Lexer
The index of the last parsed character.
- $ Lexer#list — Property in class Lexer
Tokens extracted from given strings.
- Lexer::lex() — Method in class Lexer
Parses the string and extracts lexemes.
- $ Parser#list — Property in class Parser
The list of tokens that are parsed.
- Limits — Class in namespace PhpMyAdmin\SqlParser\Parsers
LIMIT
keyword parser.- LockExpressions — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses a reference to a LOCK expression.
- $ Statement#last — Property in class Statement
The index of the last token used in this statement.
- $ CreateStatement#like — Property in class CreateStatement
If
CREATE TABLE ... LIKE
.- $ DeleteStatement#limit — Property in class DeleteStatement
Conditions used for limiting the size of the result set.
- LoadStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
LOAD
statement.- $ LoadStatement#linesOptions — Property in class LoadStatement
Options for OPTIONS keyword.
- $ LoadStatement#linesRows — Property in class LoadStatement
LINES/ROWS Keyword.
- LockStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
LOCK
statement.- $ LockStatement#locked — Property in class LockStatement
Tables with their Lock expressions.
- $ PurgeStatement#logType — Property in class PurgeStatement
The type of logs
- $ SelectStatement#limit — Property in class SelectStatement
Conditions used for limiting the size of the result set.
- $ UpdateStatement#limit — Property in class UpdateStatement
Conditions used for limiting the size of the result set.
- $ ContextGenerator#labelsFlags — Property in class ContextGenerator
Labels and flags that may be used when defining keywords.
- $ ContextGenerator#links — Property in class ContextGenerator
Documentation links for each context.
- Translator::load() — Method in class Translator
Loads translator.
- UtfString::length() — Method in class UtfString
Returns the length in characters of the string.
- $ StatementFlags#limit — Property in class StatementFlags
M
- OptionsArray::merge() — Method in class OptionsArray
Merges the specified options with these ones. Values with same ID will be replaced.
- $ Context#mode — Property in class Context
The mode of the MySQL server that will be used in lexing, parsing and building the statements.
- MaintenanceStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
Maintenance statement.
- CLI::mergeLongOpts() — Method in class CLI
N
- $ CreateDefinition#name — Property in class CreateDefinition
The name of the new column.
- $ DataType#name — Property in class DataType
The name of the data type.
- $ FunctionCall#name — Property in class FunctionCall
The name of this function.
- $ Key#name — Property in class Key
The name of this key.
- $ ParameterDefinition#name — Property in class ParameterDefinition
The name of the new column.
- $ PartitionDefinition#name — Property in class PartitionDefinition
The name of this partition.
- $ RenameOperation#new — Property in class RenameOperation
The new table name.
- $ CreateStatement#name — Property in class CreateStatement
The name of the entity that is created.
- NotImplementedStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
Not implemented (yet) statements.
O
- $ AlterOperation#options — Property in class AlterOperation
Options of this operation.
- $ Condition#operator — Property in class Condition
- $ CreateDefinition#options — Property in class CreateDefinition
The options of this field.
- $ DataType#options — Property in class DataType
The options of this data type.
- $ JoinKeyword#on — Property in class JoinKeyword
Join conditions.
- $ Key#options — Property in class Key
The options of this key or null if none where found.
- $ Limit#offset — Property in class Limit
The number of rows skipped.
- OptionsArray — Class in namespace PhpMyAdmin\SqlParser\Components
- OrderKeyword — Class in namespace PhpMyAdmin\SqlParser\Components
ORDER BY
keyword parser.- $ PartitionDefinition#options — Property in class PartitionDefinition
The options of this field.
- $ Reference#options — Property in class Reference
The options of the referencing.
- $ RenameOperation#old — Property in class RenameOperation
The old table name.
- OptionsArrays — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses a list of options.
- OrderKeywords — Class in namespace PhpMyAdmin\SqlParser\Parsers
ORDER BY
keyword parser.- $ Statement#options — Property in class Statement
The options of this query.
- $ DeleteStatement#order — Property in class DeleteStatement
Specifies the order of the rows in the result set.
- $ InsertStatement#onDuplicateSet — Property in class InsertStatement
If ON DUPLICATE KEY UPDATE clause is present holds the SetOperation.
- OptimizeStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
OPTIMIZE
statement.- $ SelectStatement#order — Property in class SelectStatement
Specifies the order of the rows in the result set.
- $ SetStatement#options — Property in class SetStatement
Options used in current statement.
- $ UpdateStatement#order — Property in class UpdateStatement
Specifies the order of the rows in the result set.
- TokensList::offsetSet() — Method in class TokensList
Sets a Token inside the list of tokens.
- TokensList::offsetGet() — Method in class TokensList
Gets a Token from the list of tokens.
- TokensList::offsetExists() — Method in class TokensList
Checks if an offset was previously set.
- TokensList::offsetUnset() — Method in class TokensList
Unsets the value of an offset, if the offset exists.
- UtfString::offsetExists() — Method in class UtfString
Checks if the given offset exists.
- UtfString::offsetGet() — Method in class UtfString
Gets the character at given offset.
- UtfString::offsetSet() — Method in class UtfString
Sets the value of a character.
- UtfString::offsetUnset() — Method in class UtfString
Unsets an index.
- $ BufferedQuery#options — Property in class BufferedQuery
The options of this parser.
- $ Formatter#options — Property in class Formatter
The formatting options.
- $ StatementFlags#offset — Property in class StatementFlags
- TODO
- $ StatementFlags#order — Property in class StatementFlags
P
- $ AlterOperation#partitions — Property in class AlterOperation
The partitions.
- $ DataType#parameters — Property in class DataType
The parameters of this data type.
- $ FunctionCall#parameters — Property in class FunctionCall
The list of parameters.
- IntoKeyword::parseFileOptions() — Method in class IntoKeyword
- ParameterDefinition — Class in namespace PhpMyAdmin\SqlParser\Components
The definition of a parameter of a function or procedure.
- PartitionDefinition — Class in namespace PhpMyAdmin\SqlParser\Components
Parses the create definition of a partition.
- $ PartitionDefinition#partitionOptions — Property in class PartitionDefinition
All field options.
- $ LexerException#pos — Property in class LexerException
The index of the character that produced this error.
- ParserException — Class in namespace PhpMyAdmin\SqlParser\Exceptions
Exception thrown by the parser.
- Lexer::parseKeyword() — Method in class Lexer
Parses a keyword.
- Lexer::parseLabel() — Method in class Lexer
Parses a label.
- Lexer::parseOperator() — Method in class Lexer
Parses an operator.
- Lexer::parseWhitespace() — Method in class Lexer
Parses a whitespace.
- Lexer::parseComment() — Method in class Lexer
Parses a comment.
- Lexer::parseBool() — Method in class Lexer
Parses a boolean.
- Lexer::parseNumber() — Method in class Lexer
Parses a number.
- Lexer::parseString() — Method in class Lexer
Parses a string.
- Lexer::parseSymbol() — Method in class Lexer
Parses a symbol.
- Lexer::parseUnknown() — Method in class Lexer
Parses unknown parts of the query.
- Lexer::parseDelimiter() — Method in class Lexer
Parses the delimiter of the query.
- Parseable — Class in namespace PhpMyAdmin\SqlParser
Defines a class that offers the parse() static method.
- Parseable::parse() — Method in class Parseable
Parses the tokens contained in the given list in the context of the given parser.
- Parser — Class in namespace PhpMyAdmin\SqlParser
Defines the parser of the library.
- Parser::parse() — Method in class Parser
Builds the parse trees.
- AlterOperations::parse() — Method in class AlterOperations
- Array2d::parse() — Method in class Array2d
- ArrayObjs::parse() — Method in class ArrayObjs
- CaseExpressions::parse() — Method in class CaseExpressions
- Conditions::parse() — Method in class Conditions
- CreateDefinitions::parse() — Method in class CreateDefinitions
- DataTypes::parse() — Method in class DataTypes
- ExpressionArray::parse() — Method in class ExpressionArray
- Expressions::parse() — Method in class Expressions
Possible options:.
- FunctionCalls::parse() — Method in class FunctionCalls
- GroupKeywords::parse() — Method in class GroupKeywords
- IndexHints::parse() — Method in class IndexHints
- IntoKeywords::parse() — Method in class IntoKeywords
- JoinKeywords::parse() — Method in class JoinKeywords
- Keys::parse() — Method in class Keys
- Limits::parse() — Method in class Limits
- LockExpressions::parse() — Method in class LockExpressions
- OptionsArrays::parse() — Method in class OptionsArrays
- OrderKeywords::parse() — Method in class OrderKeywords
- ParameterDefinitions — Class in namespace PhpMyAdmin\SqlParser\Parsers
The definition of a parameter of a function or procedure.
- ParameterDefinitions::parse() — Method in class ParameterDefinitions
- PartitionDefinitions — Class in namespace PhpMyAdmin\SqlParser\Parsers
Parses the create definition of a partition.
- $ PartitionDefinitions#partitionOptions — Property in class PartitionDefinitions
All field options.
- PartitionDefinitions::parse() — Method in class PartitionDefinitions
- References::parse() — Method in class References
- RenameOperations::parse() — Method in class RenameOperations
- SetOperations::parse() — Method in class SetOperations
- UnionKeywords::parse() — Method in class UnionKeywords
Parses the tokens contained in the given list in the context of the given parser.
- Statement::parse() — Method in class Statement
Parses the statements defined by the tokens list.
- AlterStatement::parse() — Method in class AlterStatement
- $ CreateStatement#partitionBy — Property in class CreateStatement
Expression used for partitioning.
- $ CreateStatement#partitionsNum — Property in class CreateStatement
The number of partitions.
- $ CreateStatement#partitions — Property in class CreateStatement
The partition of the new table.
- $ CreateStatement#parameters — Property in class CreateStatement
The parameters of this routine.
- CreateStatement::parse() — Method in class CreateStatement
- $ DeleteStatement#partition — Property in class DeleteStatement
Partitions used as source for this statement.
- DeleteStatement::parse() — Method in class DeleteStatement
- ExplainStatement::parse() — Method in class ExplainStatement
- InsertStatement::parse() — Method in class InsertStatement
- $ KillStatement#parenthesisUsed — Property in class KillStatement
Whether parenthesis used around the identifier or not
- KillStatement::parse() — Method in class KillStatement
- $ LoadStatement#partition — Property in class LoadStatement
Partitions used as source for this statement.
- LoadStatement::parse() — Method in class LoadStatement
- LoadStatement::parseFileOptions() — Method in class LoadStatement
- LoadStatement::parseKeywordsAccordingToState() — Method in class LoadStatement
- LockStatement::parse() — Method in class LockStatement
- NotImplementedStatement::parse() — Method in class NotImplementedStatement
- PurgeStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
PURGE
statement.- PurgeStatement::parse() — Method in class PurgeStatement
- ReplaceStatement::parse() — Method in class ReplaceStatement
- $ SelectStatement#partition — Property in class SelectStatement
Partitions used as source for this statement.
- $ SelectStatement#procedure — Property in class SelectStatement
Procedure that should process the data in the result set.
- SelectStatement::parse() — Method in class SelectStatement
Parses the statements defined by the tokens list.
- TransactionStatement::parse() — Method in class TransactionStatement
- WithStatement::parse() — Method in class WithStatement
- $ Token#position — Property in class Token
The position in the initial string where this token started.
- ContextGenerator::printWords() — Method in class ContextGenerator
Prints an array of a words in PHP format.
- CLI::parseHighlight() — Method in class CLI
- CLI::parseLint() — Method in class CLI
- CLI::parseTokenize() — Method in class CLI
Q
- $ BufferedQuery#query — Property in class BufferedQuery
The query that is being processed.
- Query — Class in namespace PhpMyAdmin\SqlParser\Utils
Statement utilities.
- $ StatementFlags#queryType — Property in class StatementFlags
The type of the statement (which is usually the first keyword).
R
- $ ArrayObj#raw — Property in class ArrayObj
The array that contains the unprocessed value of each token.
- $ CaseExpression#results — Property in class CaseExpression
The results matching with the WHEN clauses.
- $ Condition#rightOperand — Property in class Condition
- $ CreateDefinition#references — Property in class CreateDefinition
The table that is referenced.
- $ Limit#rowCount — Property in class Limit
The number of rows to be returned.
- OptionsArray::remove() — Method in class OptionsArray
Removes the option from the array.
- Reference — Class in namespace PhpMyAdmin\SqlParser\Components
REFERENCES
keyword parser.- RenameOperation — Class in namespace PhpMyAdmin\SqlParser\Components
RENAME TABLE
keyword parser.- References — Class in namespace PhpMyAdmin\SqlParser\Parsers
REFERENCES
keyword parser.- RenameOperations — Class in namespace PhpMyAdmin\SqlParser\Parsers
RENAME TABLE
keyword parser.- $ CreateStatement#return — Property in class CreateStatement
The return data type of this routine.
- $ LoadStatement#replaceIgnore — Property in class LoadStatement
REPLACE/IGNORE Keyword.
- RenameStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
RENAME
statement.- $ RenameStatement#renames — Property in class RenameStatement
The old and new names of the tables.
- RepairStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
REPAIR
statement.- ReplaceStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
REPLACE
statement.- RestoreStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
RESTORE
statement.- ContextGenerator::readWords() — Method in class ContextGenerator
Reads a list of words and sorts it by type, length and keyword.
- CLI::run() — Method in class CLI
- CLI::runHighlight() — Method in class CLI
- CLI::runLint() — Method in class CLI
- CLI::runTokenize() — Method in class CLI
- CLI::readStdin() — Method in class CLI
- Query::replaceClause() — Method in class Query
Builds a query by rebuilding the statement from the tokens list supplied and replaces a clause.
- Query::replaceClauses() — Method in class Query
Builds a query by rebuilding the statement from the tokens list supplied and replaces multiple clauses.
- $ StatementFlags#reload — Property in class StatementFlags
Whether a page reload is required.
S
- $ Expression#subquery — Property in class Expression
The type of subquery.
- $ PartitionDefinition#subpartitions — Property in class PartitionDefinition
The subpartitions of this partition.
- SetOperation — Class in namespace PhpMyAdmin\SqlParser\Components
- $ WithKeyword#statement — Property in class WithKeyword
- Context::setMode() — Method in class Context
Sets the SQL mode.
- $ Lexer#str — Property in class Lexer
The string to be parsed.
- Lexer::setDelimiter() — Method in class Lexer
Sets the delimiter.
- $ Parser#statements — Property in class Parser
List of statements parsed.
- SetOperations — Class in namespace PhpMyAdmin\SqlParser\Parsers
SET
keyword parser.- Statement — Class in namespace PhpMyAdmin\SqlParser
The result of the parser is an array of statements are extensions of the class defined here.
- $ Statement#statementOptions — Property in class Statement
Options for this statement.
- $ AlterStatement#statementOptions — Property in class AlterStatement
Options of this statement.
- $ AnalyzeStatement#statementOptions — Property in class AnalyzeStatement
Options of this statement.
- $ BackupStatement#statementOptions — Property in class BackupStatement
Options of this statement.
- $ CheckStatement#statementOptions — Property in class CheckStatement
Options of this statement.
- $ ChecksumStatement#statementOptions — Property in class ChecksumStatement
Options of this statement.
- $ CreateStatement#statementOptions — Property in class CreateStatement
Options for
CREATE
statements.- $ CreateStatement#select — Property in class CreateStatement
If
CREATE TABLE ... SELECT
.- $ CreateStatement#subpartitionBy — Property in class CreateStatement
Expression used for subpartitioning.
- $ CreateStatement#subpartitionsNum — Property in class CreateStatement
The number of subpartitions.
- $ DeleteStatement#statementOptions — Property in class DeleteStatement
Options for
DELETE
statements.- $ DropStatement#statementOptions — Property in class DropStatement
Options of this statement.
- $ ExplainStatement#statementAlias — Property in class ExplainStatement
The statement alias, could be any of the following:
- {EXPLAIN | DESCRIBE | DESC}
- {EXPLAIN | DESCRIBE | DESC} ANALYZE
- ANALYZE
- $ InsertStatement#statementOptions — Property in class InsertStatement
Options for
INSERT
statements.- $ InsertStatement#set — Property in class InsertStatement
If SET clause is present holds the SetOperation.
- $ InsertStatement#select — Property in class InsertStatement
If SELECT clause is present holds the SelectStatement.
- $ KillStatement#statementOptions — Property in class KillStatement
Options of this statement.
- $ LoadStatement#statementOptions — Property in class LoadStatement
Options for
LOAD
statements and their slot ID.- $ LoadStatement#set — Property in class LoadStatement
SET clause's updated values(optional).
- $ OptimizeStatement#statementOptions — Property in class OptimizeStatement
Options of this statement.
- $ RepairStatement#statementOptions — Property in class RepairStatement
Options of this statement.
- $ ReplaceStatement#statementOptions — Property in class ReplaceStatement
Options for
REPLACE
statements and their slot ID.- $ ReplaceStatement#set — Property in class ReplaceStatement
If SET clause is present holds the SetOperation.
- $ ReplaceStatement#select — Property in class ReplaceStatement
If SELECT clause is present holds the SelectStatement.
- $ RestoreStatement#statementOptions — Property in class RestoreStatement
Options of this statement.
- SelectStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
SELECT
statement.- $ SelectStatement#statementOptions — Property in class SelectStatement
Options for
SELECT
statements and their slot ID.- SetStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
SET
statement.- $ SetStatement#statementOptions — Property in class SetStatement
Possible exceptions in SET statement.
- $ SetStatement#set — Property in class SetStatement
The updated values.
- ShowStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
SHOW
statement.- $ ShowStatement#statementOptions — Property in class ShowStatement
Options of this statement.
- $ TransactionStatement#statements — Property in class TransactionStatement
The list of statements in this transaction.
- $ TransactionStatement#statementOptions — Property in class TransactionStatement
Options for this query.
- $ TruncateStatement#statementOptions — Property in class TruncateStatement
Options for
TRUNCATE
statements.- $ UpdateStatement#statementOptions — Property in class UpdateStatement
Options for
UPDATE
statements and their slot ID.- $ UpdateStatement#set — Property in class UpdateStatement
The updated values.
- $ WithStatement#statementOptions — Property in class WithStatement
Options for
WITH
statements and their slot ID.- ContextGenerator::sortWords() — Method in class ContextGenerator
Sorts an array of words.
- Translator::setLocale() — Method in class Translator
- $ BufferedQuery#status — Property in class BufferedQuery
The current status of the parser.
- BufferedQuery::setDelimiter() — Method in class BufferedQuery
Sets the delimiter.
- $ Formatter#shortClauses — Property in class Formatter
Clauses that are usually short.
- StatementFlags — Class in namespace PhpMyAdmin\SqlParser\Utils
- $ StatementFlags#selectFrom — Property in class StatementFlags
SELECT ... FROM .
- StatementInfo — Class in namespace PhpMyAdmin\SqlParser\Utils
T
- $ CreateDefinition#type — Property in class CreateDefinition
The data type of thew new column.
- $ Expression#table — Property in class Expression
The name of this table.
- $ GroupKeyword#type — Property in class GroupKeyword
- $ IndexHint#type — Property in class IndexHint
The type of hint (USE/FORCE/IGNORE)
- $ IntoKeyword#type — Property in class IntoKeyword
Type of target (OUTFILE or SYMBOL).
- $ JoinKeyword#type — Property in class JoinKeyword
Type of this join.
- $ Key#type — Property in class Key
The type of this key.
- $ LockExpression#table — Property in class LockExpression
The table to be locked.
- $ LockExpression#type — Property in class LockExpression
The type of lock to be applied.
- $ OrderKeyword#type — Property in class OrderKeyword
The order type.
- $ ParameterDefinition#type — Property in class ParameterDefinition
The data type of thew new column.
- $ PartitionDefinition#type — Property in class PartitionDefinition
The type of this partition (what follows the
VALUES
keyword).- $ Reference#table — Property in class Reference
The referenced table.
- $ ParserException#token — Property in class ParserException
The token that produced this error.
- $ AlterStatement#table — Property in class AlterStatement
Table affected.
- $ AnalyzeStatement#tables — Property in class AnalyzeStatement
Analyzed tables.
- $ CreateStatement#table — Property in class CreateStatement
If
CREATE TRIGGER
the name of the table.- $ DropStatement#table — Property in class DropStatement
Table of the dropped index.
- $ LoadStatement#table — Property in class LoadStatement
Table used as destination for this statement.
- $ MaintenanceStatement#tables — Property in class MaintenanceStatement
Tables maintained.
- $ OptimizeStatement#tables — Property in class OptimizeStatement
Optimized tables.
- TransactionStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
Transaction statement.
- $ TransactionStatement#type — Property in class TransactionStatement
The type of this query.
- TruncateStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
TRUNCATE
statement.- $ TruncateStatement#table — Property in class TruncateStatement
The name of the truncated table.
- $ UpdateStatement#tables — Property in class UpdateStatement
Tables used as sources for this statement.
- Token — Class in namespace PhpMyAdmin\SqlParser
Defines a token along with a set of types and flags and utility functions.
- $ Token#token — Property in class Token
The token it its raw string representation.
- $ Token#type — Property in class Token
The type of this token.
- TokensList — Class in namespace PhpMyAdmin\SqlParser
Defines an array of tokens and utility functions to iterate through it.
- TestGenerator — Class in namespace PhpMyAdmin\SqlParser\Tools
Used for test generation.
- Translator — Class in namespace PhpMyAdmin\SqlParser
Defines the localization helper infrastructure of the library.
- Formatter::toString() — Method in class Formatter
Tries to print the query and returns the result.
- Table — Class in namespace PhpMyAdmin\SqlParser\Utils
Table utilities.
U
- $ JoinKeyword#using — Property in class JoinKeyword
Columns in Using clause.
- UnionKeywords — Class in namespace PhpMyAdmin\SqlParser\Parsers
UNION
keyword builder.- $ DeleteStatement#using — Property in class DeleteStatement
Tables used as sources for this statement.
- $ NotImplementedStatement#unknown — Property in class NotImplementedStatement
The part of the statement that can't be parsed.
- $ SelectStatement#union — Property in class SelectStatement
- Unions.
- UpdateStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
UPDATE
statement.- UtfString — Class in namespace PhpMyAdmin\SqlParser
Implementation for UTF-8 strings.
- CLI::usageHighlight() — Method in class CLI
- CLI::usageLint() — Method in class CLI
- CLI::usageTokenize() — Method in class CLI
- $ StatementFlags#union — Property in class StatementFlags
V
- $ ArrayObj#values — Property in class ArrayObj
The array that contains the processed value of each token.
- $ CaseExpression#value — Property in class CaseExpression
The value to be compared.
- $ IntoKeyword#values — Property in class IntoKeyword
The values to be selected into (SELECT .. INTO @var1).
- $ SetOperation#value — Property in class SetOperation
The new value.
- Statement::validateClauseOrder() — Method in class Statement
Validates the order of the clauses in parsed statement Ideally this should be called after successfully completing the parsing of each statement.
- $ InsertStatement#values — Property in class InsertStatement
Values to be inserted.
- $ ReplaceStatement#values — Property in class ReplaceStatement
Values to be replaced.
- $ Token#value — Property in class Token
The value this token contains (i.e. token after some evaluation).
W
- WithKeyword — Class in namespace PhpMyAdmin\SqlParser\Components
WITH
keyword builder.- $ CreateStatement#with — Property in class CreateStatement
If
CREATE TABLE WITH
.- $ DeleteStatement#where — Property in class DeleteStatement
Conditions used for filtering each row of the result set.
- $ InsertStatement#with — Property in class InsertStatement
If WITH CTE is present holds the WithStatement.
- $ SelectStatement#where — Property in class SelectStatement
Conditions used for filtering each row of the result set.
- $ UpdateStatement#where — Property in class UpdateStatement
Conditions used for filtering each row of the result set.
- WithStatement — Class in namespace PhpMyAdmin\SqlParser\Statements
WITH
statement.- $ WithStatement#withers — Property in class WithStatement
_
- AlterOperation::__construct() — Method in class AlterOperation
- AlterOperation::__toString() — Method in class AlterOperation
- ArrayObj::__construct() — Method in class ArrayObj
- ArrayObj::__toString() — Method in class ArrayObj
- CaseExpression::__toString() — Method in class CaseExpression
- Condition::__construct() — Method in class Condition
- Condition::__toString() — Method in class Condition
- CreateDefinition::__construct() — Method in class CreateDefinition
- CreateDefinition::__toString() — Method in class CreateDefinition
- DataType::__construct() — Method in class DataType
- DataType::__toString() — Method in class DataType
- Expression::__construct() — Method in class Expression
Syntax: new Expression('expr') new Expression('expr', 'alias') new Expression('database', 'table', 'column') new Expression('database', 'table', 'column', 'alias')
- Expression::__toString() — Method in class Expression
- FunctionCall::__construct() — Method in class FunctionCall
- FunctionCall::__toString() — Method in class FunctionCall
- GroupKeyword::__construct() — Method in class GroupKeyword
- GroupKeyword::__toString() — Method in class GroupKeyword
- IndexHint::__construct() — Method in class IndexHint
- IndexHint::__toString() — Method in class IndexHint
- IntoKeyword::__construct() — Method in class IntoKeyword
- IntoKeyword::__toString() — Method in class IntoKeyword
- JoinKeyword::__construct() — Method in class JoinKeyword
- JoinKeyword::__toString() — Method in class JoinKeyword
- Key::__construct() — Method in class Key
- Key::__toString() — Method in class Key
- Limit::__construct() — Method in class Limit
- Limit::__toString() — Method in class Limit
- LockExpression::__toString() — Method in class LockExpression
- OptionsArray::__construct() — Method in class OptionsArray
- OptionsArray::__toString() — Method in class OptionsArray
- OrderKeyword::__construct() — Method in class OrderKeyword
- OrderKeyword::__toString() — Method in class OrderKeyword
- ParameterDefinition::__construct() — Method in class ParameterDefinition
- ParameterDefinition::__toString() — Method in class ParameterDefinition
- PartitionDefinition::__toString() — Method in class PartitionDefinition
- Reference::__construct() — Method in class Reference
- Reference::__toString() — Method in class Reference
- RenameOperation::__construct() — Method in class RenameOperation
- RenameOperation::__toString() — Method in class RenameOperation
- SetOperation::__construct() — Method in class SetOperation
- SetOperation::__toString() — Method in class SetOperation
- WithKeyword::__construct() — Method in class WithKeyword
- WithKeyword::__toString() — Method in class WithKeyword
- LexerException::__construct() — Method in class LexerException
- ParserException::__construct() — Method in class ParserException
- Lexer::__construct() — Method in class Lexer
- Parser::__construct() — Method in class Parser
- Statement::__construct() — Method in class Statement
- Statement::__toString() — Method in class Statement
Builds the string representation of this statement.
- Token::__construct() — Method in class Token
- TokensList::__construct() — Method in class TokensList
- UtfString::__construct() — Method in class UtfString
- UtfString::__toString() — Method in class UtfString
Returns the contained string.
- BufferedQuery::__construct() — Method in class BufferedQuery
- CLI::__construct() — Method in class CLI
- ForeignKey::__construct() — Method in class ForeignKey
- Formatter::__construct() — Method in class Formatter
- StatementInfo::__construct() — Method in class StatementInfo