pradosoft / prado

framework/Data/Common/Mssql/TMssqlCommandBuilder.php

Spacing +19 added lines, -19 removed lines

@@ -31,7 +31,7 @@ 
 		{
 			if($column->hasSequence())
 			{
-				$command = $this->getDbConnection()->createCommand('SELECT @@Identity');
+				$command=$this->getDbConnection()->createCommand('SELECT @@Identity');
 				return intval($command->queryScalar());
 			}
 		}
@@ -79,12 +79,12 @@ 
 	 */
 	public function applyLimitOffset($sql, $limit=-1, $offset=-1)
 	{
-		$limit = $limit!==null ? intval($limit) : -1;
-		$offset = $offset!==null ? intval($offset) : -1;
-		if ($limit > 0 && $offset <= 0) //just limit
-			$sql = preg_replace('/^([\s(])*SELECT( DISTINCT)?(?!\s*TOP\s*\()/i',"\\1SELECT\\2 TOP $limit", $sql);
+		$limit=$limit!==null ? intval($limit) : -1;
+		$offset=$offset!==null ? intval($offset) : -1;
+		if($limit > 0 && $offset <= 0) //just limit
+			$sql=preg_replace('/^([\s(])*SELECT( DISTINCT)?(?!\s*TOP\s*\()/i', "\\1SELECT\\2 TOP $limit", $sql);
 		else if($limit > 0 && $offset > 0)
-			$sql = $this->rewriteLimitOffsetSql($sql, $limit,$offset);
+			$sql=$this->rewriteLimitOffsetSql($sql, $limit, $offset);
 		return $sql;
 	}
 
@@ -98,13 +98,13 @@ 
 	 */
 	protected function rewriteLimitOffsetSql($sql, $limit, $offset)
 	{
-		$fetch = $limit+$offset;
-		$sql = preg_replace('/^([\s(])*SELECT( DISTINCT)?(?!\s*TOP\s*\()/i',"\\1SELECT\\2 TOP $fetch", $sql);
-		$ordering = $this->findOrdering($sql);
+		$fetch=$limit + $offset;
+		$sql=preg_replace('/^([\s(])*SELECT( DISTINCT)?(?!\s*TOP\s*\()/i', "\\1SELECT\\2 TOP $fetch", $sql);
+		$ordering=$this->findOrdering($sql);
 
-		$orginalOrdering = $this->joinOrdering($ordering);
-		$reverseOrdering = $this->joinOrdering($this->reverseDirection($ordering));
-		$sql = "SELECT * FROM (SELECT TOP {$limit} * FROM ($sql) as [__inner top table__] {$reverseOrdering}) as [__outer top table__] {$orginalOrdering}";
+		$orginalOrdering=$this->joinOrdering($ordering);
+		$reverseOrdering=$this->joinOrdering($this->reverseDirection($ordering));
+		$sql="SELECT * FROM (SELECT TOP {$limit} * FROM ($sql) as [__inner top table__] {$reverseOrdering}) as [__outer top table__] {$orginalOrdering}";
 		return $sql;
 	}
 
@@ -121,9 +121,9 @@ 
 		$matches=array();
 		$ordering=array();
 		preg_match_all('/(ORDER BY)[\s"\[](.*)(ASC|DESC)?(?:[\s"\[]|$|COMPUTE|FOR)/i', $sql, $matches);
-		if(count($matches)>1 && count($matches[2]) > 0)
+		if(count($matches) > 1 && count($matches[2]) > 0)
 		{
-			$parts = explode(',', $matches[2][0]);
+			$parts=explode(',', $matches[2][0]);
 			foreach($parts as $part)
 			{
 				$subs=array();
@@ -131,12 +131,12 @@ 
 				{
 					if(count($subs) > 1 && count($subs[2]) > 0)
 					{
-						$ordering[$subs[1][0]] = $subs[2][0];
+						$ordering[$subs[1][0]]=$subs[2][0];
 					}
 					//else what?
 				}
 				else
-					$ordering[trim($part)] = 'ASC';
+					$ordering[trim($part)]='ASC';
 			}
 		}
 		return $ordering;
@@ -148,11 +148,11 @@ 
 	 */
 	protected function joinOrdering($orders)
 	{
-		if(count($orders)>0)
+		if(count($orders) > 0)
 		{
 			$str=array();
 			foreach($orders as $column => $direction)
-				$str[] = $column.' '.$direction;
+				$str[]=$column.' '.$direction;
 			return 'ORDER BY '.implode(', ', $str);
 		}
 	}
@@ -164,7 +164,7 @@ 
 	protected function reverseDirection($orders)
 	{
 		foreach($orders as $column => $direction)
-			$orders[$column] = strtolower(trim($direction))==='desc' ? 'ASC' : 'DESC';
+			$orders[$column]=strtolower(trim($direction))==='desc' ? 'ASC' : 'DESC';
 		return $orders;
 	}
 }

framework/Data/Common/Mssql/TMssqlMetaData.php

Spacing +47 added lines, -47 removed lines

