use of com.mysql.cj.xdevapi.TableFilterParams in project aws-mysql-jdbc by awslabs.
the class XProtocolTest method tableInsert.
@Test
public void tableInsert() {
assumeTrue(this.isSetForXTests, PropertyDefinitions.SYSP_testsuite_url_mysqlx + " must be set to run this test.");
this.protocol.send(this.messageBuilder.buildSqlStatement("drop table if exists tableInsert"), 0);
this.protocol.readQueryResult(new StatementExecuteOkBuilder());
this.protocol.send(this.messageBuilder.buildSqlStatement("create table tableInsert (x int, y varchar(20), z decimal(10, 2))"), 0);
this.protocol.readQueryResult(new StatementExecuteOkBuilder());
InsertParams insertParams = new InsertParams();
insertParams.setProjection(new String[] { "z", "x", "y" });
insertParams.addRow(Arrays.asList("10.2", 40, "some string value"));
insertParams.addRow(Arrays.asList("10.3", 50, "another string value"));
this.protocol.send(this.messageBuilder.buildRowInsert(getTestDatabase(), "tableInsert", insertParams), 0);
SqlResult res = this.protocol.readQueryResult(new SqlResultBuilder(this.protocol.getServerSession().getDefaultTimeZone(), this.protocol.getPropertySet()));
assertEquals(2, res.getAffectedItemsCount());
FilterParams filterParams = new TableFilterParams(getTestDatabase(), "tableInsert");
filterParams.setOrder("x DESC");
filterParams.setFields("z, y, x");
this.protocol.send(this.messageBuilder.buildFind(filterParams), 0);
ColumnDefinition metadata = this.protocol.readMetadata();
Iterator<Row> ris = new XProtocolRowInputStream(metadata, this.protocol, null);
Row r = ris.next();
assertEquals("10.30", r.getValue(0, new StringValueFactory(this.protocol.getPropertySet())));
assertEquals("another string value", r.getValue(1, new StringValueFactory(this.protocol.getPropertySet())));
assertEquals("50", r.getValue(2, new StringValueFactory(this.protocol.getPropertySet())));
r = ris.next();
assertEquals("10.20", r.getValue(0, new StringValueFactory(this.protocol.getPropertySet())));
assertEquals("some string value", r.getValue(1, new StringValueFactory(this.protocol.getPropertySet())));
assertEquals("40", r.getValue(2, new StringValueFactory(this.protocol.getPropertySet())));
this.protocol.readQueryResult(new StatementExecuteOkBuilder());
this.protocol.send(this.messageBuilder.buildSqlStatement("drop table tableInsert"), 0);
this.protocol.readQueryResult(new StatementExecuteOkBuilder());
}
Aggregations