QueryBuilder.php 3.11 KB
Newer Older
Carsten Brandt committed
1 2 3 4 5 6 7 8 9 10 11 12
<?php
/**
 * @link http://www.yiiframework.com/
 * @copyright Copyright (c) 2008 Yii Software LLC
 * @license http://www.yiiframework.com/license/
 */

namespace yii\db\cubrid;

use yii\base\InvalidParamException;

/**
13
 * QueryBuilder is the query builder for CUBRID databases (version 9.1.x and higher).
Carsten Brandt committed
14 15 16 17 18 19 20 21 22
 *
 * @author Carsten Brandt <mail@cebe.cc>
 * @since 2.0
 */
class QueryBuilder extends \yii\db\QueryBuilder
{
	/**
	 * @var array mapping from abstract column types (keys) to physical column types (values).
	 */
Alexander Makarov committed
23
	public $typeMap = [
24
		Schema::TYPE_PK => 'int NOT NULL AUTO_INCREMENT PRIMARY KEY',
25
		Schema::TYPE_BIGPK => 'bigint NOT NULL AUTO_INCREMENT PRIMARY KEY',
Carsten Brandt committed
26 27 28 29 30 31 32 33 34 35 36 37
		Schema::TYPE_STRING => 'varchar(255)',
		Schema::TYPE_TEXT => 'varchar',
		Schema::TYPE_SMALLINT => 'smallint',
		Schema::TYPE_INTEGER => 'int',
		Schema::TYPE_BIGINT => 'bigint',
		Schema::TYPE_FLOAT => 'float(7)',
		Schema::TYPE_DECIMAL => 'decimal(10,0)',
		Schema::TYPE_DATETIME => 'datetime',
		Schema::TYPE_TIMESTAMP => 'timestamp',
		Schema::TYPE_TIME => 'time',
		Schema::TYPE_DATE => 'date',
		Schema::TYPE_BINARY => 'blob',
38
		Schema::TYPE_BOOLEAN => 'smallint',
Carsten Brandt committed
39
		Schema::TYPE_MONEY => 'decimal(19,4)',
Alexander Makarov committed
40
	];
Carsten Brandt committed
41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69

	/**
	 * Creates a SQL statement for resetting the sequence value of a table's primary key.
	 * The sequence will be reset such that the primary key of the next new row inserted
	 * will have the specified value or 1.
	 * @param string $tableName the name of the table whose primary key sequence will be reset
	 * @param mixed $value the value for the primary key of the next new row inserted. If this is not set,
	 * the next new row's primary key will have a value 1.
	 * @return string the SQL statement for resetting sequence
	 * @throws InvalidParamException if the table does not exist or there is no sequence associated with the table.
	 */
	public function resetSequence($tableName, $value = null)
	{
		$table = $this->db->getTableSchema($tableName);
		if ($table !== null && $table->sequenceName !== null) {
			$tableName = $this->db->quoteTableName($tableName);
			if ($value === null) {
				$key = reset($table->primaryKey);
				$value = (int)$this->db->createCommand("SELECT MAX(`$key`) FROM " . $this->db->schema->quoteTableName($tableName))->queryScalar() + 1;
			} else {
				$value = (int)$value;
			}
			return "ALTER TABLE " . $this->db->schema->quoteTableName($tableName) . " AUTO_INCREMENT=$value;";
		} elseif ($table === null) {
			throw new InvalidParamException("Table not found: $tableName");
		} else {
			throw new InvalidParamException("There is not sequence associated with table '$tableName'.");
		}
	}
70 71

	/**
Qiang Xue committed
72
	 * @inheritdoc
73 74 75 76 77 78 79
	 */
	public function buildLimit($limit, $offset)
	{
		$sql = '';
		// limit is not optional in CUBRID
		// http://www.cubrid.org/manual/90/en/LIMIT%20Clause
		// "You can specify a very big integer for row_count to display to the last row, starting from a specific row."
80 81 82 83
		if ($this->hasLimit($limit)) {
			$sql = 'LIMIT ' . $limit;
			if ($this->hasOffset($offset)) {
				$sql .= ' OFFSET ' . $offset;
84
			}
85 86
		} elseif ($this->hasOffset($offset)) {
			$sql = "LIMIT 9223372036854775807 OFFSET $offset"; // 2^63-1
87 88 89
		}
		return $sql;
	}
Carsten Brandt committed
90
}