use of io.shardingjdbc.core.integrate.type.sharding.hint.helper.HintDatabaseShardingValueHelper in project sharding-jdbc by shardingjdbc.
the class RoutingDatabaseOnlyWithHintForDMLTest method deleteWithoutAlias.
private void deleteWithoutAlias(final Map.Entry<DatabaseType, ShardingDataSource> dataSourceEntry) throws SQLException, DatabaseUnitException {
for (int i = 10; i < 30; i++) {
for (int j = 0; j < 2; j++) {
try (HintShardingValueHelper helper = new HintDatabaseShardingValueHelper(i);
Connection connection = dataSourceEntry.getValue().getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(SQLPlaceholderUtil.replacePreparedStatement(DatabaseTestSQL.DELETE_WITHOUT_ALIAS_SQL))) {
preparedStatement.setInt(1, i * 100 + j);
preparedStatement.setInt(2, i);
preparedStatement.setString(3, "init");
assertThat(preparedStatement.executeUpdate(), is(1));
}
}
}
assertDataSet(dataSourceEntry.getValue().getConnection(), dataSourceEntry.getKey(), "delete", "init");
}
Aggregations