From 78af2b4630ccde4b03659a259f739f83ae0de9ec Mon Sep 17 00:00:00 2001 From: rojaro <> Date: Mon, 13 Jul 2009 14:02:17 +0000 Subject: - ActiveRecord Port from Yii ... not perfect but works ^^ --- .../Db/Schema/sqlite/TSqliteCommandBuilder.php | 43 ++++++++++++++++++++++ 1 file changed, 43 insertions(+) create mode 100755 framework/Db/Schema/sqlite/TSqliteCommandBuilder.php (limited to 'framework/Db/Schema/sqlite/TSqliteCommandBuilder.php') 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 @@ + + * @link http://www.yiiframework.com/ + * @copyright Copyright © 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 + * @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).')'; + } +} -- cgit v1.2.3