|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
namespace Bonfim\ActiveRecord; |
|
4
|
|
|
|
|
5
|
|
|
abstract class Schema extends ActiveRecord |
|
6
|
|
|
{ |
|
7
|
|
|
private $sql = ''; |
|
8
|
|
|
private $table; |
|
9
|
|
|
|
|
10
|
|
|
abstract public function up(); |
|
11
|
|
|
abstract public function down(); |
|
12
|
|
|
|
|
13
|
30 |
|
public function __construct() |
|
14
|
|
|
{ |
|
15
|
30 |
|
$this->table = new Table(); |
|
16
|
30 |
|
} |
|
17
|
|
|
|
|
18
|
30 |
|
public function create(string $name, $callback) |
|
19
|
|
|
{ |
|
20
|
30 |
|
call_user_func_array($callback, [$this->table]); |
|
21
|
|
|
|
|
22
|
30 |
|
$q = "CREATE TABLE IF NOT EXISTS $name ({$this->getColumns()}"; |
|
23
|
30 |
|
$q .= $this->pk().$this->fk().$this->onUpdate().$this->onDelete(); |
|
24
|
30 |
|
$q .= "\n) ENGINE=INNODB;"; |
|
25
|
|
|
|
|
26
|
30 |
|
$this->sql = $q; |
|
27
|
30 |
|
} |
|
28
|
|
|
|
|
29
|
|
|
public function drop(string $name) |
|
30
|
|
|
{ |
|
31
|
|
|
$this->sql = "DROP TABLE $name"; |
|
32
|
|
|
} |
|
33
|
|
|
|
|
34
|
30 |
|
private function pk() |
|
35
|
|
|
{ |
|
36
|
30 |
|
return (!empty($pk = $this->table->getPk())) |
|
|
|
|
|
|
37
|
30 |
|
? $this->sql .= ",\n\tPRIMARY KEY ($pk)" |
|
38
|
30 |
|
: ""; |
|
39
|
|
|
} |
|
40
|
|
|
|
|
41
|
30 |
|
private function fk() |
|
42
|
|
|
{ |
|
43
|
30 |
|
return (!empty($fk = $this->table->getFk())) |
|
|
|
|
|
|
44
|
|
|
? ",\n\t$fk {$this->table->getReferences()}" |
|
|
|
|
|
|
45
|
30 |
|
: ""; |
|
46
|
|
|
} |
|
47
|
|
|
|
|
48
|
30 |
|
private function onUpdate() |
|
49
|
|
|
{ |
|
50
|
30 |
|
return (!empty($on = $this->table->getOnupdate())) |
|
|
|
|
|
|
51
|
|
|
? " $on" |
|
52
|
30 |
|
: ""; |
|
53
|
|
|
} |
|
54
|
|
|
|
|
55
|
30 |
|
private function onDelete() |
|
56
|
|
|
{ |
|
57
|
30 |
|
return (!empty($on = $this->table->getOndelete())) |
|
|
|
|
|
|
58
|
|
|
? " $on" |
|
59
|
30 |
|
: ""; |
|
60
|
|
|
} |
|
61
|
|
|
|
|
62
|
30 |
|
private function getColumns() |
|
63
|
|
|
{ |
|
64
|
30 |
|
$q = "\n\t"; |
|
65
|
|
|
|
|
66
|
30 |
|
$columns = $this->table->getColumns(); |
|
67
|
30 |
|
$count = count($columns); |
|
68
|
|
|
|
|
69
|
30 |
|
reset($columns); |
|
70
|
|
|
|
|
71
|
30 |
|
for ($i = 0; $i < $count; $i++) { |
|
72
|
30 |
|
$key = key($columns); |
|
73
|
30 |
|
$q .= key($columns) . ' ' . $columns[$key]; |
|
74
|
30 |
|
if ($i < $count - 1) { |
|
75
|
30 |
|
$q .= ",\n\t"; |
|
76
|
|
|
} |
|
77
|
30 |
|
next($columns); |
|
78
|
|
|
} |
|
79
|
|
|
|
|
80
|
30 |
|
return $q; |
|
81
|
|
|
} |
|
82
|
|
|
|
|
83
|
30 |
|
public function run() |
|
84
|
|
|
{ |
|
85
|
30 |
|
self::exec($this->sql); |
|
86
|
30 |
|
} |
|
87
|
|
|
} |
|
88
|
|
|
|