Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
90.00% |
9 / 10 |
CRAP | |
95.45% |
21 / 22 |
| MySQLConstraint | |
0.00% |
0 / 1 |
|
90.00% |
9 / 10 |
11 | |
95.45% |
21 / 22 |
| __construct | |
100.00% |
1 / 1 |
1 | |
100.00% |
2 / 2 |
|||
| fromResultSet | |
100.00% |
1 / 1 |
1 | |
100.00% |
4 / 4 |
|||
| addConstraint | |
100.00% |
1 / 1 |
1 | |
100.00% |
4 / 4 |
|||
| addUpdateAndDeleteRule | |
100.00% |
1 / 1 |
1 | |
100.00% |
3 / 3 |
|||
| getName | |
0.00% |
0 / 1 |
2.06 | |
75.00% |
3 / 4 |
|||
| getConstraintName | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| getForeignTable | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| getOnUpdate | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| getOnDelete | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| getConstraintMappingList | |
100.00% |
1 / 1 |
1 | |
100.00% |
1 / 1 |
|||
| <?php | |
| declare(strict_types = 1); | |
| namespace Siesta\Driver\MySQL\MetaData; | |
| use Siesta\Database\MetaData\ConstraintMappingMetaData; | |
| use Siesta\Database\MetaData\ConstraintMetaData; | |
| use Siesta\Database\ResultSet; | |
| use Siesta\Util\StringUtil; | |
| /** | |
| * @author Gregor Müller | |
| */ | |
| class MySQLConstraint implements ConstraintMetaData | |
| { | |
| const COLUMN_NAME = "COLUMN_NAME"; | |
| const CONSTRAINT_NAME = "CONSTRAINT_NAME"; | |
| const REFERENCED_TABLE_NAME = "REFERENCED_TABLE_NAME"; | |
| const REFERENCED_COLUMN_NAME = "REFERENCED_COLUMN_NAME"; | |
| const DELETE_RULE = "DELETE_RULE"; | |
| const UPDATE_RULE = "UPDATE_RULE"; | |
| /** | |
| * @var string | |
| */ | |
| protected $constraintName; | |
| /** | |
| * @var string | |
| */ | |
| protected $foreignTable; | |
| /** | |
| * @var string | |
| */ | |
| protected $onUpdate; | |
| /** | |
| * @var string | |
| */ | |
| protected $onDelete; | |
| /** | |
| * @var | |
| */ | |
| protected $constraintMappingList; | |
| /** | |
| * MySQLConstraint constructor. | |
| */ | |
| public function __construct() | |
| { | |
| $this->constraintMappingList = []; | |
| } | |
| /** | |
| * @param ResultSet $resultSet | |
| */ | |
| public function fromResultSet(ResultSet $resultSet) | |
| { | |
| $this->constraintName = $resultSet->getStringValue(self::CONSTRAINT_NAME); | |
| $this->foreignTable = $resultSet->getStringValue(self::REFERENCED_TABLE_NAME); | |
| $this->addConstraint($resultSet); | |
| } | |
| /** | |
| * @param ResultSet $resultSet | |
| */ | |
| public function addConstraint(ResultSet $resultSet) | |
| { | |
| $constraintMapping = new MySQLConstraintMapping(); | |
| $constraintMapping->fromResultSet($resultSet); | |
| $this->constraintMappingList[] = $constraintMapping; | |
| } | |
| public function addUpdateAndDeleteRule(ResultSet $resultSet) | |
| { | |
| $this->onUpdate = $resultSet->getStringValue(self::UPDATE_RULE); | |
| $this->onDelete = $resultSet->getStringValue(self::DELETE_RULE); | |
| } | |
| /** | |
| * @return string | |
| */ | |
| public function getName() : string | |
| { | |
| $constraintName = $this->getConstraintName(); | |
| if (strpos($constraintName, "_") !== false) { | |
| return StringUtil::getEndAfterLast($constraintName, "_"); | |
| } | |
| return $constraintName; | |
| } | |
| public function getConstraintName() : string | |
| { | |
| return $this->constraintName; | |
| } | |
| /** | |
| * @return string | |
| */ | |
| public function getForeignTable() : string | |
| { | |
| return $this->foreignTable; | |
| } | |
| /** | |
| * @return string | |
| */ | |
| public function getOnUpdate() : string | |
| { | |
| return ConstraintRule::mySQLToSchema($this->onUpdate); | |
| } | |
| /** | |
| * @return string | |
| */ | |
| public function getOnDelete() : string | |
| { | |
| return ConstraintRule::mySQLToSchema($this->onDelete); | |
| } | |
| /** | |
| * @return ConstraintMappingMetaData[] | |
| */ | |
| public function getConstraintMappingList() : array | |
| { | |
| return $this->constraintMappingList; | |
| } | |
| } |