silverstripe-labs / silverstripe-sqlite3

code/SQLite3Query.php

Spacing +2 added lines, -2 removed lines

@@ -43,7 +43,7 @@ 
     public function seek($row)
     {
         $this->handle->reset();
-        $i=0;
+        $i = 0;
         while ($i < $row && $row = @$this->handle->fetchArray()) {
             $i++;
         }
@@ -55,7 +55,7 @@ 
      */
     public function numRecords()
     {
-        $c=0;
+        $c = 0;
         while ($this->handle->fetchArray()) {
             $c++;
         }

code/SQLiteDatabaseConfigurationHelper.php

Spacing +2 added lines, -2 removed lines

@@ -26,7 +26,7 @@ 
                 self::create_db_dir($databaseConfig['path']);
                 self::secure_db_dir($databaseConfig['path']);
             }
-            $file = $databaseConfig['path'] . '/' . $databaseConfig['database'];
+            $file = $databaseConfig['path'].'/'.$databaseConfig['database'];
             $conn = null;
         
             switch ($databaseConfig['type']) {
@@ -212,7 +212,7 @@ 
      */
     public static function secure_db_dir($path)
     {
-        return (is_writeable($path)) ? file_put_contents($path . '/.htaccess', 'deny from all') : false;
+        return (is_writeable($path)) ? file_put_contents($path.'/.htaccess', 'deny from all') : false;
     }
     
     public function requireDatabaseAlterPermissions($databaseConfig)

code/SQLite3SchemaManager.php

Spacing +12 added lines, -12 removed lines

@@ -44,7 +44,7 @@ 
          
         // If using file based database ensure any existing file is removed
         $parameters = $this->database->getParameters();
-        $fullpath = $parameters['path'] . '/' . $name;
+        $fullpath = $parameters['path'].'/'.$name;
         if (is_writable($fullpath)) {
             unlink($fullpath);
         }
@@ -242,7 +242,7 @@ 
     public function alterField($tableName, $fieldName, $fieldSpec)
     {
         $oldFieldList = $this->fieldList($tableName);
-        $fieldNameList = '"' . implode('","', array_keys($oldFieldList)) . '"';
+        $fieldNameList = '"'.implode('","', array_keys($oldFieldList)).'"';
 
         if (!empty($_REQUEST['avoidConflict']) && Director::isDev()) {
             $fieldSpec = preg_replace('/\snot null\s/i', ' NOT NULL ON CONFLICT REPLACE ', $fieldSpec);
@@ -256,12 +256,12 @@ 
         // Update field spec
         $newColsSpec = array();
         foreach ($oldFieldList as $name => $oldSpec) {
-            $newColsSpec[] = "\"$name\" " . ($name == $fieldName ? $fieldSpec : $oldSpec);
+            $newColsSpec[] = "\"$name\" ".($name == $fieldName ? $fieldSpec : $oldSpec);
         }
 
         $queries = array(
             "BEGIN TRANSACTION",
-            "CREATE TABLE \"{$tableName}_alterfield_{$fieldName}\"(" . implode(',', $newColsSpec) . ")",
+            "CREATE TABLE \"{$tableName}_alterfield_{$fieldName}\"(".implode(',', $newColsSpec).")",
             "INSERT INTO \"{$tableName}_alterfield_{$fieldName}\" SELECT {$fieldNameList} FROM \"$tableName\"",
             "DROP TABLE \"$tableName\"",
             "ALTER TABLE \"{$tableName}_alterfield_{$fieldName}\" RENAME TO \"$tableName\"",
@@ -295,15 +295,15 @@ 
         $oldCols = array();
         $newColsSpec = array();
         foreach ($oldFieldList as $name => $spec) {
-            $oldCols[] = "\"$name\"" . (($name == $oldName) ? " AS $newName" : '');
-            $newColsSpec[] = "\"" . (($name == $oldName) ? $newName : $name) . "\" $spec";
+            $oldCols[] = "\"$name\"".(($name == $oldName) ? " AS $newName" : '');
+            $newColsSpec[] = "\"".(($name == $oldName) ? $newName : $name)."\" $spec";
         }
 
         // SQLite doesn't support direct renames through ALTER TABLE
         $queries = array(
             "BEGIN TRANSACTION",
-            "CREATE TABLE \"{$tableName}_renamefield_{$oldName}\" (" . implode(',', $newColsSpec) . ")",
-            "INSERT INTO \"{$tableName}_renamefield_{$oldName}\" SELECT " . implode(',', $oldCols) . " FROM \"$tableName\"",
+            "CREATE TABLE \"{$tableName}_renamefield_{$oldName}\" (".implode(',', $newColsSpec).")",
+            "INSERT INTO \"{$tableName}_renamefield_{$oldName}\" SELECT ".implode(',', $oldCols)." FROM \"$tableName\"",
             "DROP TABLE \"$tableName\"",
             "ALTER TABLE \"{$tableName}_renamefield_{$oldName}\" RENAME TO \"$tableName\"",
             "COMMIT"
@@ -455,7 +455,7 @@ 
      */
     public function boolean($values)
     {
-        $default = empty($values['default']) ? 0 : (int)$values['default'];
+        $default = empty($values['default']) ? 0 : (int) $values['default'];
         return "BOOL NOT NULL DEFAULT $default";
     }
 
@@ -499,7 +499,7 @@ 
      */
     public function enum($values)
     {
-        $tablefield = $values['table'] . '.' . $values['name'];
+        $tablefield = $values['table'].'.'.$values['name'];
         $enumValues = implode(',', $values['enums']);
         
         // Ensure the cache table exists
@@ -569,7 +569,7 @@ 
      */
     public function int($values, $asDbValue = false)
     {
-        return "INTEGER({$values['precision']}) " . strtoupper($values['null']) . " DEFAULT " . (int)$values['default'];
+        return "INTEGER({$values['precision']}) ".strtoupper($values['null'])." DEFAULT ".(int) $values['default'];
     }
 
     /**
@@ -644,7 +644,7 @@ 
 
     public function hasTable($tableName)
     {
-        return (bool)$this->preparedQuery(
+        return (bool) $this->preparedQuery(
             'SELECT name FROM sqlite_master WHERE type = ? AND name = ?',
             array('table', $tableName)
         )->first();

code/SQLite3QueryBuilder.php

Spacing +4 added lines, -4 removed lines

@@ -49,7 +49,7 @@ 
             $rowParts[] = implode(', ', $parts);
         }
         $columnSQL = implode(', ', $columns);
-        $sql = "INSERT INTO {$into}{$nl}($columnSQL){$nl}SELECT " . implode("{$nl}UNION ALL SELECT ", $rowParts);
+        $sql = "INSERT INTO {$into}{$nl}($columnSQL){$nl}SELECT ".implode("{$nl}UNION ALL SELECT ", $rowParts);
         
         return $sql;
     }
@@ -72,14 +72,14 @@ 
         }
 
         // For literal values return this as the limit SQL
-        if (! is_array($limit)) {
+        if (!is_array($limit)) {
             return "{$nl}LIMIT $limit";
         }
 
         // Assert that the array version provides the 'limit' key
-        if (! array_key_exists('limit', $limit) || ($limit['limit'] !== null && ! is_numeric($limit['limit']))) {
+        if (!array_key_exists('limit', $limit) || ($limit['limit'] !== null && !is_numeric($limit['limit']))) {
             throw new InvalidArgumentException(
-                'SQLite3QueryBuilder::buildLimitSQL(): Wrong format for $limit: '. var_export($limit, true)
+                'SQLite3QueryBuilder::buildLimitSQL(): Wrong format for $limit: '.var_export($limit, true)
             );
         }
 

code/SQLite3Database.php

Spacing +12 added lines, -12 removed lines

@@ -107,7 +107,7 @@ 
 
         // Ensure database name is set
         if (empty($parameters['database'])) {
-            $parameters['database'] = 'database' . self::database_extension();
+            $parameters['database'] = 'database'.self::database_extension();
         }
         $dbName = $parameters['database'];
         if (!self::is_valid_database_name($dbName)) {
@@ -123,11 +123,11 @@ 
         } else {
             // Ensure path is given
             if (empty($parameters['path'])) {
-                $parameters['path'] = ASSETS_PATH . '/.sqlitedb';
+                $parameters['path'] = ASSETS_PATH.'/.sqlitedb';
             }
 
             //assumes that the path to dbname will always be provided:
-            $file = $parameters['path'] . '/' . $dbName;
+            $file = $parameters['path'].'/'.$dbName;
             if (!file_exists($parameters['path'])) {
                 SQLiteDatabaseConfigurationHelper::create_db_dir($parameters['path']);
                 SQLiteDatabaseConfigurationHelper::secure_db_dir($parameters['path']);
@@ -286,7 +286,7 @@ 
             $extraFilters['File'] .= " AND ShowInSearch <> 0";
         }
 
-        $limit = $start . ", " . (int) $pageLength;
+        $limit = $start.", ".(int) $pageLength;
 
         $notMatch = $invertedMatch ? "NOT " : "";
         if ($keywords) {
@@ -311,7 +311,7 @@ 
         $queries = array();
         foreach ($classesToSearch as $class) {
             $queries[$class] = DataList::create($class)
-                ->where($notMatch . $match[$class] . $extraFilters[$class])
+                ->where($notMatch.$match[$class].$extraFilters[$class])
                 ->dataQuery()
                 ->query();
             $fromArr = $queries[$class]->getFrom();
@@ -376,7 +376,7 @@ 
             $totalCount += $query->unlimitedRowCount();
         }
 
-        $fullQuery = implode(" UNION ", $querySQLs) . " ORDER BY $sortBy LIMIT $limit";
+        $fullQuery = implode(" UNION ", $querySQLs)." ORDER BY $sortBy LIMIT $limit";
         // Get records
         $records = $this->preparedQuery($fullQuery, $queryParameters);
 
@@ -463,7 +463,7 @@ 
                 $comp = 'LIKE';
             }
             if ($negate) {
-                $comp = 'NOT ' . $comp;
+                $comp = 'NOT '.$comp;
             }
         }
 
@@ -479,7 +479,7 @@ 
         preg_match_all('/%(.)/', $format, $matches);
         foreach ($matches[1] as $match) {
             if (array_search($match, array('Y', 'm', 'd', 'H', 'i', 's', 'U')) === false) {
-                user_error('formattedDatetimeClause(): unsupported format character %' . $match, E_USER_WARNING);
+                user_error('formattedDatetimeClause(): unsupported format character %'.$match, E_USER_WARNING);
             }
         }
 
@@ -504,7 +504,7 @@ 
             $date = "'$date'";
         }
 
-        $modifier = empty($modifiers) ? '' : ", '" . implode("', '", $modifiers) . "'";
+        $modifier = empty($modifiers) ? '' : ", '".implode("', '", $modifiers)."'";
         return "strftime('$format', $date$modifier)";
     }
 
@@ -521,7 +521,7 @@ 
             $date = "'$date'";
         }
 
-        $modifier = empty($modifiers) ? '' : ", '" . implode("', '", $modifiers) . "'";
+        $modifier = empty($modifiers) ? '' : ", '".implode("', '", $modifiers)."'";
         return "datetime($date$modifier, '$interval')";
     }
 
@@ -549,8 +549,8 @@ 
             $date2 = "'$date2'";
         }
 
-        $modifier1 = empty($modifiers1) ? '' : ", '" . implode("', '", $modifiers1) . "'";
-        $modifier2 = empty($modifiers2) ? '' : ", '" . implode("', '", $modifiers2) . "'";
+        $modifier1 = empty($modifiers1) ? '' : ", '".implode("', '", $modifiers1)."'";
+        $modifier2 = empty($modifiers2) ? '' : ", '".implode("', '", $modifiers2)."'";
 
         return "strftime('%s', $date1$modifier1) - strftime('%s', $date2$modifier2)";
     }