Class ColumnTableAnalyzer


  • public class ColumnTableAnalyzer
    extends Object
    Created by arcuri82 on 24-Apr-19.
    • Constructor Detail

      • ColumnTableAnalyzer

        public ColumnTableAnalyzer()
    • Method Detail

      • getDeletedTables

        public static Set<String> getDeletedTables​(String delete)
      • getSelectReadDataFields

        public static Map<String,​Set<String>> getSelectReadDataFields​(String select)
        Given a SELECT, check what it returns is based on (columns and tables). Something like "select x from Foo" would give info on "Foo->{x}". However, at times, what is returned is not directly the content of a column, but rather some computations on it. For example, in "select avg(x) from Foo", we would still be just interested in the info that the data in "Foo->{x}" was used to compute the result.
        Parameters:
        select - SQL select command
        Returns:
        a map from table_names to column_names