ai.heavy.jdbc.HeavyAIArrayTest Class Reference

Collaboration diagram for ai.heavy.jdbc.HeavyAIArrayTest:

Public Member Functions
void	setUp () throws Exception
void	tearDown () throws Exception
void	create_and_read_array_test () throws Exception
void	insert_select_test () throws Exception
void	illegal_arguments_test () throws Exception

Static Package Attributes
static Properties	PROPERTIES = new Property_loader("prepare_test.properties")
static final String	url = PROPERTIES.getProperty("default_db_connection_url")
static final String	user = PROPERTIES.getProperty("default_super_user")
static final String	password = PROPERTIES.getProperty("default_user_password")
static final Integer[]	ia = {100, null, 200, 300, 400, 500}
static final Float[]	fa = {null, null, 1.0001f, 12.541f, null}
static final BigDecimal[]	da
static final String[]	sa = {"Hello", null, "World", "!"}
static final Timestamp[]	ta

Private Attributes
Connection	m_conn = null

Detailed Description

Definition at line 18 of file HeavyAIArrayTest.java.

Member Function Documentation

void ai.heavy.jdbc.HeavyAIArrayTest.create_and_read_array_test ( ) throws Exception

inline

Definition at line 54 of file HeavyAIArrayTest.java.

References ai.heavy.jdbc.HeavyAIArrayTest.da, ai.heavy.jdbc.HeavyAIArrayTest.fa, Float, ai.heavy.jdbc.HeavyAIArrayTest.ia, Integer, ai.heavy.jdbc.HeavyAIArrayTest.sa, and ai.heavy.jdbc.HeavyAIArrayTest.ta.

                                                            {
    Array ints = m_conn.createArrayOf("INT", ia);
    Array floats = m_conn.createArrayOf("FLOAT", fa);
    Array decimals = m_conn.createArrayOf("DECIMAL", da);
    Array strings = m_conn.createArrayOf("STR", sa);
    Array timestamps = m_conn.createArrayOf("TIMESTAMP", ta);

    assertEquals(ints.getArray(), ia);
    assertEquals(floats.getArray(), fa);
    assertEquals(decimals.getArray(), da);
    assertEquals(strings.getArray(), sa);
    assertEquals(timestamps.getArray(), ta);

    ResultSet rs = ints.getResultSet();
    while (rs.next()) {
      Integer val = rs.getInt(2);
      if (rs.wasNull()) val = null;
      assertEquals(val, ia[rs.getInt(1) - 1]);
    }
    rs = floats.getResultSet();
    while (rs.next()) {
      Float val = rs.getFloat(2);
      if (rs.wasNull()) val = null;
      assertEquals(val, fa[rs.getInt(1) - 1]);
    }
    rs = decimals.getResultSet();
    while (rs.next()) {
      assertEquals(rs.getBigDecimal(2), da[rs.getInt(1) - 1]);
    }
    rs = strings.getResultSet();
    while (rs.next()) {
      assertEquals(rs.getString(2), sa[rs.getInt(1) - 1]);
    }
    rs = timestamps.getResultSet();
    while (rs.next()) {
      assertEquals(rs.getTimestamp(2), ta[rs.getInt(1) - 1]);
    }
  }

void ai.heavy.jdbc.HeavyAIArrayTest.illegal_arguments_test ( ) throws Exception

inline

Definition at line 129 of file HeavyAIArrayTest.java.

References ai.heavy.jdbc.HeavyAIArrayTest.ia.

                                                        {
    try {
      m_conn.createArrayOf("BIGINT", ia);
      assertTrue("Should not be able to create BIGINT array from integers", false);
    } catch (SQLException e) {
    } catch (Exception ex) {
      assertTrue("Expected an SQLException", false);
    }

    try {
      m_conn.createArrayOf("not_a_type", ia);
      assertTrue("Should not be able to create an array without a valid type", false);
    } catch (SQLException e) {
    } catch (Exception ex) {
      assertTrue("Expected an SQLException", false);
    }

    try {
      m_conn.createArrayOf("BIGINT", null);
      assertTrue("Should not be able to create an array from null", false);
    } catch (SQLException e) {
    } catch (Exception ex) {
      assertTrue("Expected an SQLException", false);
    }

    Array ints = m_conn.createArrayOf("INT", ia);
    int sz = ia.length;
    try {
      ints.getArray(sz / 2, sz / 2 + 2);
      assertTrue("Should not be able to get array bigger than its initial size", false);
    } catch (SQLException e) {
    } catch (Exception ex) {
      assertTrue("Expected an SQLException", false);
    }
  }

void ai.heavy.jdbc.HeavyAIArrayTest.insert_select_test ( ) throws Exception

inline

Definition at line 94 of file HeavyAIArrayTest.java.

