@@ -109,7 +109,7 @@ |
||
| 109 | 109 | * @param $jsonStructureFile PathUtil | string | Array |
| 110 | 110 | * @param $sqlVendor string |
| 111 | 111 | */ |
| 112 | - public function __construct($jsonStructureFile, $sqlVendor='default') |
|
| 112 | + public function __construct($jsonStructureFile, $sqlVendor = 'default') |
|
| 113 | 113 | { |
| 114 | 114 | if (is_array($jsonStructureFile)) { |
| 115 | 115 | $this->jsonStructure = $jsonStructureFile; |
@@ -66,10 +66,10 @@ |
||
| 66 | 66 | return array( |
| 67 | 67 | 'Create Database with Multiple Tables' => [ |
| 68 | 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', |
|
| 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 | 73 | ], |
| 74 | 74 | 'Alter Table' => [ |
| 75 | 75 | "ALTER TABLE facultys ADD COLUMN (full_name varchar(30) NOT NULL DEFAULT 'john doe')", __DIR__.'/json/2.json', |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | |
| 56 | 56 | if (isset($this->sqlSyntax)) { |
| 57 | 57 | $sqlSyntax = $this->sqlSyntax; |
| 58 | - if (!isset($this->jsyn->$sqlSyntax)){ |
|
| 58 | + if (!isset($this->jsyn->$sqlSyntax)) { |
|
| 59 | 59 | $sqlSyntax = "default"; |
| 60 | 60 | } |
| 61 | 61 | $this->jsyn = $this->jsyn->$sqlSyntax; |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | $this->jsyn = $this->jsyn->$sqlSyntax; |
| 78 | 78 | } |
| 79 | 79 | else { |
| 80 | - $sqlSyntax ="default"; |
|
| 80 | + $sqlSyntax = "default"; |
|
| 81 | 81 | $this->jsyn = $this->jsyn->$sqlSyntax; |
| 82 | 82 | } |
| 83 | 83 | |