*/
package org.mxchange.addressbook.model.addressbook;
+import java.text.MessageFormat;
import java.util.List;
-import javax.ejb.EJB;
import javax.ejb.Stateless;
+import javax.persistence.NoResultException;
import javax.persistence.Query;
import org.mxchange.addressbook.exceptions.AddressbookNameAlreadyUsedException;
+import org.mxchange.addressbook.exceptions.AddressbookNotFoundException;
+import org.mxchange.addressbook.model.addressbook.entry.AddressbookEntry;
+import org.mxchange.addressbook.model.addressbook.shared.ShareableAddressbook;
import org.mxchange.jcoreee.database.BaseDatabaseBean;
-import org.mxchange.jusercore.model.login.UserLoginSessionBeanRemote;
import org.mxchange.jusercore.model.user.User;
/**
*/
private static final long serialVersionUID = 129_857_871_287_691L;
- /**
- * Login bean
- */
- @EJB (mappedName = "ejb/stateless-login")
- private UserLoginSessionBeanRemote loginBean;
+ @Override
+ @SuppressWarnings ("unchecked")
+ public List<AddressbookEntry> allEntries (final Addressbook addressbook) {
+ // Generate query
+ Query query = this.getEntityManager().createNamedQuery("AllAddressbookEntries", List.class); //NOI18N
+
+ // Set parameters
+ query.setParameter("addressbook", addressbook); //NOI18N
+ query.setParameter("owner", addressbook.getAddressbookUser()); //NOI18N
+ query.setParameter("sharer", addressbook.getAddressbookUser()); //NOI18N
+
+ // Return it
+ return query.getResultList();
+ }
@Override
@SuppressWarnings ("unchecked")
- public List<Addressbook> getUsersList (final User loggedInUser) {
- // Get query instance
- Query query = this.getEntityManager().createNamedQuery("AllUsersAddressbooks"); //NOI18N
+ public Integer countAllUserSharedAddressbooks (final User user) {
+ // Trace message
+ this.getLoggerBeanLocal().logTrace(MessageFormat.format("countAllUserSharedAddressbooks: user={0} - CALLED!", user)); //NOI18N
+
+ // user should be valid
+ if (null == user) {
+ // Throw NPE
+ throw new NullPointerException("user is null"); //NOI18N
+ } else if (user.getUserId() == null) {
+ // Throw NPE again
+ throw new NullPointerException("user.userId is null"); //NOI18N
+ } else if (user.getUserId() < 1) {
+ // Invalid id
+ throw new IllegalArgumentException(MessageFormat.format("user.userId={0} is invalid", user.getUserId())); //NOI18N
+ }
+
+ // Get named query
+ Query query = this.getEntityManager().createNamedQuery("SearchUserSharedAddressbooks", List.class); //NOI18N
// Set parameter
- query.setParameter("param", loggedInUser); //NOI18N
+ query.setParameter("user", user); //NOI18N
- // Get full list from JPA
- List<Addressbook> addressbooks = query.getResultList();
+ // Default is zero
+ Integer count = 0;
- // Return it
- return addressbooks;
+ // Try it
+ try {
+ // Get whole list
+ List<ShareableAddressbook> dummy = query.getResultList();
+
+ // Set size
+ count = dummy.size();
+ } catch (final NoResultException ex) {
+ // Need to catch this, so log it
+ this.getLoggerBeanLocal().logDebug(MessageFormat.format("countAllUserSharedAddressbooks: getResultList() failed: {0}", ex)); //NOI18N
+ }
+
+ // Trace message
+ this.getLoggerBeanLocal().logTrace(MessageFormat.format("countAllUserSharedAddressbooks: count={0} - EXIT!", count)); //NOI18N
+
+ // Return count
+ return count;
}
@Override
// Is it not null?
if (null == addressbook) {
// Abort here
- throw new NullPointerException("addressbook is null");
+ throw new NullPointerException("addressbook is null"); //NOI18N
} else if (addressbook.getAddressbookUser() == null) {
// User instance is null
- throw new IllegalArgumentException("addressbook.user should not be null.");
+ throw new NullPointerException("addressbook.user should not be null."); //NOI18N
} else if (addressbook.getAddressbookName() == null) {
// Address book name not set
- throw new IllegalArgumentException("addressbook.addressbookName should not be null");
+ throw new NullPointerException("addressbook.addressbookName should not be null"); //NOI18N
} else if (addressbook.getAddressbookName().isEmpty()) {
// Address book name not set
- throw new IllegalArgumentException("addressbook.addressbookName should not be empty");
+ throw new IllegalArgumentException("addressbook.addressbookName should not be empty"); //NOI18N
} else if (this.isAddressbookNameUsed(addressbook)) {
// The assigned user already used that name
throw new AddressbookNameAlreadyUsedException(addressbook);
return addressbook;
}
+ @Override
+ public Addressbook getAddressbookById (final Long addressbookId) throws AddressbookNotFoundException {
+ // Trace message
+ this.getLoggerBeanLocal().logTrace(MessageFormat.format("getAddressbookById: addressbookId={0} - CALLED!", addressbookId)); //NOI18N
+
+ // addressbookId should not be null or below 1
+ if (null == addressbookId) {
+ // Throw NPE
+ throw new NullPointerException("addressbookId is null"); //NOI18N
+ } else if (addressbookId < 1) {
+ // Not valid
+ throw new IllegalArgumentException(MessageFormat.format("addressbookId is not valid: {0}", addressbookId)); //NOI18N
+ } else if (!this.isAddressbookIdUsed(addressbookId)) {
+ // No address book found
+ throw new AddressbookNotFoundException(addressbookId);
+ }
+
+ // Get named query instance
+ Query query = this.getEntityManager().createNamedQuery("SearchAddressbookById", UserAddressbook.class); //NOI18N
+
+ // Set parameter
+ query.setParameter("id", addressbookId); //NOI18N
+
+ // Return it
+ return (Addressbook) query.getSingleResult();
+ }
+
+ @Override
+ @SuppressWarnings ("unchecked")
+ public List<Addressbook> getUsersList (final User loggedInUser) {
+ // Trace message
+ this.getLoggerBeanLocal().logTrace(MessageFormat.format("getUsersList: loggedInUser={0} - CALLED!", loggedInUser)); //NOI18N
+
+ // Is the user instance null?
+ if (null == loggedInUser) {
+ // Abort here
+ throw new NullPointerException("loggedInUser is null"); //NOI18N
+ }
+
+ // Get query instance
+ Query query = this.getEntityManager().createNamedQuery("AllUsersAddressbooks", List.class); //NOI18N
+
+ // Set parameter
+ query.setParameter("param", loggedInUser); //NOI18N
+
+ // Get full list from JPA
+ List<Addressbook> addressbooks = query.getResultList();
+
+ // Return it
+ return addressbooks;
+ }
+
+ @Override
+ public boolean isAddressbookIdUsed (final Long addressbookId) {
+ // Trace message
+ this.getLoggerBeanLocal().logTrace(MessageFormat.format("isAddressbookIdUsed: addressbookId={0} - CALLED!", addressbookId)); //NOI18N
+
+ // Is it null or zero?
+ if (null == addressbookId) {
+ // Throw NPE
+ throw new NullPointerException("addressbookId is null"); //NOI18N
+ } else if (addressbookId < 1) {
+ // Not valid id number
+ throw new IllegalArgumentException(MessageFormat.format("addressbookId is not valid: {0}", addressbookId)); //NOI18N
+ }
+
+ // Get query instance
+ Query query = this.getEntityManager().createNamedQuery("SearchAddressbookById", UserAddressbook.class); //NOI18N
+
+ // Set parameter
+ query.setParameter("id", addressbookId); //NOI18N
+
+ // Default is not valid
+ boolean isValid = false;
+
+ // Try it again, yes no other way
+ try {
+ // Get single result
+ Addressbook addressbook = (Addressbook) query.getSingleResult();
+
+ // Debug message
+ this.getLoggerBeanLocal().logDebug(MessageFormat.format("isAddressbookIdUsed: addressbook={0} - FOUND!", addressbook)); //NOI18N
+
+ // Found one!
+ isValid = true;
+ } catch (final NoResultException ex) {
+ // Debug log only, maybe out-dated link followed
+ this.getLoggerBeanLocal().logDebug(MessageFormat.format("isAddressbookIdUsed: addressbookId={0} is not valid: {1}", addressbookId, ex)); //NOI18N
+ }
+
+ // Trace message
+ this.getLoggerBeanLocal().logTrace(MessageFormat.format("isAddressbookIdUsed: isValid={0} - EXIT!", isValid)); //NOI18N
+
+ // Return result
+ return isValid;
+ }
+
@Override
public boolean isAddressbookNameUsed (final Addressbook addressbook) {
- throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
+ // Is it not null?
+ if (null == addressbook) {
+ // Abort here
+ throw new NullPointerException("addressbook is null"); //NOI18N
+ } else if (addressbook.getAddressbookUser() == null) {
+ // User instance is null
+ throw new NullPointerException("addressbook.user should not be null."); //NOI18N
+ } else if (addressbook.getAddressbookName() == null) {
+ // Address book name not set
+ throw new NullPointerException("addressbook.addressbookName should not be null"); //NOI18N
+ } else if (addressbook.getAddressbookName().isEmpty()) {
+ // Address book name not set
+ throw new IllegalArgumentException("addressbook.addressbookName should not be empty"); //NOI18N
+ }
+
+ // Get query instance
+ Query query = this.getEntityManager().createNamedQuery("SearchUserAddressbookName", Addressbook.class); //NOI18N
+
+ // Set parameter
+ query.setParameter("user", addressbook.getAddressbookUser()); //NOI18N
+ query.setParameter("name", addressbook.getAddressbookName()); //NOI18N
+
+ // Default is not found
+ boolean isUsed = false;
+
+ // Try it
+ try {
+ // Get a single result
+ Addressbook dummy = (Addressbook) query.getSingleResult();
+
+ // Log it
+ this.getLoggerBeanLocal().logDebug(MessageFormat.format("isAddressbookNameUsed: Found an address book: {0}", dummy)); //NOI18N
+
+ // Found one
+ isUsed = true;
+ } catch (final NoResultException ex) {
+ // No result found, so log it away
+ this.getLoggerBeanLocal().logDebug(MessageFormat.format("isAddressbookNameUsed: getSingleResult() did not return a result: {0}", ex)); //NOI18N
+ }
+
+ // Return result
+ return isUsed;
}
}