summaryrefslogtreecommitdiff
path: root/framework/Db/schema/oci/TOciCommandBuilder.php
diff options
context:
space:
mode:
Diffstat (limited to 'framework/Db/schema/oci/TOciCommandBuilder.php')
-rwxr-xr-xframework/Db/schema/oci/TOciCommandBuilder.php122
1 files changed, 122 insertions, 0 deletions
diff --git a/framework/Db/schema/oci/TOciCommandBuilder.php b/framework/Db/schema/oci/TOciCommandBuilder.php
new file mode 100755
index 00000000..fc8b8dc9
--- /dev/null
+++ b/framework/Db/schema/oci/TOciCommandBuilder.php
@@ -0,0 +1,122 @@
+<?php
+/**
+ * TOciCommandBuilder class file.
+ *
+ * @author Ricardo Grana <rickgrana@yahoo.com.br>
+ * @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');
+
+/**
+ * TOciCommandBuilder provides basic methods to create query commands for tables.
+ *
+ * @author Ricardo Grana <rickgrana@yahoo.com.br>
+ * @version $Id$
+ * @package system.db.schema.oci
+ * @since 1.0.5
+ */
+class TOciCommandBuilder extends TDbCommandBuilder
+{
+ /**
+ * @var integer the last insertion ID
+ */
+ public $returnID;
+
+ /**
+ * Returns the last insertion ID for the specified table.
+ * @param mixed the table schema ({@link TDbTableSchema}) or the table name (string).
+ * @return mixed last insertion id. Null is returned if no sequence name.
+ */
+ public function getLastInsertID($table)
+ {
+ return $this->returnID;
+ }
+
+ /**
+ * Alters the SQL to apply LIMIT and OFFSET.
+ * Default implementation is applicable for PostgreSQL, MySQL and SQLite.
+ * @param string SQL query string without LIMIT and OFFSET.
+ * @param integer maximum number of rows, -1 to ignore limit.
+ * @param integer row offset, -1 to ignore offset.
+ * @return string SQL with LIMIT and OFFSET
+ */
+ public function applyLimit($sql,$limit,$offset)
+ {
+ if (($limit < 0) and ($offset < 0)) return $sql;
+
+ $filters = array();
+ if($offset>0){
+ $filters[] = 'rowNumId >= '.(int)$offset;
+ }
+
+ if($limit>=0){
+ $filters[]= 'rownum <= '.(int)$limit;
+ }
+
+ if (count($filters) > 0){
+ $filter = implode(' and ', $filters);
+ $filter= " WHERE ".$filter;
+ }else{
+ $filter = '';
+ }
+
+
+ $sql = <<<EOD
+ WITH USER_SQL AS ({$sql}),
+ PAGINATION AS (SELECT USER_SQL.*, rownum as rowNumId FROM USER_SQL)
+ SELECT *
+ FROM PAGINATION
+ {$filter}
+EOD;
+
+ return $sql;
+ }
+
+ /**
+ * Creates an INSERT command.
+ * @param mixed the table schema ({@link TDbTableSchema}) or the table name (string).
+ * @param array data to be inserted (column name=>column value). If a key is not a valid column name, the corresponding value will be ignored.
+ * @return TDbCommand insert command
+ */
+ public function createInsertCommand($table,$data)
+ {
+ $this->ensureTable($table);
+ $fields=array();
+ $values=array();
+ $placeholders=array();
+ foreach($data as $name=>$value)
+ {
+ if(($column=$table->getColumn($name))!==null && ($value!==null || $column->allowNull))
+ {
+ $fields[]=$column->rawName;
+ if($value instanceof TDbExpression)
+ $placeholders[]=(string)$value;
+ else
+ {
+ $placeholders[]=':'.$name;
+ $values[':'.$name]=$column->typecast($value);
+ }
+ }
+ }
+
+ $sql="INSERT INTO {$table->rawName} (".implode(', ',$fields).') VALUES ('.implode(', ',$placeholders).')';
+
+ if(is_string($table->primaryKey))
+ {
+ $sql.=" RETURNING ".$table->primaryKey." INTO :RETURN_ID";
+ $command=$this->getDbConnection()->createCommand($sql);
+ $command->bindParam(':RETURN_ID', $this->returnID, PDO::PARAM_INT, 12);
+ $table->sequenceName='RETURN_ID';
+ }
+ else
+ $command=$this->getDbConnection()->createCommand($sql);
+
+ foreach($values as $name=>$value)
+ $command->bindValue($name,$value);
+
+ return $command;
+ }
+} \ No newline at end of file