How to use

singleOrNull

method

in

leap.orm.query.Query

@Override
public UserDetails loadUserDetailsById(Object userId) {
  return lazyDao.get()
       .createNamedQuery(SQL_KEY_FIND_USER_DETAILS_BY_ID, SimpleUserDetails.class)
       .param(SQL_PARAM_USER_ID, userId)
       .singleOrNull();
}

@Override
public UserDetails loadUserDetailsByLoginName(String username) {
  return lazyDao.get()
      .createNamedQuery(SQL_KEY_FIND_USER_DETAILS_BY_LOGIN_NAME, SimpleUserDetails.class)
      .param(SQL_PARAM_LOGIN_NAME, username)
      .singleOrNull();
}

@Override
public AuthzSSOSession loadSessionById(String id) {
  AuthzSSOSessionEntity session = null;
  if(null != loadSessionByIdCommand) {
    session = dao.createQuery(AuthzSSOSessionEntity.class, loadSessionByIdCommand).singleOrNull();
  }else{
    session = dao.createCriteriaQuery(AuthzSSOSessionEntity.class)
        .where("id = ? and expiration > ?", new Object[]{id, new Date()})
        .singleOrNull();
  }
  if(null == session) {
    return null;
  }
  return createSessionFromEntity(session);
}

@Override
public AuthzSSOSession loadSessionByToken(String username, String token) {
  AuthzSSOSessionEntity session = null;
  if(null != loadSessionByTokenCommand) {
    session = dao.createQuery(AuthzSSOSessionEntity.class, loadSessionByTokenCommand).singleOrNull();
  }else{
    session = dao.createCriteriaQuery(AuthzSSOSessionEntity.class)
           .where("token = ? and user_name = ? and expiration > ?", new Object[]{token, username, new Date()})
           .firstOrNull();
  }
  if(null == session) {
    return null;
  }
  return createSessionFromEntity(session);
}

@Override
public AuthzSSOSession loadSessionByToken(String username, String token) {
  AuthzSSOSessionEntity session = null;
  if(null != loadSessionByTokenCommand) {
    session = dao.createQuery(AuthzSSOSessionEntity.class, loadSessionByTokenCommand).singleOrNull();
  }else{
    session = dao.createCriteriaQuery(AuthzSSOSessionEntity.class)
           .where("token = ? and user_name = ? and expiration > ?", new Object[]{token, username, new Date()})
           .firstOrNull();
  }
  if(null == session) {
    return null;
  }
  return createSessionFromEntity(session);
}

@Override
public AuthzSSOSession loadSessionById(String id) {
  AuthzSSOSessionEntity session = null;
  if(null != loadSessionByIdCommand) {
    session = dao.createQuery(AuthzSSOSessionEntity.class, loadSessionByIdCommand).singleOrNull();
  }else{
    session = dao.createCriteriaQuery(AuthzSSOSessionEntity.class)
        .where("id = ? and expiration > ?", new Object[]{id, new Date()})
        .singleOrNull();
  }
  if(null == session) {
    return null;
  }
  return createSessionFromEntity(session);
}