Tukukkk

So I have an entity class "RecipeClientConfig" that has a many to one relationship with "RecipeClientConfigParam"

RecipeClientConfig:

@Entity

@Table(name="recipe_client_config", schema="app")

public class RecipeClientConfig {



    @Id

    @Column(name="recipe_client_config_id")

    @GeneratedValue(

            strategy = GenerationType.SEQUENCE,

            generator = "sequence-generator"

        )

        @SequenceGenerator(

            name = "sequence-generator",

            sequenceName = "app.recipe_client_config_seq",

            allocationSize=1

        )

    private long recipeClientConfigId;       



    @Column(name="recipe_setup_id")

    private int recipeSetupId;   



    @Column(name="personid", columnDefinition = "NVARCHAR(10)")

    private String personId; 



    @Column(name="from_account_num")

    private String fromAccountNum;         



    @Column(name="to_account_num")

    private String toAccountNum;



    @Column(name="status", columnDefinition = "CHAR(1)")

    private String status;    



    @OneToMany(mappedBy="recipeClientConfig", cascade = CascadeType.ALL, fetch= FetchType.EAGER)  

    private List<RecipeClientConfigParam> configParams = new ArrayList<>();

RecipeClientConfigParam:

@Entity

@Table(name="recipe_client_config_params", schema="app")



public class RecipeClientConfigParam {



    @Id

    @Column(name="recipe_client_config_param_id")

    @GeneratedValue(

            strategy = GenerationType.SEQUENCE,

            generator = "sequence-generator"

        )

        @SequenceGenerator(

            name = "sequence-generator",

            sequenceName = "app.recipe_client_config_params_seq",

            allocationSize=1

        )

    private long recipeClientConfigParamId;       





    @Column(name="param_name", columnDefinition = "NVARCHAR(50)")

    private String paramName;                        



    @Column(name="param_value", columnDefinition = "NVARCHAR(50)")

    private String paramValue;                        



    @ManyToOne

    @JoinColumn(name = "recipe_client_config_id", nullable = false, updatable = false, insertable = true)

    private RecipeClientConfig recipeClientConfig;

Now this RecipeConfiguration is able to be updated by the user where they will pass down DTO object and then mapped to a JPA entity. Some of these RecipeConfigParameters may or may not be updated.

This is my save method:

public void saveRecipeConfig (RecipeClientConfig recipeConfig) {

        recipeConfig.setLastupdDat(LocalDateTime.now());

        recipeConfig.setCreateDate(LocalDateTime.now());



        List<RecipeClientConfigParam> params = recipeConfig.getConfigParams();

        if (params != null) {

            for (RecipeClientConfigParam param : params) {

                param.setRecipeClientConfig(recipeConfig);

                param.setCreateOp(recipeConfig.getPersonId());

                param.setLastupdOp(recipeConfig.getPersonId());

                param.setCreateDate(LocalDateTime.now());

                param.setLastupdDat(LocalDateTime.now());

            }

        }

        configRepository.saveAndFlush(recipeConfig);

    }

If I just simply save the updated RecipeConfig entity object, all the fields and the RecipeConfigParameters that are not present in the update object but are present in the database will be deleted.

Not all the fields are shown in the code above for the sake of simplicity and some of the fields and Parameter objects really should not even be able to be updated.

I really want to avoid retrieving the RecipeConfig entity object using findById() or getOne() and then going through every single field and Parameter object to check if its already in the DB. Is there a better way to do this? Thanks!