Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
AlterStatement.php	3.96 KB	-rw-r--r--	2023-01-25 10:43
AnalyzeStatement.php	744 B	-rw-r--r--	2023-01-25 10:43
BackupStatement.php	631 B	-rw-r--r--	2023-01-25 10:43
CallStatement.php	716 B	-rw-r--r--	2023-01-25 10:43
CheckStatement.php	632 B	-rw-r--r--	2023-01-25 10:43
ChecksumStatement.php	553 B	-rw-r--r--	2023-01-25 10:43
CreateStatement.php	24.01 KB	-rw-r--r--	2023-01-25 10:43
DeleteStatement.php	11.19 KB	-rw-r--r--	2023-01-25 10:43
DropStatement.php	1.61 KB	-rw-r--r--	2023-01-25 10:43
ExplainStatement.php	6.31 KB	-rw-r--r--	2023-01-25 10:43
InsertStatement.php	7.2 KB	-rw-r--r--	2023-01-25 10:43
LoadStatement.php	11.05 KB	-rw-r--r--	2023-01-25 10:43
LockStatement.php	3.36 KB	-rw-r--r--	2023-01-25 10:43
MaintenanceStatement.php	1.47 KB	-rw-r--r--	2023-01-25 10:43
NotImplementedStatement.php	1.3 KB	-rw-r--r--	2023-01-25 10:43
OptimizeStatement.php	748 B	-rw-r--r--	2023-01-25 10:43
PurgeStatement.php	3.74 KB	-rw-r--r--	2023-01-25 10:43
RenameStatement.php	1.36 KB	-rw-r--r--	2023-01-25 10:43
RepairStatement.php	674 B	-rw-r--r--	2023-01-25 10:43
ReplaceStatement.php	4.97 KB	-rw-r--r--	2023-01-25 10:43
RestoreStatement.php	580 B	-rw-r--r--	2023-01-25 10:43
SelectStatement.php	7.83 KB	-rw-r--r--	2023-01-25 10:43
SetStatement.php	2.36 KB	-rw-r--r--	2023-01-25 10:43
ShowStatement.php	1.35 KB	-rw-r--r--	2023-01-25 10:43
TransactionStatement.php	2.39 KB	-rw-r--r--	2023-01-25 10:43
TruncateStatement.php	854 B	-rw-r--r--	2023-01-25 10:43
UpdateStatement.php	2.5 KB	-rw-r--r--	2023-01-25 10:43
WithStatement.php	11.07 KB	-rw-r--r--	2023-01-25 10:43

Rename

<?php

declare(strict_types=1);

namespace PhpMyAdmin\SqlParser\Statements;

use PhpMyAdmin\SqlParser\Components\Condition;
use PhpMyAdmin\SqlParser\Components\Expression;
use PhpMyAdmin\SqlParser\Components\Limit;
use PhpMyAdmin\SqlParser\Components\OrderKeyword;
use PhpMyAdmin\SqlParser\Components\SetOperation;
use PhpMyAdmin\SqlParser\Statement;

/**
 * `UPDATE` statement.
 *
 * UPDATE [LOW_PRIORITY] [IGNORE] table_reference
 *     SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
 *     [WHERE where_condition]
 *     [ORDER BY ...]
 *     [LIMIT row_count]
 *
 * or
 *
 * UPDATE [LOW_PRIORITY] [IGNORE] table_references
 *     SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
 *     [WHERE where_condition]
 */
class UpdateStatement extends Statement
{
    /**
     * Options for `UPDATE` statements and their slot ID.
     *
     * @var array<string, int|array<int, int|string>>
     * @psalm-var array<string, (positive-int|array{positive-int, ('var'|'var='|'expr'|'expr=')})>
     */
    public static $OPTIONS = [
        'LOW_PRIORITY' => 1,
        'IGNORE' => 2,
    ];

/**
     * The clauses of this statement, in order.
     *
     * @see Statement::$CLAUSES
     *
     * @var array<string, array<int, int|string>>
     * @psalm-var array<string, array{non-empty-string, (1|2|3)}>
     */
    public static $CLAUSES = [
        'UPDATE' => [
            'UPDATE',
            2,
        ],
        // Used for options.
        '_OPTIONS' => [
            '_OPTIONS',
            1,
        ],
        // Used for updated tables.
        '_UPDATE' => [
            'UPDATE',
            1,
        ],
        'SET' => [
            'SET',
            3,
        ],
        'WHERE' => [
            'WHERE',
            3,
        ],
        'ORDER BY' => [
            'ORDER BY',
            3,
        ],
        'LIMIT' => [
            'LIMIT',
            3,
        ],
    ];

/**
     * Tables used as sources for this statement.
     *
     * @var Expression[]|null
     */
    public $tables;

/**
     * The updated values.
     *
     * @var SetOperation[]|null
     */
    public $set;

/**
     * Conditions used for filtering each row of the result set.
     *
     * @var Condition[]|null
     */
    public $where;

/**
     * Specifies the order of the rows in the result set.
     *
     * @var OrderKeyword[]|null
     */
    public $order;

/**
     * Conditions used for limiting the size of the result set.
     *
     * @var Limit|null
     */
    public $limit;
}