ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest Class Reference

Collaboration diagram for ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest:

Classes
class	QueryStruct

Public Member Functions
void	setUp () throws Exception
void	tearDown () throws Exception
void	tst01_get_meta_data () throws Exception
void	tst02_heavyDB_table () throws Exception
void	tst03_heavyDB_table () throws Exception
void	tst04_heavyDB_table () throws Exception
void	tst05_user_table () throws Exception
void	tst06_user_table () throws Exception
void	tst07_user_table () throws Exception
void	tst08_user_table () throws Exception
void	tst09_user_table () throws Exception
void	tst10_heavyDB_table () throws Exception
void	tst11_user2_table () throws Exception
void	getTablePrivileges (Connection conn, QueryStruct qt, ArrayList< HashMap< String, String >> rows) throws Exception
void	getDriverVersion () throws SQLException
void	getTables () throws Exception

Static Package Attributes
static Properties	PROPERTIES = new Property_loader("metadata_test.properties")
static final ArrayList< String >	default_tables
static final ArrayList< String >	default_perms
static final String	super_user = PROPERTIES.getProperty("default_super_user")
static final String	super_password = PROPERTIES.getProperty("default_user_password")
static final String	user1 = PROPERTIES.getProperty("user1")
static final String	user1_password = PROPERTIES.getProperty("user1_password")
static final String	user_url = PROPERTIES.getProperty("user_db_connection_url")
static final String	user_table1 = PROPERTIES.getProperty("tst_table1")
static final String	user_table2 = PROPERTIES.getProperty("tst_table2")

Private Member Functions
void	run_command (Statement st, String cmd) throws SQLException
void	set_user2 () throws Exception
void	set_user1 (boolean extra_table) throws Exception
void	set_heavyDB () throws Exception
void	drop_setup () throws Exception
void	test_permissons (Connection conn, QueryStruct qt, ArrayList< String > possible_tables) throws Exception
ArrayList< String >	getTablesFromResultSet (ResultSet rs) throws SQLException

Private Attributes
Connection	m_super_conn = null

Detailed Description

Definition at line 15 of file HeavyAIDatabaseMetaDataTest.java.

Member Function Documentation

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup ( ) throws Exception

inlineprivate

