@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()));
}
