Samshal / Scripd

JsonDbStructureTest.php

Indentation +4 added lines, -4 removed lines

@@ -66,10 +66,10 @@
         return array(
             'Create Database with Multiple Tables' => [
                 'CREATE DATABASE another_unify_schools;'.
-                 'USE another_unify_schools;'.
-                 "CREATE TABLE students (id int PRIMARY KEY, first_name varchar(20) DEFAULT 'samuel', last_name varchar(20), class varchar(10));".
-                 'CREATE TABLE faculty (fac_id int AUTO_INCREMENT PRIMARY KEY, first_name varchar(20), last_name varchar(20));'.
-                 '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',
+                    'USE another_unify_schools;'.
+                    "CREATE TABLE students (id int PRIMARY KEY, first_name varchar(20) DEFAULT 'samuel', last_name varchar(20), class varchar(10));".
+                    'CREATE TABLE faculty (fac_id int AUTO_INCREMENT PRIMARY KEY, first_name varchar(20), last_name varchar(20));'.
+                    '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',
             ],
             'Alter Table' => [
                 "ALTER TABLE facultys ADD COLUMN (full_name varchar(30) NOT NULL DEFAULT 'john doe')", __DIR__.'/json/2.json',

JsynExtractor.php

Braces +1 added lines, -2 removed lines

@@ -113,8 +113,7 @@
     {
         if (is_array($jsonStructureFile)){
             $this->jsonStructure = $jsonStructureFile;
-        }
-        else {
+        } else {
             $this->jsonStructure = self::getObjectFromJsonFile($jsonStructureFile);
         }
         $this->sqlVendor = $sqlVendor;