diff options
Diffstat (limited to 'framework/db/schema/sqlite/CSqliteCommandBuilder.php')
| -rw-r--r-- | framework/db/schema/sqlite/CSqliteCommandBuilder.php | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/framework/db/schema/sqlite/CSqliteCommandBuilder.php b/framework/db/schema/sqlite/CSqliteCommandBuilder.php new file mode 100644 index 0000000..c4bf75a --- /dev/null +++ b/framework/db/schema/sqlite/CSqliteCommandBuilder.php @@ -0,0 +1,40 @@ +<?php +/** + * CSqliteCommandBuilder class file. + * + * @author Qiang Xue <qiang.xue@gmail.com> + * @link http://www.yiiframework.com/ + * @copyright Copyright © 2008-2011 Yii Software LLC + * @license http://www.yiiframework.com/license/ + */ + +/** + * CSqliteCommandBuilder provides basic methods to create query commands for SQLite tables. + * + * @author Qiang Xue <qiang.xue@gmail.com> + * @version $Id: CSqliteCommandBuilder.php 3515 2011-12-28 12:29:24Z mdomba $ + * @package system.db.schema.sqlite + * @since 1.0 + */ +class CSqliteCommandBuilder extends CDbCommandBuilder +{ + /** + * 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 CDbTableSchema $table the table schema + * @param array $values list of primary key values to be selected within + * @param string $prefix column prefix (ended with dot) + * @return string the expression for selection + */ + 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).')'; + } +} |