@Test public void insertTest() throws SQLException { OrderQuantityAdjustmentType adjustmentType = new OrderQuantityAdjustmentType(); adjustmentType.setName("Test Adjustment 1"); adjustmentType.setDisplayOrder(2); adjustmentType.setDescription("Test Adjustment Description1"); adjustmentType.setCreatedDate(new Date()); // adjustmentType.setCreatedBy(Long.valueOf(2)); this.adjustmentTypeMapper.insert(adjustmentType); ResultSet resultSet = queryExecutor.execute( "SELECT * FROM order_quantity_adjustment_types WHERE name = ?", adjustmentType.getName()); resultSet.next(); assertThat(resultSet.getString("name"), is(adjustmentType.getName())); assertThat(resultSet.getString("description"), is(adjustmentType.getDescription())); }
@Test public void updateTest() throws SQLException { OrderQuantityAdjustmentType adjustmentType = new OrderQuantityAdjustmentType(); adjustmentType.setName("Test Adjustment inserted"); adjustmentType.setDisplayOrder(2); adjustmentType.setDescription("Test Adjustment inserted Description"); adjustmentType.setCreatedDate(new Date()); // adjustmentType.setCreatedBy(Long.valueOf(2)); this.adjustmentTypeMapper.insert(adjustmentType); adjustmentType.setName("Test Adjustment updated"); adjustmentType.setDisplayOrder(4); adjustmentType.setDescription("Test Adjustment updated Description"); this.adjustmentTypeMapper.update(adjustmentType); OrderQuantityAdjustmentType updatedAdjustmentType1 = this.adjustmentTypeMapper.getById(adjustmentType.getId()); assertThat(updatedAdjustmentType1.getName(), is(adjustmentType.getName())); assertThat(updatedAdjustmentType1.getDescription(), is(adjustmentType.getDescription())); assertThat(updatedAdjustmentType1.getDisplayOrder(), is(adjustmentType.getDisplayOrder())); }