public UserEntity updateUserHobby(UserEntity user, HobbyEntity hobby, boolean deleted) {
Session session = HibernateUtil.getSessionFactory().openSession();
int id = user.getId();
String queryStr = "from UserHobbyEntity where userId = :userId and hobbyId = :hobbyId";
List<UserHobbyEntity> userHobbies =
session
.createQuery(queryStr)
.setString("userId", String.valueOf(id))
.setString("hobbyId", String.valueOf(hobby.getId()))
.list();
if (userHobbies.size() == 0) {
UserHobbyEntity userHobbyEntity = new UserHobbyEntity();
userHobbyEntity.setUserId(id);
userHobbyEntity.setHobbyId(hobby.getId());
userHobbyEntity.setDeleted(deleted);
session.beginTransaction();
session.save(userHobbyEntity);
session.getTransaction().commit();
} else {
UserHobbyEntity userHobbyEntity = userHobbies.get(0);
userHobbyEntity.setDeleted(deleted);
session.beginTransaction();
session.update(userHobbyEntity);
session.getTransaction().commit();
}
session.close();
return user;
}
public List<UserHobbyEntity> getUserHobby(UserEntity user) {
Session session = HibernateUtil.getSessionFactory().openSession();
String queryStr = "from UserHobbyEntity where userId = :userId and deleted = false";
List<UserHobbyEntity> list =
session.createQuery(queryStr).setString("userId", String.valueOf(user.getId())).list();
session.close();
return list;
}
public List<UserEntity> getUser(String userName) {
Session session = HibernateUtil.getSessionFactory().openSession();
String queryStr = "from UserEntity where userName = :userName";
List<UserEntity> list = session.createQuery(queryStr).setString("userName", userName).list();
session.close();
return list;
}
@Override
public List<UserEntity> getUser(int userId) {
Session session = HibernateUtil.getSessionFactory().openSession();
String queryStr = "from UserEntity where id = :userId";
List<UserEntity> list = session.createQuery(queryStr).setInteger("userId", userId).list();
session.close();
return list;
}
public UserEntity updateUserPersonality(UserEntity user, PersonalityEntity personality) {
Session session = HibernateUtil.getSessionFactory().openSession();
user.setPersonality(personality.getId());
session.beginTransaction();
session.update(user);
session.getTransaction().commit();
session.close();
return user;
}
@Override
public UserEntity updateUserDisplayName(UserEntity user, String displayName) {
Session session = HibernateUtil.getSessionFactory().openSession();
user.setDisplayName(displayName);
session.beginTransaction();
session.update(user);
session.getTransaction().commit();
session.close();
return user;
}
public UserEntity updateUserGender(UserEntity user, String gender) {
Session session = HibernateUtil.getSessionFactory().openSession();
user.setGender(gender);
session.beginTransaction();
session.update(user);
session.getTransaction().commit();
session.close();
return user;
}
@Override
public UserEntity updateProfileImage(UserEntity user, String imageURL) {
Session session = HibernateUtil.getSessionFactory().openSession();
user.setProfileImageUrl(imageURL);
session.beginTransaction();
session.update(user);
session.getTransaction().commit();
session.close();
return user;
}
@Override
public UserEntity updatePhoneNumber(UserEntity user, String phoneNumber) {
Session session = HibernateUtil.getSessionFactory().openSession();
user.setPhoneNum(phoneNumber);
session.beginTransaction();
session.update(user);
session.getTransaction().commit();
session.close();
return user;
}
@Override
public List<ArrangementGuestEntity> getAllComments(UserEntity user) {
Session session = HibernateUtil.getSessionFactory().openSession();
String queryStr =
"select age from com.linterest.entity.ArrangementGuestEntity as age "
+ ", com.linterest.entity.ArrangementEntity as ae "
+ "where age.arrangementId = ae.id and ae.host = :user "
+ "order by age.commentStar desc";
List<ArrangementGuestEntity> userHobbies =
session.createQuery(queryStr).setEntity("user", user).list();
return userHobbies;
}
public UserEntity userSignup(String userName, String password) {
Session session = HibernateUtil.getSessionFactory().openSession();
password = DigestUtils.md5Hex(password);
UserEntity user = new UserEntity();
user.setUserName(userName);
user.setPassword(password);
session.getTransaction().begin();
session.persist(user);
session.getTransaction().commit();
session.close();
return user;
}
public UserEntity userSignupWithDevice(String deviceName, String deviceId) {
Session session = HibernateUtil.getSessionFactory().openSession();
String queryStr =
"from UserDeviceIdEntity where deviceName = :deviceName and deviceId = :deviceId";
List<UserDeviceIdEntity> list =
session
.createQuery(queryStr)
.setString("deviceName", deviceName)
.setString("deviceId", deviceId)
.list();
UserEntity user;
if (list.size() > 0) {
// Device found.
UserDeviceIdEntity deviceIdEntity = list.get(0);
user = deviceIdEntity.getUser();
session.beginTransaction();
session.update(user);
session.getTransaction().commit();
} else {
// Device not found.
user = new UserEntity();
user.setUserName(Constants.GUEST_NAME);
user.setPassword(DigestUtils.md5Hex(Constants.GUEST_PASSWORD));
UserDeviceIdEntity deviceIdEntity = new UserDeviceIdEntity();
deviceIdEntity.setDeviceName(deviceName);
deviceIdEntity.setDeviceId(deviceId);
deviceIdEntity.setUser(user);
session.beginTransaction();
session.save(deviceIdEntity);
session.getTransaction().commit();
user = deviceIdEntity.getUser();
}
session.close();
return user;
}