FM / Statements

/usr/share/php/PhpMyAdmin/SqlParser/Statements/

/usr/share/php/PhpMyAdmin/SqlParser/Statements

Name	Size	Mode	Actions
AlterStatement.php	3768	0644	edit dl rm
AnalyzeStatement.php	636	0644	edit dl rm
BackupStatement.php	527	0644	edit dl rm
CallStatement.php	739	0644	edit dl rm
CheckStatement.php	527	0644	edit dl rm
ChecksumStatement.php	451	0644	edit dl rm
CreateStatement.php	22928	0644	edit dl rm
DeleteStatement.php	11678	0644	edit dl rm
DropStatement.php	1433	0644	edit dl rm
ExplainStatement.php	200	0644	edit dl rm
InsertStatement.php	7459	0644	edit dl rm
LoadStatement.php	11074	0644	edit dl rm
LockStatement.php	3494	0644	edit dl rm
MaintenanceStatement.php	1503	0644	edit dl rm
NotImplementedStatement.php	1374	0644	edit dl rm
OptimizeStatement.php	641	0644	edit dl rm
PurgeStatement.php	3853	0644	edit dl rm
RenameStatement.php	1377	0644	edit dl rm
RepairStatement.php	570	0644	edit dl rm
ReplaceStatement.php	5335	0644	edit dl rm
RestoreStatement.php	477	0644	edit dl rm
SelectStatement.php	7436	0644	edit dl rm
SetStatement.php	2028	0644	edit dl rm
ShowStatement.php	1280	0644	edit dl rm
TransactionStatement.php	2348	0644	edit dl rm
TruncateStatement.php	747	0644	edit dl rm
UpdateStatement.php	2334	0644	edit dl rm

Edit: /usr/share/php/PhpMyAdmin/SqlParser/Statements/TransactionStatement.php (2348B)

<?php
/**
 * Transaction statement.
 */

declare(strict_types=1);

namespace PhpMyAdmin\SqlParser\Statements;

use PhpMyAdmin\SqlParser\Components\OptionsArray;
use PhpMyAdmin\SqlParser\Parser;
use PhpMyAdmin\SqlParser\Statement;
use PhpMyAdmin\SqlParser\TokensList;

/**
 * Transaction statement.
 */
class TransactionStatement extends Statement
{
    /**
     * START TRANSACTION and BEGIN.
     */
    public const TYPE_BEGIN = 1;

/**
     * COMMIT and ROLLBACK.
     */
    public const TYPE_END = 2;

/**
     * The type of this query.
     *
     * @var int
     */
    public $type;

/**
     * The list of statements in this transaction.
     *
     * @var Statement[]
     */
    public $statements;

/**
     * The ending transaction statement which may be a `COMMIT` or a `ROLLBACK`.
     *
     * @var TransactionStatement
     */
    public $end;

/**
     * Options for this query.
     *
     * @var array
     */
    public static $OPTIONS = [
        'START TRANSACTION' => 1,
        'BEGIN' => 1,
        'COMMIT' => 1,
        'ROLLBACK' => 1,
        'WITH CONSISTENT SNAPSHOT' => 2,
        'WORK' => 2,
        'AND NO CHAIN' => 3,
        'AND CHAIN' => 3,
        'RELEASE' => 4,
        'NO RELEASE' => 4,
    ];

/**
     * @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)
    {
        parent::parse($parser, $list);

// Checks the type of this query.
        if ($this->options->has('START TRANSACTION')
            || $this->options->has('BEGIN')
        ) {
            $this->type = self::TYPE_BEGIN;
        } elseif ($this->options->has('COMMIT')
            || $this->options->has('ROLLBACK')
        ) {
            $this->type = self::TYPE_END;
        }
    }

/**
     * @return string
     */
    public function build()
    {
        $ret = OptionsArray::build($this->options);
        if ($this->type === self::TYPE_BEGIN) {
            foreach ($this->statements as $statement) {
                /*
                 * @var SelectStatement $statement
                 */
                $ret .= ';' . $statement->build();
            }

$ret .= ';' . $this->end->build();
        }

return $ret;
    }
}

1, 'BEGIN' => 1, 'COMMIT' => 1, 'ROLLBACK' => 1, 'WITH CONSISTENT SNAPSHOT' => 2, 'WORK' => 2, 'AND NO CHAIN' => 3, 'AND CHAIN' => 3, 'RELEASE' => 4, 'NO RELEASE' => 4, ]; /** * @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) { parent::parse($parser, $list); // Checks the type of this query. if ($this->options->has('START TRANSACTION') || $this->options->has('BEGIN') ) { $this->type = self::TYPE_BEGIN; } elseif ($this->options->has('COMMIT') || $this->options->has('ROLLBACK') ) { $this->type = self::TYPE_END; } } /** * @return string */ public function build() { $ret = OptionsArray::build($this->options); if ($this->type === self::TYPE_BEGIN) { foreach ($this->statements as $statement) { /* * @var SelectStatement $statement */ $ret .= ';' . $statement->build(); } $ret .= ';' . $this->end->build(); } return $ret; } }