-
Notifications
You must be signed in to change notification settings - Fork 159
Expand file tree
/
Copy pathAlterTableDropConstraintSQL.php
More file actions
35 lines (27 loc) · 1.11 KB
/
AlterTableDropConstraintSQL.php
File metadata and controls
35 lines (27 loc) · 1.11 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?php namespace DBDiff\SQLGen\DiffToSQL;
use DBDiff\Exceptions\InvalidConstraintException;
use DBDiff\SQLGen\SQLGenInterface;
use DBDiff\SQLGen\Dialect\DialectRegistry;
use DBDiff\SQLGen\Dialect\SQLDialectInterface;
class AlterTableDropConstraintSQL implements SQLGenInterface {
protected $obj;
protected SQLDialectInterface $dialect;
public function __construct($obj, SQLDialectInterface $dialect = null) {
$this->obj = $obj;
$this->dialect = $dialect ?? DialectRegistry::get();
}
public function getUp(): string {
if (empty($this->obj->name)) {
throw new InvalidConstraintException(
"Cannot generate DROP CONSTRAINT for table `{$this->obj->table}`: constraint name is empty"
);
}
$schema = $this->obj->diff->getOldValue();
return $this->dialect->dropConstraint($this->obj->table, $this->obj->name, $schema);
}
public function getDown(): string {
$t = $this->dialect->quote($this->obj->table);
$schema = $this->obj->diff->getOldValue();
return "ALTER TABLE $t ADD $schema;";
}
}