summaryrefslogtreecommitdiff
path: root/framework/Db/Schema/sqlite/TSqliteCommandBuilder.php
diff options
context:
space:
mode:
authorrojaro <>2009-07-13 14:02:17 +0000
committerrojaro <>2009-07-13 14:02:17 +0000
commit78af2b4630ccde4b03659a259f739f83ae0de9ec (patch)
treef1a27cc2dbe77682143ae8243eee91187e66c6fe /framework/Db/Schema/sqlite/TSqliteCommandBuilder.php
parentb4b2c7e5e2eadd48b344538823dcf5645939ba44 (diff)
- ActiveRecord Port from Yii ... not perfect but works ^^
Diffstat (limited to 'framework/Db/Schema/sqlite/TSqliteCommandBuilder.php')
-rwxr-xr-xframework/Db/Schema/sqlite/TSqliteCommandBuilder.php43
1 files changed, 43 insertions, 0 deletions
diff --git a/framework/Db/Schema/sqlite/TSqliteCommandBuilder.php b/framework/Db/Schema/sqlite/TSqliteCommandBuilder.php
new file mode 100755
index 00000000..69ffd8a8
--- /dev/null
+++ b/framework/Db/Schema/sqlite/TSqliteCommandBuilder.php
@@ -0,0 +1,43 @@
+<?php
+/**
+ * TSqliteCommandBuilder class file.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @link http://www.yiiframework.com/
+ * @copyright Copyright &copy; 2008-2009 Yii Software LLC
+ * @license http://www.yiiframework.com/license/
+ */
+
+prado::using('System.Db.Schema.TDbCommandBuilder');
+
+/**
+ * TSqliteCommandBuilder provides basic methods to create query commands for SQLite tables.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @version $Id: TSqliteCommandBuilder.php 2679 2009-06-15 07:49:42Z Christophe.Boulain $
+ * @package System.Db.Schema.sqlite
+ * @since 1.0
+ */
+class TSqliteCommandBuilder extends TDbCommandBuilder
+{
+ /**
+ * Generates the expression for selecting rows with specified composite key values.
+ * This method is overridden because SQLite does not support the default
+ * IN expression with composite columns.
+ * @param TDbTableSchema the table schema
+ * @param array list of primary key values to be selected within
+ * @param string column prefix (ended with dot)
+ * @return string the expression for selection
+ * @since 1.0.4
+ */
+ protected function createCompositeInCondition($table,$values,$prefix)
+ {
+ $keyNames=array();
+ foreach(array_keys($values[0]) as $name)
+ $keyNames[]=$prefix.$table->columns[$name]->rawName;
+ $vs=array();
+ foreach($values as $value)
+ $vs[]=implode("||','||",$value);
+ return implode("||','||",$keyNames).' IN ('.implode(', ',$vs).')';
+ }
+}