/**
* Return a page
*
* @param page Page to display
* @param pageSize Number of publicacao per page
* @param sortBy publicacao titulo property used for sorting
* @param order Sort order (either or asc or desc)
* @param filter Filter applied on the name column
*/
public static PagedList<Album> page(
int page, int pageSize, String sortBy, String order, String filter) {
return find.where()
.ilike("titulo", "%" + filter + "%")
.orderBy(sortBy + " " + order)
.findPagedList(page, pageSize);
}
/**
* Finds all sellers in database and orders them by first name ascending.
*
* @return <code>List</code> type value of AppUser
*/
public static List<AppUser> getAllSellersOrderedByFirstname() {
return finder
.where()
.eq("user_access_level", UserAccessLevel.SELLER)
.orderBy("firstname asc")
.findList();
}
public static <T extends UserAction> int countBy(
Finder<Long, T> finder, ResourceType resourceType, String resourceId) {
return finder
.where()
.eq("resourceType", resourceType)
.eq("resourceId", resourceId)
.findRowCount();
}
public static int getTotalPrivateSearchPageCount(String searchTerm, String user, int pageSize) {
PagingList<Scenario> pagingList =
find.where()
.eq("members.email", user)
.icontains("name", searchTerm)
.findPagingList(pageSize);
return pagingList.getTotalPageCount();
}
/**
* 주어진 {@code attach}와 내용이 같은 첨부 파일을 찾는다.
*
* <p>내용이 같은 첨부 파일이라고 하는 것은 이름과 파일의 내용이 같고 첨부된 리소스도 같은 것을 말한다. 구체적으로 말하면 {@link Attachment#name},
* {@link Attachment#hash}, {@link Attachment#containerType}, {@link Attachment#containerId}가 서로
* 같은 첨부이다.
*
* @param attach 이 첨부 파일과 내용이 같은 첨부 파일을 찾는다.
* @return 발견된 첨부 파일
*/
private static Attachment findBy(Attachment attach) {
return find.where()
.eq("name", attach.name)
.eq("hash", attach.hash)
.eq("containerType", attach.containerType)
.eq("containerId", attach.containerId)
.findUnique();
}
/**
* Checks if user with provided email exists in database. Should be used when using an email from
* the cookies, to be sure that email from cookies exists in the database.
*
* @param email
* @returns App_User object if user exists, and NULL if doesn't.
*/
public static AppUser existsInDB(String email) {
AppUser user = finder.where().eq("email", email.toString()).findUnique();
if (user == null) {
return null;
} else {
return user;
}
}
public static List<Post_thread> all(String usrInterest) {
return find.where()
.eq("interest", usrInterest)
.order()
.desc("id")
.fetch("user")
.setMaxRows(8)
.findList();
}
/**
* {@code project}에서 보낸 풀리퀘 목록 중 한 페이지를 가져온다.
*
* <p>{@code pageNum}은 0부터 시작하고, 한 페이지당 {@code ITEMS_PER_PAGE} 만큼 가져온다.
*
* @param project
* @param pageNum
* @return
*/
public static Page<PullRequest> findSentPullRequests(Project project, int pageNum) {
return finder
.where()
.eq("fromProject", project)
.order()
.desc("created")
.findPagingList(ITEMS_PER_PAGE)
.getPage(pageNum);
}
public static List<PullRequest> findByFromProjectAndBranch(
Project fromProject, String fromBranch) {
return finder
.where()
.eq("fromProject", fromProject)
.eq("fromBranch", fromBranch)
.or(eq("state", State.OPEN), eq("state", State.REJECTED))
.findList();
}
public static List<PullRequest> findAcceptedPullRequests(Project project) {
return finder
.where()
.eq("fromProject", project)
.or(eq("state", State.CLOSED), eq("state", State.MERGED))
.order()
.desc("created")
.findList();
}
public static List<PullRequest> findOpendPullRequests(Project project) {
return finder
.where()
.eq("toProject", project)
.eq("state", State.OPEN)
.order()
.desc("created")
.findList();
}
/**
* Return a page of Performance
*
* @param page Page to display
* @param pageSize Number of computers per page
* @param sortBy Computer property used for sorting
* @param order Sort order (either or asc or desc)
* @param filter Filter applied on the name column
*/
public static Page<Performance> page(
int page, int pageSize, String sortBy, String order, String filter) {
return find.where()
.ilike("name", "%" + filter + "%")
.orderBy(sortBy + " " + order)
.fetch("INSERT FOREIGN KEY NAME")
.findPagingList(pageSize)
.getPage(page);
}
public static <T extends UserAction> T findBy(
Finder<Long, T> finder, User subject, ResourceType resourceType, String resourceId) {
return finder
.where()
.eq("user.id", subject.id)
.eq("resourceType", resourceType)
.eq("resourceId", resourceId)
.findUnique();
}
/**
* {@code project}에서 {@code state}에 해당하는 풀리퀘 목록 중 한 페이지를 가져온다.
*
* <p>{@code pageNum}은 0부터 시작하고, 한 페이지당 {@code ITEMS_PER_PAGE} 만큼 가져온다.
*
* @param state
* @param project
* @param pageNum
* @return
*/
public static Page<PullRequest> findPagingList(State state, Project project, int pageNum) {
return finder
.where()
.eq("toProject", project)
.eq("state", state)
.order()
.desc("number")
.findPagingList(ITEMS_PER_PAGE)
.getPage(pageNum);
}
public static List<PullRequest> findRecentlyReceived(Project project, int size) {
return finder
.where()
.eq("toProject", project)
.order()
.desc("created")
.findPagingList(size)
.getPage(0)
.getList();
}
public static List<Scenario> findInvolvingUserSearch(
String searchTerm, String user, int pageSize, int pageNum) {
PagingList<Scenario> pagingList =
find.where()
.eq("members.email", user)
.icontains("name", searchTerm)
.findPagingList(pageSize);
Page<Scenario> page = pagingList.getPage(pageNum);
return page.getList();
}
public static PullRequest findDuplicatedPullRequest(PullRequest pullRequest) {
return finder
.where()
.eq("fromBranch", pullRequest.fromBranch)
.eq("toBranch", pullRequest.toBranch)
.eq("fromProject", pullRequest.fromProject)
.eq("toProject", pullRequest.toProject)
.eq("state", State.OPEN)
.findUnique();
}
/**
* Returns the PerformanceID of given performance time
*
* @param performanceTime Which subversion number to find ID for
* @return id of Performance. Creates new one if no performanceTime already existed
*/
public static Long getPerformanceID(String performanceTime) { // Used in saveRun
Performance performance = find.where().eq("time", performanceTime).findUnique();
if (performance == null) { // If no Performance was found... add it and return that id
Performance newPerformance = new Performance();
newPerformance.time = performanceTime;
newPerformance.save();
return newPerformance.id;
}
return performance.id;
}
public static int getTotalToAcceptPageCount(Date currentDate, int pageSize) {
return find.where()
.eq("isAccepted", false)
.eq("isPublic", true)
.or(
com.avaje.ebean.Expr.lt("expirationDate", currentDate),
com.avaje.ebean.Expr.isNull("expirationDate"))
.findPagingList(pageSize)
.getTotalPageCount();
}
/**
* 받은 코드 목록을 반환한다.
*
* <p>받은 코드는 닫혔(Closed)거나 병합(Merged)된 코드이다.
*
* @param project
* @param pageNum
* @return
*/
public static Page<PullRequest> findClosedPagingList(Project project, int pageNum) {
return finder
.where()
.eq("toProject", project)
.or(eq("state", State.CLOSED), eq("state", State.MERGED))
.order()
.desc("received")
.findPagingList(ITEMS_PER_PAGE)
.getPage(pageNum);
}
/**
* 보내거나 받는 쪽에 {@code project} 의 {@code branch} 를 가지고 있는 pull-request 목록 조회
*
* <p>병합(Closed)되지 않은 모든 보낸코드를 조회한다.
*
* @param project
* @param branch
* @return
*/
public static List<PullRequest> findRelatedPullRequests(Project project, String branch) {
return finder
.where()
.or(
Expr.and(eq("fromProject", project), eq("fromBranch", branch)),
Expr.and(eq("toProject", project), eq("toBranch", branch)))
.ne("state", State.CLOSED)
.ne("state", State.MERGED)
.findList();
}
public static List<PullRequest> findOpendPullRequestsByDaysAgo(Project project, int days) {
return finder
.where()
.eq("toProject", project)
.eq("state", State.OPEN)
.ge("created", JodaDateUtil.before(days))
.order()
.desc("created")
.findList();
}
/**
* Tries to authenticate user who is trying to log in. Hashes entered password for entered email,
* and checks if provided combination exists in the database.
*
* @param email
* @param password
* @return
*/
public static AppUser authenticate(String email, String password) {
AppUser user = finder.where().eq("email", email.toString()).findUnique();
if (user != null && BCrypt.checkpw(password, user.password)) {
return user;
} else {
return null;
}
}
public static int getTotalPublicAcceptedNotExpiredPageCount(int pageSize, Date currentDate) {
PagingList<Scenario> pagingList =
find.where()
.eq("isPublic", true)
.eq("isAccepted", true)
.or(
com.avaje.ebean.Expr.lt("expirationDate", currentDate),
com.avaje.ebean.Expr.isNull("expirationDate"))
.findPagingList(pageSize);
return pagingList.getTotalPageCount();
}
public static Set<PassageQuestionRecord> byUserAndPassage(User user, SimplePassage passage) {
ArrayList<String> lessonQuestionIds = new ArrayList<String>(passage.questions.size());
for (PassageQuestion question : passage.questions) {
lessonQuestionIds.add(question.id.toString());
}
return find.where()
.ne("disavowed", true)
.eq("user_id", user.id)
.in("passage_question_id", lessonQuestionIds)
.findSet();
}
public static List<Scenario> findToAccept(Date currentDate, int pageSize, int pageNum) {
PagingList<Scenario> pagingList =
find.where()
.eq("isAccepted", false)
.eq("isPublic", true)
.or(
com.avaje.ebean.Expr.lt("expirationDate", currentDate),
com.avaje.ebean.Expr.isNull("expirationDate"))
.findPagingList(pageSize);
Page<Scenario> page = pagingList.getPage(pageNum);
return page.getList();
}
/**
* {@code fromProject}의 {@code fromBranch}에서 보낸 가장 최근 코드보내기 요청을 찾는다.
*
* <p>fromProject와 toProject가 같은 수도 있다고 가정한다. {@code fromProject}가 fork 프로젝트 일때는 upstream으로 보낸
* 코드보내기 요청을 포함하여 찾는다.
*
* <p>when: 코드 메뉴의 브랜치 탭에서 브랜치 목록을 보여줄 때 특정 브랜치와 관련있는 코드보내기 요청을 찾을 때 사용한다.
*
* @param fromProject
* @param fromBranch
* @return
*/
public static PullRequest findTheLatestOneFrom(Project fromProject, String fromBranch) {
ExpressionList<PullRequest> el =
finder.where().eq("fromProject", fromProject).eq("fromBranch", fromBranch);
if (fromProject.isForkedFromOrigin()) {
el.in("toProject", fromProject, fromProject.originalProject);
} else {
el.eq("toProject", fromProject);
}
return el.order().desc("number").setMaxRows(1).findUnique();
}
public static Doctor findByFullName(String fullName) {
String[] fio = fullName.split(" ");
String query = "find doctor where name=:name and surname=:surname and patronymic=:patronymic";
/*Doctor doctor = Ebean.find(Doctor.class).setQuery(query).setParameter("surname", fio[0])
.setParameter("name", fio[1]).setParameter("patronymic", fio[2]).findUnique(); */
Doctor doctor =
find.setQuery(query)
.setParameter("surname", fio[0])
.setParameter("name", fio[1])
.setParameter("patronymic", fio[2])
.findUnique();
return doctor;
}
public static List<Scenario> findPublicAcceptedNotExpiredSearch(
String searchTerm, Date currentDate, int pageSize, int pageNum) {
PagingList<Scenario> pagingList =
find.where()
.eq("isPublic", true)
.eq("isAccepted", true)
.or(
com.avaje.ebean.Expr.gt("expirationDate", currentDate),
com.avaje.ebean.Expr.isNull("expirationDate"))
.icontains("name", searchTerm)
.findPagingList(pageSize);
Page<Scenario> page = pagingList.getPage(pageNum);
return page.getList();
}
public static PassageQuestionRecord byMostRecentForUser(User user, PassageQuestion question) {
List<PassageQuestionRecord> theList =
find.where()
.ne("disavowed", true)
.eq("user_id", user.id)
.eq("passage_question_id", question.id)
.findList();
if (theList.size() == 0) {
return null;
} else {
return theList.get(theList.size() - 1);
}
}
