Add IBM DB2 driver for active record.

1 files changed, 16 insertions, 3 deletions

diff --git a/framework/Data/ActiveRecord/Vendor/TSqliteMetaData.php b/framework/Data/ActiveRecord/Vendor/TSqliteMetaData.php
index c82a99ad..c44d73cb 100644
--- a/framework/Data/ActiveRecord/Vendor/TSqliteMetaData.php
+++ b/framework/Data/ActiveRecord/Vendor/TSqliteMetaData.php
@@ -48,10 +48,23 @@ class TSqliteMetaData extends TDbMetaDataCommon
 		return strlen($sql) > 0 ? $sql : '';

 	}

 

-	protected function getOrdering($by, $direction)

+	public function getSearchRegExpCriteria($fields, $keywords)

 	{

-		$dir = strtolower($direction) == 'desc' ? 'DESC' : 'ASC';

-		return $this->getColumn($by)->getName(). ' '.$dir;

+		if(strlen(trim($keywords)) == 0) return '';

+		$words = array();

+		preg_match_all('/([a-zA-Z0-9-+]+)/', $keywords, $words);

+		$result = array();

+		foreach($fields as $field)

+			$result[] = $this->getLikeCriteriaStr($this->getColumn($field)->getName(), $words[0]);

+		return '('.implode(' OR ', $result).')';

+	}

+

+	protected function getLikeCriteriaStr($column, $words)

+	{

+		$result=array();

+		foreach($words as $word)

+			$result[] = "({$column} LIKE \"%{$word}%\")";

+		return '('.implode(' AND ', $result).')';

 	}

 

 	/**