/*
- * Copyright (C) 2015 Roland Haeder
+ * Copyright (C) 2016 Roland Haeder
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
package org.mxchange.addressbook.model.addressbook;
import java.util.Calendar;
+import java.util.Objects;
import javax.persistence.Basic;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
+import javax.persistence.Lob;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToOne;
/**
* A POJO for user addressbooks
* <p>
- * @author Roland Haeder
+ * @author Roland Haeder<roland@mxchange.org>
*/
@Entity (name = "addressbooks")
@Table (name = "addressbooks")
@NamedQueries (
{
- @NamedQuery (name = "AllUsersAddressbooks", query = "SELECT a FROM addressbooks AS a WHERE a.addressbookUser = :param ORDER BY a.addressbookId ASC")
+ @NamedQuery (name = "AllUsersAddressbooks", query = "SELECT a FROM addressbooks AS a WHERE a.addressbookUser = :param ORDER BY a.addressbookId ASC"),
+ @NamedQuery (name = "SearchUserAddressbookName", query = "SELECT a FROM addressbooks AS a WHERE a.addressbookUser = :user AND LOWER(a.addressbookName) LIKE LOWER(:name)"),
+ @NamedQuery (name = "SearchAddressbookById", query = "SELECT a FROM addressbooks AS a WHERE a.addressbookId = :id")
}
)
-public class UserAddressbook implements Addressbook, Comparable<Addressbook> {
+public class UserAddressbook implements Addressbook {
/**
* Serial number
*/
private static final long serialVersionUID = 176_573_148_678_169L;
+ /**
+ * When this address book has been created
+ */
+ @Basic (optional = false)
+ @Temporal (value = TemporalType.TIMESTAMP)
+ @Column (name = "addressbook_created", nullable = false, updatable = false)
+ private Calendar addressbookCreated;
+
/**
* Id number
*/
private Long addressbookId;
/**
- * Connection to "users" table
+ * Last locked timestamp
*/
- @JoinColumn (name = "addressbook_user_id", nullable = false)
- @OneToOne (targetEntity = LoginUser.class, optional = false, cascade = CascadeType.ALL)
- private User addressbookUser;
+ @Temporal (TemporalType.TIMESTAMP)
+ @Column (name = "addressbook_last_locked")
+ private Calendar addressbookLastLocked;
/**
- * When this address book has been created
+ * Last locked timestamp
+ */
+ @Lob
+ @Column (name = "addressbook_last_locked_reason")
+ private String addressbookLastLockedReason;
+
+ /**
+ * Name for this address book
*/
@Basic (optional = false)
- @Temporal (TemporalType.TIMESTAMP)
- @Column (name = "addressbook_created", nullable = false, updatable = false)
- private Calendar addressbookCreated;
+ @Column (name = "addressbook_name", length = 50, nullable = false)
+ private String addressbookName;
/**
* Adress book status
private AddressbokStatus addressbookStatus;
/**
- * Name for this address book
+ * Connection to "users" table
*/
- @Basic (optional = false)
- @Column (name = "addressbook_name", length = 50, nullable = false)
- private String addressbookName;
+ @JoinColumn (name = "addressbook_user_id", nullable = false)
+ @OneToOne (targetEntity = LoginUser.class, optional = false, cascade = CascadeType.REFRESH)
+ private User addressbookUser;
/**
* Public constructor with address book name
- * @param addressbookName Address book name
+ * <p>
+ * @param addressbookName Address book name
+ * @param addressbookUser User instance
+ * @param addressbookCreated When this entry has been created
*/
- public UserAddressbook(final String addressbookName) {
+ public UserAddressbook (final String addressbookName, final User addressbookUser, final Calendar addressbookCreated) {
+ // Call default constructor
+ this();
+
+ // Set name, user instance and creation timestamp
this.addressbookName = addressbookName;
+ this.addressbookUser = addressbookUser;
+ this.addressbookCreated = addressbookCreated;
+ }
+
+ /**
+ * Default constructor
+ */
+ public UserAddressbook () {
+ // Set status to UNLOCKED
+ this.addressbookStatus = AddressbokStatus.UNLOCKED;
+ }
+
+ @Override
+ public boolean equals (final Object object) {
+ if (this == object) {
+ return true;
+ } else if (null == object) {
+ return false;
+ } else if (this.getClass() != object.getClass()) {
+ return false;
+ }
+
+ final Addressbook other = (Addressbook) object;
+
+ if (!Objects.equals(this.getAddressbookName(), other.getAddressbookName())) {
+ return false;
+ } else if (!Objects.equals(this.getAddressbookUser(), other.getAddressbookUser())) {
+ return false;
+ }
+
+ return true;
}
@Override
- public int compareTo (final Addressbook addressbook) {
- throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
+ public int hashCode () {
+ int hash = 7;
+ hash = 59 * hash + Objects.hashCode(this.getAddressbookName());
+ hash = 59 * hash + Objects.hashCode(this.getAddressbookUser());
+ return hash;
}
@Override
this.addressbookId = addressbookId;
}
+ @Override
+ public Calendar getAddressbookLastLocked () {
+ return this.addressbookLastLocked;
+ }
+
+ @Override
+ public void setAddressbookLastLocked (final Calendar addressbookLastLocked) {
+ this.addressbookLastLocked = addressbookLastLocked;
+ }
+
+ @Override
+ public String getAddressbookLastLockedReason () {
+ return this.addressbookLastLockedReason;
+ }
+
+ @Override
+ public void setAddressbookLastLockedReason (final String addressbookLastLockedReason) {
+ this.addressbookLastLockedReason = addressbookLastLockedReason;
+ }
+
@Override
public String getAddressbookName () {
return this.addressbookName;
public void setAddressbookUser (final User addressbookUser) {
this.addressbookUser = addressbookUser;
}
+
}