@@ -276,11 +276,11 @@ |
||
| 276 | 276 | $retval = array(); |
| 277 | 277 | for ($i = 0, $c = count($query); $i < $c; $i++) |
| 278 | 278 | { |
| 279 | - $retval[$i] = new stdClass(); |
|
| 279 | + $retval[$i] = new stdClass(); |
|
| 280 | 280 | $retval[$i]->name = $query[$i]->column_name; |
| 281 | 281 | $retval[$i]->type = $query[$i]->data_type; |
| 282 | - $retval[$i]->max_length = ($query[$i]->character_maximum_length > 0) ? $query[$i]->character_maximum_length : $query[$i]->numeric_precision; |
|
| 283 | - $retval[$i]->default = $query[$i]->column_default; |
|
| 282 | + $retval[$i]->max_length = ($query[$i]->character_maximum_length > 0) ? $query[$i]->character_maximum_length : $query[$i]->numeric_precision; |
|
| 283 | + $retval[$i]->default = $query[$i]->column_default; |
|
| 284 | 284 | } |
| 285 | 285 | |
| 286 | 286 | return $retval; |
@@ -483,7 +483,7 @@ |
||
| 483 | 483 | * @param string $orderby |
| 484 | 484 | * @param string $direction ASC, DESC or RANDOM |
| 485 | 485 | * @param bool $escape |
| 486 | - * @return object |
|
| 486 | + * @return CI_DB_query_builder |
|
| 487 | 487 | */ |
| 488 | 488 | public function order_by($orderby, $direction = '', $escape = NULL) |
| 489 | 489 | { |
@@ -51,14 +51,14 @@ |
||
| 51 | 51 | * |
| 52 | 52 | * @var string |
| 53 | 53 | */ |
| 54 | - protected $_drop_table_if = 'DROP TABLE IF EXISTS'; |
|
| 54 | + protected $_drop_table_if = 'DROP TABLE IF EXISTS'; |
|
| 55 | 55 | |
| 56 | 56 | /** |
| 57 | 57 | * UNSIGNED support |
| 58 | 58 | * |
| 59 | 59 | * @var array |
| 60 | 60 | */ |
| 61 | - protected $_unsigned = array( |
|
| 61 | + protected $_unsigned = array( |
|
| 62 | 62 | 'INT2' => 'INTEGER', |
| 63 | 63 | 'SMALLINT' => 'INTEGER', |
| 64 | 64 | 'INT' => 'BIGINT', |
@@ -51,28 +51,28 @@ |
||
| 51 | 51 | * |
| 52 | 52 | * @var string |
| 53 | 53 | */ |
| 54 | - protected $_create_table_if = 'CREATE TABLE IF NOT EXISTS'; |
|
| 54 | + protected $_create_table_if = 'CREATE TABLE IF NOT EXISTS'; |
|
| 55 | 55 | |
| 56 | 56 | /** |
| 57 | 57 | * DROP TABLE IF statement |
| 58 | 58 | * |
| 59 | 59 | * @var string |
| 60 | 60 | */ |
| 61 | - protected $_drop_table_if = 'DROP TABLE IF EXISTS'; |
|
| 61 | + protected $_drop_table_if = 'DROP TABLE IF EXISTS'; |
|
| 62 | 62 | |
| 63 | 63 | /** |
| 64 | 64 | * UNSIGNED support |
| 65 | 65 | * |
| 66 | 66 | * @var bool|array |
| 67 | 67 | */ |
| 68 | - protected $_unsigned = FALSE; |
|
| 68 | + protected $_unsigned = FALSE; |
|
| 69 | 69 | |
| 70 | 70 | /** |
| 71 | 71 | * NULL value representation in CREATE/ALTER TABLE statements |
| 72 | 72 | * |
| 73 | 73 | * @var string |
| 74 | 74 | */ |
| 75 | - protected $_null = 'NULL'; |
|
| 75 | + protected $_null = 'NULL'; |
|
| 76 | 76 | |
| 77 | 77 | // -------------------------------------------------------------------- |
| 78 | 78 | |
@@ -112,8 +112,7 @@ |
||
| 112 | 112 | if ( ! @unlink($this->db->database)) |
| 113 | 113 | { |
| 114 | 114 | return $this->db->db_debug ? $this->db->display_error('db_unable_to_drop') : FALSE; |
| 115 | - } |
|
| 116 | - elseif ( ! empty($this->db->data_cache['db_names'])) |
|
| 115 | + } elseif ( ! empty($this->db->data_cache['db_names'])) |
|
| 117 | 116 | { |
| 118 | 117 | $key = array_search(strtolower($this->db->database), array_map('strtolower', $this->db->data_cache['db_names']), TRUE); |
| 119 | 118 | if ($key !== FALSE) |
@@ -133,8 +133,7 @@ discard block |
||
| 133 | 133 | empty($this->MultipleActiveResultSets) OR $this->dsn .= ';MultipleActiveResultSets='.$this->MultipleActiveResultSets; |
| 134 | 134 | empty($this->TraceFile) OR $this->dsn .= ';TraceFile='.$this->TraceFile; |
| 135 | 135 | empty($this->WSID) OR $this->dsn .= ';WSID='.$this->WSID; |
| 136 | - } |
|
| 137 | - elseif (preg_match('/QuotedId=(0|1)/', $this->dsn, $match)) |
|
| 136 | + } elseif (preg_match('/QuotedId=(0|1)/', $this->dsn, $match)) |
|
| 138 | 137 | { |
| 139 | 138 | $this->_quoted_identifier = (bool) $match[1]; |
| 140 | 139 | } |
@@ -319,8 +318,7 @@ discard block |
||
| 319 | 318 | if (count($this->qb_select) === 0) |
| 320 | 319 | { |
| 321 | 320 | $select = '*'; // Inevitable |
| 322 | - } |
|
| 323 | - else |
|
| 321 | + } else |
|
| 324 | 322 | { |
| 325 | 323 | // Use only field names and their aliases, everything else is out of our scope. |
| 326 | 324 | $select = array(); |
@@ -341,11 +341,11 @@ discard block |
||
| 341 | 341 | $retval = array(); |
| 342 | 342 | for ($i = 0, $c = count($query); $i < $c; $i++) |
| 343 | 343 | { |
| 344 | - $retval[$i] = new stdClass(); |
|
| 344 | + $retval[$i] = new stdClass(); |
|
| 345 | 345 | $retval[$i]->name = $query[$i]->COLUMN_NAME; |
| 346 | 346 | $retval[$i]->type = $query[$i]->DATA_TYPE; |
| 347 | - $retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION; |
|
| 348 | - $retval[$i]->default = $query[$i]->COLUMN_DEFAULT; |
|
| 347 | + $retval[$i]->max_length = ($query[$i]->CHARACTER_MAXIMUM_LENGTH > 0) ? $query[$i]->CHARACTER_MAXIMUM_LENGTH : $query[$i]->NUMERIC_PRECISION; |
|
| 348 | + $retval[$i]->default = $query[$i]->COLUMN_DEFAULT; |
|
| 349 | 349 | } |
| 350 | 350 | |
| 351 | 351 | return $retval; |
@@ -501,7 +501,7 @@ discard block |
||
| 501 | 501 | ."\nWHERE ".$this->escape_identifiers('CI_rownum').' BETWEEN '.($this->qb_offset + 1).' AND '.$limit; |
| 502 | 502 | } |
| 503 | 503 | |
| 504 | - return preg_replace('/(^\SELECT (DISTINCT)?)/i','\\1 TOP '.$limit.' ', $sql); |
|
| 504 | + return preg_replace('/(^\SELECT (DISTINCT)?)/i', '\\1 TOP '.$limit.' ', $sql); |
|
| 505 | 505 | } |
| 506 | 506 | |
| 507 | 507 | // -------------------------------------------------------------------- |
@@ -53,7 +53,7 @@ |
||
| 53 | 53 | * |
| 54 | 54 | * @var array |
| 55 | 55 | */ |
| 56 | - protected $_unsigned = array( |
|
| 56 | + protected $_unsigned = array( |
|
| 57 | 57 | 'INT2' => 'INTEGER', |
| 58 | 58 | 'SMALLINT' => 'INTEGER', |
| 59 | 59 | 'INT' => 'BIGINT', |
@@ -108,10 +108,10 @@ |
||
| 108 | 108 | $retval = array(); |
| 109 | 109 | for ($i = 0, $c = $this->num_fields(); $i < $c; $i++) |
| 110 | 110 | { |
| 111 | - $retval[$i] = new stdClass(); |
|
| 111 | + $retval[$i] = new stdClass(); |
|
| 112 | 112 | $retval[$i]->name = pg_field_name($this->result_id, $i); |
| 113 | 113 | $retval[$i]->type = pg_field_type($this->result_id, $i); |
| 114 | - $retval[$i]->max_length = pg_field_size($this->result_id, $i); |
|
| 114 | + $retval[$i]->max_length = pg_field_size($this->result_id, $i); |
|
| 115 | 115 | } |
| 116 | 116 | |
| 117 | 117 | return $retval; |
@@ -53,14 +53,14 @@ |
||
| 53 | 53 | * |
| 54 | 54 | * @var string |
| 55 | 55 | */ |
| 56 | - protected $_list_databases = 'SELECT datname FROM pg_database'; |
|
| 56 | + protected $_list_databases = 'SELECT datname FROM pg_database'; |
|
| 57 | 57 | |
| 58 | 58 | /** |
| 59 | 59 | * OPTIMIZE TABLE statement |
| 60 | 60 | * |
| 61 | 61 | * @var string |
| 62 | 62 | */ |
| 63 | - protected $_optimize_table = 'REINDEX TABLE %s'; |
|
| 63 | + protected $_optimize_table = 'REINDEX TABLE %s'; |
|
| 64 | 64 | |
| 65 | 65 | // -------------------------------------------------------------------- |
| 66 | 66 | |
@@ -1,40 +1,40 @@ |
||
| 1 | 1 | <?php |
| 2 | 2 | /** |
| 3 | - * CodeIgniter |
|
| 4 | - * |
|
| 5 | - * An open source application development framework for PHP |
|
| 6 | - * |
|
| 7 | - * This content is released under the MIT License (MIT) |
|
| 8 | - * |
|
| 9 | - * Copyright (c) 2014 - 2015, British Columbia Institute of Technology |
|
| 10 | - * |
|
| 11 | - * Permission is hereby granted, free of charge, to any person obtaining a copy |
|
| 12 | - * of this software and associated documentation files (the "Software"), to deal |
|
| 13 | - * in the Software without restriction, including without limitation the rights |
|
| 14 | - * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell |
|
| 15 | - * copies of the Software, and to permit persons to whom the Software is |
|
| 16 | - * furnished to do so, subject to the following conditions: |
|
| 17 | - * |
|
| 18 | - * The above copyright notice and this permission notice shall be included in |
|
| 19 | - * all copies or substantial portions of the Software. |
|
| 20 | - * |
|
| 21 | - * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR |
|
| 22 | - * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, |
|
| 23 | - * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE |
|
| 24 | - * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER |
|
| 25 | - * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, |
|
| 26 | - * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN |
|
| 27 | - * THE SOFTWARE. |
|
| 28 | - * |
|
| 29 | - * @package CodeIgniter |
|
| 30 | - * @author EllisLab Dev Team |
|
| 31 | - * @copyright Copyright (c) 2008 - 2014, EllisLab, Inc. (http://ellislab.com/) |
|
| 32 | - * @copyright Copyright (c) 2014 - 2015, British Columbia Institute of Technology (http://bcit.ca/) |
|
| 33 | - * @license http://opensource.org/licenses/MIT MIT License |
|
| 34 | - * @link http://codeigniter.com |
|
| 35 | - * @since Version 1.3.0 |
|
| 36 | - * @filesource |
|
| 37 | - */ |
|
| 3 | + * CodeIgniter |
|
| 4 | + * |
|
| 5 | + * An open source application development framework for PHP |
|
| 6 | + * |
|
| 7 | + * This content is released under the MIT License (MIT) |
|
| 8 | + * |
|
| 9 | + * Copyright (c) 2014 - 2015, British Columbia Institute of Technology |
|
| 10 | + * |
|
| 11 | + * Permission is hereby granted, free of charge, to any person obtaining a copy |
|
| 12 | + * of this software and associated documentation files (the "Software"), to deal |
|
| 13 | + * in the Software without restriction, including without limitation the rights |
|
| 14 | + * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell |
|
| 15 | + * copies of the Software, and to permit persons to whom the Software is |
|
| 16 | + * furnished to do so, subject to the following conditions: |
|
| 17 | + * |
|
| 18 | + * The above copyright notice and this permission notice shall be included in |
|
| 19 | + * all copies or substantial portions of the Software. |
|
| 20 | + * |
|
| 21 | + * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR |
|
| 22 | + * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, |
|
| 23 | + * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE |
|
| 24 | + * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER |
|
| 25 | + * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, |
|
| 26 | + * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN |
|
| 27 | + * THE SOFTWARE. |
|
| 28 | + * |
|
| 29 | + * @package CodeIgniter |
|
| 30 | + * @author EllisLab Dev Team |
|
| 31 | + * @copyright Copyright (c) 2008 - 2014, EllisLab, Inc. (http://ellislab.com/) |
|
| 32 | + * @copyright Copyright (c) 2014 - 2015, British Columbia Institute of Technology (http://bcit.ca/) |
|
| 33 | + * @license http://opensource.org/licenses/MIT MIT License |
|
| 34 | + * @link http://codeigniter.com |
|
| 35 | + * @since Version 1.3.0 |
|
| 36 | + * @filesource |
|
| 37 | + */ |
|
| 38 | 38 | defined('BASEPATH') OR exit('No direct script access allowed'); |
| 39 | 39 | |
| 40 | 40 | /** |
@@ -274,11 +274,11 @@ |
||
| 274 | 274 | $retval = array(); |
| 275 | 275 | for ($i = 0, $c = count($query); $i < $c; $i++) |
| 276 | 276 | { |
| 277 | - $retval[$i] = new stdClass(); |
|
| 277 | + $retval[$i] = new stdClass(); |
|
| 278 | 278 | $retval[$i]->name = $query[$i]['name']; |
| 279 | 279 | $retval[$i]->type = $query[$i]['type']; |
| 280 | 280 | $retval[$i]->max_length = NULL; |
| 281 | - $retval[$i]->default = $query[$i]['dflt_value']; |
|
| 281 | + $retval[$i]->default = $query[$i]['dflt_value']; |
|
| 282 | 282 | $retval[$i]->primary_key = isset($query[$i]['pk']) ? (int) $query[$i]['pk'] : 0; |
| 283 | 283 | } |
| 284 | 284 | |
@@ -51,21 +51,21 @@ |
||
| 51 | 51 | * |
| 52 | 52 | * @var string |
| 53 | 53 | */ |
| 54 | - protected $_create_table_if = FALSE; |
|
| 54 | + protected $_create_table_if = FALSE; |
|
| 55 | 55 | |
| 56 | 56 | /** |
| 57 | 57 | * UNSIGNED support |
| 58 | 58 | * |
| 59 | 59 | * @var bool|array |
| 60 | 60 | */ |
| 61 | - protected $_unsigned = FALSE; |
|
| 61 | + protected $_unsigned = FALSE; |
|
| 62 | 62 | |
| 63 | 63 | /** |
| 64 | 64 | * NULL value representation in CREATE/ALTER TABLE statements |
| 65 | 65 | * |
| 66 | 66 | * @var string |
| 67 | 67 | */ |
| 68 | - protected $_null = 'NULL'; |
|
| 68 | + protected $_null = 'NULL'; |
|
| 69 | 69 | |
| 70 | 70 | // -------------------------------------------------------------------- |
| 71 | 71 | |
@@ -95,8 +95,7 @@ |
||
| 95 | 95 | if ( ! file_exists($this->db->database) OR ! @unlink($this->db->database)) |
| 96 | 96 | { |
| 97 | 97 | return ($this->db->db_debug) ? $this->db->display_error('db_unable_to_drop') : FALSE; |
| 98 | - } |
|
| 99 | - elseif ( ! empty($this->db->data_cache['db_names'])) |
|
| 98 | + } elseif ( ! empty($this->db->data_cache['db_names'])) |
|
| 100 | 99 | { |
| 101 | 100 | $key = array_search(strtolower($this->db->database), array_map('strtolower', $this->db->data_cache['db_names']), TRUE); |
| 102 | 101 | if ($key !== FALSE) |