ci-bonfire /
Sprint
| @@ 164-180 (lines=17) @@ | ||
| 161 | * @param string $table |
|
| 162 | * @return string |
|
| 163 | */ |
|
| 164 | protected function _list_columns($table = '') |
|
| 165 | { |
|
| 166 | if (strpos($table, '.') !== FALSE) |
|
| 167 | { |
|
| 168 | sscanf($table, '%[^.].%s', $owner, $table); |
|
| 169 | } |
|
| 170 | else |
|
| 171 | { |
|
| 172 | $owner = $this->username; |
|
| 173 | } |
|
| 174 | ||
| 175 | return 'SELECT "colname" FROM "systables", "syscolumns" |
|
| 176 | WHERE "systables"."tabid" = "syscolumns"."tabid" |
|
| 177 | AND "systables"."tabtype" = \'T\' |
|
| 178 | AND LOWER("systables"."owner") = '.$this->escape(strtolower($owner)).' |
|
| 179 | AND LOWER("systables"."tabname") = '.$this->escape(strtolower($table)); |
|
| 180 | } |
|
| 181 | ||
| 182 | // -------------------------------------------------------------------- |
|
| 183 | ||
| @@ 478-492 (lines=15) @@ | ||
| 475 | * @param string $table |
|
| 476 | * @return string |
|
| 477 | */ |
|
| 478 | protected function _list_columns($table = '') |
|
| 479 | { |
|
| 480 | if (strpos($table, '.') !== FALSE) |
|
| 481 | { |
|
| 482 | sscanf($table, '%[^.].%s', $owner, $table); |
|
| 483 | } |
|
| 484 | else |
|
| 485 | { |
|
| 486 | $owner = $this->username; |
|
| 487 | } |
|
| 488 | ||
| 489 | return 'SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS |
|
| 490 | WHERE UPPER(OWNER) = '.$this->escape(strtoupper($owner)).' |
|
| 491 | AND UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table)); |
|
| 492 | } |
|
| 493 | ||
| 494 | // -------------------------------------------------------------------- |
|
| 495 | ||
| @@ 186-200 (lines=15) @@ | ||
| 183 | * @param string $table |
|
| 184 | * @return string |
|
| 185 | */ |
|
| 186 | protected function _list_columns($table = '') |
|
| 187 | { |
|
| 188 | if (strpos($table, '.') !== FALSE) |
|
| 189 | { |
|
| 190 | sscanf($table, '%[^.].%s', $owner, $table); |
|
| 191 | } |
|
| 192 | else |
|
| 193 | { |
|
| 194 | $owner = $this->username; |
|
| 195 | } |
|
| 196 | ||
| 197 | return 'SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS |
|
| 198 | WHERE UPPER(OWNER) = '.$this->escape(strtoupper($owner)).' |
|
| 199 | AND UPPER(TABLE_NAME) = '.$this->escape(strtoupper($table)); |
|
| 200 | } |
|
| 201 | ||
| 202 | // -------------------------------------------------------------------- |
|
| 203 | ||
