summaryrefslogtreecommitdiff
path: root/framework/Data/ActiveRecord/Vendor
diff options
context:
space:
mode:
authorwei <>2007-03-31 06:42:15 +0000
committerwei <>2007-03-31 06:42:15 +0000
commit54c90d0102515ad58a882a6b3f4ac623fc9d50ed (patch)
treef111d06ef5ab1771a723e9a4f807f39039ec3fae /framework/Data/ActiveRecord/Vendor
parente54507780bbb25537735139fdf65637fbaa39542 (diff)
Add changes by ezar for IBM Db2 Active Record support.
Diffstat (limited to 'framework/Data/ActiveRecord/Vendor')
-rw-r--r--framework/Data/ActiveRecord/Vendor/TIbmColumnMetaData.php10
-rw-r--r--framework/Data/ActiveRecord/Vendor/TIbmMetaData.php33
-rw-r--r--framework/Data/ActiveRecord/Vendor/TIbmMetaDataInspector.php4
3 files changed, 44 insertions, 3 deletions
diff --git a/framework/Data/ActiveRecord/Vendor/TIbmColumnMetaData.php b/framework/Data/ActiveRecord/Vendor/TIbmColumnMetaData.php
index 65e40a59..eafadae5 100644
--- a/framework/Data/ActiveRecord/Vendor/TIbmColumnMetaData.php
+++ b/framework/Data/ActiveRecord/Vendor/TIbmColumnMetaData.php
@@ -45,7 +45,7 @@ class TIbmColumnMetaData extends TComponent
*/
public function __construct($name,$type,$length,$notNull,$autoIncrement,$default,$primary)
{
- $this->_property = $name;
+ $this->_property=$name;
$this->_name=$name;
$this->_type=$type;
$this->_length=$length;
@@ -64,6 +64,14 @@ class TIbmColumnMetaData extends TComponent
}
/**
+ * @return integer length.
+ */
+ public function getLength()
+ {
+ return $this->_length;
+ }
+
+ /**
* @return string active record property name
*/
public function getProperty()
diff --git a/framework/Data/ActiveRecord/Vendor/TIbmMetaData.php b/framework/Data/ActiveRecord/Vendor/TIbmMetaData.php
index 4f923406..eeaea851 100644
--- a/framework/Data/ActiveRecord/Vendor/TIbmMetaData.php
+++ b/framework/Data/ActiveRecord/Vendor/TIbmMetaData.php
@@ -76,5 +76,38 @@ class TIbmMetaData extends TDbMetaDataCommon
$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
diff --git a/framework/Data/ActiveRecord/Vendor/TIbmMetaDataInspector.php b/framework/Data/ActiveRecord/Vendor/TIbmMetaDataInspector.php
index 0ccc05ae..3920ac39 100644
--- a/framework/Data/ActiveRecord/Vendor/TIbmMetaDataInspector.php
+++ b/framework/Data/ActiveRecord/Vendor/TIbmMetaDataInspector.php
@@ -78,8 +78,8 @@ class TIbmMetaDataInspector extends TDbMetaDataInspector
$name = strtolower($col['COLNAME']);
$type = $col['TYPENAME'];
$length = $col['LENGTH'];
- $notNull = $col['NULLS']==='N';
- $autoIncrement=$col['IDENTITY']==='N';
+ $notNull = $col['NULLS']==='N'?1:0;
+ $autoIncrement=$col['IDENTITY']==='Y'?1:0;
$default = $col['DEFAULT'];
$primaryKey = $col['KEYSEQ']?1:0;
return new TIbmColumnMetaData($name,$type,$length,$notNull,$autoIncrement,$default,$primaryKey);