@Override
    public UserModel getUserByEmail(String email, RealmModel realm) {
        logger.debug("User by email: " + email);
        TypedQuery<UserEntity> query = em.createNamedQuery(UserEntity.GET_USER_BY_EMAIL, UserEntity.class);
        query.setParameter("email", email);
        List<UserEntity> result = query.getResultList();
        if (result.isEmpty()) {
            logger.info("could not find email: " + email);
            return null;
        }
        return new UserAdapter(session, realm, model, result.get(0));
    }

    @Override
    public UserModel getUserById(String id, RealmModel realm) {
        String persistenceId = StorageId.externalId(id);
        UserEntity entity = em.find(UserEntity.class, Integer.parseInt(persistenceId));
        if (entity == null) {
            logger.info("User not found by id " + id);
            return null;
        }
        return new UserAdapter(session, realm, model, entity);
    }

    @Override
    public UserModel getUserByUsername(String username, RealmModel realm) {
        logger.debug("User by username: " + username);
        TypedQuery<UserEntity> query = em.createNamedQuery(UserEntity.GET_USER_BY_USERNAME, UserEntity.class);
        query.setParameter("login", username);
        List<UserEntity> result = query.getResultList();
        if (result.isEmpty()) {
            logger.info("could not find username: " + username);
            return null;
        }

        return new UserAdapter(session, realm, model, result.get(0));

    }