@@ -69,9 +69,9 @@ 
 	 */
 	protected function createTableInfo($table)
 	{
-		list($catalogName,$schemaName,$tableName) = $this->getCatalogSchemaTableName($table);
+		list($catalogName, $schemaName, $tableName)=$this->getCatalogSchemaTableName($table);
 		$this->getDbConnection()->setActive(true);
-		$sql = <<<EOD
+		$sql=<<<EOD
 				SELECT t.*,
 												c.*,
 					columnproperty(object_id(c.table_schema + '.' + c.table_name), c.column_name,'IsIdentity') as IsIdentity
@@ -81,11 +81,11 @@ 
 										AND t.table_name = :table
 EOD;
 		if($schemaName!==null)
-			$sql .= ' AND t.table_schema = :schema';
+			$sql.=' AND t.table_schema = :schema';
 		if($catalogName!==null)
-			$sql .= ' AND t.table_catalog = :catalog';
+			$sql.=' AND t.table_catalog = :catalog';
 
-		$command = $this->getDbConnection()->createCommand($sql);
+		$command=$this->getDbConnection()->createCommand($sql);
 		$command->bindValue(':table', $tableName);
 		if($schemaName!==null)
 			$command->bindValue(':schema', $schemaName);
@@ -96,8 +96,8 @@ 
 		foreach($command->query() as $col)
 		{
 			if($tableInfo===null)
-				$tableInfo = $this->createNewTableInfo($col);
-			$this->processColumn($tableInfo,$col);
+				$tableInfo=$this->createNewTableInfo($col);
+			$this->processColumn($tableInfo, $col);
 		}
 		if($tableInfo===null)
 			throw new TDbException('dbmetadata_invalid_table_view', $table);
@@ -111,13 +111,13 @@ 
 	protected function getCatalogSchemaTableName($table)
 	{
 		//remove possible delimiters
-		$result = explode('.', preg_replace('/\[|\]|"/', '', $table));
+		$result=explode('.', preg_replace('/\[|\]|"/', '', $table));
 		if(count($result)===1)
-			return array(null,null,$result[0]);
+			return array(null, null, $result[0]);
 		if(count($result)===2)
-			return array(null,$result[0],$result[1]);
-		if(count($result)>2)
-			return array($result[0],$result[1],$result[2]);
+			return array(null, $result[0], $result[1]);
+		if(count($result) > 2)
+			return array($result[0], $result[1], $result[2]);
 	}
 
 	/**
@@ -126,31 +126,31 @@ 
 	 */
 	protected function processColumn($tableInfo, $col)
 	{
-		$columnId = $col['COLUMN_NAME'];
+		$columnId=$col['COLUMN_NAME'];
 
-		$info['ColumnName'] = "[$columnId]"; //quote the column names!
-		$info['ColumnId'] = $columnId;
-		$info['ColumnIndex'] = intval($col['ORDINAL_POSITION'])-1; //zero-based index
+		$info['ColumnName']="[$columnId]"; //quote the column names!
+		$info['ColumnId']=$columnId;
+		$info['ColumnIndex']=intval($col['ORDINAL_POSITION']) - 1; //zero-based index
 		if($col['IS_NULLABLE']!=='NO')
-			$info['AllowNull'] = true;
+			$info['AllowNull']=true;
 		if($col['COLUMN_DEFAULT']!==null)
-			$info['DefaultValue'] = $col['COLUMN_DEFAULT'];
+			$info['DefaultValue']=$col['COLUMN_DEFAULT'];
 
 		if(in_array($columnId, $tableInfo->getPrimaryKeys()))
-			$info['IsPrimaryKey'] = true;
+			$info['IsPrimaryKey']=true;
 		if($this->isForeignKeyColumn($columnId, $tableInfo))
-			$info['IsForeignKey'] = true;
+			$info['IsForeignKey']=true;
 
 		if($col['IsIdentity']==='1')
-			$info['AutoIncrement'] = true;
-		$info['DbType'] = $col['DATA_TYPE'];
+			$info['AutoIncrement']=true;
+		$info['DbType']=$col['DATA_TYPE'];
 		if($col['CHARACTER_MAXIMUM_LENGTH']!==null)
-			$info['ColumnSize'] = intval($col['CHARACTER_MAXIMUM_LENGTH']);
-		if($col['NUMERIC_PRECISION'] !== null)
-			$info['NumericPrecision'] = intval($col['NUMERIC_PRECISION']);
+			$info['ColumnSize']=intval($col['CHARACTER_MAXIMUM_LENGTH']);
+		if($col['NUMERIC_PRECISION']!==null)
+			$info['NumericPrecision']=intval($col['NUMERIC_PRECISION']);
 		if($col['NUMERIC_SCALE']!==null)
-			$info['NumericScale'] = intval($col['NUMERIC_SCALE']);
-		$tableInfo->Columns[$columnId] = new TMssqlTableColumn($info);
+			$info['NumericScale']=intval($col['NUMERIC_SCALE']);
+		$tableInfo->Columns[$columnId]=new TMssqlTableColumn($info);
 	}
 
 	/**
@@ -160,14 +160,14 @@ 
 	 */
 	protected function createNewTableInfo($col)
 	{
-		$info['CatalogName'] = $col['TABLE_CATALOG'];
-		$info['SchemaName'] = $col['TABLE_SCHEMA'];
-		$info['TableName'] = $col['TABLE_NAME'];
+		$info['CatalogName']=$col['TABLE_CATALOG'];
+		$info['SchemaName']=$col['TABLE_SCHEMA'];
+		$info['TableName']=$col['TABLE_NAME'];
 		if($col['TABLE_TYPE']==='VIEW')
-			$info['IsView'] = true;
-		list($primary, $foreign) = $this->getConstraintKeys($col);
-		$class = $this->getTableInfoClass();
-		return new $class($info,$primary,$foreign);
+			$info['IsView']=true;
+		list($primary, $foreign)=$this->getConstraintKeys($col);
+		$class=$this->getTableInfoClass();
+		return new $class($info, $primary, $foreign);
 	}
 
 	/**
@@ -178,7 +178,7 @@ 
 	 */
 	protected function getConstraintKeys($col)
 	{
-		$sql = <<<EOD
+		$sql=<<<EOD
 		SELECT k.column_name field_name
 				FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k
 				LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS c
@@ -189,13 +189,13 @@ 
 			c.constraint_type ='PRIMARY KEY'
 				AND k.table_name = :table
 EOD;
-		$command = $this->getDbConnection()->createCommand($sql);
+		$command=$this->getDbConnection()->createCommand($sql);
 		$command->bindValue(':table', $col['TABLE_NAME']);
-		$primary = array();
+		$primary=array();
 		foreach($command->query()->readAll() as $field)
-			$primary[] = $field['field_name'];
-		$foreign = $this->getForeignConstraints($col);
-		return array($primary,$foreign);
+			$primary[]=$field['field_name'];
+		$foreign=$this->getForeignConstraints($col);
+		return array($primary, $foreign);
 	}
 
 	/**
@@ -207,7 +207,7 @@ 
 	protected function getForeignConstraints($col)
 	{
 		//From http://msdn2.microsoft.com/en-us/library/aa175805(SQL.80).aspx
-		$sql = <<<EOD
+		$sql=<<<EOD
 		SELECT
 				KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME'
 			, KCU1.TABLE_NAME AS 'FK_TABLE_NAME'
@@ -232,14 +232,14 @@ 
 			AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION
 		WHERE KCU1.TABLE_NAME = :table
 EOD;
-		$command = $this->getDbConnection()->createCommand($sql);
+		$command=$this->getDbConnection()->createCommand($sql);
 		$command->bindValue(':table', $col['TABLE_NAME']);
 		$fkeys=array();
-		$catalogSchema = "[{$col['TABLE_CATALOG']}].[{$col['TABLE_SCHEMA']}]";
+		$catalogSchema="[{$col['TABLE_CATALOG']}].[{$col['TABLE_SCHEMA']}]";
 		foreach($command->query() as $info)
 		{
-			$fkeys[$info['FK_CONSTRAINT_NAME']]['keys'][$info['FK_COLUMN_NAME']] = $info['UQ_COLUMN_NAME'];
-			$fkeys[$info['FK_CONSTRAINT_NAME']]['table'] = $info['UQ_TABLE_NAME'];
+			$fkeys[$info['FK_CONSTRAINT_NAME']]['keys'][$info['FK_COLUMN_NAME']]=$info['UQ_COLUMN_NAME'];
+			$fkeys[$info['FK_CONSTRAINT_NAME']]['table']=$info['UQ_TABLE_NAME'];
 		}
 		return count($fkeys) > 0 ? array_values($fkeys) : $fkeys;
 	}
@@ -276,9 +276,9 @@ 
 		$command->bindParam(":schema", $schema);
 		$rows=$command->queryAll();
 		$names=array();
-		foreach ($rows as $row)
+		foreach($rows as $row)
 		{
-			if ($schema == self::DEFAULT_SCHEMA)
+			if($schema==self::DEFAULT_SCHEMA)
 				$names[]=$row['TABLE_NAME'];
 			else
 				$names[]=$schema.'.'.$row['TABLE_SCHEMA'].'.'.$row['TABLE_NAME'];

framework/Data/Common/Mssql/TMssqlTableColumn.php

Spacing +2 added lines, -2 removed lines

@@ -23,7 +23,7 @@ 
  */
 class TMssqlTableColumn extends TDbTableColumn
 {
-	private static $types = array();
+	private static $types=array();
 
 	/**
 	 * Overrides parent implementation, returns PHP type from the db type.
@@ -40,7 +40,7 @@ 
 	 */
 	public function getAutoIncrement()
 	{
-		return $this->getInfo('AutoIncrement',false);
+		return $this->getInfo('AutoIncrement', false);
 	}
 
 	/**

framework/Data/Common/Mysql/TMysqlTableColumn.php

Spacing +2 added lines, -2 removed lines

@@ -23,7 +23,7 @@ 
  */
 class TMysqlTableColumn extends TDbTableColumn
 {
-	private static $types = array(
+	private static $types=array(
 		'integer' => array('bit', 'tinyint', 'smallint', 'mediumint', 'int', 'integer', 'bigint'),
 		'boolean' => array('boolean', 'bool'),
 		'float' => array('float', 'double', 'double precision', 'decimal', 'dec', 'numeric', 'fixed')
@@ -35,7 +35,7 @@ 
 	 */
 	public function getPHPType()
 	{
-		$dbtype = trim(str_replace(array('unsigned', 'zerofill'),array('','',),strtolower($this->getDbType())));
+		$dbtype=trim(str_replace(array('unsigned', 'zerofill'), array('', '',), strtolower($this->getDbType())));
 		if($dbtype==='tinyint' && $this->getColumnSize()===1)
 			return 'boolean';
 		foreach(self::$types as $type => $dbtypes)

framework/Data/Common/Mysql/TMysqlMetaData.php

Spacing +74 added lines, -74 removed lines

@@ -74,24 +74,24 @@ 
 	 */
 	protected function createTableInfo($table)
 	{
-		list($schemaName,$tableName) = $this->getSchemaTableName($table);
-		$find = $schemaName===null ? "`{$tableName}`" : "`{$schemaName}`.`{$tableName}`";
-		$colCase = $this->getDbConnection()->getColumnCase();
-		if($colCase != TDbColumnCaseMode::Preserved)
+		list($schemaName, $tableName)=$this->getSchemaTableName($table);
+		$find=$schemaName===null ? "`{$tableName}`" : "`{$schemaName}`.`{$tableName}`";
+		$colCase=$this->getDbConnection()->getColumnCase();
+		if($colCase!=TDbColumnCaseMode::Preserved)
 			$this->getDbConnection()->setColumnCase('Preserved');
 		$this->getDbConnection()->setActive(true);
-		$sql = "SHOW FULL FIELDS FROM {$find}";
-		$command = $this->getDbConnection()->createCommand($sql);
-		$tableInfo = $this->createNewTableInfo($table);
+		$sql="SHOW FULL FIELDS FROM {$find}";
+		$command=$this->getDbConnection()->createCommand($sql);
+		$tableInfo=$this->createNewTableInfo($table);
 		$index=0;
 		foreach($command->query() as $col)
 		{
-			$col['index'] = $index++;
-			$this->processColumn($tableInfo,$col);
+			$col['index']=$index++;
+			$this->processColumn($tableInfo, $col);
 		}
 		if($index===0)
 			throw new TDbException('dbmetadata_invalid_table_view', $table);
-		if($colCase != TDbColumnCaseMode::Preserved)
+		if($colCase!=TDbColumnCaseMode::Preserved)
 			$this->getDbConnection()->setColumnCase($colCase);
 		return $tableInfo;
 	}
@@ -103,7 +103,7 @@ 
 	{
 		if(!$this->_serverVersion)
 		{
-			$version = $this->getDbConnection()->getAttribute(PDO::ATTR_SERVER_VERSION);
+			$version=$this->getDbConnection()->getAttribute(PDO::ATTR_SERVER_VERSION);
 			$digits=array();
 			preg_match('/(\d+)\.(\d+)\.(\d+)/', $version, $digits);
 			$this->_serverVersion=floatval($digits[1].'.'.$digits[2].$digits[3]);
@@ -117,50 +117,50 @@ 
 	 */
 	protected function processColumn($tableInfo, $col)
 	{
-		$columnId = $col['Field'];
+		$columnId=$col['Field'];
 
-		$info['ColumnName'] = "`$columnId`"; //quote the column names!
-		$info['ColumnId'] = $columnId;
-		$info['ColumnIndex'] = $col['index'];
+		$info['ColumnName']="`$columnId`"; //quote the column names!
+		$info['ColumnId']=$columnId;
+		$info['ColumnIndex']=$col['index'];
 		if($col['Null']==='YES')
-			$info['AllowNull'] = true;
+			$info['AllowNull']=true;
 		if(is_int(strpos(strtolower($col['Extra']), 'auto_increment')))
 			$info['AutoIncrement']=true;
 		if($col['Default']!=="")
-			$info['DefaultValue'] = $col['Default'];
+			$info['DefaultValue']=$col['Default'];
 
 		if($col['Key']==='PRI' || in_array($columnId, $tableInfo->getPrimaryKeys()))
-			$info['IsPrimaryKey'] = true;
+			$info['IsPrimaryKey']=true;
 		if($this->isForeignKeyColumn($columnId, $tableInfo))
-			$info['IsForeignKey'] = true;
+			$info['IsForeignKey']=true;
 
-		$info['DbType'] = $col['Type'];
+		$info['DbType']=$col['Type'];
 		$match=array();
 		//find SET/ENUM values, column size, precision, and scale
 		if(preg_match('/\((.*)\)/', $col['Type'], $match))
 		{
-			$info['DbType']= preg_replace('/\(.*\)/', '', $col['Type']);
+			$info['DbType']=preg_replace('/\(.*\)/', '', $col['Type']);
 
 			//find SET/ENUM values
 			if($this->isEnumSetType($info['DbType']))
-				$info['DbTypeValues'] = preg_split("/[',]/S", $match[1], -1, PREG_SPLIT_NO_EMPTY);
+				$info['DbTypeValues']=preg_split("/[',]/S", $match[1], -1, PREG_SPLIT_NO_EMPTY);
 
 			//find column size, precision and scale
-			$pscale = array();
+			$pscale=array();
 			if(preg_match('/(\d+)(?:,(\d+))?+/', $match[1], $pscale))
 			{
 				if($this->isPrecisionType($info['DbType']))
 				{
-					$info['NumericPrecision'] = intval($pscale[1]);
+					$info['NumericPrecision']=intval($pscale[1]);
 					if(count($pscale) > 2)
-						$info['NumericScale'] = intval($pscale[2]);
+						$info['NumericScale']=intval($pscale[2]);
 				}
 				else
-					$info['ColumnSize'] = intval($pscale[1]);
+					$info['ColumnSize']=intval($pscale[1]);
 			}
 		}
 
-		$tableInfo->Columns[$columnId] = new TMysqlTableColumn($info);
+		$tableInfo->Columns[$columnId]=new TMysqlTableColumn($info);
 	}
 
 	/**
@@ -168,7 +168,7 @@ 
 	 */
 	protected function isPrecisionType($type)
 	{
-		$type = strtolower(trim($type));
+		$type=strtolower(trim($type));
 		return $type==='decimal' || $type==='dec'
 				|| $type==='float' || $type==='double'
 				|| $type==='double precision' || $type==='real';
@@ -179,7 +179,7 @@ 
 	 */
 	protected function isEnumSetType($type)
 	{
-		$type = strtolower(trim($type));
+		$type=strtolower(trim($type));
 		return $type==='set' || $type==='enum';
 	}
 
@@ -191,12 +191,12 @@ 
 	protected function getSchemaTableName($table)
 	{
 		//remove the back ticks and separate out the "database.table"
-		$result = explode('.', str_replace('`', '', $table));
+		$result=explode('.', str_replace('`', '', $table));
 		foreach($result as $name)
 		{
 			if(!$this->isValidIdentifier($name))
 			{
-				$ref = 'http://dev.mysql.com/doc/refman/5.0/en/identifiers.html';
+				$ref='http://dev.mysql.com/doc/refman/5.0/en/identifiers.html';
 				throw new TDbException('dbcommon_invalid_identifier_name', $table, $ref);
 			}
 		}
@@ -220,14 +220,14 @@ 
 	 */
 	protected function createNewTableInfo($table)
 	{
-		list($schemaName,$tableName) = $this->getSchemaTableName($table);
-		$info['SchemaName'] = $schemaName;
-		$info['TableName'] = $tableName;
-		if($this->getIsView($schemaName,$tableName))
-			$info['IsView'] = true;
-		list($primary, $foreign) = $this->getConstraintKeys($schemaName, $tableName);
-		$class = $this->getTableInfoClass();
-		return new $class($info,$primary,$foreign);
+		list($schemaName, $tableName)=$this->getSchemaTableName($table);
+		$info['SchemaName']=$schemaName;
+		$info['TableName']=$tableName;
+		if($this->getIsView($schemaName, $tableName))
+			$info['IsView']=true;
+		list($primary, $foreign)=$this->getConstraintKeys($schemaName, $tableName);
+		$class=$this->getTableInfoClass();
+		return new $class($info, $primary, $foreign);
 	}
 
 	/**
@@ -240,25 +240,25 @@ 
 	 * @return boolean true if is view, false otherwise.
 	 * @throws TDbException if table or view does not exist.
 	 */
-	protected function getIsView($schemaName,$tableName)
+	protected function getIsView($schemaName, $tableName)
 	{
-		if($this->getServerVersion()<5.01)
+		if($this->getServerVersion() < 5.01)
 			return false;
 		if($schemaName!==null)
-			$sql = "SHOW FULL TABLES FROM `{$schemaName}` LIKE :table";
+			$sql="SHOW FULL TABLES FROM `{$schemaName}` LIKE :table";
 		else
-			$sql = "SHOW FULL TABLES LIKE :table";
+			$sql="SHOW FULL TABLES LIKE :table";
 
-		$command = $this->getDbConnection()->createCommand($sql);
+		$command=$this->getDbConnection()->createCommand($sql);
 		$command->bindValue(':table', $tableName);
 		try
 		{
-			return count($result = $command->queryRow()) > 0 && $result['Table_type']==='VIEW';
+			return count($result=$command->queryRow()) > 0 && $result['Table_type']==='VIEW';
 		}
 		catch(TDbException $e)
 		{
-			$table = $schemaName===null?$tableName:$schemaName.'.'.$tableName;
-			throw new TDbException('dbcommon_invalid_table_name',$table,$e->getMessage());
+			$table=$schemaName===null ? $tableName : $schemaName.'.'.$tableName;
+			throw new TDbException('dbcommon_invalid_table_name', $table, $e->getMessage());
 		}
 	}
 
@@ -270,22 +270,22 @@ 
 	 */
 	protected function getConstraintKeys($schemaName, $tableName)
 	{
-		$table = $schemaName===null ? "`{$tableName}`" : "`{$schemaName}`.`{$tableName}`";
-		$sql = "SHOW INDEX FROM {$table}";
-		$command = $this->getDbConnection()->createCommand($sql);
-		$primary = array();
+		$table=$schemaName===null ? "`{$tableName}`" : "`{$schemaName}`.`{$tableName}`";
+		$sql="SHOW INDEX FROM {$table}";
+		$command=$this->getDbConnection()->createCommand($sql);
+		$primary=array();
 		foreach($command->query() as $row)
 		{
 			if($row['Key_name']==='PRIMARY')
-				$primary[] = $row['Column_name'];
+				$primary[]=$row['Column_name'];
 		}
 				// MySQL version was increased to >=5.1.21 instead of 5.x
 				// due to a MySQL bug (http://bugs.mysql.com/bug.php?id=19588)
 		if($this->getServerVersion() >= 5.121)
-			$foreign = $this->getForeignConstraints($schemaName,$tableName);
+			$foreign=$this->getForeignConstraints($schemaName, $tableName);
 		else
-			$foreign = $this->findForeignConstraints($schemaName,$tableName);
-		return array($primary,$foreign);
+			$foreign=$this->findForeignConstraints($schemaName, $tableName);
+		return array($primary, $foreign);
 	}
 
 	/**
@@ -296,8 +296,8 @@ 
 	 */
 	protected function getForeignConstraints($schemaName, $tableName)
 	{
-		$andSchema = $schemaName !== null ? 'AND TABLE_SCHEMA LIKE :schema' : 'AND TABLE_SCHEMA LIKE DATABASE()';
-		$sql = <<<EOD
+		$andSchema=$schemaName!==null ? 'AND TABLE_SCHEMA LIKE :schema' : 'AND TABLE_SCHEMA LIKE DATABASE()';
+		$sql=<<<EOD
 			SELECT
 				CONSTRAINT_NAME as con,
 				COLUMN_NAME as col,
@@ -311,15 +311,15 @@ 
 				AND TABLE_NAME LIKE :table
 				$andSchema
 EOD;
-		$command = $this->getDbConnection()->createCommand($sql);
+		$command=$this->getDbConnection()->createCommand($sql);
 		$command->bindValue(':table', $tableName);
 		if($schemaName!==null)
 			$command->bindValue(':schema', $schemaName);
 		$fkeys=array();
 		foreach($command->query() as $col)
 		{
-			$fkeys[$col['con']]['keys'][$col['col']] = $col['fkcol'];
-			$fkeys[$col['con']]['table'] = $col['fktable'];
+			$fkeys[$col['con']]['keys'][$col['col']]=$col['fkcol'];
+			$fkeys[$col['con']]['table']=$col['fktable'];
 		}
 		return count($fkeys) > 0 ? array_values($fkeys) : $fkeys;
 	}
@@ -332,17 +332,17 @@ 
 	 */
 	protected function getShowCreateTable($schemaName, $tableName)
 	{
-		if(version_compare(PHP_VERSION,'5.1.3','<'))
+		if(version_compare(PHP_VERSION, '5.1.3', '<'))
 			throw new TDbException('dbmetadata_requires_php_version', 'Mysql 4.1.x', '5.1.3');
 
 		//See http://netevil.org/node.php?nid=795&SC=1
 		$this->getDbConnection()->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
 		if($schemaName!==null)
-			$sql = "SHOW CREATE TABLE `{$schemaName}`.`{$tableName}`";
+			$sql="SHOW CREATE TABLE `{$schemaName}`.`{$tableName}`";
 		else
-			$sql = "SHOW CREATE TABLE `{$tableName}`";
-		$command = $this->getDbConnection()->createCommand($sql);
-		$result = $command->queryRow();
+			$sql="SHOW CREATE TABLE `{$tableName}`";
+		$command=$this->getDbConnection()->createCommand($sql);
+		$result=$command->queryRow();
 		return isset($result['Create Table']) ? $result['Create Table'] : (isset($result['Create View']) ? $result['Create View'] : '');
 	}
 
@@ -354,19 +354,19 @@ 
 	 */
 	protected function findForeignConstraints($schemaName, $tableName)
 	{
-		$sql = $this->getShowCreateTable($schemaName, $tableName);
-		$matches =array();
-		$regexp = '/FOREIGN KEY\s+\(([^\)]+)\)\s+REFERENCES\s+`?([^`]+)`?\s\(([^\)]+)\)/mi';
-		preg_match_all($regexp,$sql,$matches,PREG_SET_ORDER);
-		$foreign = array();
+		$sql=$this->getShowCreateTable($schemaName, $tableName);
+		$matches=array();
+		$regexp='/FOREIGN KEY\s+\(([^\)]+)\)\s+REFERENCES\s+`?([^`]+)`?\s\(([^\)]+)\)/mi';
+		preg_match_all($regexp, $sql, $matches, PREG_SET_ORDER);
+		$foreign=array();
 		foreach($matches as $match)
 		{
-			$fields = array_map('trim',explode(',',str_replace('`','',$match[1])));
-			$fk_fields = array_map('trim',explode(',',str_replace('`','',$match[3])));
+			$fields=array_map('trim', explode(',', str_replace('`', '', $match[1])));
+			$fk_fields=array_map('trim', explode(',', str_replace('`', '', $match[3])));
 			$keys=array();
 			foreach($fields as $k=>$v)
-				$keys[$v] = $fk_fields[$k];
-			$foreign[] = array('keys' => $keys, 'table' => trim($match[2]));
+				$keys[$v]=$fk_fields[$k];
+			$foreign[]=array('keys' => $keys, 'table' => trim($match[2]));
 		}
 		return $foreign;
 	}

framework/Data/Common/Sqlite/TSqliteMetaData.php

Spacing +36 added lines, -36 removed lines

@@ -69,30 +69,30 @@ 
 	 */
 	protected function createTableInfo($tableName)
 	{
-		$tableName = str_replace("'",'',$tableName);
+		$tableName=str_replace("'", '', $tableName);
 		$this->getDbConnection()->setActive(true);
-		$table = $this->getDbConnection()->quoteString($tableName);
-		$sql = "PRAGMA table_info({$table})";
-		$command = $this->getDbConnection()->createCommand($sql);
-		$foreign = $this->getForeignKeys($table);
+		$table=$this->getDbConnection()->quoteString($tableName);
+		$sql="PRAGMA table_info({$table})";
+		$command=$this->getDbConnection()->createCommand($sql);
+		$foreign=$this->getForeignKeys($table);
 		$index=0;
 		$columns=array();
 		$primary=array();
 		foreach($command->query() as $col)
 		{
-			$col['index'] = $index++;
-			$column = $this->processColumn($col, $foreign);
-			$columns[$col['name']] = $column;
+			$col['index']=$index++;
+			$column=$this->processColumn($col, $foreign);
+			$columns[$col['name']]=$column;
 			if($column->getIsPrimaryKey())
-				$primary[] = $col['name'];
+				$primary[]=$col['name'];
 		}
-		$info['TableName'] = $tableName;
+		$info['TableName']=$tableName;
 		if($this->getIsView($tableName))
-			$info['IsView'] = true;
+			$info['IsView']=true;
 		if(count($columns)===0)
 			throw new TDbException('dbmetadata_invalid_table_view', $tableName);
-		$class = $this->getTableInfoClass();
-		$tableInfo = new $class($info,$primary,$foreign);
+		$class=$this->getTableInfoClass();
+		$tableInfo=new $class($info, $primary, $foreign);
 		$tableInfo->getColumns()->copyFrom($columns);
 		return $tableInfo;
 	}
@@ -103,11 +103,11 @@ 
 	 */
 	protected function getIsView($tableName)
 	{
-		$sql = 'SELECT count(*) FROM sqlite_master WHERE type="view" AND name= :table';
+		$sql='SELECT count(*) FROM sqlite_master WHERE type="view" AND name= :table';
 		$this->getDbConnection()->setActive(true);
-		$command = $this->getDbConnection()->createCommand($sql);
+		$command=$this->getDbConnection()->createCommand($sql);
 		$command->bindValue(':table', $tableName);
-		return intval($command->queryScalar()) === 1;
+		return intval($command->queryScalar())===1;
 	}
 
 	/**
@@ -117,39 +117,39 @@ 
 	 */
 	protected function processColumn($col, $foreign)
 	{
-		$columnId = $col['name']; //use column name as column Id
+		$columnId=$col['name']; //use column name as column Id
 
-		$info['ColumnName'] = '"'.$columnId.'"'; //quote the column names!
-		$info['ColumnId'] = $columnId;
-		$info['ColumnIndex'] = $col['index'];
+		$info['ColumnName']='"'.$columnId.'"'; //quote the column names!
+		$info['ColumnId']=$columnId;
+		$info['ColumnIndex']=$col['index'];
 
 		if($col['notnull']!=='99')
-			$info['AllowNull'] = true;
+			$info['AllowNull']=true;
 
 		if($col['pk']==='1')
-			$info['IsPrimaryKey'] = true;
+			$info['IsPrimaryKey']=true;
 		if($this->isForeignKeyColumn($columnId, $foreign))
-			$info['IsForeignKey'] = true;
+			$info['IsForeignKey']=true;
 
 		if($col['dflt_value']!==null)
-			$info['DefaultValue'] = $col['dflt_value'];
+			$info['DefaultValue']=$col['dflt_value'];
 
-		$type = strtolower($col['type']);
-		$info['AutoIncrement'] = $type==='integer' && $col['pk']==='1';
+		$type=strtolower($col['type']);
+		$info['AutoIncrement']=$type==='integer' && $col['pk']==='1';
 
-		$info['DbType'] = $type;
+		$info['DbType']=$type;
 		$match=array();
 		if(is_int($pos=strpos($type, '(')) && preg_match('/\((.*)\)/', $type, $match))
 		{
-			$ps = explode(',', $match[1]);
+			$ps=explode(',', $match[1]);
 			if(count($ps)===2)
 			{
-				$info['NumericPrecision'] = intval($ps[0]);
-				$info['NumericScale'] = intval($ps[1]);
+				$info['NumericPrecision']=intval($ps[0]);
+				$info['NumericScale']=intval($ps[1]);
 			}
 			else
 				$info['ColumnSize']=intval($match[1]);
-			$info['DbType'] = substr($type,0,$pos);
+			$info['DbType']=substr($type, 0, $pos);
 		}
 
 		return new TSqliteTableColumn($info);
@@ -163,13 +163,13 @@ 
 	 */
 	protected function getForeignKeys($table)
 	{
-		$sql = "PRAGMA foreign_key_list({$table})";
-		$command = $this->getDbConnection()->createCommand($sql);
-		$fkeys = array();
+		$sql="PRAGMA foreign_key_list({$table})";
+		$command=$this->getDbConnection()->createCommand($sql);
+		$fkeys=array();
 		foreach($command->query() as $col)
 		{
-			$fkeys[$col['table']]['keys'][$col['from']] = $col['to'];
-			$fkeys[$col['table']]['table'] = $col['table'];
+			$fkeys[$col['table']]['keys'][$col['from']]=$col['to'];
+			$fkeys[$col['table']]['table']=$col['table'];
 		}
 		return count($fkeys) > 0 ? array_values($fkeys) : $fkeys;
 	}

framework/Data/Common/Sqlite/TSqliteCommandBuilder.php

Spacing +4 added lines, -4 removed lines

@@ -30,12 +30,12 @@
 	 */
 	public function applyLimitOffset($sql, $limit=-1, $offset=-1)
 	{
-		$limit = $limit!==null ? intval($limit) : -1;
-		$offset = $offset!==null ? intval($offset) : -1;
+		$limit=$limit!==null ? intval($limit) : -1;
+		$offset=$offset!==null ? intval($offset) : -1;
 		if($limit > 0 || $offset > 0)
 		{
-			$limitStr = ' LIMIT '.$limit;
-			$offsetStr = $offset >= 0 ? ' OFFSET '.$offset : '';
+			$limitStr=' LIMIT '.$limit;
+			$offsetStr=$offset >= 0 ? ' OFFSET '.$offset : '';
 			return $sql.$limitStr.$offsetStr;
 		}
 		else

framework/Data/Common/Sqlite/TSqliteTableColumn.php

Spacing +2 added lines, -2 removed lines

@@ -26,7 +26,7 @@ 
 	/**
 	 * @TODO add sqlite types.
 	 */
-	private static $types = array();
+	private static $types=array();
 
 	/**
 	 * Overrides parent implementation, returns PHP type from the db type.
@@ -34,7 +34,7 @@ 
 	 */
 	public function getPHPType()
 	{
-		$dbtype = strtolower($this->getDbType());
+		$dbtype=strtolower($this->getDbType());
 		foreach(self::$types as $type => $dbtypes)
 		{
 			if(in_array($dbtype, $dbtypes))

framework/Data/TDataSourceConfig.php

Spacing +6 added lines, -6 removed lines

@@ -62,7 +62,7 @@ 
 			{
 				$db=$this->getDbConnection();
 				foreach($xml['database'] as $name=>$value)
-					$db->setSubProperty($name,$value);
+					$db->setSubProperty($name, $value);
 			}
 		}
 		else
@@ -71,7 +71,7 @@ 
 			{
 				$db=$this->getDbConnection();
 				foreach($prop->getAttributes() as $name=>$value)
-					$db->setSubproperty($name,$value);
+					$db->setSubproperty($name, $value);
 			}
 		}
 	}
@@ -106,9 +106,9 @@ 
 		if($this->_conn===null)
 		{
 			if($this->_connID!=='')
-				$this->_conn = $this->findConnectionByID($this->getConnectionID());
+				$this->_conn=$this->findConnectionByID($this->getConnectionID());
 			else
-				$this->_conn = Prado::createComponent($this->getConnectionClass());
+				$this->_conn=Prado::createComponent($this->getConnectionClass());
 		}
 		return $this->_conn;
 	}
@@ -154,12 +154,12 @@ 
 	 */
 	protected function findConnectionByID($id)
 	{
-		$conn = $this->getApplication()->getModule($id);
+		$conn=$this->getApplication()->getModule($id);
 		if($conn instanceof TDbConnection)
 			return $conn;
 		else if($conn instanceof TDataSourceConfig)
 			return $conn->getDbConnection();
 		else
-			throw new TConfigurationException('datasource_dbconnection_invalid',$id);
+			throw new TConfigurationException('datasource_dbconnection_invalid', $id);
 	}
 }