| Server IP : 37.220.80.31 / Your IP : 18.219.123.84 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/perfmon/lib/sql/ |
Upload File : |
<?php
namespace Bitrix\Perfmon\Sql;
use Bitrix\Main\NotSupportedException;
class Trigger extends BaseObject
{
/**
* Creates trigger object from tokens.
* <p>
* Current position should point to the name of the trigger.
*
* @param Tokenizer $tokenizer Tokens collection.
*
* @return Trigger
*/
public static function create(Tokenizer $tokenizer)
{
$name = $tokenizer->getCurrentToken()->text;
$trigger = new self($name);
$tokenizer->resetState();
$definition = '';
while (!$tokenizer->endOfInput())
{
$definition .= $tokenizer->getCurrentToken()->text;
$tokenizer->nextToken();
}
$trigger->setBody($definition);
return $trigger;
}
/**
* Searches token collection for 'ON' keyword.
* <p>
* Advances current position on to next token skipping whitespace.
*
* @param Tokenizer $tokenizer Tokens collection.
*
* @return void
* @throws NotSupportedException
*/
public static function searchTableName(Tokenizer $tokenizer)
{
$lineToken = $tokenizer->getCurrentToken();
while (!$tokenizer->endOfInput())
{
if ($tokenizer->getCurrentToken()->upper === 'ON')
{
$tokenizer->nextToken();
$tokenizer->skipWhiteSpace();
return;
}
$tokenizer->nextToken();
}
throw new NotSupportedException('Trigger: table name not found. line: '.$lineToken->line);
}
/**
* Return DDL for trigger creation.
*
* @param string $dbType Database type (MYSQL, ORACLE or MSSQL).
*
* @return array|string
*/
public function getCreateDdl($dbType = '')
{
return $this->body;
}
/**
* Return DDL for trigger destruction.
*
* @param string $dbType Database type (MYSQL, ORACLE or MSSQL).
*
* @return array|string
*/
public function getDropDdl($dbType = '')
{
switch ($dbType)
{
case "MYSQL":
return "// ".get_class($this).":getDropDdl for database type [".$dbType."] not implemented";
case "MSSQL":
return "DROP TRIGGER ".$this->name;
case "ORACLE":
return "DROP TRIGGER ".$this->name;
default:
return "// ".get_class($this).":getDropDdl for database type [".$dbType."] not implemented";
}
}
/**
* Return DDL for trigger modification (drop with subsequent create).
*
* @param BaseObject $target Target object.
* @param string $dbType Database type (MYSQL, ORACLE or MSSQL).
*
* @return array|string
*/
public function getModifyDdl(BaseObject $target, $dbType = '')
{
return array(
$this->getDropDdl($dbType),
$target->getCreateDdl($dbType),
);
}
}