public static void upsertGlobalParameter(DbConn cnx, GlobalParameterDto dto) { if (dto == null || dto.getKey() == null || dto.getKey().isEmpty() || dto.getValue() == null || dto.getValue().isEmpty()) { throw new IllegalArgumentException("invalid dto object"); } GlobalParameter.setParameter(cnx, dto.getKey(), dto.getValue()); }
private static GlobalParameterDto mapGlobalParameter(ResultSet rs) throws SQLException { GlobalParameterDto res = new GlobalParameterDto(); res.setId(rs.getInt(1)); res.setKey(rs.getString(2)); res.setValue(rs.getString(3)); return res; }
public static void syncGlobalParameters(DbConn cnx, List<GlobalParameterDto> dtos) { for (GlobalParameterDto existing : getGlobalParameter(cnx)) { boolean foundInNewSet = false; for (GlobalParameterDto newdto : dtos) { if (newdto.getId() != null && newdto.getId().equals(existing.getId())) { foundInNewSet = true; break; } } if (!foundInNewSet) { deleteGlobalParameter(cnx, existing.getId()); } } for (GlobalParameterDto dto : dtos) { upsertGlobalParameter(cnx, dto); } }
public static void syncGlobalParameters(DbConn cnx, List<GlobalParameterDto> dtos) { for (GlobalParameterDto existing : getGlobalParameter(cnx)) { boolean foundInNewSet = false; for (GlobalParameterDto newdto : dtos) { if (newdto.getId() != null && newdto.getId().equals(existing.getId())) { foundInNewSet = true; break; } } if (!foundInNewSet) { deleteGlobalParameter(cnx, existing.getId()); } } for (GlobalParameterDto dto : dtos) { upsertGlobalParameter(cnx, dto); } }
private static GlobalParameterDto mapGlobalParameter(ResultSet rs) throws SQLException { GlobalParameterDto res = new GlobalParameterDto(); res.setId(rs.getInt(1)); res.setKey(rs.getString(2)); res.setValue(rs.getString(3)); return res; }
public static void upsertGlobalParameter(DbConn cnx, GlobalParameterDto dto) { if (dto == null || dto.getKey() == null || dto.getKey().isEmpty() || dto.getValue() == null || dto.getValue().isEmpty()) { throw new IllegalArgumentException("invalid dto object"); } GlobalParameter.setParameter(cnx, dto.getKey(), dto.getValue()); }