protected function executeDropTable(DropStatement $statement, ExecutionContext $context) { foreach ($statement->getSubjects() as $tableNameValue) { $tableName = $this->valueResolver->resolveValue($tableNameValue, $context); $this->schemaManager->dropTable($tableName); } $databaseSchema = $this->schemaManager->getSchema(); $result = new TemporaryResult(); $result->setIsSuccess(!$databaseSchema->tableExists($tableName)); return $result; }
public function convertSqlToJob(SQLTokenIterator $tokens) { $tokens->seekTokenNum(SqlToken::T_DROP()); if ($tokens->getCurrentTokenNumber() !== SqlToken::T_DROP()) { throw new ErrorException("Tried to parse sql-drop when token-iterator does not point to T_DROP!"); } $dropJob = new DropStatement(); if ($tokens->seekTokenNum(SqlToken::T_TEMPORARY())) { $dropJob->setIsTemporary(true); } switch (true) { case $tokens->seekTokenNum(SqlToken::T_SCHEMA(), TokenIterator::NEXT): case $tokens->seekTokenNum(SqlToken::T_DATABASE()): $dropJob->setType(DropStatement::TYPE_DATABASE); break; case $tokens->seekTokenNum(SqlToken::T_TABLE()): $dropJob->setType(DropStatement::TYPE_TABLE); break; case $tokens->seekTokenNum(SqlToken::T_VIEW()): $dropJob->setType(DropStatement::TYPE_VIEW); break; } if ($tokens->seekTokenNum(SqlToken::T_IF())) { if (!$tokens->seekTokenNum(SqlToken::T_EXISTS())) { throw new MalformedSqlException("Malformed drop-statement (missing T_EXISTS after T_IF)!"); } $dropJob->setOnlyIfExist(true); } else { $dropJob->setOnlyIfExist(false); } do { if (!$this->valueParser->canParseTokens($tokens)) { throw new MalformedSqlException("Missing a subject to drop for T_DROP statement!", $tokens); } $subject = $this->valueParser->convertSqlToJob($tokens); $dropJob->addSubject($subject); } while ($tokens->seekTokenText(',')); if ($tokens->seekTokenNum(SqlToken::T_RESTRICT())) { $dropJob->setReferenceOption(ReferenceOption::RESTRICT()); if ($tokens->seekTokenNum(SqlToken::T_CASCADE())) { throw new MalformedSqlException("Conflicting T_RESTRICT with T_CASCADE!", $tokens); } } if ($tokens->seekTokenNum(SqlToken::T_CASCADE())) { $dropJob->setReferenceOption(ReferenceOption::CASCADE()); if ($tokens->seekTokenNum(SqlToken::T_RESTRICT())) { throw new MalformedSqlException("Conflicting T_RESTRICT with T_CASCADE!", $tokens); } } return $dropJob; }