/system/codeigniter/database/drivers/pdo/subdrivers/pdo_cubrid_forge.php
PHP | 219 lines | 100 code | 25 blank | 94 comment | 11 complexity | 9740a1f23907b14c7821f50ad0dc659f MD5 | raw file
Possible License(s): CC-BY-3.0, BSD-3-Clause, CC0-1.0, LGPL-2.1, MPL-2.0-no-copyleft-exception, MIT
- <?php
- /**
- * CodeIgniter
- *
- * An open source application development framework for PHP 5.2.4 or newer
- *
- * NOTICE OF LICENSE
- *
- * Licensed under the Open Software License version 3.0
- *
- * This source file is subject to the Open Software License (OSL 3.0) that is
- * bundled with this package in the files license.txt / license.rst. It is
- * also available through the world wide web at this URL:
- * http://opensource.org/licenses/OSL-3.0
- * If you did not receive a copy of the license and are unable to obtain it
- * through the world wide web, please send an email to
- * licensing@ellislab.com so we can send you a copy immediately.
- *
- * @package CodeIgniter
- * @author EllisLab Dev Team
- * @copyright Copyright (c) 2008 - 2013, EllisLab, Inc. (http://ellislab.com/)
- * @license http://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
- * @link http://codeigniter.com
- * @since Version 2.1.0
- * @filesource
- */
- defined('BASEPATH') OR exit('No direct script access allowed');
- /**
- * PDO CUBRID Forge Class
- *
- * @category Database
- * @author EllisLab Dev Team
- * @link http://codeigniter.com/user_guide/database/
- */
- class CI_DB_pdo_cubrid_forge extends CI_DB_pdo_forge {
- /**
- * CREATE DATABASE statement
- *
- * @var string
- */
- protected $_create_database = FALSE;
- /**
- * DROP DATABASE statement
- *
- * @var string
- */
- protected $_drop_database = FALSE;
- /**
- * CREATE TABLE keys flag
- *
- * Whether table keys are created from within the
- * CREATE TABLE statement.
- *
- * @var bool
- */
- protected $_create_table_keys = TRUE;
- /**
- * DROP TABLE IF statement
- *
- * @var string
- */
- protected $_drop_table_if = 'DROP TABLE IF EXISTS';
- /**
- * UNSIGNED support
- *
- * @var array
- */
- protected $_unsigned = array(
- 'SHORT' => 'INTEGER',
- 'SMALLINT' => 'INTEGER',
- 'INT' => 'BIGINT',
- 'INTEGER' => 'BIGINT',
- 'BIGINT' => 'NUMERIC',
- 'FLOAT' => 'DOUBLE',
- 'REAL' => 'DOUBLE'
- );
- // --------------------------------------------------------------------
- /**
- * ALTER TABLE
- *
- * @param string $alter_type ALTER type
- * @param string $table Table name
- * @param mixed $field Column definition
- * @return string|string[]
- */
- protected function _alter_table($alter_type, $table, $field)
- {
- if (in_array($alter_type, array('DROP', 'ADD'), TRUE))
- {
- return parent::_alter_table($alter_type, $table, $field);
- }
- $sql = 'ALTER TABLE '.$this->db->escape_identifiers($table);
- $sqls = array();
- for ($i = 0, $c = count($field); $i < $c; $i++)
- {
- if ($field[$i]['_literal'] !== FALSE)
- {
- $sqls[] = $sql.' CHANGE '.$field[$i]['_literal'];
- }
- else
- {
- $alter_type = empty($field[$i]['new_name']) ? ' MODIFY ' : ' CHANGE ';
- $sqls[] = $sql.$alter_type.$this->_process_column($field[$i]);
- }
- }
- return $sqls;
- }
- // --------------------------------------------------------------------
- /**
- * Process column
- *
- * @param array $field
- * @return string
- */
- protected function _process_column($field)
- {
- $extra_clause = isset($field['after'])
- ? ' AFTER '.$this->db->escape_identifiers($field['after']) : '';
- if (empty($extra_clause) && isset($field['first']) && $field['first'] === TRUE)
- {
- $extra_clause = ' FIRST';
- }
- return $this->db->escape_identifiers($field['name'])
- .(empty($field['new_name']) ? '' : ' '.$this->db->escape_identifiers($field['new_name']))
- .' '.$field['type'].$field['length']
- .$field['unsigned']
- .$field['null']
- .$field['default']
- .$field['auto_increment']
- .$field['unique']
- .$extra_clause;
- }
- // --------------------------------------------------------------------
- /**
- * Field attribute TYPE
- *
- * Performs a data type mapping between different databases.
- *
- * @param array &$attributes
- * @return void
- */
- protected function _attr_type(&$attributes)
- {
- switch (strtoupper($attributes['TYPE']))
- {
- case 'TINYINT':
- $attributes['TYPE'] = 'SMALLINT';
- $attributes['UNSIGNED'] = FALSE;
- return;
- case 'MEDIUMINT':
- $attributes['TYPE'] = 'INTEGER';
- $attributes['UNSIGNED'] = FALSE;
- return;
- default: return;
- }
- }
- // --------------------------------------------------------------------
- /**
- * Process indexes
- *
- * @param string $table (ignored)
- * @return string
- */
- protected function _process_indexes($table)
- {
- $sql = '';
- for ($i = 0, $c = count($this->keys); $i < $c; $i++)
- {
- if (is_array($this->keys[$i]))
- {
- for ($i2 = 0, $c2 = count($this->keys[$i]); $i2 < $c2; $i2++)
- {
- if ( ! isset($this->fields[$this->keys[$i][$i2]]))
- {
- unset($this->keys[$i][$i2]);
- continue;
- }
- }
- }
- elseif ( ! isset($this->fields[$this->keys[$i]]))
- {
- unset($this->keys[$i]);
- continue;
- }
- is_array($this->keys[$i]) OR $this->keys[$i] = array($this->keys[$i]);
- $sql .= ",\n\tKEY ".$this->db->escape_identifiers(implode('_', $this->keys[$i]))
- .' ('.implode(', ', $this->db->escape_identifiers($this->keys[$i])).')';
- }
- $this->keys = array();
- return $sql;
- }
- }
- /* End of file pdo_cubrid_forge.php */
- /* Location: ./system/database/drivers/pdo/subdrivers/pdo_cubrid_forge.php */