public List<Lecture> findBySpeaker(Speaker speaker) {
List<Lecture> lectures = new ArrayList<Lecture>();
QueryBuilder<LectureSpeaker, Integer> lectureSpeakerQB = getLectureSpeakerDao().queryBuilder();
lectureSpeakerQB.selectColumns(LectureSpeaker.LECTURE_ID_FIELD_NAME);
try {
lectureSpeakerQB.where().eq(LectureSpeaker.SPEAKER_ID_FIELD_NAME, speaker);
QueryBuilder<Lecture, Integer> lectureQB = getDao().queryBuilder();
lectureQB.where().in(Lecture.ID_FIELD_NAME, lectureSpeakerQB);
PreparedQuery<Lecture> lecturePrepare = lectureQB.prepare();
return getDao().query(lecturePrepare);
} catch (SQLException e) {
e.printStackTrace();
return lectures;
}
}
private PreparedQuery<ProjectBean> makeProjectForUserQuery() {
QueryBuilder<UserProjectMapping, Integer> userPostQb = userProjectMappingDao.queryBuilder();
userPostQb.selectColumns(UserProjectMapping.PROJECT_ID_FIELD_NAME);
SelectArg userSelectArg = new SelectArg();
QueryBuilder<ProjectBean, Integer> projectQb = null;
try {
userPostQb.where().eq(UserProjectMapping.USER_ID_FIELD_NAME, userSelectArg);
projectQb = projectDao.queryBuilder();
projectQb.where().eq("isDisabled", false).and().in(ProjectBean.ID_FIELD_NAME, userPostQb);
return projectQb.prepare();
} catch (SQLException e) {
logger.error(
"Error creating prepared query for fetching user mapped projects : " + e.getMessage());
}
return null;
}