za.co.knonchalant.candogram.dao.PendingResponseDAO Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of CanDoGram Show documentation

Wraps Telegram and Discord bot API, so you can code once and deploy multi.

The newest version!

package za.co.knonchalant.candogram.dao;


import za.co.knonchalant.candogram.domain.PendingResponse;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import javax.persistence.TypedQuery;
import java.util.List;

@Stateless
public class PendingResponseDAO {
    @PersistenceContext
    EntityManager em;

    public PendingResponse persistPendingResponse(PendingResponse pendingResponse) {
        return em.merge(pendingResponse);
    }

    public void markDone(PendingResponse response) {
        response.setComplete(true);
        em.merge(response);
    }

    public List getPendingResponses(Long userId, Long chatId) {
        TypedQuery query = em.createQuery("Select n from PendingResponse n where n.chatId = :chatId and n.userId = :userId and n.complete = false", PendingResponse.class);
        query.setParameter("chatId", chatId);
        query.setParameter("userId", userId);
        return query.getResultList();
    }

    public void delete(PendingResponse pendingResponse) {
        em.remove(pendingResponse);
    }

    public void clearPending(long userId, long chatId) {
        Query query = em.createQuery("delete from PendingResponse n where n.chatId = :chatId and n.userId = :userId");
        query.setParameter("chatId", chatId);
        query.setParameter("userId", userId);
        query.executeUpdate();
    }
}