pradosoft / prado

framework/Data/ActiveRecord/Relations/TActiveRecordHasOne.php

Spacing +11 added lines, -11 removed lines

@@ -94,12 +94,12 @@ 
 	 */
 	protected function collectForeignObjects(&$results)
 	{
-		$fkeys = $this->getRelationForeignKeys();
-		$properties = array_values($fkeys);
-		$fields = array_keys($fkeys);
+		$fkeys=$this->getRelationForeignKeys();
+		$properties=array_values($fkeys);
+		$fields=array_keys($fkeys);
 
-		$indexValues = $this->getIndexValues($properties, $results);
-		$fkObjects = $this->findForeignObjects($fields, $indexValues);
+		$indexValues=$this->getIndexValues($properties, $results);
+		$fkObjects=$this->findForeignObjects($fields, $indexValues);
 		$this->populateResult($results, $properties, $fkObjects, $fields);
 	}
 
@@ -109,7 +109,7 @@ 
 	 */
 	public function getRelationForeignKeys()
 	{
-		$fkObject = $this->getContext()->getForeignRecordFinder();
+		$fkObject=$this->getContext()->getForeignRecordFinder();
 		return $this->findForeignKeys($fkObject, $this->getSourceRecord());
 	}
 
@@ -120,8 +120,8 @@ 
 	 */
 	protected function setObjectProperty($source, $properties, &$collections)
 	{
-		$hash = $this->getObjectHash($source, $properties);
-		$prop = $this->getContext()->getProperty();
+		$hash=$this->getObjectHash($source, $properties);
+		$prop=$this->getContext()->getProperty();
 		if(isset($collections[$hash]) && count($collections[$hash]) > 0)
 		{
 			if(count($collections[$hash]) > 1)
@@ -136,9 +136,9 @@ 
 	 */
 	public function updateAssociatedRecords()
 	{
-		$fkObject = $this->getContext()->getPropertyValue();
-		$source = $this->getSourceRecord();
-		$fkeys = $this->findForeignKeys($fkObject, $source);
+		$fkObject=$this->getContext()->getPropertyValue();
+		$source=$this->getSourceRecord();
+		$fkeys=$this->findForeignKeys($fkObject, $source);
 		foreach($fkeys as $fKey => $srcKey)
 			$fkObject->setColumnValue($fKey, $source->getColumnValue($srcKey));
 		return $fkObject->save();

framework/Data/ActiveRecord/Scaffold/InputBuilder/TSqliteScaffoldInput.php

Spacing +10 added lines, -10 removed lines

@@ -61,8 +61,8 @@ 
 
 	protected function createDateControl($container, $column, $record)
 	{
-		$control = parent::createDateControl($container, $column, $record);
-		$value = $this->getRecordPropertyValue($column, $record);
+		$control=parent::createDateControl($container, $column, $record);
+		$value=$this->getRecordPropertyValue($column, $record);
 		if(!empty($value) && preg_match('/timestamp/i', $column->getDbType()))
 			$control->setTimestamp(intval($value));
 		return $control;
@@ -70,11 +70,11 @@ 
 
 	protected function createDateTimeControl($container, $column, $record)
 	{
-		$value = $this->getRecordPropertyValue($column, $record);
-		$time = parent::createDateTimeControl($container, $column, $record);
+		$value=$this->getRecordPropertyValue($column, $record);
+		$time=parent::createDateTimeControl($container, $column, $record);
 		if(!empty($value) && preg_match('/timestamp/i', $column->getDbType()))
 		{
-			$dt = new \DateTime;
+			$dt=new \DateTime;
 			$dt->setTimestamp(intval($value));
 			$time[1]->setSelectedValue($dt->format('G'));
 			$time[2]->setSelectedValue($dt->format('i'));
@@ -87,12 +87,12 @@ 
 	{
 		if(preg_match('/timestamp/i', $column->getDbType()))
 		{
-			$time = $container->findControl(self::DEFAULT_ID)->getTimestamp();
-			$dt = new \DateTime;
+			$time=$container->findControl(self::DEFAULT_ID)->getTimestamp();
+			$dt=new \DateTime;
 			$dt->setTimestamp($time);
-			$hour = $container->findControl('scaffold_time_hour')->getSelectedValue();
-			$mins = $container->findControl('scaffold_time_min')->getSelectedValue();
-			$secs = $container->findControl('scaffold_time_sec')->getSelectedValue();
+			$hour=$container->findControl('scaffold_time_hour')->getSelectedValue();
+			$mins=$container->findControl('scaffold_time_min')->getSelectedValue();
+			$secs=$container->findControl('scaffold_time_sec')->getSelectedValue();
 			return $s->getTimeStamp(
 				$hour,
 				$mins,

framework/Data/SqlMap/Configuration/TSqlMapCacheKey.php

Spacing +1 added lines, -1 removed lines

@@ -29,7 +29,7 @@
 	 */
 	public function __construct($object)
 	{
-		$this->_key = $this->generateKey(serialize($object));
+		$this->_key=$this->generateKey(serialize($object));
 	}
 
 	/**

framework/Data/SqlMap/DataMapper/TPropertyAccess.php

Spacing +20 added lines, -20 removed lines

@@ -56,25 +56,25 @@ 
 	{
 		if(!is_array($object) && !is_object($object))
 			return $object;
-		$properties = explode('.', $path);
+		$properties=explode('.', $path);
 		foreach($properties as $prop)
 		{
 			if(is_array($object) || $object instanceof \ArrayAccess)
 			{
 				if(array_key_exists($prop, $object))
-					$object = $object[$prop];
+					$object=$object[$prop];
 				else
 					throw new TInvalidPropertyException('sqlmap_invalid_property', $path);
 			}
 			elseif(is_object($object))
 			{
-				$getter = 'get' . $prop;
+				$getter='get'.$prop;
 				if(method_exists($object, $getter) && is_callable([$object, $getter]))
-					$object = $object->{$getter}();
+					$object=$object->{$getter}();
 				elseif(in_array($prop, array_keys(get_object_vars($object))))
-					$object = $object->{$prop};
+					$object=$object->{$prop};
 				elseif(method_exists($object, '__get') && is_callable([$object, '__get']))
-					$object = $object->{$prop};
+					$object=$object->{$prop};
 				else
 					throw new TInvalidPropertyException('sqlmap_invalid_property', $path);
 			}
@@ -93,25 +93,25 @@ 
 	{
 		if(!is_array($object) && !is_object($object))
 			return false;
-		$properties = explode('.', $path);
+		$properties=explode('.', $path);
 		foreach($properties as $prop)
 		{
 			if(is_array($object) || $object instanceof \ArrayAccess)
 			{
 				if(array_key_exists($prop, $object))
-					$object = $object[$prop];
+					$object=$object[$prop];
 				else
 					return false;
 			}
 			elseif(is_object($object))
 			{
-				$getter = 'get' . $prop;
+				$getter='get'.$prop;
 				if(method_exists($object, $getter) && is_callable([$object, $getter]))
-					$object = $object->{$getter}();
+					$object=$object->{$getter}();
 				elseif(in_array($prop, array_keys(get_object_vars($object))))
-					$object = $object->{$prop};
+					$object=$object->{$prop};
 				elseif(method_exists($object, '__get') && is_callable([$object, '__get']))
-					$object = $object->{$prop};
+					$object=$object->{$prop};
 				else
 					return false;
 			}
@@ -130,24 +130,24 @@ 
 	 */
 	public static function set(&$originalObject, $path, $value)
 	{
-		$properties = explode('.', $path);
-		$prop = array_pop($properties);
+		$properties=explode('.', $path);
+		$prop=array_pop($properties);
 		if(count($properties) > 0)
-			$object = self::get($originalObject, implode('.', $properties));
+			$object=self::get($originalObject, implode('.', $properties));
 		else
-			$object = &$originalObject;
+			$object=&$originalObject;
 
 		if(is_array($object) || $object instanceof \ArrayAccess)
 		{
-			$object[$prop] = $value;
+			$object[$prop]=$value;
 		}
 		elseif(is_object($object))
 		{
-			$setter = 'set' . $prop;
-			if (method_exists($object, $setter) && is_callable([$object, $setter]))
+			$setter='set'.$prop;
+			if(method_exists($object, $setter) && is_callable([$object, $setter]))
 				$object->{$setter}($value);
 			else
-				$object->{$prop} = $value;
+				$object->{$prop}=$value;
 		}
 		else
 			throw new TInvalidPropertyException('sqlmap_invalid_property_type', $path);

framework/Data/SqlMap/DataMapper/TObjectProxy.php

Spacing +2 added lines, -2 removed lines

@@ -30,8 +30,8 @@
 	 */
 	public function __construct($handler, $object)
 	{
-		$this->_handler = $handler;
-		$this->_object = $object;
+		$this->_handler=$handler;
+		$this->_object=$object;
 	}
 
 	/**

framework/Web/UI/ActiveControls/TActiveButton.php

Spacing +1 added lines, -1 removed lines

@@ -66,7 +66,7 @@
 	 */
 	public function setText($value)
 	{
-		if(parent::getText() === $value)
+		if(parent::getText()===$value)
 			return;
 
 		parent::setText($value);

framework/TComponentReflection.php

Spacing +30 added lines, -30 removed lines

@@ -36,9 +36,9 @@ 
 class TComponentReflection extends \Prado\TComponent
 {
 	private $_className;
-	private $_properties = [];
-	private $_events = [];
-	private $_methods = [];
+	private $_properties=[];
+	private $_events=[];
+	private $_methods=[];
 
 	/**
 	 * Constructor.
@@ -48,9 +48,9 @@ 
 	public function __construct($component)
 	{
 		if(is_string($component) && class_exists($component, false))
-			$this->_className = $component;
+			$this->_className=$component;
 		elseif(is_object($component))
-			$this->_className = get_class($component);
+			$this->_className=get_class($component);
 		else
 			throw new TInvalidDataTypeException('componentreflection_class_invalid');
 		$this->reflect();
@@ -58,74 +58,74 @@ 
 
 	private function isPropertyMethod($method)
 	{
-		$methodName = $method->getName();
-		return $method->getNumberOfRequiredParameters() === 0
-				&& strncasecmp($methodName, 'get', 3) === 0
+		$methodName=$method->getName();
+		return $method->getNumberOfRequiredParameters()===0
+				&& strncasecmp($methodName, 'get', 3)===0
 				&& isset($methodName[3]);
 	}
 
 	private function isEventMethod($method)
 	{
-		$methodName = $method->getName();
-		return strncasecmp($methodName, 'on', 2) === 0
+		$methodName=$method->getName();
+		return strncasecmp($methodName, 'on', 2)===0
 				&& isset($methodName[2]);
 	}
 
 	private function reflect()
 	{
-		$class = new \ReflectionClass($this->_className);
-		$properties = [];
-		$events = [];
-		$methods = [];
-		$isComponent = is_subclass_of($this->_className, 'TComponent') || strcasecmp($this->_className, 'TComponent') === 0;
+		$class=new \ReflectionClass($this->_className);
+		$properties=[];
+		$events=[];
+		$methods=[];
+		$isComponent=is_subclass_of($this->_className, 'TComponent') || strcasecmp($this->_className, 'TComponent')===0;
 		foreach($class->getMethods() as $method)
 		{
 			if($method->isPublic() || $method->isProtected())
 			{
-				$methodName = $method->getName();
+				$methodName=$method->getName();
 				if(!$method->isStatic() && $isComponent)
 				{
 					if($this->isPropertyMethod($method))
-						$properties[substr($methodName, 3)] = $method;
+						$properties[substr($methodName, 3)]=$method;
 					elseif($this->isEventMethod($method))
 					{
-						$methodName[0] = 'O';
-						$events[$methodName] = $method;
+						$methodName[0]='O';
+						$events[$methodName]=$method;
 					}
 				}
-				if(strncmp($methodName, '__', 2) !== 0)
-					$methods[$methodName] = $method;
+				if(strncmp($methodName, '__', 2)!==0)
+					$methods[$methodName]=$method;
 			}
 		}
-		$reserved = [];
+		$reserved=[];
 		ksort($properties);
 		foreach($properties as $name => $method)
 		{
-			$this->_properties[$name] = [
+			$this->_properties[$name]=[
 				'type' => $this->determinePropertyType($method),
-				'readonly' => !$class->hasMethod('set' . $name),
+				'readonly' => !$class->hasMethod('set'.$name),
 				'protected' => $method->isProtected(),
 				'class' => $method->getDeclaringClass()->getName(),
 				'comments' => $method->getDocComment()
 			];
-			$reserved['get' . strtolower($name)] = 1;
-			$reserved['set' . strtolower($name)] = 1;
+			$reserved['get'.strtolower($name)]=1;
+			$reserved['set'.strtolower($name)]=1;
 		}
 		ksort($events);
 		foreach($events as $name => $method)
 		{
-			$this->_events[$name] = [
+			$this->_events[$name]=[
 				'class' => $method->getDeclaringClass()->getName(),
 				'protected' => $method->isProtected(),
 				'comments' => $method->getDocComment()
 			];
-			$reserved[strtolower($name)] = 1;
+			$reserved[strtolower($name)]=1;
 		}
 		ksort($methods);
 		foreach($methods as $name => $method)
 		{
 			if(!isset($reserved[strtolower($name)]))
-				$this->_methods[$name] = [
+				$this->_methods[$name]=[
 					'class' => $method->getDeclaringClass()->getName(),
 					'protected' => $method->isProtected(),
 					'static' => $method->isStatic(),
@@ -142,7 +142,7 @@ 
 	 */
 	protected function determinePropertyType($method)
 	{
-		$comment = $method->getDocComment();
+		$comment=$method->getDocComment();
 		if(preg_match('/@return\\s+(.*?)\\s+/', $comment, $matches))
 			return $matches[1];
 		else

framework/Caching/TFileCacheDependency.php

Spacing +3 added lines, -3 removed lines

@@ -50,8 +50,8 @@ 
 	 */
 	public function setFileName($value)
 	{
-		$this->_fileName = $value;
-		$this->_timestamp = @filemtime($value);
+		$this->_fileName=$value;
+		$this->_timestamp=@filemtime($value);
 	}
 
 	/**
@@ -69,6 +69,6 @@ 
 	 */
 	public function getHasChanged()
 	{
-		return @filemtime($this->_fileName) !== $this->_timestamp;
+		return @filemtime($this->_fileName)!==$this->_timestamp;
 	}
 }
\ No newline at end of file

framework/Caching/TDbCache.php

Spacing +61 added lines, -61 removed lines

@@ -95,7 +95,7 @@ 
 	/**
 	 * @var string the ID of TDataSourceConfig module
 	 */
-	private $_connID = '';
+	private $_connID='';
 	/**
 	 * @var TDbConnection the DB connection instance
 	 */
@@ -103,26 +103,26 @@ 
 	/**
 	 * @var string name of the DB cache table
 	 */
-	private $_cacheTable = 'pradocache';
+	private $_cacheTable='pradocache';
 	/**
 	 * @var integer Interval expired items will be removed from cache
 	 */
-	private $_flushInterval = 60;
+	private $_flushInterval=60;
 	/**
 	 * @var boolean
 	 */
-	private $_cacheInitialized = false;
+	private $_cacheInitialized=false;
 	/**
 	 * @var boolean
 	 */
-	private $_createCheck = false;
+	private $_createCheck=false;
 	/**
 	 * @var boolean whether the cache DB table should be created automatically
 	 */
-	private $_autoCreate = true;
-	private $_username = '';
-	private $_password = '';
-	private $_connectionString = '';
+	private $_autoCreate=true;
+	private $_username='';
+	private $_password='';
+	private $_connectionString='';
 
 	/**
 	 * Destructor.
@@ -130,7 +130,7 @@ 
 	 */
 	public function __destruct()
 	{
-		if($this->_db !== null)
+		if($this->_db!==null)
 			$this->_db->setActive(false);
 	}
 
@@ -183,26 +183,26 @@ 
 	 * @throws TConfigurationException if any error happens during creating database or cache table.
 	 * @since 3.1.5
 	 */
-	protected function initializeCache($force = false)
+	protected function initializeCache($force=false)
 	{
 		if($this->_cacheInitialized && !$force) return;
-		$db = $this->getDbConnection();
+		$db=$this->getDbConnection();
 		try
 		{
-			$key = 'TDbCache:' . $this->_cacheTable . ':created';
+			$key='TDbCache:'.$this->_cacheTable.':created';
 			if($force)
-				$this -> _createCheck = false;
+				$this -> _createCheck=false;
 			else
-				$this -> _createCheck = $this -> getApplication() -> getGlobalState($key, 0);
+				$this -> _createCheck=$this -> getApplication() -> getGlobalState($key, 0);
 
 			if($this->_autoCreate && !$this -> _createCheck) {
 
-				Prado::trace(($force ? 'Force initializing: ' : 'Initializing: ') . $this -> id . ', ' . $this->_cacheTable, '\Prado\Caching\TDbCache');
+				Prado::trace(($force ? 'Force initializing: ' : 'Initializing: ').$this -> id.', '.$this->_cacheTable, '\Prado\Caching\TDbCache');
 
-				$sql = 'SELECT 1 FROM ' . $this->_cacheTable . ' WHERE 0=1';
+				$sql='SELECT 1 FROM '.$this->_cacheTable.' WHERE 0=1';
 				$db->createCommand($sql)->queryScalar();
 
-				$this -> _createCheck = true;
+				$this -> _createCheck=true;
 				$this -> getApplication() -> setGlobalState($key, time());
 			}
 		}
@@ -211,29 +211,29 @@ 
 			// DB table not exists
 			if($this->_autoCreate)
 			{
-				Prado::trace('Autocreate: ' . $this->_cacheTable, '\Prado\Caching\TDbCache');
+				Prado::trace('Autocreate: '.$this->_cacheTable, '\Prado\Caching\TDbCache');
 
-				$driver = $db->getDriverName();
-				if($driver === 'mysql')
-					$blob = 'LONGBLOB';
-				elseif($driver === 'pgsql')
-					$blob = 'BYTEA';
+				$driver=$db->getDriverName();
+				if($driver==='mysql')
+					$blob='LONGBLOB';
+				elseif($driver==='pgsql')
+					$blob='BYTEA';
 				else
-					$blob = 'BLOB';
+					$blob='BLOB';
 
-				$sql = 'CREATE TABLE ' . $this->_cacheTable . " (itemkey CHAR(128) PRIMARY KEY, value $blob, expire INTEGER)";
+				$sql='CREATE TABLE '.$this->_cacheTable." (itemkey CHAR(128) PRIMARY KEY, value $blob, expire INTEGER)";
 				$db->createCommand($sql)->execute();
 
-				$sql = 'CREATE INDEX IX_expire ON ' . $this->_cacheTable . ' (expire)';
+				$sql='CREATE INDEX IX_expire ON '.$this->_cacheTable.' (expire)';
 				$db->createCommand($sql)->execute();
 
-				$this -> _createCheck = true;
+				$this -> _createCheck=true;
 				$this -> getApplication() -> setGlobalState($key, time());
 			}
 			else
 				throw new TConfigurationException('db_cachetable_inexistent', $this->_cacheTable);
 		}
-		$this->_cacheInitialized = true;
+		$this->_cacheInitialized=true;
 	}
 
 	/**
@@ -242,20 +242,20 @@ 
 	 * @return void
 	 * @since 3.1.5
 	 */
-	public function flushCacheExpired($force = false)
+	public function flushCacheExpired($force=false)
 	{
-		$interval = $this -> getFlushInterval();
-		if(!$force && $interval === 0) return;
+		$interval=$this -> getFlushInterval();
+		if(!$force && $interval===0) return;
 
-		$key = 'TDbCache:' . $this->_cacheTable . ':flushed';
-		$now = time();
-		$next = $interval + (integer)$this -> getApplication() -> getGlobalState($key, 0);
+		$key='TDbCache:'.$this->_cacheTable.':flushed';
+		$now=time();
+		$next=$interval + (integer) $this -> getApplication() -> getGlobalState($key, 0);
 
 		if($force || $next <= $now)
 		{
 			if(!$this->_cacheInitialized) $this->initializeCache();
-			Prado::trace(($force ? 'Force flush of expired items: ' : 'Flush expired items: ') . $this -> id . ', ' . $this->_cacheTable, '\Prado\Caching\TDbCache');
-			$sql = 'DELETE FROM ' . $this->_cacheTable . ' WHERE expire<>0 AND expire<' . $now;
+			Prado::trace(($force ? 'Force flush of expired items: ' : 'Flush expired items: ').$this -> id.', '.$this->_cacheTable, '\Prado\Caching\TDbCache');
+			$sql='DELETE FROM '.$this->_cacheTable.' WHERE expire<>0 AND expire<'.$now;
 			$this->getDbConnection()->createCommand($sql)->execute();
 			$this -> getApplication() -> setGlobalState($key, $now);
 		}
@@ -281,7 +281,7 @@ 
 	 */
 	public function setFlushInterval($value)
 	{
-		$this->_flushInterval = (integer) $value;
+		$this->_flushInterval=(integer) $value;
 	}
 
 	/**
@@ -292,9 +292,9 @@ 
 	 */
 	protected function createDbConnection()
 	{
-		if($this->_connID !== '')
+		if($this->_connID!=='')
 		{
-			$config = $this->getApplication()->getModule($this->_connID);
+			$config=$this->getApplication()->getModule($this->_connID);
 			if($config instanceof TDataSourceConfig)
 				return $config->getDbConnection();
 			else
@@ -302,20 +302,20 @@ 
 		}
 		else
 		{
-			$db = new TDbConnection;
-			if($this->_connectionString !== '')
+			$db=new TDbConnection;
+			if($this->_connectionString!=='')
 			{
 				$db->setConnectionString($this->_connectionString);
-				if($this->_username !== '')
+				if($this->_username!=='')
 					$db->setUsername($this->_username);
-				if($this->_password !== '')
+				if($this->_password!=='')
 					$db->setPassword($this->_password);
 			}
 			else
 			{
 				// default to SQLite3 database
-				$dbFile = $this->getApplication()->getRuntimePath() . '/sqlite3.cache';
-				$db->setConnectionString('sqlite:' . $dbFile);
+				$dbFile=$this->getApplication()->getRuntimePath().'/sqlite3.cache';
+				$db->setConnectionString('sqlite:'.$dbFile);
 			}
 			return $db;
 		}
@@ -326,8 +326,8 @@ 
 	 */
 	public function getDbConnection()
 	{
-		if($this->_db === null)
-			$this->_db = $this->createDbConnection();
+		if($this->_db===null)
+			$this->_db=$this->createDbConnection();
 
 		$this->_db->setActive(true);
 		return $this->_db;
@@ -352,7 +352,7 @@ 
 	 */
 	public function setConnectionID($value)
 	{
-		$this->_connID = $value;
+		$this->_connID=$value;
 	}
 
 	/**
@@ -369,7 +369,7 @@ 
 	 */
 	public function setConnectionString($value)
 	{
-		$this->_connectionString = $value;
+		$this->_connectionString=$value;
 	}
 
 	/**
@@ -385,7 +385,7 @@ 
 	 */
 	public function setUsername($value)
 	{
-		$this->_username = $value;
+		$this->_username=$value;
 	}
 
 	/**
@@ -401,7 +401,7 @@ 
 	 */
 	public function setPassword($value)
 	{
-		$this->_password = $value;
+		$this->_password=$value;
 	}
 
 	/**
@@ -434,7 +434,7 @@ 
 	 */
 	public function setCacheTableName($value)
 	{
-		$this->_cacheTable = $value;
+		$this->_cacheTable=$value;
 	}
 
 	/**
@@ -452,7 +452,7 @@ 
 	 */
 	public function setAutoCreateCacheTable($value)
 	{
-		$this->_autoCreate = TPropertyValue::ensureBoolean($value);
+		$this->_autoCreate=TPropertyValue::ensureBoolean($value);
 	}
 
 	/**
@@ -465,8 +465,8 @@ 
 	{
 		if(!$this->_cacheInitialized) $this->initializeCache();
 		try {
-			$sql = 'SELECT value FROM ' . $this->_cacheTable . ' WHERE itemkey=\'' . $key . '\' AND (expire=0 OR expire>' . time() . ') ORDER BY expire DESC';
-			$command = $this->getDbConnection()->createCommand($sql);
+			$sql='SELECT value FROM '.$this->_cacheTable.' WHERE itemkey=\''.$key.'\' AND (expire=0 OR expire>'.time().') ORDER BY expire DESC';
+			$command=$this->getDbConnection()->createCommand($sql);
 			return unserialize($command->queryScalar());
 		}
 		catch(\Exception $e)
@@ -503,11 +503,11 @@ 
 	protected function addValue($key, $value, $expire)
 	{
 		if(!$this->_cacheInitialized) $this->initializeCache();
-		$expire = ($expire <= 0)?0:time() + $expire;
-		$sql = "INSERT INTO {$this->_cacheTable} (itemkey,value,expire) VALUES(:key,:value,$expire)";
+		$expire=($expire <= 0) ? 0 : time() + $expire;
+		$sql="INSERT INTO {$this->_cacheTable} (itemkey,value,expire) VALUES(:key,:value,$expire)";
 		try
 		{
-			$command = $this->getDbConnection()->createCommand($sql);
+			$command=$this->getDbConnection()->createCommand($sql);
 			$command->bindValue(':key', $key, \PDO::PARAM_STR);
 			$command->bindValue(':value', serialize($value), \PDO::PARAM_LOB);
 			$command->execute();
@@ -539,7 +539,7 @@ 
 		if(!$this->_cacheInitialized) $this->initializeCache();
 		try
 		{
-			$command = $this->getDbConnection()->createCommand("DELETE FROM {$this->_cacheTable} WHERE itemkey=:key");
+			$command=$this->getDbConnection()->createCommand("DELETE FROM {$this->_cacheTable} WHERE itemkey=:key");
 			$command->bindValue(':key', $key, \PDO::PARAM_STR);
 			$command->execute();
 			return true;
@@ -561,7 +561,7 @@ 
 		if(!$this->_cacheInitialized) $this->initializeCache();
 		try
 		{
-			$command = $this->getDbConnection()->createCommand("DELETE FROM {$this->_cacheTable}");
+			$command=$this->getDbConnection()->createCommand("DELETE FROM {$this->_cacheTable}");
 			$command->execute();
 		}
 		catch(\Exception $e)