Package com.ubs.backend.classes.database.dao.questions

Class AnsweredQuestionTimesResultDAO

java.lang.Object

com.ubs.backend.classes.database.dao.DAO<AnsweredQuestionTimesResult>

com.ubs.backend.classes.database.dao.questions.AnsweredQuestionTimesResultDAO

public class AnsweredQuestionTimesResultDAO
extends DAO<AnsweredQuestionTimesResult>

Constructor Summary

Constructors

Constructor	Description
AnsweredQuestionTimesResultDAO()

Method Summary

Modifier and Type	Method	Description
long	countMonthly(StatistikTimes times)
long	countMonthly(StatistikTimes times, javax.persistence.EntityManager em)
private @NotNull List<TempAnsweredQuestionTimesResult>	getTempAnsweredQuestionTimesResultsMonthlyViews(javax.persistence.EntityManager em, long month, long year, List<AnsweredQuestionTimesResult> answeredQuestionTimesResults)
Long	getTotalCount(AnsweredQuestionTimesResult answeredQuestionTimesResult, javax.persistence.EntityManager em)
void	removeByAnsweredQuestion(long id, javax.persistence.EntityManager em)
void	removeByResult(long resultID, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectByAnswer(long answerId)
List<TempAnsweredQuestionTimesResult>	selectByAnswer(long answerId, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectByDayGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectByHourGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectByMonthGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<AnsweredQuestionTimesResult>	selectByQuestion(long questionId, javax.persistence.EntityManager em)
List<AnsweredQuestionTimesResult>	selectByResult(long resultId, javax.persistence.EntityManager em)
List<AnsweredQuestionTimesResult>	selectByResultQuestionAndTime(ResultParent resultParent, String question, StatistikTimes times, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectByTimeGroupedByQuestion(long userID, TimeSearchType time, StatistikTimes statistikTimes)
List<TempAnsweredQuestionTimesResult>	selectByTimeGroupedByQuestion(TimeSearchType time, StatistikTimes statistikTimes)
List<TempAnsweredQuestionTimesResult>	selectByTimeGroupedByQuestion(Long userID, TimeSearchType time, StatistikTimes statistikTimes, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectByWeekGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectByYearGroupedByQuestion(StatistikTimes times, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectGroupedByQuestion(javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectMonthlyOrderedByUpvotes(StatistikTimes times, int max)
List<TempAnsweredQuestionTimesResult>	selectMonthlyOrderedByUpvotes(StatistikTimes times, int max, javax.persistence.EntityManager em)
List<TempAnsweredQuestionTimesResult>	selectSinceLastLoginGroupedByQuestion(long userID, javax.persistence.EntityManager em)
void	vote(ResultParent resultParent, boolean isUpvote, boolean revert, String question, javax.persistence.EntityManager em)
void	voteWithMatch(long matchID, long answerID, boolean isUpvote, boolean revert, String question, javax.persistence.EntityManager em)

Methods inherited from class com.ubs.backend.classes.database.dao.DAO

insert, insert, merge, remove, remove, remove, select, select, select, select

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

AnsweredQuestionTimesResultDAO

public AnsweredQuestionTimesResultDAO()

Method Details

selectMonthlyOrderedByUpvotes

public List<TempAnsweredQuestionTimesResult> selectMonthlyOrderedByUpvotes(StatistikTimes times,
 int max,
 javax.persistence.EntityManager em)

Parameters:

times -

max -

em -

Returns:

Since:

03.08.2021

getTempAnsweredQuestionTimesResultsMonthlyViews

@NotNull
private @NotNull List<TempAnsweredQuestionTimesResult> getTempAnsweredQuestionTimesResultsMonthlyViews(javax.persistence.EntityManager em,
 long month,
 long year,
 List<AnsweredQuestionTimesResult> answeredQuestionTimesResults)

selectMonthlyOrderedByUpvotes

public List<TempAnsweredQuestionTimesResult> selectMonthlyOrderedByUpvotes(StatistikTimes times,
 int max)

Parameters:

times -

max -

Returns:

Since:

03.08.2021

selectByResultQuestionAndTime

public List<AnsweredQuestionTimesResult> selectByResultQuestionAndTime(ResultParent resultParent,
 String question,
 StatistikTimes times,
 javax.persistence.EntityManager em)

voteWithMatch

public void voteWithMatch(long matchID,
 long answerID,
 boolean isUpvote,
 boolean revert,
 String question,
 javax.persistence.EntityManager em)

Parameters:

matchID -

answerID -

isUpvote -

revert -

question -

em -

Since:

21.08.2021

vote

public void vote(ResultParent resultParent,
 boolean isUpvote,
 boolean revert,
 String question,
 javax.persistence.EntityManager em)

removeByResult

public void removeByResult(long resultID,
 javax.persistence.EntityManager em)

Parameters:

resultID -

em -

Since:

04.08.2021

removeByAnsweredQuestion

public void removeByAnsweredQuestion(long id,
 javax.persistence.EntityManager em)

countMonthly

public long countMonthly(StatistikTimes times,
 javax.persistence.EntityManager em)

countMonthly

public long countMonthly(StatistikTimes times)

selectByTimeGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectByTimeGroupedByQuestion(long userID,
 TimeSearchType time,
 StatistikTimes statistikTimes)

Parameters:

userID -

time -

statistikTimes -

Returns:

Since:

29.08.2021

selectByTimeGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectByTimeGroupedByQuestion(TimeSearchType time,
 StatistikTimes statistikTimes)

Parameters:

time -

statistikTimes -

Returns:

Since:

29.08.2021

selectByTimeGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectByTimeGroupedByQuestion(Long userID,
 TimeSearchType time,
 StatistikTimes statistikTimes,
 javax.persistence.EntityManager em)

Parameters:

userID -

time -

statistikTimes -

em -

Returns:

selectByHourGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectByHourGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectByDayGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectByDayGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectByWeekGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectByWeekGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectByMonthGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectByMonthGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectByYearGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectByYearGroupedByQuestion(StatistikTimes times,
 javax.persistence.EntityManager em)

selectSinceLastLoginGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectSinceLastLoginGroupedByQuestion(long userID,
 javax.persistence.EntityManager em)

Parameters:

userID -

em -

Returns:

Since:

29.08.2021

selectGroupedByQuestion

public List<TempAnsweredQuestionTimesResult> selectGroupedByQuestion(javax.persistence.EntityManager em)

selectByQuestion

public List<AnsweredQuestionTimesResult> selectByQuestion(long questionId,
 javax.persistence.EntityManager em)

selectByAnswer

public List<TempAnsweredQuestionTimesResult> selectByAnswer(long answerId)

selectByAnswer

public List<TempAnsweredQuestionTimesResult> selectByAnswer(long answerId,
 javax.persistence.EntityManager em)

selectByResult

public List<AnsweredQuestionTimesResult> selectByResult(long resultId,
 javax.persistence.EntityManager em)

getTotalCount

public Long getTotalCount(AnsweredQuestionTimesResult answeredQuestionTimesResult,
 javax.persistence.EntityManager em)