|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/* |
|
4
|
|
|
* This file is part of the samshal/scripd package. |
|
5
|
|
|
* |
|
6
|
|
|
* (c) Samuel Adeshina <[email protected]> |
|
7
|
|
|
* |
|
8
|
|
|
* For the full copyright and license information, please view the LICENSE |
|
9
|
|
|
* file that was distributed with this source code. |
|
10
|
|
|
*/ |
|
11
|
|
|
|
|
12
|
|
|
class JsonDbStructureTest extends PHPUnit_Framework_TestCase |
|
|
|
|
|
|
13
|
|
|
{ |
|
14
|
|
|
public function parseJsonFile($jsonFile) |
|
15
|
|
|
{ |
|
16
|
|
|
$jsonDbStructure = new Samshal\Scripd\JsonDbStructure($jsonFile, 'sqlite'); |
|
17
|
|
|
$jsonDbStructure->parseStructure(); |
|
18
|
|
|
|
|
19
|
|
|
return $jsonDbStructure->getGeneratedSql(';'); |
|
20
|
|
|
} |
|
21
|
|
|
|
|
22
|
|
|
public function parseArrayInput($jsonFile) |
|
23
|
|
|
{ |
|
24
|
|
|
$jsonArray = json_decode(file_get_contents($jsonFile), JSON_FORCE_OBJECT); |
|
25
|
|
|
|
|
26
|
|
|
$jsonDbStructure = new Samshal\Scripd\JsonDbStructure($jsonArray, 'mysql'); |
|
27
|
|
|
$jsonDbStructure->parseStructure(); |
|
28
|
|
|
|
|
29
|
|
|
return $jsonDbStructure->getGeneratedSql(';'); |
|
30
|
|
|
} |
|
31
|
|
|
|
|
32
|
|
|
public function parseWithoutVendor($jsonFile) |
|
33
|
|
|
{ |
|
34
|
|
|
$jsonDbStructure = new Samshal\Scripd\JsonDbStructure($jsonFile); |
|
35
|
|
|
$jsonDbStructure->parseStructure(); |
|
36
|
|
|
|
|
37
|
|
|
return $jsonDbStructure->getGeneratedSql(';'); |
|
38
|
|
|
} |
|
39
|
|
|
|
|
40
|
|
|
/** |
|
41
|
|
|
* @dataProvider dataProvider |
|
42
|
|
|
*/ |
|
43
|
|
|
public function testStructureParserWithJsonFileInput($expected, $jsonFile) |
|
44
|
|
|
{ |
|
45
|
|
|
$this->assertEquals($expected, self::parseJsonFile($jsonFile)); |
|
46
|
|
|
} |
|
47
|
|
|
|
|
48
|
|
|
/** |
|
49
|
|
|
* @dataProvider dataProvider |
|
50
|
|
|
*/ |
|
51
|
|
|
public function testStructureParserWithArrayInput($expected, $jsonFile) |
|
52
|
|
|
{ |
|
53
|
|
|
$this->assertEquals($expected, self::parseArrayInput($jsonFile)); |
|
54
|
|
|
} |
|
55
|
|
|
|
|
56
|
|
|
/** |
|
57
|
|
|
* @dataProvider dataProvider |
|
58
|
|
|
*/ |
|
59
|
|
|
public function testStructureParserWithoutVendor($expected, $jsonFile) |
|
60
|
|
|
{ |
|
61
|
|
|
$this->assertEquals($expected, self::parseWithoutVendor($jsonFile)); |
|
62
|
|
|
} |
|
63
|
|
|
|
|
64
|
|
|
public function dataProvider() |
|
65
|
|
|
{ |
|
66
|
|
|
return array( |
|
67
|
|
|
'Create Database with Multiple Tables' => [ |
|
68
|
|
|
'CREATE DATABASE another_unify_schools;'. |
|
69
|
|
|
'USE another_unify_schools;'. |
|
70
|
|
|
"CREATE TABLE students (id int PRIMARY KEY, first_name varchar(20) DEFAULT 'samuel', last_name varchar(20), class varchar(10));". |
|
71
|
|
|
'CREATE TABLE faculty (fac_id int AUTO_INCREMENT PRIMARY KEY, first_name varchar(20), last_name varchar(20));'. |
|
72
|
|
|
'CREATE TABLE subjects (subject_id int AUTO_INCREMENT PRIMARY KEY, subject_name varchar(30), subject_faculty int , FOREIGN KEY (subject_faculty) REFERENCES faculty(fac_id) ON UPDATE cascade ON DELETE set null)', __DIR__.'/json/1.json', |
|
73
|
|
|
], |
|
74
|
|
|
'Alter Table' => [ |
|
75
|
|
|
"ALTER TABLE facultys ADD COLUMN (full_name varchar(30) NOT NULL DEFAULT 'john doe')", __DIR__.'/json/2.json', |
|
76
|
|
|
], |
|
77
|
|
|
'Drop Objects' => [ |
|
78
|
|
|
'DROP TABLE IF EXISTS faculty;'. |
|
79
|
|
|
'DROP DATABASE another_unify_schools', __DIR__.'/json/3.json', |
|
80
|
|
|
], |
|
81
|
|
|
'Create View' => [ |
|
82
|
|
|
'CREATE VIEW student_vw (id, first_name, last_name, class) AS select * from students where id < 3 WITH LOCAL CHECK OPTION', __DIR__.'/json/4.json', |
|
83
|
|
|
], |
|
84
|
|
|
); |
|
85
|
|
|
} |
|
86
|
|
|
} |
|
87
|
|
|
|
Samshal /
Scripd
You can fix this by adding a namespace to your class:
When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries.