Java SUBSCRIPTIONS.NEWS_SOURCE_ID Examples

Example #1

File: MysqlSubscriptionDAO.java Project: davidmotson/kindlenews

 @Override
 public List<MailTask> getMailTasksForToday() {
   String dayOfWeek = getDayAsRegex();
   return dsl.select(NEWS_SOURCES.RECIPE_FILE, USERS.KINDLE_EMAIL)
       .from(
           NEWS_SOURCES
               .join(SUBSCRIPTIONS)
               .on(SUBSCRIPTIONS.NEWS_SOURCE_ID.eq(NEWS_SOURCES.ID))
               .join(USERS)
               .on(SUBSCRIPTIONS.USER_ID.eq(USERS.ID)))
       .where(NEWS_SOURCES.CONTENT_DAYS.like(dayOfWeek))
       .fetch()
       .map(
           x ->
               new MailTask(
                   x.getValue(USERS.KINDLE_EMAIL, String.class),
                   x.getValue(NEWS_SOURCES.RECIPE_FILE, String.class)));
 }

Example #2

File: MysqlSubscriptionDAO.java Project: davidmotson/kindlenews

 @Override
 public void unsubscribe(int userId, int newsSourceId) {
   dsl.delete(SUBSCRIPTIONS)
       .where(SUBSCRIPTIONS.USER_ID.eq(userId).and(SUBSCRIPTIONS.NEWS_SOURCE_ID.eq(newsSourceId)))
       .execute();
 }