From 0f0d3c62e608287cdf77f1a3239371b521ecb40b Mon Sep 17 00:00:00 2001
From: wei <>
Date: Sat, 14 Apr 2007 05:02:29 +0000
Subject: Refactor ActiveRecordGateway to use TDataGatewayCommand

---
 framework/Data/Common/IbmDb2/TIbmMetaData.php | 113 ++++++++++++++++++++++++++
 1 file changed, 113 insertions(+)
 create mode 100644 framework/Data/Common/IbmDb2/TIbmMetaData.php

(limited to 'framework/Data/Common/IbmDb2/TIbmMetaData.php')

diff --git a/framework/Data/Common/IbmDb2/TIbmMetaData.php b/framework/Data/Common/IbmDb2/TIbmMetaData.php
new file mode 100644
index 00000000..99df5465
--- /dev/null
+++ b/framework/Data/Common/IbmDb2/TIbmMetaData.php
@@ -0,0 +1,113 @@
+<?php
+
+/**
+ * TIbmMetaData class file.
+ *
+ * @author Cesar Ramos <cramos[at]gmail[dot]com>
+ * @link http://www.pradosoft.com/
+ * @copyright Copyright &copy; 2005-2007 PradoSoft
+ * @license http://www.pradosoft.com/license/
+ * @version $Id: TIbmMetaData.php 1807 2007-03-31 06:42:15Z wei $
+ * @package System.Data.ActiveRecord.Vendor
+ */
+Prado::using('System.Data.ActiveRecord.Vendor.TDbMetaDataCommon');
+
+/**
+ * TIbmMetaData class.
+ *
+ * Column details for IBM DB2 database. Using php_pdo_ibm.dll extension.
+ *
+ * Does not support LIMIT and OFFSET criterias.
+ *
+ * @author Cesar Ramos <cramos[at]gmail[dot]com>
+ * @version $Id: TIbmMetaData.php 1807 2007-03-31 06:42:15Z wei $
+ * @package System.Data.ActiveRecord.Vendor
+ * @since 3.1
+ */
+class TIbmMetaData extends TDbMetaDataCommon
+{
+	/**
+	 * Build the SQL search string from the criteria object for IBM DB2 database.
+	 * @param TDbConnection database connection.
+	 * @param TActiveRecordCriteria search criteria.
+	 * @return string SQL search.
+	 */
+	protected function getSqlFromCriteria($conn, $criteria)
+	{
+		if($criteria===null) return '';
+		$sql = '';
+		if(($condition = $criteria->getCondition())!==null)
+			$sql .= ' WHERE '.$condition;
+		$orders=array();
+		foreach($criteria->getOrdersBy() as $by=>$ordering)
+			$orders[] = $this->getOrdering($by, $ordering);
+		if(count($orders) > 0)
+			$sql .= ' ORDER BY '.implode(', ', $orders);
+		//if(($limit = $criteria->getLimit())!==null)
+		//{
+		//	$sql .= ' FETCH FIRST '.intval($limit).' ROWS ONLY';
+		//}
+		return strlen($sql) > 0 ? $sql : '';
+	}
+
+	/**
+	 * Lowercase the data keys, IBM DB2 returns uppercase column names
+	 * @param mixed record row
+	 * @return array record row
+	 */
+	public function postQueryRow($row)
+	{
+		if(!is_array($row)) return $row;
+		$result=array();
+		foreach($row as $k=>$v)
+			$result[strtolower($k)]=$v;
+		return $result;
+	}
+
+	/**
+	 * Lowercase the data keys, IBM DB2 returns uppercase column names
+	 * @param mixed record row
+	 * @return array record row
+	 */
+	public function postQuery($rows)
+	{
+		$data = array();
+		foreach($rows as $k=>$v)
+			$data[$k] = $this->postQueryRow($v);
+		return $data;
+	}
+	
+	public function getSearchRegExpCriteria($fields, $keywords)
+	{
+		if(strlen(trim($keywords)) == 0) return '';
+		$words = array();
+		preg_match_all('/([a-zA-Z0-9-+]+)/', $keywords, $words);
+		$result = array();
+		foreach($fields as $field)
+		{
+			$column = $this->getColumn($field);
+			if($this->isSearchableColumn($column))
+				$result[] = $this->getLikeCriteriaStr($column->getName(), $words[0]);
+		}
+			$a = '('.implode(' OR ', $result).')';
+			error_log($a);
+		return '('.implode(' OR ', $result).')';
+	}
+
+	protected function isSearchableColumn($column)
+	{
+		$type = strtolower($column->getType());
+		return $type === 'char' || $type === 'varchar';
+	}
+
+	protected function getLikeCriteriaStr($column, $words)
+	{
+		$result=array();
+		foreach($words as $word)
+			$result[] = "{$column} LIKE '%{$word}%'";
+		return '('.implode(' AND ', $result).')';
+	}
+
+	
+}
+?>
\ No newline at end of file
-- 
cgit v1.2.3