| @@ 78-99 (lines=22) @@ | ||
| 75 | * |
|
| 76 | * @return string[] |
|
| 77 | */ |
|
| 78 | public function getListNameTable () |
|
| 79 | { |
|
| 80 | if ( empty( $this->tableList ) ) |
|
| 81 | { |
|
| 82 | $strSchema = implode ( "', '" , $this->schema ); |
|
| 83 | ||
| 84 | $this->tableList = $this->getPDO ()->query ( |
|
| 85 | "SELECT table_schema, |
|
| 86 | table_name |
|
| 87 | FROM information_schema.tables |
|
| 88 | WHERE |
|
| 89 | table_type = 'BASE TABLE' |
|
| 90 | AND table_schema IN ( '$strSchema' ) |
|
| 91 | ORDER by |
|
| 92 | table_schema, |
|
| 93 | table_name |
|
| 94 | ASC" |
|
| 95 | )->fetchAll (); |
|
| 96 | } |
|
| 97 | ||
| 98 | return $this->tableList; |
|
| 99 | } |
|
| 100 | ||
| 101 | /** |
|
| 102 | * retorna multiplos arrays com dados da column em array |
|
| @@ 237-253 (lines=17) @@ | ||
| 234 | * |
|
| 235 | * @return int |
|
| 236 | */ |
|
| 237 | public function getTotalTables () |
|
| 238 | { |
|
| 239 | if ( empty( $this->totalTables ) ) |
|
| 240 | { |
|
| 241 | $strSchema = implode ( "', '" , $this->schema ); |
|
| 242 | ||
| 243 | $this->totalTables = $this->getPDO ()->query ( |
|
| 244 | "SELECT COUNT(table_name) AS total |
|
| 245 | FROM information_schema.tables |
|
| 246 | WHERE |
|
| 247 | table_type = 'BASE TABLE' |
|
| 248 | AND table_schema IN ( '" . $strSchema . "' )" |
|
| 249 | )->fetchColumn (); |
|
| 250 | } |
|
| 251 | ||
| 252 | return (int) $this->totalTables; |
|
| 253 | } |
|
| 254 | } |
|
| 255 | ||