package com.gzzm.lobster.feedback;

import net.cyan.thunwind.annotation.OQL;
import net.cyan.thunwind.dao.GeneralDao;

import java.util.Date;
import java.util.List;

public abstract class UserFeedbackDao extends GeneralDao {

    @OQL("select f from UserFeedback f where f.runId=:1")
    public abstract UserFeedback getByRun(String runId) throws Exception;

    @OQL("select f from UserFeedback f where f.userId=:1 order by f.createTime desc limit 0,:2")
    public abstract List<UserFeedback> listByUser(String userId, int limit) throws Exception;

    @OQL("select count(f.feedbackId) from UserFeedback f where f.feedbackType=?1 and f.createTime>=?2")
    public abstract Long countSince(String feedbackType, Date since) throws Exception;
}