Esempio n. 1
0
 protected function getColumns($tableName, $tableSchema = 'public')
 {
     $dataSource = call_user_func([$this->modelParentClass, '_getDataSource'], 'default');
     $query = "SELECT * FROM `information_schema`.`columns` WHERE `table_name` = ``{$tableName}`` AND `table_schema` = ``{$tableSchema}``";
     $columns = $dataSource->processRecords($dataSource->query(DbExpr::create($query)));
     if (empty($columns)) {
         $this->line("Table [{$tableName}] possibly not exists");
         return false;
     }
     $columns = Set::combine($columns, '/column_name', '/.');
     return $columns;
 }