Samshal / Scripd

JsynExtractor.php

Doc Comments +2 added lines, -2 removed lines

@@ -35,7 +35,7 @@ 
     private $sqlSyntax;
 
     /**
-     * @param $jsynFile string | PathUtil
+     * @param string $jsynFile string | PathUtil
      * @param $sqlSyntax string
      */
     public function __construct($jsynFile, $sqlSyntax)
@@ -78,7 +78,7 @@ 
     }
 
     /**
-     * @return array
+     * @return string
      */
     public function getJsyn()
     {

Spacing +2 added lines, -2 removed lines

@@ -55,7 +55,7 @@ 
 
         if (isset($this->sqlSyntax)) {
             $sqlSyntax = $this->sqlSyntax;
-            if (!isset($this->jsyn->$sqlSyntax)){
+            if (!isset($this->jsyn->$sqlSyntax)) {
                 $sqlSyntax = "default";
             }
             $this->jsyn = $this->jsyn->$sqlSyntax;
@@ -77,7 +77,7 @@ 
             $this->jsyn = $this->jsyn->$sqlSyntax;
         }
         else {
-            $sqlSyntax ="default";
+            $sqlSyntax = "default";
             $this->jsyn = $this->jsyn->$sqlSyntax;
         }
 

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;

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',