From fd4b8d9f45d1707035021bc19b8d5bc17ede66ce Mon Sep 17 00:00:00 2001
From: wei <>
Date: Mon, 12 Feb 2007 12:46:11 +0000
Subject: Add IBM DB2 driver for active record.

---
 .../Data/ActiveRecord/Vendor/TIbmMetaData.php      | 80 ++++++++++++++++++++++
 1 file changed, 80 insertions(+)
 create mode 100644 framework/Data/ActiveRecord/Vendor/TIbmMetaData.php

(limited to 'framework/Data/ActiveRecord/Vendor/TIbmMetaData.php')

diff --git a/framework/Data/ActiveRecord/Vendor/TIbmMetaData.php b/framework/Data/ActiveRecord/Vendor/TIbmMetaData.php
new file mode 100644
index 00000000..4f923406
--- /dev/null
+++ b/framework/Data/ActiveRecord/Vendor/TIbmMetaData.php
@@ -0,0 +1,80 @@
+<?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$
+ * @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$
+ * @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;
+	}
+}
+?>
\ No newline at end of file
-- 
cgit v1.2.3