src/Model/Dao/MysqlSchemaDao.php
public function getTableSchema(string $db, string $inc, string $exc): array
    {
        $query = Query::table('information_schema.`tables`')->where('TABLE_SCHEMA', $db)->where('TABLE_TYPE', 'BASE TABLE');
        if (!empty($inc)) {
            $query = $query->whereIn('TABLE_NAME', explode(',', $inc));
        }

        if (!empty($exc)) {
            $query = $query->whereNotIn('TABLE_NAME', explode(',', $exc));
        }

        $columns = [
            'TABLE_NAME'    => 'name',
            'TABLE_COMMENT' => 'comment',
        ];

        return $query->get($columns)->getResult();
    }
public function getTableSchema(string $db, string $inc, string $exc): array
    {
        $query = Query::table('information_schema.`tables`')->where('TABLE_SCHEMA', $db)->where('TABLE_TYPE', 'BASE TABLE');
        if (!empty($inc)) {
            $query = $query->whereIn('TABLE_NAME', explode(',', $inc));
        }

        if (!empty($exc)) {
            $query = $query->whereNotIn('TABLE_NAME', explode(',', $exc));
        }

        $columns = [
            'TABLE_NAME'    => 'name',
            'TABLE_COMMENT' => 'comment',
        ];

        return $query->get($columns)->getResult();
    }
public function getTableSchema ( string $ db , string $ inc , string $ exc ) : array { $ query = Query :: table ( 'information_schema.`tables`' ) -> where ( 'TABLE_SCHEMA' , $ db ) -> where ( 'TABLE_TYPE' , 'BASE TABLE' ) ; if ( ! empty ( $ inc ) ) { $ query = $ query -> whereIn ( 'TABLE_NAME' , explode ( ',' , $ inc ) ) ; } if ( ! empty ( $ exc ) ) { $ query = $ query -> whereNotIn ( 'TABLE_NAME' , explode ( ',' , $ exc ) ) ; } $ columns = [ 'TABLE_NAME' => 'name' , 'TABLE_COMMENT' => 'comment' , ] ; return $ query -> get ( $ columns ) -> getResult ( ) ; }
@param string $db
@param string $inc
@param string $exc

@return array
@param string $db @param string $inc @param string $exc