system/database/drivers/ibase/ibase_driver.php 1 location
|
@@ 223-234 (lines=12) @@
|
| 220 |
|
* @param bool $prefix_limit |
| 221 |
|
* @return string |
| 222 |
|
*/ |
| 223 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 224 |
|
{ |
| 225 |
|
$sql = 'SELECT TRIM("RDB$RELATION_NAME") AS TABLE_NAME FROM "RDB$RELATIONS" WHERE "RDB$RELATION_NAME" NOT LIKE \'RDB$%\' AND "RDB$RELATION_NAME" NOT LIKE \'MON$%\''; |
| 226 |
|
|
| 227 |
|
if ($prefix_limit !== FALSE && $this->dbprefix !== '') |
| 228 |
|
{ |
| 229 |
|
return $sql.' AND TRIM("RDB$RELATION_NAME") AS TABLE_NAME LIKE \''.$this->escape_like_str($this->dbprefix)."%' " |
| 230 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 231 |
|
} |
| 232 |
|
|
| 233 |
|
return $sql; |
| 234 |
|
} |
| 235 |
|
|
| 236 |
|
// -------------------------------------------------------------------- |
| 237 |
|
|
system/database/drivers/mysql/mysql_driver.php 1 location
|
@@ 366-376 (lines=11) @@
|
| 363 |
|
* @param bool $prefix_limit |
| 364 |
|
* @return string |
| 365 |
|
*/ |
| 366 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 367 |
|
{ |
| 368 |
|
$sql = 'SHOW TABLES FROM '.$this->escape_identifiers($this->database); |
| 369 |
|
|
| 370 |
|
if ($prefix_limit !== FALSE && $this->dbprefix !== '') |
| 371 |
|
{ |
| 372 |
|
return $sql." LIKE '".$this->escape_like_str($this->dbprefix)."%'"; |
| 373 |
|
} |
| 374 |
|
|
| 375 |
|
return $sql; |
| 376 |
|
} |
| 377 |
|
|
| 378 |
|
// -------------------------------------------------------------------- |
| 379 |
|
|
system/database/drivers/mysqli/mysqli_driver.php 1 location
|
@@ 387-397 (lines=11) @@
|
| 384 |
|
* @param bool $prefix_limit |
| 385 |
|
* @return string |
| 386 |
|
*/ |
| 387 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 388 |
|
{ |
| 389 |
|
$sql = 'SHOW TABLES FROM '.$this->escape_identifiers($this->database); |
| 390 |
|
|
| 391 |
|
if ($prefix_limit !== FALSE && $this->dbprefix !== '') |
| 392 |
|
{ |
| 393 |
|
return $sql." LIKE '".$this->escape_like_str($this->dbprefix)."%'"; |
| 394 |
|
} |
| 395 |
|
|
| 396 |
|
return $sql; |
| 397 |
|
} |
| 398 |
|
|
| 399 |
|
// -------------------------------------------------------------------- |
| 400 |
|
|
system/database/drivers/odbc/odbc_driver.php 1 location
|
@@ 236-247 (lines=12) @@
|
| 233 |
|
* @param bool $prefix_limit |
| 234 |
|
* @return string |
| 235 |
|
*/ |
| 236 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 237 |
|
{ |
| 238 |
|
$sql = "SELECT table_name FROM information_schema.tables WHERE table_schema = '".$this->schema."'"; |
| 239 |
|
|
| 240 |
|
if ($prefix_limit !== FALSE && $this->dbprefix !== '') |
| 241 |
|
{ |
| 242 |
|
return $sql." AND table_name LIKE '".$this->escape_like_str($this->dbprefix)."%' " |
| 243 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 244 |
|
} |
| 245 |
|
|
| 246 |
|
return $sql; |
| 247 |
|
} |
| 248 |
|
|
| 249 |
|
// -------------------------------------------------------------------- |
| 250 |
|
|
system/database/drivers/pdo/subdrivers/pdo_firebird_driver.php 1 location
|
@@ 117-128 (lines=12) @@
|
| 114 |
|
* @param bool $prefix_limit |
| 115 |
|
* @return string |
| 116 |
|
*/ |
| 117 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 118 |
|
{ |
| 119 |
|
$sql = 'SELECT "RDB$RELATION_NAME" FROM "RDB$RELATIONS" WHERE "RDB$RELATION_NAME" NOT LIKE \'RDB$%\' AND "RDB$RELATION_NAME" NOT LIKE \'MON$%\''; |
| 120 |
|
|
| 121 |
|
if ($prefix_limit === TRUE && $this->dbprefix !== '') |
| 122 |
|
{ |
| 123 |
|
return $sql.' AND "RDB$RELATION_NAME" LIKE \''.$this->escape_like_str($this->dbprefix)."%' " |
| 124 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 125 |
|
} |
| 126 |
|
|
| 127 |
|
return $sql; |
| 128 |
|
} |
| 129 |
|
|
| 130 |
|
// -------------------------------------------------------------------- |
| 131 |
|
|
system/database/drivers/pdo/subdrivers/pdo_odbc_driver.php 1 location
|
@@ 171-182 (lines=12) @@
|
| 168 |
|
* @param bool $prefix_limit |
| 169 |
|
* @return string |
| 170 |
|
*/ |
| 171 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 172 |
|
{ |
| 173 |
|
$sql = "SELECT table_name FROM information_schema.tables WHERE table_schema = '".$this->schema."'"; |
| 174 |
|
|
| 175 |
|
if ($prefix_limit !== FALSE && $this->dbprefix !== '') |
| 176 |
|
{ |
| 177 |
|
return $sql." AND table_name LIKE '".$this->escape_like_str($this->dbprefix)."%' " |
| 178 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 179 |
|
} |
| 180 |
|
|
| 181 |
|
return $sql; |
| 182 |
|
} |
| 183 |
|
|
| 184 |
|
// -------------------------------------------------------------------- |
| 185 |
|
|
system/database/drivers/pdo/subdrivers/pdo_pgsql_driver.php 1 location
|
@@ 225-237 (lines=13) @@
|
| 222 |
|
* @param bool $prefix_limit |
| 223 |
|
* @return string |
| 224 |
|
*/ |
| 225 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 226 |
|
{ |
| 227 |
|
$sql = 'SELECT "table_name" FROM "information_schema"."tables" WHERE "table_schema" = \''.$this->schema."'"; |
| 228 |
|
|
| 229 |
|
if ($prefix_limit === TRUE && $this->dbprefix !== '') |
| 230 |
|
{ |
| 231 |
|
return $sql.' AND "table_name" LIKE \'' |
| 232 |
|
.$this->escape_like_str($this->dbprefix)."%' " |
| 233 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 234 |
|
} |
| 235 |
|
|
| 236 |
|
return $sql; |
| 237 |
|
} |
| 238 |
|
|
| 239 |
|
// -------------------------------------------------------------------- |
| 240 |
|
|
system/database/drivers/pdo/subdrivers/pdo_sqlite_driver.php 1 location
|
@@ 108-119 (lines=12) @@
|
| 105 |
|
* @param bool $prefix_limit |
| 106 |
|
* @return string |
| 107 |
|
*/ |
| 108 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 109 |
|
{ |
| 110 |
|
$sql = 'SELECT "NAME" FROM "SQLITE_MASTER" WHERE "TYPE" = \'table\''; |
| 111 |
|
|
| 112 |
|
if ($prefix_limit === TRUE && $this->dbprefix !== '') |
| 113 |
|
{ |
| 114 |
|
return $sql.' AND "NAME" LIKE \''.$this->escape_like_str($this->dbprefix)."%' " |
| 115 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 116 |
|
} |
| 117 |
|
|
| 118 |
|
return $sql; |
| 119 |
|
} |
| 120 |
|
|
| 121 |
|
// -------------------------------------------------------------------- |
| 122 |
|
|
system/database/drivers/postgre/postgre_driver.php 1 location
|
@@ 399-411 (lines=13) @@
|
| 396 |
|
* @param bool $prefix_limit |
| 397 |
|
* @return string |
| 398 |
|
*/ |
| 399 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 400 |
|
{ |
| 401 |
|
$sql = 'SELECT "table_name" FROM "information_schema"."tables" WHERE "table_schema" = \''.$this->schema."'"; |
| 402 |
|
|
| 403 |
|
if ($prefix_limit !== FALSE && $this->dbprefix !== '') |
| 404 |
|
{ |
| 405 |
|
return $sql.' AND "table_name" LIKE \'' |
| 406 |
|
.$this->escape_like_str($this->dbprefix)."%' " |
| 407 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 408 |
|
} |
| 409 |
|
|
| 410 |
|
return $sql; |
| 411 |
|
} |
| 412 |
|
|
| 413 |
|
// -------------------------------------------------------------------- |
| 414 |
|
|
system/database/drivers/sqlite/sqlite_driver.php 1 location
|
@@ 203-213 (lines=11) @@
|
| 200 |
|
* @param bool $prefix_limit |
| 201 |
|
* @return string |
| 202 |
|
*/ |
| 203 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 204 |
|
{ |
| 205 |
|
$sql = "SELECT name FROM sqlite_master WHERE type='table'"; |
| 206 |
|
|
| 207 |
|
if ($prefix_limit !== FALSE && $this->dbprefix != '') |
| 208 |
|
{ |
| 209 |
|
return $sql." AND 'name' LIKE '".$this->escape_like_str($this->dbprefix)."%' ".sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 210 |
|
} |
| 211 |
|
|
| 212 |
|
return $sql; |
| 213 |
|
} |
| 214 |
|
|
| 215 |
|
// -------------------------------------------------------------------- |
| 216 |
|
|
system/database/drivers/oci8/oci8_driver.php 1 location
|
@@ 455-466 (lines=12) @@
|
| 452 |
|
* @param bool $prefix_limit |
| 453 |
|
* @return string |
| 454 |
|
*/ |
| 455 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 456 |
|
{ |
| 457 |
|
$sql = 'SELECT "TABLE_NAME" FROM "ALL_TABLES"'; |
| 458 |
|
|
| 459 |
|
if ($prefix_limit !== FALSE && $this->dbprefix !== '') |
| 460 |
|
{ |
| 461 |
|
return $sql.' WHERE "TABLE_NAME" LIKE \''.$this->escape_like_str($this->dbprefix)."%' " |
| 462 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 463 |
|
} |
| 464 |
|
|
| 465 |
|
return $sql; |
| 466 |
|
} |
| 467 |
|
|
| 468 |
|
// -------------------------------------------------------------------- |
| 469 |
|
|
system/database/drivers/pdo/subdrivers/pdo_oci_driver.php 1 location
|
@@ 163-174 (lines=12) @@
|
| 160 |
|
* @param bool $prefix_limit |
| 161 |
|
* @return string |
| 162 |
|
*/ |
| 163 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 164 |
|
{ |
| 165 |
|
$sql = 'SELECT "TABLE_NAME" FROM "ALL_TABLES"'; |
| 166 |
|
|
| 167 |
|
if ($prefix_limit === TRUE && $this->dbprefix !== '') |
| 168 |
|
{ |
| 169 |
|
return $sql.' WHERE "TABLE_NAME" LIKE \''.$this->escape_like_str($this->dbprefix)."%' " |
| 170 |
|
.sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 171 |
|
} |
| 172 |
|
|
| 173 |
|
return $sql; |
| 174 |
|
} |
| 175 |
|
|
| 176 |
|
// -------------------------------------------------------------------- |
| 177 |
|
|
ci-bonfire /
Sprint