References ai.heavy.jdbc.HeavyAIArrayTest.da, ai.heavy.jdbc.HeavyAIArrayTest.fa, Float, ai.heavy.jdbc.HeavyAIArrayTest.ia, Integer, ai.heavy.jdbc.HeavyAIArrayTest.sa, and ai.heavy.jdbc.HeavyAIArrayTest.ta.

                                                    {
    Statement stmt = m_conn.createStatement();
    stmt.executeUpdate("DROP TABLE IF EXISTS arrays_tbl");
    stmt.executeUpdate("CREATE TABLE arrays_tbl ("
            + "i integer,"
            + "ia INTEGER[],"
            + "fa FLOAT[],"
            + "da DECIMAL(4,3)[],"
            + "sa TEXT[] ENCODING DICT,"
            + "ta TIMESTAMP(3)[])");
    PreparedStatement ps =
            m_conn.prepareStatement("INSERT INTO arrays_tbl VALUES(?, ?, ?, ?, ?, ?)");
    ps.setInt(1, 1);
    ps.setArray(2, m_conn.createArrayOf("INT", ia));
    ps.setArray(3, m_conn.createArrayOf("FLOAT", fa));
    ps.setArray(4, m_conn.createArrayOf("DECIMAL", da));
    ps.setArray(5, m_conn.createArrayOf("STR", sa));
    ps.setArray(6, m_conn.createArrayOf("TIMESTAMP", ta));
    ps.executeUpdate();

    ResultSet rs = stmt.executeQuery("SELECT i, ia, fa, da, sa, ta FROM arrays_tbl");
    assertTrue(rs.next());
    assertEquals(rs.getInt("i"), 1);
    assertArrayEquals((Integer[]) rs.getArray("ia").getArray(), ia);
    assertArrayEquals((Float[]) rs.getArray("fa").getArray(), fa);
    assertArrayEquals((BigDecimal[]) rs.getArray("da").getArray(), da);
    assertArrayEquals((String[]) rs.getArray("sa").getArray(), sa);
    assertArrayEquals((Timestamp[]) rs.getArray("ta").getArray(), ta);

    ps.close();
    stmt.executeUpdate("DROP TABLE arrays_tbl");
    stmt.close();
  }

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

inline

Definition at line 38 of file HeavyAIArrayTest.java.

References ai.heavy.jdbc.HeavyAIArrayTest.password, ai.heavy.jdbc.HeavyAIArrayTest.url, and ai.heavy.jdbc.HeavyAIArrayTest.user.

                                       {
    Properties pt = new Properties();
    pt.setProperty("user", user);
    pt.setProperty("password", password);
    m_conn = DriverManager.getConnection(url, pt);
    TimeZone.setDefault(TimeZone.getTimeZone("UTC"));
  }

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

inline

Definition at line 47 of file HeavyAIArrayTest.java.

                                          {
    m_conn.close();
  }

Member Data Documentation

final BigDecimal [] ai.heavy.jdbc.HeavyAIArrayTest.da

staticpackage

Initial value:

= {BigDecimal.valueOf(1.100),
          null,
          BigDecimal.valueOf(2.15),
          BigDecimal.valueOf(3.5)}

Definition at line 26 of file HeavyAIArrayTest.java.

Referenced by ai.heavy.jdbc.HeavyAIArrayTest.create_and_read_array_test(), and ai.heavy.jdbc.HeavyAIArrayTest.insert_select_test().

final Float [] ai.heavy.jdbc.HeavyAIArrayTest.fa = {null, null, 1.0001f, 12.541f, null}

staticpackage

Definition at line 25 of file HeavyAIArrayTest.java.

Referenced by ai.heavy.jdbc.HeavyAIArrayTest.create_and_read_array_test(), and ai.heavy.jdbc.HeavyAIArrayTest.insert_select_test().

final Integer [] ai.heavy.jdbc.HeavyAIArrayTest.ia = {100, null, 200, 300, 400, 500}

staticpackage

Definition at line 24 of file HeavyAIArrayTest.java.

Referenced by ai.heavy.jdbc.HeavyAIArrayTest.create_and_read_array_test(), ai.heavy.jdbc.HeavyAIArrayTest.illegal_arguments_test(), and ai.heavy.jdbc.HeavyAIArrayTest.insert_select_test().

Connection ai.heavy.jdbc.HeavyAIArrayTest.m_conn = null

private

Definition at line 35 of file HeavyAIArrayTest.java.

final String ai.heavy.jdbc.HeavyAIArrayTest.password = PROPERTIES.getProperty("default_user_password")

staticpackage

Definition at line 22 of file HeavyAIArrayTest.java.

Referenced by ai.heavy.jdbc.HeavyAIArrayTest.setUp().

Properties ai.heavy.jdbc.HeavyAIArrayTest.PROPERTIES = new Property_loader("prepare_test.properties")

staticpackage

Definition at line 19 of file HeavyAIArrayTest.java.

final String [] ai.heavy.jdbc.HeavyAIArrayTest.sa = {"Hello", null, "World", "!"}

staticpackage

Definition at line 30 of file HeavyAIArrayTest.java.

Referenced by ai.heavy.jdbc.HeavyAIArrayTest.create_and_read_array_test(), and ai.heavy.jdbc.HeavyAIArrayTest.insert_select_test().

final Timestamp [] ai.heavy.jdbc.HeavyAIArrayTest.ta

staticpackage

Initial value:

= {new Timestamp(System.currentTimeMillis()),
          new Timestamp(System.currentTimeMillis() + 1000000),
          null}

Definition at line 31 of file HeavyAIArrayTest.java.

Referenced by ai.heavy.jdbc.HeavyAIArrayTest.create_and_read_array_test(), and ai.heavy.jdbc.HeavyAIArrayTest.insert_select_test().

final String ai.heavy.jdbc.HeavyAIArrayTest.url = PROPERTIES.getProperty("default_db_connection_url")

staticpackage

Definition at line 20 of file HeavyAIArrayTest.java.

Referenced by ai.heavy.jdbc.HeavyAIArrayTest.setUp().

final String ai.heavy.jdbc.HeavyAIArrayTest.user = PROPERTIES.getProperty("default_super_user")

staticpackage

Definition at line 21 of file HeavyAIArrayTest.java.

Referenced by heavydb.thrift.ttypes.TSessionInfo.read(), heavydb.thrift.Heavy.connect_args.read(), ai.heavy.jdbc.HeavyAIArrayTest.setUp(), heavydb.thrift.ttypes.TSessionInfo.write(), and heavydb.thrift.Heavy.connect_args.write().

---

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/HeavyAIArrayTest.java