ForeignKey   A
last analyzed

Complexity

Total Complexity 10

Size/Duplication

Total Lines 114
Duplicated Lines 0 %

Importance

Changes 3
Bugs 1 Features 0
Metric Value
eloc 18
c 3
b 1
f 0
dl 0
loc 114
rs 10
wmc 10

9 Methods

Rating   Name   Duplication   Size   Complexity  
A references() 0 6 1
A getActions() 0 3 1
A __construct() 0 2 1
A getColumns() 0 3 1
A addAction() 0 10 2
A getReferenceTable() 0 3 1
A onUpdate() 0 3 1
A getReferenceColumns() 0 3 1
A onDelete() 0 3 1
1
<?php
2
3
/**
4
 * Platine Database
5
 *
6
 * Platine Database is the abstraction layer using PDO with support of query and schema builder
7
 *
8
 * This content is released under the MIT License (MIT)
9
 *
10
 * Copyright (c) 2020 Platine Database
11
 *
12
 * Permission is hereby granted, free of charge, to any person obtaining a copy
13
 * of this software and associated documentation files (the "Software"), to deal
14
 * in the Software without restriction, including without limitation the rights
15
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
16
 * copies of the Software, and to permit persons to whom the Software is
17
 * furnished to do so, subject to the following conditions:
18
 *
19
 * The above copyright notice and this permission notice shall be included in all
20
 * copies or substantial portions of the Software.
21
 *
22
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
23
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
24
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
25
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
26
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
27
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
28
 * SOFTWARE.
29
 */
30
31
/**
32
 *  @file ForeignKey.php
33
 *
34
 *  The foreign key schema class
35
 *
36
 *  @package    Platine\Database\Schema
37
 *  @author Platine Developers Team
38
 *  @copyright  Copyright (c) 2020
39
 *  @license    http://opensource.org/licenses/MIT  MIT License
40
 *  @link   https://www.platine-php.com
41
 *  @version 1.0.0
42
 *  @filesource
43
 */
44
45
declare(strict_types=1);
46
47
namespace Platine\Database\Schema;
48
49
/**
50
 * @class ForeignKey
51
 * @package Platine\Database\Schema
52
 */
53
class ForeignKey
54
{
55
    /**
56
     * The referenced table
57
     * @var string
58
     */
59
    protected string $referenceTable;
60
61
    /**
62
     * The referenced columns
63
     * @var string[]
64
     */
65
    protected array $referenceColumns = [];
66
67
    /**
68
     * The list of actions
69
     * @var array<string, string>
70
     */
71
    protected array $actions = [];
72
73
    /**
74
     * Class constructor
75
     * @param array<int, string> $columns The base table columns
76
     */
77
    public function __construct(protected array $columns)
78
    {
79
    }
80
81
    /**
82
     *
83
     * @return string
84
     */
85
    public function getReferenceTable(): string
86
    {
87
        return $this->referenceTable;
88
    }
89
90
    /**
91
     *
92
     * @return string[]
93
     */
94
    public function getReferenceColumns(): array
95
    {
96
        return $this->referenceColumns;
97
    }
98
99
    /**
100
     *
101
     * @return array<int, string>
102
     */
103
    public function getColumns(): array
104
    {
105
        return $this->columns;
106
    }
107
108
    /**
109
     *
110
     * @return array<string, string>
111
     */
112
    public function getActions(): array
113
    {
114
        return $this->actions;
115
    }
116
117
    /**
118
     * Set the references
119
     * @param string $table
120
     * @param string ...$columns
121
     * @return $this
122
     */
123
    public function references(string $table, string ...$columns): self
124
    {
125
        $this->referenceTable = $table;
126
        $this->referenceColumns = $columns;
127
128
        return $this;
129
    }
130
131
    /**
132
     *
133
     * @param string $action
134
     * @return $this
135
     */
136
    public function onDelete(string $action): self
137
    {
138
        return $this->addAction('ON DELETE', $action);
139
    }
140
141
    /**
142
     *
143
     * @param string $action
144
     * @return $this
145
     */
146
    public function onUpdate(string $action): self
147
    {
148
        return $this->addAction('ON UPDATE', $action);
149
    }
150
151
    /**
152
     * Add the action
153
     * @param string $on the type of action DELETE, UPDATE
154
     * @param string $action
155
     * @return $this
156
     */
157
    protected function addAction(string $on, string $action): self
158
    {
159
        $actionValue = strtoupper($action);
160
        if (!in_array($actionValue, ['RESTRICT', 'CASCADE', 'NO ACTION', 'SET NULL'])) {
161
            return $this;
162
        }
163
164
        $this->actions[$on] = $actionValue;
165
166
        return $this;
167
    }
168
}
169