com.omnisci.jdbc.OmniSciGeomTest Class Reference

Collaboration diagram for com.omnisci.jdbc.OmniSciGeomTest:

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

Static Package Attributes
static Properties	PROPERTIES = new Property_loader("connection.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 OmniSciGeomTest.java.

Member Function Documentation

void com.omnisci.jdbc.OmniSciGeomTest.tst1_geometry ( ) throws Exception

inline

Definition at line 30 of file OmniSciGeomTest.java.

References com.omnisci.jdbc.OmniSciGeomTest.password, com.omnisci.jdbc.OmniSciGeomTest.sql_create_tbl_geom, com.omnisci.jdbc.OmniSciGeomTest.sql_drop_tbl_geom, com.omnisci.jdbc.OmniSciGeomTest.sql_insert_geom, com.omnisci.jdbc.OmniSciGeomTest.sql_select_geom, com.omnisci.jdbc.OmniSciGeomTest.url, and com.omnisci.jdbc.OmniSciGeomTest.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 com.omnisci.jdbc.OmniSciGeomTest.tst2_geometry ( ) throws Exception

inline

Definition at line 55 of file OmniSciGeomTest.java.

References com.omnisci.jdbc.OmniSciGeomTest.password, com.omnisci.jdbc.OmniSciGeomTest.sql_create_tbl_geom, com.omnisci.jdbc.OmniSciGeomTest.sql_drop_tbl_geom, com.omnisci.jdbc.OmniSciGeomTest.sql_insert_geom_batch, com.omnisci.jdbc.OmniSciGeomTest.sql_select_geom, Experimental.String, com.omnisci.jdbc.OmniSciGeomTest.url, and com.omnisci.jdbc.OmniSciGeomTest.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 com.omnisci.jdbc.OmniSciGeomTest.password = PROPERTIES.getProperty("default_user_password")

staticpackage

Definition at line 13 of file OmniSciGeomTest.java.

Referenced by com.omnisci.jdbc.OmniSciGeomTest.tst1_geometry(), and com.omnisci.jdbc.OmniSciGeomTest.tst2_geometry().

Properties com.omnisci.jdbc.OmniSciGeomTest.PROPERTIES = new Property_loader("connection.properties")

staticpackage

Definition at line 10 of file OmniSciGeomTest.java.

String com.omnisci.jdbc.OmniSciGeomTest.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 OmniSciGeomTest.java.

Referenced by com.omnisci.jdbc.OmniSciGeomTest.tst1_geometry(), and com.omnisci.jdbc.OmniSciGeomTest.tst2_geometry().

String com.omnisci.jdbc.OmniSciGeomTest.sql_drop_tbl_geom = "drop table if exists jdbc_geom"

staticpackage

Definition at line 15 of file OmniSciGeomTest.java.

Referenced by com.omnisci.jdbc.OmniSciGeomTest.tst1_geometry(), and com.omnisci.jdbc.OmniSciGeomTest.tst2_geometry().

String com.omnisci.jdbc.OmniSciGeomTest.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 OmniSciGeomTest.java.

Referenced by com.omnisci.jdbc.OmniSciGeomTest.tst1_geometry().

String com.omnisci.jdbc.OmniSciGeomTest.sql_insert_geom_batch = "insert into jdbc_geom values (?, ?, ?, ?)"

staticpackage

Definition at line 24 of file OmniSciGeomTest.java.

Referenced by com.omnisci.jdbc.OmniSciGeomTest.tst2_geometry().

String com.omnisci.jdbc.OmniSciGeomTest.sql_select_geom = "select * from jdbc_geom"

staticpackage

Definition at line 26 of file OmniSciGeomTest.java.

Referenced by com.omnisci.jdbc.OmniSciGeomTest.tst1_geometry(), and com.omnisci.jdbc.OmniSciGeomTest.tst2_geometry().

final String com.omnisci.jdbc.OmniSciGeomTest.url = PROPERTIES.getProperty("default_db_connection_url")

staticpackage

Definition at line 11 of file OmniSciGeomTest.java.

Referenced by com.omnisci.jdbc.OmniSciGeomTest.tst1_geometry(), and com.omnisci.jdbc.OmniSciGeomTest.tst2_geometry().

final String com.omnisci.jdbc.OmniSciGeomTest.user = PROPERTIES.getProperty("default_super_user")

staticpackage

Definition at line 12 of file OmniSciGeomTest.java.

Referenced by com.omnisci.jdbc.OmniSciGeomTest.tst1_geometry(), and com.omnisci.jdbc.OmniSciGeomTest.tst2_geometry().

---

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

• /home/jenkins-slave/workspace/core-os-doxygen/java/omniscijdbc/src/test/java/com/omnisci/jdbc/OmniSciGeomTest.java