Definition at line 165 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.PROPERTIES, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.run_command().

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getTables(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst02_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst03_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst04_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst11_user2_table().

                                             {
    Statement st = m_super_conn.createStatement();
    try {
      // Drop the lot even of they aren't there to make the code easier
      run_command(st, PROPERTIES.getProperty("drop_tst_table1"));
      run_command(st, PROPERTIES.getProperty("drop_tst_table2"));
      run_command(st, PROPERTIES.getProperty("drop_user1"));
      run_command(st, PROPERTIES.getProperty("drop_user2"));
      run_command(st, PROPERTIES.getProperty("drop_user_db"));
    } catch (SQLException sE) {
      System.out.println("drop_setup ERROR");
      System.out.println(sE.toString());
      throw(sE);
    } finally {
      st.close();
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getDriverVersion ( ) throws SQLException

inline

Definition at line 488 of file HeavyAIDatabaseMetaDataTest.java.

                                                     {
    int max = m_super_conn.getMetaData().getDatabaseMajorVersion();
    assertNotEquals(0, max);
    int min = m_super_conn.getMetaData().getDatabaseMinorVersion();
    assertNotEquals(0, max);
  }

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getTablePrivileges ( Connection  conn, QueryStruct  qt, ArrayList< HashMap< String, String >>  rows  ) throws Exception

inline

Definition at line 443 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.QueryStruct.D, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.QueryStruct.S, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.QueryStruct.T.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons().

                           {
    {
      ResultSet privileges = conn.getMetaData().getTablePrivileges(qt.D, qt.S, qt.T);
      assertEquals(7, privileges.getMetaData().getColumnCount());

      while (privileges.next()) {
        HashMap<String, String> record = new HashMap<String, String>();
        record.put("TABLE_CAT", privileges.getString("TABLE_CAT"));
        record.put("TABLE_SCHEM", privileges.getString("TABLE_SCHEM"));
        record.put("TABLE_NAME", privileges.getString("TABLE_NAME"));
        record.put("PRIVILEGE", privileges.getString("PRIVILEGE"));
        record.put("GRANTOR", privileges.getString("GRANTOR"));
        record.put("GRANTEE", privileges.getString("GRANTEE"));
        record.put("IS_GRANTABLE", privileges.getString("IS_GRANTABLE"));
        rows.add(record);
      }
    }
  }

Here is the caller graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getTables ( ) throws Exception

inline

Definition at line 532 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getTablesFromResultSet(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_heavyDB().

                                           {
    ArrayList<String> heavyDB_2_tables = new ArrayList<String>() {
      {
        add("test_base_table1");
        add("test_base_table2");
        add("test_base_table3");
      }
    };
    ArrayList<String> system_tables = new ArrayList<String>() {
      {
        add("dashboards");
        add("databases");
        add("memory_details");
        add("memory_summary");
        add("permissions");
        add("role_assignments");
        add("roles");
        add("storage_details");
        add("tables");
        add("users");
      }
    };

    set_heavyDB();
    ResultSet heavyDB_2_tables_result_set =
            m_super_conn.getMetaData().getTables("heavyDB_2", null, null, null);
    ArrayList<String> actual_heavyDB_2_tables =
            getTablesFromResultSet(heavyDB_2_tables_result_set);
    assertEquals(heavyDB_2_tables, actual_heavyDB_2_tables);

    ResultSet system_tables_result_set =
            m_super_conn.getMetaData().getTables("information_schema", null, null, null);
    ArrayList<String> actual_system_tables =
            getTablesFromResultSet(system_tables_result_set);
    assertTrue(actual_system_tables.containsAll(system_tables));
    drop_setup();
  }

Here is the call graph for this function:

ArrayList<String> ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getTablesFromResultSet ( ResultSet  rs ) throws SQLException

inlineprivate

Definition at line 517 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getTables().

                                                                                     {
    ArrayList<String> sorted_tables = new ArrayList<String>();
    int column_count = rs.getMetaData().getColumnCount();
    while (rs.next()) {
      for (int i = 1; i <= column_count; i++) {
        if (rs.getMetaData().getColumnName(i) == "TABLE_NAME") {
          sorted_tables.add(rs.getString(i));
        }
      }
    }
    Collections.sort(sorted_tables);
    return sorted_tables;
  }

Here is the caller graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.run_command ( Statement  st, String  cmd  ) throws SQLException

inlineprivate

Definition at line 84 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_heavyDB(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user2(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.setUp(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tearDown().

                                                                         {
    try {
      st.executeUpdate(cmd);
    } catch (SQLException sE) {
      // Intention is to ignore simple object does not exist
      // errors on drop commands
      if (0 != sE.getErrorCode()) {
        System.out.println("run_command ERROR");
        System.out.println(sE.toString());
        throw(sE);
      }
    }
  }

Here is the caller graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_heavyDB ( ) throws Exception

inlineprivate

Definition at line 145 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.PROPERTIES, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.run_command().

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getTables(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst02_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst03_heavyDB_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst04_heavyDB_table().

                                              {
    Statement st = m_super_conn.createStatement();
    try {
      run_command(st, PROPERTIES.getProperty("drop_base_table1"));
      run_command(st, PROPERTIES.getProperty("create_base_table1"));
      run_command(st, PROPERTIES.getProperty("drop_base_table2"));
      run_command(st, PROPERTIES.getProperty("create_base_table2"));
      run_command(st, PROPERTIES.getProperty("drop_base_table3"));
      run_command(st, PROPERTIES.getProperty("create_base_table3"));
    } catch (SQLException sE) {
      System.out.println("set_user1 ERROR");
      System.out.println(sE.toString());
      throw(sE);
    } finally {
      st.close();
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1 ( boolean  extra_table ) throws Exception

inlineprivate

Definition at line 116 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.PROPERTIES, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.run_command(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1_password, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst11_user2_table().

                                                               {
    Statement st = m_super_conn.createStatement();
    Connection conn = null;
    try {
      run_command(st, PROPERTIES.getProperty("drop_user1"));
      run_command(st, PROPERTIES.getProperty("drop_user_db"));

      run_command(st, PROPERTIES.getProperty("create_user1"));
      run_command(st, PROPERTIES.getProperty("create_user_db"));
      st.close();

      conn = DriverManager.getConnection(user_url, user1, user1_password);
      st = conn.createStatement();
      run_command(st, PROPERTIES.getProperty("drop_tst_table1"));
      run_command(st, PROPERTIES.getProperty("create_tst_table1"));
      if (extra_table == true) {
        run_command(st, PROPERTIES.getProperty("drop_tst_table2"));
        run_command(st, PROPERTIES.getProperty("create_tst_table2"));
      }
    } catch (SQLException sE) {
      System.out.println("set_user1 ERROR");
      System.out.println(sE.toString());
      throw(sE);
    } finally {
      st.close();
      if (conn != null) conn.close();
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user2 ( ) throws Exception

inlineprivate

Definition at line 98 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.PROPERTIES, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.run_command(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_password, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_user, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst11_user2_table().

                                            {
    Connection x_conn = DriverManager.getConnection(user_url, super_user, super_password);
    Statement st = x_conn.createStatement();
    try {
      run_command(st, PROPERTIES.getProperty("drop_user2"));
      run_command(st, PROPERTIES.getProperty("create_user2"));
      run_command(st, PROPERTIES.getProperty("grant_user2_db_access"));
      run_command(st, PROPERTIES.getProperty("grant_user2_tble_select"));
    } catch (SQLException sE) {
      System.out.println("set_user2 ERROR");
      System.out.println(sE.toString());
      throw(sE);
    } finally {
      st.close();
      x_conn.close();
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.setUp ( ) throws Exception

inline

Definition at line 51 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.m_super_conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.PROPERTIES, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.run_command(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_password, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_user.

                                       {
    // 1. Connect to the default db to create the actual db used for the tests
    Connection l_conn = DriverManager.getConnection(
            PROPERTIES.getProperty("default_db_connection_url"),
            super_user,
            super_password);
    Statement st = l_conn.createStatement();
    // 2. Create base db and connect.  Shouldn't need to reconnect to
    // the default db again.
    run_command(st, PROPERTIES.getProperty("drop_base_db"));
    run_command(st, PROPERTIES.getProperty("create_base_db"));
    st.close();
    l_conn.close();

    m_super_conn = DriverManager.getConnection(
            PROPERTIES.getProperty("base_db_connection_url"), super_user, super_password);
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tearDown ( ) throws Exception

inline

Definition at line 70 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.PROPERTIES, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.run_command(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_password, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_user.

                                          {
    m_super_conn.close();
    // When we drop a DB all its connections are invalidated, so we do it from
    // a connection to another DB
    Connection default_conn = DriverManager.getConnection(
            PROPERTIES.getProperty("default_db_connection_url"),
            super_user,
            super_password);
    Statement st = default_conn.createStatement();
    run_command(st, PROPERTIES.getProperty("drop_base_db"));
    st.close();
    default_conn.close();
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons ( Connection  conn, QueryStruct  qt, ArrayList< String >  possible_tables  ) throws Exception

inlineprivate

Definition at line 409 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_perms, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.getTablePrivileges(), Integer, and report.rows.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst02_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst03_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst04_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst11_user2_table().

                           {
    ArrayList<HashMap<String, String>> rows = new ArrayList<HashMap<String, String>>();

    getTablePrivileges(conn, qt, rows);
    assertEquals(qt.result_count, rows.size());

    HashMap<String, Integer> record_count_accumulator = new HashMap<String, Integer>();
    for (HashMap<String, String> record : rows) {
      String table_name = record.get("TABLE_NAME");

      assertTrue(possible_tables.contains(table_name));
      String privilege = record.get("PRIVILEGE");
      String grantee = record.get("GRANTEE");
      assertTrue(default_perms.contains(privilege));
      // Count all records for a table_name + privilege + grantee.
      // Should only be one each
      String key = table_name + privilege + grantee;
      // insert zero if new record and alway increment
      record_count_accumulator.put(
              key, record_count_accumulator.getOrDefault(key, 0) + 1);
    }
    // Since there are the correct number of perms returned
    // and each perm is only listed once this should mean all the type
    // of perms are present
    for (Integer count : record_count_accumulator.values()) {
      // Check each instance only orrurs once.
      assertEquals(1, count.intValue());
    }

    rows.clear();
  }

Here is the call graph for this function:

Here is the caller graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst01_get_meta_data ( ) throws Exception

inline

Definition at line 184 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_user.

                                                     {
    DatabaseMetaData dM = m_super_conn.getMetaData();
    assertEquals(super_user, dM.getUserName());
    assertNotEquals(null, dM.getDatabaseProductVersion());
  }

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst02_heavyDB_table ( ) throws Exception

inline

Definition at line 198 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_tables, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.m_super_conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_heavyDB(), heavydb.dtypes.T, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons().

                                                     {
    // Get all of the tables in the base_db as super user
    set_heavyDB();
    QueryStruct qS = new QueryStruct() {
      {
        D = "%";
        S = "%";
        T = "%";
        result_count = 24;
      }
    };
    test_permissons(m_super_conn, qS, default_tables);
    drop_setup();
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst03_heavyDB_table ( ) throws Exception

inline

Definition at line 214 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_tables, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.m_super_conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_heavyDB(), heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1.

                                                     {
    // Get one specfic table in the base_db as super user
    set_heavyDB();
    QueryStruct qS = new QueryStruct() {
      {
        D = "%";
        S = "%";
        T = PROPERTIES.getProperty("base_t3");
        result_count = 8;
      }
    };
    ArrayList<String> possible_tables = default_tables;
    possible_tables.add(user_table1);
    test_permissons(m_super_conn, qS, possible_tables);
    drop_setup();
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst04_heavyDB_table ( ) throws Exception

inline

Definition at line 232 of file HeavyAIDatabaseMetaDataTest.java.

References ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_tables, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.m_super_conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_heavyDB(), heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1.

                                                     {
    // Get a specfic table in the base_db as super user with a wild card search
    set_heavyDB();
    QueryStruct qS = new QueryStruct() {
      {
        D = PROPERTIES.getProperty("default_db");
        S = "%";
        T = PROPERTIES.getProperty("base_table_ptrn");
        result_count = 8;
      }
    };
    ArrayList<String> possible_tables = default_tables;
    possible_tables.add(user_table1);
    test_permissons(m_super_conn, qS, possible_tables);
    drop_setup();
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table ( ) throws Exception

inline

Definition at line 250 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_tables, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1_password, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

                                                  {
    // Get the only table in the user_db as user1 using a wild card
    boolean extra_table = false;
    set_user1(extra_table); // create database and a single test table
    QueryStruct qS = new QueryStruct() {
      {
        D = "%";
        S = "%";
        T = "%";
        result_count = 8;
      }
    };
    Connection conn = DriverManager.getConnection(user_url, user1, user1_password);
    ArrayList<String> possible_tables = default_tables;
    possible_tables.add(user_table1);
    test_permissons(conn, qS, possible_tables);
    conn.close(); // close connection
    drop_setup(); // drop user1 and tables
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table ( ) throws Exception

inline

Definition at line 271 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_tables, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1_password, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

                                                  {
    // Get the only table by name in the user_db as user1
    boolean extra_table = false;
    set_user1(extra_table); // create database and a single test table
    QueryStruct qS = new QueryStruct() {
      {
        D = "%";
        S = "%";
        T = user_table1;
        result_count = 8;
      }
    };
    Connection conn = DriverManager.getConnection(user_url, user1, user1_password);
    ArrayList<String> possible_tables = default_tables;
    possible_tables.add(user_table1);
    test_permissons(conn, qS, possible_tables);
    conn.close(); // close connection
    drop_setup(); // drop user1 and tables
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table ( ) throws Exception

inline

Definition at line 292 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_tables, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1_password, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

                                                  {
    // Get the only table in the user_db as user1 using null for table name
    boolean extra_table = false;
    set_user1(extra_table); // create database and a single test table
    QueryStruct qS = new QueryStruct() {
      {
        D = "%";
        S = "%";
        T = null;
        result_count = 8;
      }
    };
    Connection conn = DriverManager.getConnection(user_url, user1, user1_password);
    ArrayList<String> possible_tables = default_tables;
    possible_tables.add(user_table1);
    test_permissons(conn, qS, possible_tables);
    conn.close(); // close connection
    drop_setup(); // drop user1 and tables
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table ( ) throws Exception

inline

Definition at line 313 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_tables, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1_password, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table2, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

                                                  {
    // Get the two table in the user_db as user1 using a wild card
    boolean extra_table = true;
    set_user1(extra_table); // create database and a single test table
    QueryStruct qS = new QueryStruct() {
      {
        D = "%";
        S = "%";
        T = PROPERTIES.getProperty("table_ptrn");
        result_count = 16;
      }
    };
    Connection conn = DriverManager.getConnection(user_url, user1, user1_password);
    ArrayList<String> possible_tables = default_tables;
    possible_tables.add(user_table1);
    possible_tables.add(user_table2); // add extra table to reference
    test_permissons(conn, qS, possible_tables);
    conn.close(); // close connection
    drop_setup(); // drop user1 and tables
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table ( ) throws Exception

inline

Definition at line 335 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1_password, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table2, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

                                                  {
    // Get the two table in the user_db as user1 using a wild card
    boolean extra_table = true;
    set_user1(extra_table); // create database and a single test table
    QueryStruct qS = new QueryStruct() {
      {
        D = PROPERTIES.getProperty("user_db");
        S = "%";
        T = PROPERTIES.getProperty("table_ptrn");
        result_count = 16;
      }
    };
    ArrayList<String> possible_tables = new ArrayList<String>() {
      { add(user_table1); }
      { add(user_table2); }
    };
    Connection conn = DriverManager.getConnection(user_url, user1, user1_password);
    test_permissons(conn, qS, possible_tables);
    conn.close(); // close connection
    drop_setup(); // drop user1 and tables
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table ( ) throws Exception

inline

Definition at line 358 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_password, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_user, heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table2, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

                                                     {
    // Get the two table in the user_db as super user using a wild card
    boolean extra_table = true;
    set_user1(extra_table); // create database and a single test table
    QueryStruct qS = new QueryStruct() {
      {
        D = PROPERTIES.getProperty("user_db");
        S = "%";
        T = PROPERTIES.getProperty("table_ptrn");
        result_count = 32; //  rows returned are 2 tables * 8 permissions * 2 users; super
                           //  user and user1
      }
    };
    ArrayList<String> possible_tables = new ArrayList<String>() {
      { add(user_table1); }
      { add(user_table2); }
    };
    Connection conn = DriverManager.getConnection(user_url, super_user, super_password);
    test_permissons(conn, qS, possible_tables);
    conn.close(); // close connection
    drop_setup(); // drop user1 and tables
  }

Here is the call graph for this function:

void ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst11_user2_table ( ) throws Exception

inline

Definition at line 382 of file HeavyAIDatabaseMetaDataTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.PROPERTIES, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user2(), heavydb.dtypes.T, ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1, and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url.

                                                   {
    // Get a single table in the user_db as user2 user using a wild card
    // user2 only has select access on a single table
    boolean extra_table = true;
    set_user1(extra_table); // create database and a single test table
    set_user2(); // create database and a single test table
    QueryStruct qS = new QueryStruct() {
      {
        D = PROPERTIES.getProperty("user_db");
        S = "%";
        T = PROPERTIES.getProperty("table_ptrn");
        result_count = 1; //  rows returned are 1 tables * 1 permissions * 1 users; user2
      }
    };
    ArrayList<String> possible_tables = new ArrayList<String>() {
      { add(user_table1); }
    };

    Connection conn = DriverManager.getConnection(user_url,
            PROPERTIES.getProperty("user2"),
            PROPERTIES.getProperty("user2_password"));

    test_permissons(conn, qS, possible_tables);
    conn.close(); // close connection
    drop_setup(); // drop user1 and tables
  }

Here is the call graph for this function:

Member Data Documentation

final ArrayList<String> ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_perms

staticpackage

Initial value:

= new ArrayList<String>() {
    {
      add("CREATE");
      add("DROP");
      add("SELECT");
      add("INSERT");
      add("UPDATE");
      add("DELETE");
      add("TRUNCATE");
      add("ALTER");
    }
  }

Definition at line 26 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.test_permissons().

final ArrayList<String> ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.default_tables

staticpackage

Initial value:

= new ArrayList<String>() {
    {
      add(PROPERTIES.getProperty("base_t1"));
      add(PROPERTIES.getProperty("base_t2"));
      add(PROPERTIES.getProperty("base_t3"));
    }
  }

Definition at line 18 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst02_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst03_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst04_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table().

Connection ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.m_super_conn = null

private

Definition at line 48 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.setUp(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst02_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst03_heavyDB_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst04_heavyDB_table().

Properties ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.PROPERTIES = new Property_loader("metadata_test.properties")

staticpackage

Definition at line 16 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.drop_setup(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_heavyDB(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user2(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.setUp(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tearDown(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst11_user2_table().

final String ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_password = PROPERTIES.getProperty("default_user_password")

staticpackage

Definition at line 40 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user2(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.setUp(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tearDown(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table().

final String ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.super_user = PROPERTIES.getProperty("default_super_user")

staticpackage

Definition at line 39 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user2(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.setUp(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tearDown(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst01_get_meta_data(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table().

final String ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1 = PROPERTIES.getProperty("user1")

staticpackage

Definition at line 42 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table().

final String ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user1_password = PROPERTIES.getProperty("user1_password")

staticpackage

Definition at line 43 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table().

final String ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table1 = PROPERTIES.getProperty("tst_table1")

staticpackage

Definition at line 45 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst03_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst04_heavyDB_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst11_user2_table().

final String ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_table2 = PROPERTIES.getProperty("tst_table2")

staticpackage

Definition at line 46 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table().

final String ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.user_url = PROPERTIES.getProperty("user_db_connection_url")

staticpackage

Definition at line 44 of file HeavyAIDatabaseMetaDataTest.java.

Referenced by ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user1(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.set_user2(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst05_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst06_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst07_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst08_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst09_user_table(), ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst10_heavyDB_table(), and ai.heavy.jdbc.HeavyAIDatabaseMetaDataTest.tst11_user2_table().

---

The documentation for this class was generated from the following file:

• /home/jenkins-slave/workspace/core-os-doxygen/java/heavyaijdbc/src/test/java/ai/heavy/jdbc/HeavyAIDatabaseMetaDataTest.java