ai.heavy.jdbc.HeavyAIGeomTest Class Reference

Collaboration diagram for ai.heavy.jdbc.HeavyAIGeomTest:

Public Member Functions
void	tst1_geometry () throws Exception
void	tst2_geometry () throws Exception

Static Package Attributes
static Properties	PROPERTIES = new Property_loader("connection_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 String	sql_drop_tbl_geom = "drop table if exists jdbc_geom"
static String	sql_create_tbl_geom
static String	sql_insert_geom
static String	sql_insert_geom_batch = "insert into jdbc_geom values (?, ?, ?, ?)"
static String	sql_select_geom = "select * from jdbc_geom"

Detailed Description

Definition at line 9 of file HeavyAIGeomTest.java.

Member Function Documentation

void ai.heavy.jdbc.HeavyAIGeomTest.tst1_geometry ( ) throws Exception

inline

Definition at line 30 of file HeavyAIGeomTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIGeomTest.password, ai.heavy.jdbc.HeavyAIGeomTest.sql_create_tbl_geom, ai.heavy.jdbc.HeavyAIGeomTest.sql_drop_tbl_geom, ai.heavy.jdbc.HeavyAIGeomTest.sql_insert_geom, ai.heavy.jdbc.HeavyAIGeomTest.sql_select_geom, ai.heavy.jdbc.HeavyAIGeomTest.url, and ai.heavy.jdbc.HeavyAIGeomTest.user.

                                               {
    Connection conn = DriverManager.getConnection(url, user, password);
    assertNotEquals(null, conn);
    Statement statement = conn.createStatement();
    statement.executeUpdate(sql_drop_tbl_geom);
    statement.executeUpdate(sql_create_tbl_geom);
    statement.executeUpdate(sql_insert_geom);

    ResultSet rs = statement.executeQuery(sql_select_geom);
    while (rs.next()) {
      Object m_point = rs.getObject("m_point");
      Object m_linestring = rs.getObject("m_linestring");
      Object m_polygon = rs.getObject("m_polygon");
      Object m_multi_polygon = rs.getString("m_multi_polygon");
      assertEquals("POLYGON ((0 0,4 0,4 4,0 0))", m_polygon);
      assertEquals("LINESTRING (0 1,2 2)", m_linestring);
      assertEquals("POINT (0 0)", m_point);
      assertEquals("MULTIPOLYGON (((0 0,4 0,4 4,0 4,0 0)))", m_multi_polygon);
    }
    rs.close();
    statement.executeUpdate(sql_drop_tbl_geom);
  }

void ai.heavy.jdbc.HeavyAIGeomTest.tst2_geometry ( ) throws Exception

inline

Definition at line 55 of file HeavyAIGeomTest.java.

References report.conn, ai.heavy.jdbc.HeavyAIGeomTest.password, ai.heavy.jdbc.HeavyAIGeomTest.sql_create_tbl_geom, ai.heavy.jdbc.HeavyAIGeomTest.sql_drop_tbl_geom, ai.heavy.jdbc.HeavyAIGeomTest.sql_insert_geom_batch, ai.heavy.jdbc.HeavyAIGeomTest.sql_select_geom, ai.heavy.jdbc.HeavyAIGeomTest.url, and ai.heavy.jdbc.HeavyAIGeomTest.user.

                                               {
    Connection conn = DriverManager.getConnection(url, user, password);
    assertNotEquals(null, conn);
    Statement statement = conn.createStatement();
    statement.executeUpdate(sql_drop_tbl_geom);
    statement.executeUpdate(sql_create_tbl_geom);
    PreparedStatement ps = conn.prepareStatement(sql_insert_geom_batch);
    ps.setString(1, "POINT(0 0)");
    ps.setString(2, "LINESTRING(0 1, 2 2)");
    ps.setString(3, "POLYGON((0 0,4 0,4 4,0 0))");
    ps.setString(4, "MULTIPOLYGON(((0 0,4 0,4 4,0 4,0 0)))");
    ps.addBatch();
    ps.executeBatch();

    ResultSet rs = statement.executeQuery(sql_select_geom);
    while (rs.next()) {
      // Test getString and getObject return on geo type
      Object m_point = rs.getObject("m_point");
      Object m_linestring = rs.getString("m_linestring");
      Object m_polygon = rs.getObject("m_polygon");
      String m_multi_polygon = rs.getString("m_multi_polygon");
      assertEquals("POLYGON ((0 0,4 0,4 4,0 0))", m_polygon);
      assertEquals("LINESTRING (0 1,2 2)", m_linestring);
      assertEquals("POINT (0 0)", m_point);
      assertEquals("MULTIPOLYGON (((0 0,4 0,4 4,0 4,0 0)))", m_multi_polygon);
    }
    rs.close();
    statement.executeUpdate(sql_drop_tbl_geom);
  }

Member Data Documentation

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

staticpackage

Definition at line 13 of file HeavyAIGeomTest.java.

Referenced by ai.heavy.jdbc.HeavyAIGeomTest.tst1_geometry(), and ai.heavy.jdbc.HeavyAIGeomTest.tst2_geometry().

Properties ai.heavy.jdbc.HeavyAIGeomTest.PROPERTIES = new Property_loader("connection_test.properties")

staticpackage

Definition at line 10 of file HeavyAIGeomTest.java.

String ai.heavy.jdbc.HeavyAIGeomTest.sql_create_tbl_geom

staticpackage

Initial value:

=
          "create table jdbc_geom (m_point POINT, m_linestring LINESTRING, m_polygon POLYGON, m_multi_polygon MULTIPOLYGON)"

Definition at line 16 of file HeavyAIGeomTest.java.

Referenced by ai.heavy.jdbc.HeavyAIGeomTest.tst1_geometry(), and ai.heavy.jdbc.HeavyAIGeomTest.tst2_geometry().

String ai.heavy.jdbc.HeavyAIGeomTest.sql_drop_tbl_geom = "drop table if exists jdbc_geom"

staticpackage

Definition at line 15 of file HeavyAIGeomTest.java.

Referenced by ai.heavy.jdbc.HeavyAIGeomTest.tst1_geometry(), and ai.heavy.jdbc.HeavyAIGeomTest.tst2_geometry().

String ai.heavy.jdbc.HeavyAIGeomTest.sql_insert_geom

staticpackage

Initial value:

=
          "insert into jdbc_geom values ('POINT(0 0)', 'LINESTRING(0 1, 2 2)',"
          + " 'POLYGON((0 0,4 0,4 4,0 0))',"
          + " 'MULTIPOLYGON(((0 0,4 0,4 4,0 4,0 0)))')"

Definition at line 19 of file HeavyAIGeomTest.java.

Referenced by ai.heavy.jdbc.HeavyAIGeomTest.tst1_geometry().

String ai.heavy.jdbc.HeavyAIGeomTest.sql_insert_geom_batch = "insert into jdbc_geom values (?, ?, ?, ?)"

staticpackage

Definition at line 24 of file HeavyAIGeomTest.java.

Referenced by ai.heavy.jdbc.HeavyAIGeomTest.tst2_geometry().

String ai.heavy.jdbc.HeavyAIGeomTest.sql_select_geom = "select * from jdbc_geom"

staticpackage

Definition at line 26 of file HeavyAIGeomTest.java.

Referenced by ai.heavy.jdbc.HeavyAIGeomTest.tst1_geometry(), and ai.heavy.jdbc.HeavyAIGeomTest.tst2_geometry().

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

staticpackage

Definition at line 11 of file HeavyAIGeomTest.java.

Referenced by ai.heavy.jdbc.HeavyAIGeomTest.tst1_geometry(), and ai.heavy.jdbc.HeavyAIGeomTest.tst2_geometry().

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

staticpackage

Definition at line 12 of file HeavyAIGeomTest.java.

Referenced by heavydb.thrift.ttypes.TSessionInfo.read(), heavydb.thrift.Heavy.connect_args.read(), ai.heavy.jdbc.HeavyAIGeomTest.tst1_geometry(), ai.heavy.jdbc.HeavyAIGeomTest.tst2_geometry(), 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/HeavyAIGeomTest.java