ContestProblemDao.java

package org.iatoki.judgels.uriel.models.daos;

import org.iatoki.judgels.play.models.daos.Dao;
import org.iatoki.judgels.uriel.models.entities.ContestProblemModel;

import java.util.List;

public interface ContestProblemDao extends Dao<Long, ContestProblemModel> {

    List<ContestProblemModel> findByContestJid(String contestJid);

    ContestProblemModel findByProblemJidOrderedByAlias(String contestJid, String problemJid);

    boolean existsByProblemJid(String contestJid, String problemJid);

    boolean existsByProblemAlias(String contestJid, String problemAlias);

    List<ContestProblemModel> findOpenedByContestJidOrderedByAlias(String contestJid);

    List<ContestProblemModel> findUsedByContestJidOrderedByAlias(String contestJid);

    long countValidByContestJid(String contestJid);

    List<ContestProblemModel> findUsedByContestJidOrderedByStatusAndThenAlias(String contestJid, long offset, long limit);

    boolean isThereNewProblem(String contestJid, long lastTime);
}