Server IP : 85.214.239.14 / Your IP : 3.145.88.111 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/wordpress/phpMyAdmin/vendor/phpmyadmin/sql-parser/src/Statements/ |
Upload File : |
<?php /** * `INSERT` statement. */ declare(strict_types=1); namespace PhpMyAdmin\SqlParser\Statements; use PhpMyAdmin\SqlParser\Components\Array2d; use PhpMyAdmin\SqlParser\Components\ArrayObj; use PhpMyAdmin\SqlParser\Components\IntoKeyword; use PhpMyAdmin\SqlParser\Components\OptionsArray; use PhpMyAdmin\SqlParser\Components\SetOperation; use PhpMyAdmin\SqlParser\Parser; use PhpMyAdmin\SqlParser\Statement; use PhpMyAdmin\SqlParser\Token; use PhpMyAdmin\SqlParser\TokensList; use function count; use function strlen; use function trim; /** * `INSERT` statement. * * INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] * [INTO] tbl_name * [PARTITION (partition_name,...)] * [(col_name,...)] * {VALUES | VALUE} ({expr | DEFAULT},...),(...),... * [ ON DUPLICATE KEY UPDATE * col_name=expr * [, col_name=expr] ... ] * * or * * INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] * [INTO] tbl_name * [PARTITION (partition_name,...)] * SET col_name={expr | DEFAULT}, ... * [ ON DUPLICATE KEY UPDATE * col_name=expr * [, col_name=expr] ... ] * * or * * INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] * [INTO] tbl_name * [PARTITION (partition_name,...)] * [(col_name,...)] * SELECT ... * [ ON DUPLICATE KEY UPDATE * col_name=expr * [, col_name=expr] ... ] */ class InsertStatement extends Statement { /** * Options for `INSERT` statements. * * @var array */ public static $OPTIONS = [ 'LOW_PRIORITY' => 1, 'DELAYED' => 2, 'HIGH_PRIORITY' => 3, 'IGNORE' => 4, ]; /** * Tables used as target for this statement. * * @var IntoKeyword */ public $into; /** * Values to be inserted. * * @var ArrayObj[]|null */ public $values; /** * If SET clause is present * holds the SetOperation. * * @var SetOperation[] */ public $set; /** * If SELECT clause is present * holds the SelectStatement. * * @var SelectStatement */ public $select; /** * If ON DUPLICATE KEY UPDATE clause is present * holds the SetOperation. * * @var SetOperation[] */ public $onDuplicateSet; /** * @return string */ public function build() { $ret = 'INSERT ' . $this->options; $ret = trim($ret) . ' INTO ' . $this->into; if ($this->values !== null && count($this->values) > 0) { $ret .= ' VALUES ' . Array2d::build($this->values); } elseif ($this->set !== null && count($this->set) > 0) { $ret .= ' SET ' . SetOperation::build($this->set); } elseif ($this->select !== null && strlen((string) $this->select) > 0) { $ret .= ' ' . $this->select->build(); } if ($this->onDuplicateSet !== null && count($this->onDuplicateSet) > 0) { $ret .= ' ON DUPLICATE KEY UPDATE ' . SetOperation::build($this->onDuplicateSet); } return $ret; } /** * @param Parser $parser the instance that requests parsing * @param TokensList $list the list of tokens to be parsed */ public function parse(Parser $parser, TokensList $list) { ++$list->idx; // Skipping `INSERT`. // parse any options if provided $this->options = OptionsArray::parse( $parser, $list, static::$OPTIONS ); ++$list->idx; /** * The state of the parser. * * Below are the states of the parser. * * 0 ---------------------------------[ INTO ]----------------------------------> 1 * * 1 -------------------------[ VALUES/VALUE/SET/SELECT ]-----------------------> 2 * * 2 -------------------------[ ON DUPLICATE KEY UPDATE ]-----------------------> 3 * * @var int */ $state = 0; /** * For keeping track of semi-states on encountering * ON DUPLICATE KEY UPDATE ... */ $miniState = 0; for (; $list->idx < $list->count; ++$list->idx) { /** * Token parsed at this moment. * * @var Token */ $token = $list->tokens[$list->idx]; // End of statement. if ($token->type === Token::TYPE_DELIMITER) { break; } // Skipping whitespaces and comments. if (($token->type === Token::TYPE_WHITESPACE) || ($token->type === Token::TYPE_COMMENT)) { continue; } if ($state === 0) { if ($token->type === Token::TYPE_KEYWORD && $token->keyword !== 'INTO' ) { $parser->error('Unexpected keyword.', $token); break; } ++$list->idx; $this->into = IntoKeyword::parse( $parser, $list, ['fromInsert' => true] ); $state = 1; } elseif ($state === 1) { if ($token->type === Token::TYPE_KEYWORD) { if ($token->keyword === 'VALUE' || $token->keyword === 'VALUES' ) { ++$list->idx; // skip VALUES $this->values = Array2d::parse($parser, $list); } elseif ($token->keyword === 'SET') { ++$list->idx; // skip SET $this->set = SetOperation::parse($parser, $list); } elseif ($token->keyword === 'SELECT') { $this->select = new SelectStatement($parser, $list); } else { $parser->error( 'Unexpected keyword.', $token ); break; } $state = 2; $miniState = 1; } else { $parser->error( 'Unexpected token.', $token ); break; } } elseif ($state === 2) { $lastCount = $miniState; if ($miniState === 1 && $token->keyword === 'ON') { ++$miniState; } elseif ($miniState === 2 && $token->keyword === 'DUPLICATE') { ++$miniState; } elseif ($miniState === 3 && $token->keyword === 'KEY') { ++$miniState; } elseif ($miniState === 4 && $token->keyword === 'UPDATE') { ++$miniState; } if ($lastCount === $miniState) { $parser->error( 'Unexpected token.', $token ); break; } if ($miniState === 5) { ++$list->idx; $this->onDuplicateSet = SetOperation::parse($parser, $list); $state = 3; } } } --$list->idx; } }