-
Notifications
You must be signed in to change notification settings - Fork 159
Expand file tree
/
Copy pathSetDBCharsetSQL.php
More file actions
34 lines (26 loc) · 972 Bytes
/
SetDBCharsetSQL.php
File metadata and controls
34 lines (26 loc) · 972 Bytes
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
<?php namespace DBDiff\SQLGen\DiffToSQL;
use DBDiff\SQLGen\SQLGenInterface;
use DBDiff\SQLGen\Dialect\DialectRegistry;
use DBDiff\SQLGen\Dialect\SQLDialectInterface;
class SetDBCharsetSQL 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 (!$this->dialect->isMySQLOnly()) {
return '';
}
$db = $this->dialect->quote($this->obj->db);
return "ALTER DATABASE $db CHARACTER SET {$this->obj->charset};";
}
public function getDown(): string {
if (!$this->dialect->isMySQLOnly()) {
return '';
}
$db = $this->dialect->quote($this->obj->db);
return "ALTER DATABASE $db CHARACTER SET {$this->obj->prevCharset};";
}
}