class LoadStatement extends Statement

LOAD statement.

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [PARTITION (partition_name,...)] [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number {LINES | ROWS}] [(col_name_or_user_var,...)] [SET col_name = expr,...]

Properties

static array $OPTIONS Options for LOAD statements and their slot ID.
static array $CLAUSES The clauses of this statement, in order. from Statement
OptionsArray $options The options of this query. from Statement
int $first The index of the first token used in this statement. from Statement
int $last The index of the last token used in this statement. from Statement
static array $FIELDS_OPTIONS FIELDS/COLUMNS Options for `LOAD DATA.
static array $LINES_OPTIONS LINES Options for `LOAD DATA.
Expression $file_name File name being used to load data.
Expression $table Table used as destination for this statement.
ArrayObj $partition Partitions used as source for this statement.
Expression $charset_name Character set used in this statement.
OptionsArray $fields_options Options for FIELDS/COLUMNS keyword.
string $fields_keyword Whether to use FIELDS or COLUMNS while building.
OptionsArray $lines_options Options for OPTIONS keyword.
Expression[] $col_name_or_user_var Column names or user variables.
SetOperation[] $set SET clause's updated values(optional).
Expression $ignore_number Ignore 'number' LINES/ROWS.
string $replace_ignore REPLACE/IGNORE Keyword.
string $lines_rows LINES/ROWS Keyword.

Methods

__construct(Parser $parser = null, TokensList $list = null)

Constructor.

from Statement
string
build()

No description

parse(Parser $parser, TokensList $list)

No description

before(Parser $parser, TokensList $list, Token $token)

Function called before the token is processed.

from Statement
after(Parser $parser, TokensList $list, Token $token)

Function called after the token was processed.

from Statement
array
getClauses()

Gets the clauses of this statement.

from Statement
string
__toString()

Builds the string representation of this statement.

from Statement
bool
validateClauseOrder(Parser $parser, TokensList $list)

Validates the order of the clauses in parsed statement Ideally this should be called after successfully completing the parsing of each statement.

from Statement
parseFileOptions(Parser $parser, TokensList $list, $keyword = 'FIELDS')

No description

parseKeywordsAccordingToState($parser, $list, $state)

No description

Details

in Statement at line 87
__construct(Parser $parser = null, TokensList $list = null)

Constructor.

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed

at line 171
string build()

Return Value

string

at line 217
parse(Parser $parser, TokensList $list)

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed

in Statement at line 403
before(Parser $parser, TokensList $list, Token $token)

Function called before the token is processed.

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed
Token $token the token that is being parsed

in Statement at line 414
after(Parser $parser, TokensList $list, Token $token)

Function called after the token was processed.

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed
Token $token the token that is being parsed

in Statement at line 423
array getClauses()

Gets the clauses of this statement.

Return Value

array

in Statement at line 435
string __toString()

Builds the string representation of this statement.

Return Value

string

See also

in Statement at line 450
bool validateClauseOrder(Parser $parser, TokensList $list)

Validates the order of the clauses in parsed statement Ideally this should be called after successfully completing the parsing of each statement.

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed

Return Value

bool

at line 317
parseFileOptions(Parser $parser, TokensList $list, $keyword = 'FIELDS')

Parameters

Parser $parser
TokensList $list
$keyword

at line 340
parseKeywordsAccordingToState($parser, $list, $state)

Parameters

$parser
$list
$state