From b4b2c7e5e2eadd48b344538823dcf5645939ba44 Mon Sep 17 00:00:00 2001
From: rojaro <>
Date: Mon, 13 Jul 2009 13:56:07 +0000
Subject: - removed old schema directory - some cleanups

---
 framework/Db/schema/oci/TOciCommandBuilder.php | 122 -------------------------
 1 file changed, 122 deletions(-)
 delete mode 100755 framework/Db/schema/oci/TOciCommandBuilder.php

(limited to 'framework/Db/schema/oci/TOciCommandBuilder.php')

diff --git a/framework/Db/schema/oci/TOciCommandBuilder.php b/framework/Db/schema/oci/TOciCommandBuilder.php
deleted file mode 100755
index fc8b8dc9..00000000
--- a/framework/Db/schema/oci/TOciCommandBuilder.php
+++ /dev/null
@@ -1,122 +0,0 @@
-<?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
-- 
cgit v1.2.3