Mercurial > packages > framework

comparison src/Database/MyBlueprint.php @ 2:b44434aaa767

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Moving around the components. Made a big step in the right direction with the Builder and named joins being accessible.
author luka
date Wed, 18 Jun 2025 22:28:47 -0400
parents
children 84c75d9d90be
comparison
equal deleted inserted replaced
1:56d9c64d64aa 2:b44434aaa767
1 <?php
2
3 namespace Libraries;
4
5 use Illuminate\Database\Schema\ColumnDefinition;
6
7 class MyBlueprint extends \Illuminate\Database\Schema\Blueprint
8 {
9 /**
10 * Generates the base columns for a regular table
11 */
12 public function baseColumns(): void
13 {
14 $this->id();
15 $this->reference('users', 'created_by')->nullable();
16 $this->reference('users', 'updated_by')->nullable();
17 $this->timestamps();
18 $this->softDeletes();
19 }
20
21 /**
22 * @param mixed $abbreviation
23 */
24 public function baseTextColumns($abbreviation = false): void
25 {
26 $this->string('name', 255);
27 $this->text('description')->nullable();
28 if ($abbreviation) {
29 $this->string('abbreviation', 50)->nullable();
30 }
31 }
32
33 public function pivotColumns(string $table1, string $table2): void
34 {
35 $this->comment('PIVOT:'.json_encode(['table1' => $table1, 'table2' => $table2]));
36 $this->id();
37 $this->reference($table1);
38 $this->reference($table2);
39 }
40
41 public function settingsColumns(): void
42 {
43 $this->baseColumns();
44 $this->baseTextColumns();
45 }
46
47 /**
48 * @param mixed $keep_column
49 */
50 public function dropReference(string $table, ?string $override_column_name = null, $keep_column = false): void
51 {
52 // set up relevant strings
53 $column_name = self::get_foreign_column_name($table, $override_column_name);
54 $fk_name = self::get_foreign_key_name($this->getTable(), $table, $column_name);
55
56 // drop the reference
57 $this->dropForeign($fk_name);
58
59 // drop the column if necessary
60 if (! $keep_column) {
61 $this->dropColumn($column_name);
62 }
63 }
64
65 public function reference(string $table, ?string $override_column_name = null): ColumnDefinition
66 {
67 // set up relevant strings
68 $column_name = self::get_foreign_column_name($table, $override_column_name);
69 $fk_name = self::get_foreign_key_name($this->getTable(), $table, $column_name);
70
71 // create the column
72 $column = $this->unsignedBigInteger($column_name);
73
74 // create the foreign key
75 $this->foreign($column_name, $fk_name)->references('id')->on($table);
76
77 return $column;
78 }
79
80 protected static function get_foreign_column_name(string $input, ?string $override = null): string
81 {
82 return ! is_null($override) ? $override : \Str::singular($input).'_id';
83 }
84
85 /*
86 * Generates a foreign key name
87 * 'FK_' + current table name + foreign column name
88 *
89 * */
90 protected static function get_foreign_key_name(string $current_table, string $table, string $column_name): string
91 {
92 $fk_name = 'FK_';
93
94 // add the current table name
95 $fk_name .= \Str::singular($current_table);
96
97 // add the foreign column name
98 $fk_name .= '_'.$column_name;
99
100 return $fk_name;
101 }
102 }