@@ -53,13 +53,13 @@ |
||
53 | 53 | * |
54 | 54 | * @var string |
55 | 55 | */ |
56 | - protected $_create_table_if = FALSE; |
|
56 | + protected $_create_table_if = FALSE; |
|
57 | 57 | |
58 | 58 | /** |
59 | 59 | * DROP TABLE IF statement |
60 | 60 | * |
61 | 61 | * @var string |
62 | 62 | */ |
63 | - protected $_drop_table_if = FALSE; |
|
63 | + protected $_drop_table_if = FALSE; |
|
64 | 64 | |
65 | 65 | } |
@@ -131,7 +131,7 @@ |
||
131 | 131 | { |
132 | 132 | $field = $this->result_id->getColumnMeta($i); |
133 | 133 | |
134 | - $retval[$i] = new stdClass(); |
|
134 | + $retval[$i] = new stdClass(); |
|
135 | 135 | $retval[$i]->name = $field['name']; |
136 | 136 | $retval[$i]->type = $field['native_type']; |
137 | 137 | $retval[$i]->max_length = ($field['len'] > 0) ? $field['len'] : NULL; |
@@ -60,16 +60,13 @@ discard block |
||
60 | 60 | if (is_int($this->num_rows)) |
61 | 61 | { |
62 | 62 | return $this->num_rows; |
63 | - } |
|
64 | - elseif (count($this->result_array) > 0) |
|
63 | + } elseif (count($this->result_array) > 0) |
|
65 | 64 | { |
66 | 65 | return $this->num_rows = count($this->result_array); |
67 | - } |
|
68 | - elseif (count($this->result_object) > 0) |
|
66 | + } elseif (count($this->result_object) > 0) |
|
69 | 67 | { |
70 | 68 | return $this->num_rows = count($this->result_object); |
71 | - } |
|
72 | - elseif (($num_rows = $this->result_id->rowCount()) > 0) |
|
69 | + } elseif (($num_rows = $this->result_id->rowCount()) > 0) |
|
73 | 70 | { |
74 | 71 | return $this->num_rows = $num_rows; |
75 | 72 | } |
@@ -139,8 +136,7 @@ discard block |
||
139 | 136 | } |
140 | 137 | |
141 | 138 | return $retval; |
142 | - } |
|
143 | - catch (Exception $e) |
|
139 | + } catch (Exception $e) |
|
144 | 140 | { |
145 | 141 | if ($this->db->db_debug) |
146 | 142 | { |
@@ -87,8 +87,7 @@ |
||
87 | 87 | empty($this->port) OR $this->dsn .= ';port='.$this->port; |
88 | 88 | empty($this->database) OR $this->dsn .= ';dbname='.$this->database; |
89 | 89 | empty($this->char_set) OR $this->dsn .= ';charset='.$this->char_set; |
90 | - } |
|
91 | - elseif ( ! empty($this->char_set) && strpos($this->dsn, 'charset=', 3) === FALSE) |
|
90 | + } elseif ( ! empty($this->char_set) && strpos($this->dsn, 'charset=', 3) === FALSE) |
|
92 | 91 | { |
93 | 92 | $this->dsn .= ';charset='.$this->char_set; |
94 | 93 | } |
@@ -51,42 +51,42 @@ discard block |
||
51 | 51 | * |
52 | 52 | * @var string |
53 | 53 | */ |
54 | - protected $_create_database = 'CREATE SCHEMA %s'; |
|
54 | + protected $_create_database = 'CREATE SCHEMA %s'; |
|
55 | 55 | |
56 | 56 | /** |
57 | 57 | * DROP DATABASE statement |
58 | 58 | * |
59 | 59 | * @var string |
60 | 60 | */ |
61 | - protected $_drop_database = 'DROP SCHEMA %s'; |
|
61 | + protected $_drop_database = 'DROP SCHEMA %s'; |
|
62 | 62 | |
63 | 63 | /** |
64 | 64 | * CREATE TABLE IF statement |
65 | 65 | * |
66 | 66 | * @var string |
67 | 67 | */ |
68 | - protected $_create_table_if = 'CREATE TABLE IF NOT EXISTS'; |
|
68 | + protected $_create_table_if = 'CREATE TABLE IF NOT EXISTS'; |
|
69 | 69 | |
70 | 70 | /** |
71 | 71 | * RENAME TABLE statement |
72 | 72 | * |
73 | 73 | * @var string |
74 | 74 | */ |
75 | - protected $_rename_table = FALSE; |
|
75 | + protected $_rename_table = FALSE; |
|
76 | 76 | |
77 | 77 | /** |
78 | 78 | * DROP TABLE IF statement |
79 | 79 | * |
80 | 80 | * @var string |
81 | 81 | */ |
82 | - protected $_drop_table_if = 'DROP TABLE IF EXISTS'; |
|
82 | + protected $_drop_table_if = 'DROP TABLE IF EXISTS'; |
|
83 | 83 | |
84 | 84 | /** |
85 | 85 | * UNSIGNED support |
86 | 86 | * |
87 | 87 | * @var array |
88 | 88 | */ |
89 | - protected $_unsigned = array( |
|
89 | + protected $_unsigned = array( |
|
90 | 90 | 'INT16' => 'INT', |
91 | 91 | 'SMALLINT' => 'INT', |
92 | 92 | 'INT' => 'INT64', |
@@ -98,7 +98,7 @@ discard block |
||
98 | 98 | * |
99 | 99 | * @var string |
100 | 100 | */ |
101 | - protected $_default = FALSE; |
|
101 | + protected $_default = FALSE; |
|
102 | 102 | |
103 | 103 | // -------------------------------------------------------------------- |
104 | 104 |
@@ -206,8 +206,7 @@ |
||
206 | 206 | if (stripos($field['type'], 'int') !== FALSE) |
207 | 207 | { |
208 | 208 | $field['auto_increment'] = ' AUTO_INCREMENT'; |
209 | - } |
|
210 | - elseif (strcasecmp($field['type'], 'UUID') === 0) |
|
209 | + } elseif (strcasecmp($field['type'], 'UUID') === 0) |
|
211 | 210 | { |
212 | 211 | $field['auto_increment'] = ' AUTO_GENERATE'; |
213 | 212 | } |
@@ -153,16 +153,16 @@ |
||
153 | 153 | $retval = array(); |
154 | 154 | for ($i = 0, $c = count($query); $i < $c; $i++) |
155 | 155 | { |
156 | - $retval[$i] = new stdClass(); |
|
157 | - $retval[$i]->name = $query[$i]->Field; |
|
156 | + $retval[$i] = new stdClass(); |
|
157 | + $retval[$i]->name = $query[$i]->Field; |
|
158 | 158 | |
159 | 159 | sscanf($query[$i]->Type, '%[a-z](%d)', |
160 | 160 | $retval[$i]->type, |
161 | 161 | $retval[$i]->max_length |
162 | 162 | ); |
163 | 163 | |
164 | - $retval[$i]->default = $query[$i]->Default; |
|
165 | - $retval[$i]->primary_key = (int) ($query[$i]->Key === 'PRI'); |
|
164 | + $retval[$i]->default = $query[$i]->Default; |
|
165 | + $retval[$i]->primary_key = (int) ($query[$i]->Key === 'PRI'); |
|
166 | 166 | } |
167 | 167 | |
168 | 168 | return $retval; |
@@ -51,14 +51,14 @@ discard block |
||
51 | 51 | * |
52 | 52 | * @var string |
53 | 53 | */ |
54 | - protected $_create_database = FALSE; |
|
54 | + protected $_create_database = FALSE; |
|
55 | 55 | |
56 | 56 | /** |
57 | 57 | * DROP DATABASE statement |
58 | 58 | * |
59 | 59 | * @var string |
60 | 60 | */ |
61 | - protected $_drop_database = FALSE; |
|
61 | + protected $_drop_database = FALSE; |
|
62 | 62 | |
63 | 63 | /** |
64 | 64 | * CREATE TABLE keys flag |
@@ -68,21 +68,21 @@ discard block |
||
68 | 68 | * |
69 | 69 | * @var bool |
70 | 70 | */ |
71 | - protected $_create_table_keys = TRUE; |
|
71 | + protected $_create_table_keys = TRUE; |
|
72 | 72 | |
73 | 73 | /** |
74 | 74 | * DROP TABLE IF statement |
75 | 75 | * |
76 | 76 | * @var string |
77 | 77 | */ |
78 | - protected $_drop_table_if = 'DROP TABLE IF EXISTS'; |
|
78 | + protected $_drop_table_if = 'DROP TABLE IF EXISTS'; |
|
79 | 79 | |
80 | 80 | /** |
81 | 81 | * UNSIGNED support |
82 | 82 | * |
83 | 83 | * @var array |
84 | 84 | */ |
85 | - protected $_unsigned = array( |
|
85 | + protected $_unsigned = array( |
|
86 | 86 | 'SHORT' => 'INTEGER', |
87 | 87 | 'SMALLINT' => 'INTEGER', |
88 | 88 | 'INT' => 'BIGINT', |
@@ -116,8 +116,7 @@ discard block |
||
116 | 116 | if ($field[$i]['_literal'] !== FALSE) |
117 | 117 | { |
118 | 118 | $sqls[] = $sql.' CHANGE '.$field[$i]['_literal']; |
119 | - } |
|
120 | - else |
|
119 | + } else |
|
121 | 120 | { |
122 | 121 | $alter_type = empty($field[$i]['new_name']) ? ' MODIFY ' : ' CHANGE '; |
123 | 122 | $sqls[] = $sql.$alter_type.$this->_process_column($field[$i]); |
@@ -206,8 +205,7 @@ discard block |
||
206 | 205 | continue; |
207 | 206 | } |
208 | 207 | } |
209 | - } |
|
210 | - elseif ( ! isset($this->fields[$this->keys[$i]])) |
|
208 | + } elseif ( ! isset($this->fields[$this->keys[$i]])) |
|
211 | 209 | { |
212 | 210 | unset($this->keys[$i]); |
213 | 211 | continue; |
@@ -104,8 +104,7 @@ discard block |
||
104 | 104 | empty($this->database) OR $this->dsn .= ';dbname='.$this->database; |
105 | 105 | empty($this->char_set) OR $this->dsn .= ';charset='.$this->char_set; |
106 | 106 | empty($this->appname) OR $this->dsn .= ';appname='.$this->appname; |
107 | - } |
|
108 | - else |
|
107 | + } else |
|
109 | 108 | { |
110 | 109 | if ( ! empty($this->char_set) && strpos($this->dsn, 'charset=', 6) === FALSE) |
111 | 110 | { |
@@ -282,8 +281,7 @@ discard block |
||
282 | 281 | if (count($this->qb_select) === 0) |
283 | 282 | { |
284 | 283 | $select = '*'; // Inevitable |
285 | - } |
|
286 | - else |
|
284 | + } else |
|
287 | 285 | { |
288 | 286 | // Use only field names and their aliases, everything else is out of our scope. |
289 | 287 | $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 | // -------------------------------------------------------------------- |
@@ -89,16 +89,14 @@ discard block |
||
89 | 89 | if ( ! empty($this->database)) |
90 | 90 | { |
91 | 91 | $this->dsn .= 'dbname='.$this->database; |
92 | - } |
|
93 | - elseif ( ! empty($this->hostname)) |
|
92 | + } elseif ( ! empty($this->hostname)) |
|
94 | 93 | { |
95 | 94 | $this->dsn .= 'dbname='.$this->hostname; |
96 | 95 | } |
97 | 96 | |
98 | 97 | empty($this->char_set) OR $this->dsn .= ';charset='.$this->char_set; |
99 | 98 | empty($this->role) OR $this->dsn .= ';role='.$this->role; |
100 | - } |
|
101 | - elseif ( ! empty($this->char_set) && strpos($this->dsn, 'charset=', 9) === FALSE) |
|
99 | + } elseif ( ! empty($this->char_set) && strpos($this->dsn, 'charset=', 9) === FALSE) |
|
102 | 100 | { |
103 | 101 | $this->dsn .= ';charset='.$this->char_set; |
104 | 102 | } |
@@ -250,8 +248,7 @@ discard block |
||
250 | 248 | { |
251 | 249 | $select = 'FIRST '.$this->qb_limit |
252 | 250 | .($this->qb_offset > 0 ? ' SKIP '.$this->qb_offset : ''); |
253 | - } |
|
254 | - else |
|
251 | + } else |
|
255 | 252 | { |
256 | 253 | $select = 'ROWS ' |
257 | 254 | .($this->qb_offset > 0 ? $this->qb_offset.' TO '.($this->qb_limit + $this->qb_offset) : $this->qb_limit); |
@@ -51,14 +51,14 @@ discard block |
||
51 | 51 | * |
52 | 52 | * @var string |
53 | 53 | */ |
54 | - protected $_rename_table = 'RENAME TABLE %s TO %s'; |
|
54 | + protected $_rename_table = 'RENAME TABLE %s TO %s'; |
|
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 | 'SMALLINT' => 'INTEGER', |
63 | 63 | 'INT' => 'BIGINT', |
64 | 64 | 'INTEGER' => 'BIGINT' |
@@ -69,7 +69,7 @@ discard block |
||
69 | 69 | * |
70 | 70 | * @var string |
71 | 71 | */ |
72 | - protected $_default = FALSE; |
|
72 | + protected $_default = FALSE; |
|
73 | 73 | |
74 | 74 | // -------------------------------------------------------------------- |
75 | 75 |