Package org.apache.camel.component.jooq.db.tables.daos

Class BookDao

    • Constructor Detail

      • BookDao

        public BookDao()
        Create a new BookDao without any configuration

      • BookDao

        @Autowired
public BookDao​(org.jooq.Configuration configuration)
        Create a new BookDao with an attached configuration

    • Method Detail

      • fetchRangeOfId

        public List<Book> fetchRangeOfId​(Integer lowerInclusive,
                                 Integer upperInclusive)
        Fetch records that have ID BETWEEN lowerInclusive AND upperInclusive

      • fetchById

        public List<Book> fetchById​(Integer... values)
        Fetch records that have ID IN (values)

      • fetchOneById

        public Book fetchOneById​(Integer value)
        Fetch a unique record that has ID = value

      • fetchOptionalById

        public Optional<Book> fetchOptionalById​(Integer value)
        Fetch a unique record that has ID = value

      • fetchRangeOfAuthorId

        public List<Book> fetchRangeOfAuthorId​(Integer lowerInclusive,
                                       Integer upperInclusive)
        Fetch records that have AUTHOR_ID BETWEEN lowerInclusive AND upperInclusive

      • fetchByAuthorId

        public List<Book> fetchByAuthorId​(Integer... values)
        Fetch records that have AUTHOR_ID IN (values)

      • fetchRangeOfCoAuthorId

        public List<Book> fetchRangeOfCoAuthorId​(Integer lowerInclusive,
                                         Integer upperInclusive)
        Fetch records that have CO_AUTHOR_ID BETWEEN lowerInclusive AND upperInclusive

      • fetchByCoAuthorId

        public List<Book> fetchByCoAuthorId​(Integer... values)
        Fetch records that have CO_AUTHOR_ID IN (values)

      • fetchRangeOfDetailsId

        public List<Book> fetchRangeOfDetailsId​(Integer lowerInclusive,
                                        Integer upperInclusive)
        Fetch records that have DETAILS_ID BETWEEN lowerInclusive AND upperInclusive

      • fetchByDetailsId

        public List<Book> fetchByDetailsId​(Integer... values)
        Fetch records that have DETAILS_ID IN (values)

      • fetchRangeOfTitle

        public List<Book> fetchRangeOfTitle​(String lowerInclusive,
                                    String upperInclusive)
        Fetch records that have TITLE BETWEEN lowerInclusive AND upperInclusive

      • fetchByTitle

        public List<Book> fetchByTitle​(String... values)
        Fetch records that have TITLE IN (values)

      • fetchRangeOfPublishedIn

        public List<Book> fetchRangeOfPublishedIn​(Integer lowerInclusive,
                                          Integer upperInclusive)
        Fetch records that have PUBLISHED_IN BETWEEN lowerInclusive AND upperInclusive

      • fetchByPublishedIn

        public List<Book> fetchByPublishedIn​(Integer... values)
        Fetch records that have PUBLISHED_IN IN (values)

      • fetchRangeOfLanguageId

        public List<Book> fetchRangeOfLanguageId​(Integer lowerInclusive,
                                         Integer upperInclusive)
        Fetch records that have LANGUAGE_ID BETWEEN lowerInclusive AND upperInclusive

      • fetchByLanguageId

        public List<Book> fetchByLanguageId​(Integer... values)
        Fetch records that have LANGUAGE_ID IN (values)

      • fetchRangeOfContentText

        public List<Book> fetchRangeOfContentText​(String lowerInclusive,
                                          String upperInclusive)
        Fetch records that have CONTENT_TEXT BETWEEN lowerInclusive AND upperInclusive

      • fetchByContentText

        public List<Book> fetchByContentText​(String... values)
        Fetch records that have CONTENT_TEXT IN (values)

      • fetchRangeOfContentPdf

        public List<Book> fetchRangeOfContentPdf​(byte[] lowerInclusive,
                                         byte[] upperInclusive)
        Fetch records that have CONTENT_PDF BETWEEN lowerInclusive AND upperInclusive

      • fetchByContentPdf

        public List<Book> fetchByContentPdf​(byte[]... values)
        Fetch records that have CONTENT_PDF IN (values)

      • fetchRangeOfRecVersion

        public List<Book> fetchRangeOfRecVersion​(Integer lowerInclusive,
                                         Integer upperInclusive)
        Fetch records that have REC_VERSION BETWEEN lowerInclusive AND upperInclusive

      • fetchByRecVersion

        public List<Book> fetchByRecVersion​(Integer... values)
        Fetch records that have REC_VERSION IN (values)

      • fetchRangeOfRecTimestamp

        public List<Book> fetchRangeOfRecTimestamp​(LocalDateTime lowerInclusive,
                                           LocalDateTime upperInclusive)
        Fetch records that have REC_TIMESTAMP BETWEEN lowerInclusive AND upperInclusive

      • fetchByRecTimestamp

        public List<Book> fetchByRecTimestamp​(LocalDateTime... values)
        Fetch records that have REC_TIMESTAMP IN (values)