__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<?php
declare(strict_types=1);
namespace PhpMyAdmin\SqlParser\Statements;
use PhpMyAdmin\SqlParser\Components\Expression;
use PhpMyAdmin\SqlParser\Parser;
use PhpMyAdmin\SqlParser\Statement;
use PhpMyAdmin\SqlParser\Token;
use PhpMyAdmin\SqlParser\TokensList;
use function in_array;
use function trim;
/**
* `PURGE` statement.
*
* PURGE { BINARY | MASTER } LOGS
* { TO 'log_name' | BEFORE datetime_expr }
*/
class PurgeStatement extends Statement
{
/**
* The type of logs
*
* @var string|null
*/
public $log_type;
/**
* The end option of this query.
*
* @var string|null
*/
public $end_option;
/**
* The end expr of this query.
*
* @var string|null
*/
public $end_expr;
/**
* @return string
*/
public function build()
{
$ret = 'PURGE ' . $this->log_type . ' LOGS '
. ($this->end_option !== null ? ($this->end_option . ' ' . $this->end_expr) : '');
return trim($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 `PURGE`.
/**
* The state of the parser.
*
* @var int
*/
$state = 0;
$prevToken = null;
for (; $list->idx < $list->count; ++$list->idx) {
/**
* Token parsed at this moment.
*/
$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;
}
switch ($state) {
case 0:
// parse `{ BINARY | MASTER }`
$this->log_type = self::parseExpectedKeyword($parser, $token, ['BINARY', 'MASTER']);
break;
case 1:
// parse `LOGS`
self::parseExpectedKeyword($parser, $token, ['LOGS']);
break;
case 2:
// parse `{ TO | BEFORE }`
$this->end_option = self::parseExpectedKeyword($parser, $token, ['TO', 'BEFORE']);
break;
case 3:
// parse `expr`
$this->end_expr = Expression::parse($parser, $list, []);
break;
default:
$parser->error('Unexpected token.', $token);
break;
}
$state++;
$prevToken = $token;
}
// Only one possible end state
if ($state === 4) {
return;
}
$parser->error('Unexpected token.', $prevToken);
}
/**
* Parse expected keyword (or throw relevant error)
*
* @param Parser $parser the instance that requests parsing
* @param Token $token token to be parsed
* @param string[] $expectedKeywords array of possibly expected keywords at this point
*
* @return mixed|null
*/
private static function parseExpectedKeyword($parser, $token, $expectedKeywords)
{
if ($token->type === Token::TYPE_KEYWORD) {
if (in_array($token->keyword, $expectedKeywords)) {
return $token->keyword;
}
$parser->error('Unexpected keyword', $token);
} else {
$parser->error('Unexpected token.', $token);
}
return null;
}
}
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| AlterStatement.php | File | 4.13 KB | 0644 |
|
| AnalyzeStatement.php | File | 744 B | 0644 |
|
| BackupStatement.php | File | 631 B | 0644 |
|
| CallStatement.php | File | 716 B | 0644 |
|
| CheckStatement.php | File | 632 B | 0644 |
|
| ChecksumStatement.php | File | 553 B | 0644 |
|
| CreateStatement.php | File | 24.22 KB | 0644 |
|
| DeleteStatement.php | File | 11.19 KB | 0644 |
|
| DropStatement.php | File | 1.61 KB | 0644 |
|
| ExplainStatement.php | File | 9.07 KB | 0644 |
|
| InsertStatement.php | File | 7.2 KB | 0644 |
|
| LoadStatement.php | File | 11.05 KB | 0644 |
|
| LockStatement.php | File | 3.36 KB | 0644 |
|
| MaintenanceStatement.php | File | 1.47 KB | 0644 |
|
| NotImplementedStatement.php | File | 1.3 KB | 0644 |
|
| OptimizeStatement.php | File | 748 B | 0644 |
|
| PurgeStatement.php | File | 3.74 KB | 0644 |
|
| RenameStatement.php | File | 1.36 KB | 0644 |
|
| RepairStatement.php | File | 674 B | 0644 |
|
| ReplaceStatement.php | File | 4.97 KB | 0644 |
|
| RestoreStatement.php | File | 580 B | 0644 |
|
| SelectStatement.php | File | 8.27 KB | 0644 |
|
| SetStatement.php | File | 2.36 KB | 0644 |
|
| ShowStatement.php | File | 1.35 KB | 0644 |
|
| TransactionStatement.php | File | 2.47 KB | 0644 |
|
| TruncateStatement.php | File | 854 B | 0644 |
|
| UpdateStatement.php | File | 2.91 KB | 0644 |
|
| WithStatement.php | File | 11.07 KB | 0644 |
|