Cfrgtkky

I am trying to store details of a user along with his favorite team details also. He can change his favorite team any time.
An user can have several properties, among which he can have multiple Favorite Teams.

Thus, I have made a UserEntity class with a set of FavoriteTeam class as follow (which is obviously one to many mapping)

@OneToMany(cascade=CascadeType.ALL)

@JoinTable(name="LookupTable",

joinColumns=@JoinColumn(name="userID", referencedColumnName="id"),

inverseJoinColumns=@JoinColumn(name="favTeamId", referencedColumnName="teamId",unique=true))

private Set<FavouriteTeamEntity> favouriteTeamEntities;

When someone adds a new favorite team, it works fine. But problem arises when someone removes a team from its list.
Currently i am follow this approach where I am deleting the entire user object along with its child and again reinsert all details except the removed favorite team from the set.

    Session session = this.sessionFactory.openSession();

    Transaction tx = session.beginTransaction();

    CriteriaBuilder criteriaBuilder = session.getCriteriaBuilder();

    CriteriaQuery<UserEntity> criteriaQuery = criteriaBuilder.createQuery(UserEntity.class);

    Root<UserEntity> sRoot = criteriaQuery.from(UserEntity.class);

    criteriaQuery.select(sRoot);    

    criteriaQuery.where(criteriaBuilder.equal(sRoot.get("id"),userID));

    UserEntity i = session.createQuery(criteriaQuery).uniqueResult();



    UserBean userBean = new UserBean();

    userBean.setEmail(i.getEmail());

    userBean.setId(i.getId());

    userBean.setName(i.getName());



    Set<FavouriteTeam> fSet= new HashSet<>();

    i.getFavouriteTeamEntities().forEach((x) -> {

        FavouriteTeam fTeam = new FavouriteTeam();

        fTeam.setAltCityName(x.getAltCityName());

        fTeam.setCity(x.getCity());

        fTeam.setTeamId(x.getId());

        fTeam.setTricode(x.getTricode());

        fTeam.setFullName(x.getFullName());

        fSet.add(fTeam);

    });

    userBean.setFavouriteTeam(fSet);

    session.delete(i);

    tx.commit();



    Transaction tx1 = session.beginTransaction();

    UserEntity userEntity = new UserEntity();

    userEntity.setEmail(userBean.getEmail());

    userEntity.setId(userBean.getId());

    userEntity.setName(userBean.getName());

    session.persist(userEntity);

    tx1.commit();



    userBean.getFavouriteTeam().forEach((fff) -> {

        fff.setUserId(signIn.getId());

        if(String.valueOf(fff.getTeamId()).equals(teamId)) {

            continue;

        }else {

            this.insertTeamAsFavoriteTeam(fff);

        }



    });

    session.close();

My insertTeamAsFavoriteTeam is as follows :

    public String insertTeamAsFavoriteTeam(FavouriteTeam favouriteTeam) {

    Session session = this.sessionFactory.openSession();

    UserEntity userEntity = (UserEntity) session.get(UserEntity.class, USER_ID);

    Transaction tx = session.beginTransaction();

    if (userEntity != null) {

        Set<FavouriteTeamEntity> lEntities = sEntity.getFavouriteTeamEntities();

        FavouriteTeamEntity favouriteTeamEntity = new FavouriteTeamEntity();

        favouriteTeamEntity.setId(favouriteTeam.getTeamId());

        favouriteTeamEntity.setAltCityName(favouriteTeam.getAltCityName());

        favouriteTeamEntity.setCity(favouriteTeam.getCity());

        favouriteTeamEntity.setFullName(favouriteTeam.getFullName());

        favouriteTeamEntity.setTricode(favouriteTeam.getTricode());

        lEntities.add(favouriteTeamEntity);

        userEntity.setFavouriteTeamEntities(lEntities);

    }

    session.save(userEntity);

    tx.commit();

    session.close();

}

I Know my approach is wrong but as a work around I have use this approach. If anyone has some good approach please share.
And also I am facing issue when I delete a user, corresponding its favorite team in favorite Team table gets deleted, which I don't want. I want to delete a particular team from the set or the lookup table.

Thanks in advance