PointCodecTest.java
// SPDX-License-Identifier: LGPL-2.1-or-later
// Copyright (c) 2012-2014 Monty Program Ab
// Copyright (c) 2015-2025 MariaDB Corporation Ab
package org.mariadb.jdbc.integration.codec;
import static org.junit.jupiter.api.Assertions.*;
import java.io.*;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.*;
import org.junit.jupiter.api.AfterAll;
import org.junit.jupiter.api.BeforeAll;
import org.junit.jupiter.api.Test;
import org.mariadb.jdbc.Statement;
import org.mariadb.jdbc.client.result.CompleteResult;
import org.mariadb.jdbc.type.GeometryCollection;
import org.mariadb.jdbc.type.Point;
import org.mariadb.jdbc.util.constants.Capabilities;
public class PointCodecTest extends CommonCodecTest {
public static org.mariadb.jdbc.Connection geoConn;
@AfterAll
public static void drop() throws SQLException {
Statement stmt = sharedConn.createStatement();
stmt.execute("DROP TABLE IF EXISTS PointCodec");
stmt.execute("DROP TABLE IF EXISTS PointCodec2");
if (geoConn != null) geoConn.close();
}
@BeforeAll
public static void beforeAll2() throws Exception {
drop();
Statement stmt = sharedConn.createStatement();
stmt.execute("CREATE TABLE PointCodec (t1 POINT, t2 POINT, t3 POINT, t4 POINT)");
stmt.execute(
"INSERT INTO PointCodec VALUES (ST_PointFromText('POINT(10 1)'),"
+ " ST_PointFromText('POINT(1.5 18)'), ST_PointFromText('POINT(-1 0.55)'), null)");
stmt.execute("CREATE TABLE PointCodec2 (id int not null primary key auto_increment, t1 POINT)");
stmt.execute("FLUSH TABLES");
String binUrl =
mDefUrl + (mDefUrl.indexOf("?") > 0 ? "&" : "?") + "geometryDefaultType=default";
geoConn = (org.mariadb.jdbc.Connection) DriverManager.getConnection(binUrl);
}
private ResultSet get() throws SQLException {
Statement stmt = sharedConn.createStatement();
stmt.execute("START TRANSACTION"); // if MAXSCALE ensure using WRITER
ResultSet rs =
stmt.executeQuery(
"select t1 as t1alias, t2 as t2alias, t3 as t3alias, t4 as t4alias from PointCodec");
assertTrue(rs.next());
sharedConn.commit();
return rs;
}
private CompleteResult getPrepare(org.mariadb.jdbc.Connection con) throws SQLException {
java.sql.Statement stmt = con.createStatement();
stmt.execute("START TRANSACTION"); // if MAXSCALE ensure using WRITER
PreparedStatement preparedStatement =
con.prepareStatement(
"select t1 as t1alias, t2 as t2alias, t3 as t3alias, t4 as t4alias from PointCodec"
+ " WHERE 1 > ?");
preparedStatement.closeOnCompletion();
preparedStatement.setInt(1, 0);
CompleteResult rs = (CompleteResult) preparedStatement.executeQuery();
assertTrue(rs.next());
con.commit();
return rs;
}
@Test
public void getObject() throws Exception {
getObject(get(), false);
}
@Test
public void getObjectPrepare() throws Exception {
getObject(getPrepare(sharedConn), false);
getObject(getPrepare(sharedConnBinary), false);
getObject(getPrepare(geoConn), true);
}
public void getObject(ResultSet rs, boolean defaultGeo) throws SQLException {
if (defaultGeo && hasCapability(Capabilities.EXTENDED_METADATA)) {
assertEquals(new Point(10, 1), rs.getObject(1));
assertFalse(rs.wasNull());
assertEquals(new Point(1.5, 18), rs.getObject(2));
assertFalse(rs.wasNull());
assertEquals(new Point(-1, 0.55), rs.getObject(3));
assertFalse(rs.wasNull());
assertNull(rs.getObject(4));
assertTrue(rs.wasNull());
} else {
assertEquals(new Point(10, 1), rs.getObject(1, Point.class));
assertFalse(rs.wasNull());
assertEquals(new Point(1.5, 18), rs.getObject(2, Point.class));
assertFalse(rs.wasNull());
assertEquals(new Point(-1, 0.55), rs.getObject(3, Point.class));
assertFalse(rs.wasNull());
assertNull(rs.getObject(4, Point.class));
assertTrue(rs.wasNull());
}
}
@Test
public void getObjectType() throws Exception {
getObjectType(get());
}
@Test
public void getObjectTypePrepare() throws Exception {
getObjectType(getPrepare(sharedConn));
getObjectType(getPrepare(sharedConnBinary));
}
public void getObjectType(ResultSet rs) throws Exception {
testErrObject(rs, Integer.class);
testErrObject(rs, String.class);
testErrObject(rs, Long.class);
testErrObject(rs, Short.class);
testErrObject(rs, BigDecimal.class);
testErrObject(rs, BigInteger.class);
testErrObject(rs, Double.class);
testErrObject(rs, Float.class);
testErrObject(rs, Byte.class);
testArrObject(
rs,
new byte[] {
(byte) 0x00,
0x00,
0x00,
0x00,
0x01,
0x01,
0x00,
0x00,
0x00,
0x00,
0x00,
0x00,
0x00,
0x00,
0x00,
0x24,
0x40,
0x00,
0x00,
0x00,
0x00,
0x00,
0x00,
(byte) 0xF0,
0x3F
});
testErrObject(rs, Boolean.class);
testErrObject(rs, Clob.class);
testErrObject(rs, NClob.class);
testErrObject(rs, InputStream.class);
testErrObject(rs, Reader.class);
testErrObject(rs, java.util.Date.class);
}
@Test
public void getMetaData() throws SQLException {
getMetaData(sharedConn, false);
try (org.mariadb.jdbc.Connection con = createCon("geometryDefaultType=default")) {
getMetaData(con, true);
}
}
private void getMetaData(org.mariadb.jdbc.Connection con, boolean geoDefault)
throws SQLException {
ResultSet rs = getPrepare(con);
ResultSetMetaData meta = rs.getMetaData();
if (hasCapability(Capabilities.EXTENDED_METADATA)) {
assertEquals("POINT", meta.getColumnTypeName(1));
} else {
assertEquals("GEOMETRY", meta.getColumnTypeName(1));
}
assertEquals(sharedConn.getCatalog(), meta.getCatalogName(1));
assertEquals(
geoDefault
? (hasCapability(Capabilities.EXTENDED_METADATA)
? Point.class.getName()
: GeometryCollection.class.getName())
: "byte[]",
meta.getColumnClassName(1));
assertEquals("t1alias", meta.getColumnLabel(1));
assertEquals("t1", meta.getColumnName(1));
assertEquals(Types.VARBINARY, meta.getColumnType(1));
assertEquals(4, meta.getColumnCount());
assertEquals(0, meta.getScale(1));
assertEquals("", meta.getSchemaName(1));
}
@Test
public void sendParam() throws Exception {
sendParam(sharedConn);
sendParam(sharedConnBinary);
}
private void sendParam(Connection con) throws Exception {
java.sql.Statement stmt = con.createStatement();
stmt.execute("TRUNCATE TABLE PointCodec2");
stmt.execute("START TRANSACTION"); // if MAXSCALE ensure using WRITER
try (PreparedStatement prep = con.prepareStatement("INSERT INTO PointCodec2(t1) VALUES (?)")) {
prep.setObject(1, new Point(52.1, 12.8));
prep.execute();
prep.setObject(1, null);
prep.execute();
prep.setObject(1, new Point(2.2, 3.3));
prep.addBatch();
prep.setObject(1, new Point(2, 3));
prep.addBatch();
prep.executeBatch();
}
ResultSet rs =
con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE)
.executeQuery("SELECT * FROM PointCodec2");
assertTrue(rs.next());
assertEquals(new Point(52.1, 12.8), rs.getObject(2, Point.class));
rs.updateNull(2);
rs.updateRow();
assertNull(rs.getObject(2, Point.class));
assertTrue(rs.next());
assertNull(rs.getObject(2, Point.class));
rs.updateObject(2, new Point(1, 8));
rs.updateRow();
assertEquals(new Point(1, 8), rs.getObject(2, Point.class));
assertTrue(rs.next());
assertEquals(new Point(2.2, 3.3), rs.getObject(2, Point.class));
assertTrue(rs.next());
assertEquals(new Point(2, 3), rs.getObject(2, Point.class));
con.commit();
}
@Test
public void equal() {
Point pt = new Point(0, 10);
assertEquals(pt, pt);
assertEquals(new Point(0, 10), pt);
assertEquals(new Point(0, 10).hashCode(), pt.hashCode());
assertNotEquals(null, pt);
assertNotEquals("", pt);
assertNotEquals(new Point(0, 20), pt);
assertNotEquals(new Point(10, 10), pt);
}
}