@Test public void testGlobalResourceGroupProperties() { H2ResourceGroupsDao dao = setup("global_properties"); dao.createResourceGroupsGlobalPropertiesTable(); dao.insertResourceGroupsGlobalProperties("cpu_quota_period", "1h"); ResourceGroupGlobalProperties globalProperties = new ResourceGroupGlobalProperties(Optional.of(Duration.valueOf("1h"))); ResourceGroupGlobalProperties records = dao.getResourceGroupGlobalProperties().get(0); assertEquals(globalProperties, records); try { dao.insertResourceGroupsGlobalProperties("invalid_property", "1h"); } catch (UnableToExecuteStatementException ex) { assertTrue(ex.getCause() instanceof JdbcSQLException); assertTrue(ex.getCause().getMessage().startsWith("Check constraint violation:")); } try { dao.updateResourceGroupsGlobalProperties("invalid_property_name"); } catch (UnableToExecuteStatementException ex) { assertTrue(ex.getCause() instanceof JdbcSQLException); assertTrue(ex.getCause().getMessage().startsWith("Check constraint violation:")); } }
@Test public void testPreparedBatch() { PreparedBatch b = dbRule.openHandle().prepareBatch("insert into something (id, name) values (?,?)"); b.add(0, "a"); b.add(0, "a"); assertThatExceptionOfType(UnableToExecuteStatementException.class) .isThrownBy(b::execute) .satisfies(e -> assertSuppressions(e.getCause())); }
@Test public void testSimpleBatch() { Batch b = dbRule.openHandle().createBatch(); b.add("insert into something (id, name) values (0, 'Keith')"); b.add("insert into something (id, name) values (0, 'Keith')"); assertThatExceptionOfType(UnableToExecuteStatementException.class) .isThrownBy(b::execute) .satisfies(e -> assertSuppressions(e.getCause())); }
@Test public void testGlobalResourceGroupProperties() { H2ResourceGroupsDao dao = setup("global_properties"); dao.createResourceGroupsGlobalPropertiesTable(); dao.insertResourceGroupsGlobalProperties("cpu_quota_period", "1h"); ResourceGroupGlobalProperties globalProperties = new ResourceGroupGlobalProperties(Optional.of(Duration.valueOf("1h"))); ResourceGroupGlobalProperties records = dao.getResourceGroupGlobalProperties().get(0); assertEquals(globalProperties, records); try { dao.insertResourceGroupsGlobalProperties("invalid_property", "1h"); } catch (UnableToExecuteStatementException ex) { assertTrue(ex.getCause() instanceof JdbcSQLException); assertTrue(ex.getCause().getMessage().startsWith("Check constraint violation:")); } try { dao.updateResourceGroupsGlobalProperties("invalid_property_name"); } catch (UnableToExecuteStatementException ex) { assertTrue(ex.getCause() instanceof JdbcSQLException); assertTrue(ex.getCause().getMessage().startsWith("Check constraint violation:")); } }
@Test public void testGlobalResourceGroupProperties() { H2ResourceGroupsDao dao = setup("global_properties"); dao.createResourceGroupsGlobalPropertiesTable(); dao.insertResourceGroupsGlobalProperties("cpu_quota_period", "1h"); ResourceGroupGlobalProperties globalProperties = new ResourceGroupGlobalProperties(Optional.of(Duration.valueOf("1h"))); ResourceGroupGlobalProperties records = dao.getResourceGroupGlobalProperties().get(0); assertEquals(globalProperties, records); try { dao.insertResourceGroupsGlobalProperties("invalid_property", "1h"); } catch (UnableToExecuteStatementException ex) { assertTrue(ex.getCause() instanceof JdbcSQLException); assertTrue(ex.getCause().getMessage().startsWith("Check constraint violation:")); } try { dao.updateResourceGroupsGlobalProperties("invalid_property_name"); } catch (UnableToExecuteStatementException ex) { assertTrue(ex.getCause() instanceof JdbcSQLException); assertTrue(ex.getCause().getMessage().startsWith("Check constraint violation:")); } }