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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin\Utils;
use function strtolower;
use function strtoupper;
use function substr;
use function version_compare;
final class ForeignKey
{
/**
* Verifies if this table's engine supports foreign keys
*
* @param string $engine engine
*/
public static function isSupported($engine): bool
{
global $dbi;
$engine = strtoupper((string) $engine);
if (($engine === 'INNODB') || ($engine === 'PBXT')) {
return true;
}
if ($engine === 'NDBCLUSTER' || $engine === 'NDB') {
$ndbver = strtolower(
$dbi->fetchValue('SELECT @@ndb_version_string') ?: ''
);
if (substr($ndbver, 0, 4) === 'ndb-') {
$ndbver = substr($ndbver, 4);
}
return version_compare($ndbver, '7.3', '>=');
}
return false;
}
/**
* Is Foreign key check enabled?
*/
public static function isCheckEnabled(): bool
{
global $dbi;
if ($GLOBALS['cfg']['DefaultForeignKeyChecks'] === 'enable') {
return true;
}
if ($GLOBALS['cfg']['DefaultForeignKeyChecks'] === 'disable') {
return false;
}
return $dbi->getVariable('FOREIGN_KEY_CHECKS') === 'ON';
}
/**
* Handle foreign key check request
*/
public static function handleDisableCheckInit(): bool
{
global $dbi;
$defaultCheckValue = $dbi->getVariable('FOREIGN_KEY_CHECKS') === 'ON';
if (isset($_REQUEST['fk_checks'])) {
if (empty($_REQUEST['fk_checks'])) {
// Disable foreign key checks
$dbi->setVariable('FOREIGN_KEY_CHECKS', 'OFF');
} else {
// Enable foreign key checks
$dbi->setVariable('FOREIGN_KEY_CHECKS', 'ON');
}
}
return $defaultCheckValue;
}
/**
* Cleanup changes done for foreign key check
*
* @param bool $defaultCheckValue original value for 'FOREIGN_KEY_CHECKS'
*/
public static function handleDisableCheckCleanup(bool $defaultCheckValue): void
{
global $dbi;
$dbi->setVariable('FOREIGN_KEY_CHECKS', $defaultCheckValue ? 'ON' : 'OFF');
}
}
|
