Class AuthorDao

    • Constructor Detail

      • AuthorDao

        public AuthorDao()
        Create a new AuthorDao without any configuration
      • AuthorDao

        @Autowired
        public AuthorDao​(org.jooq.Configuration configuration)
        Create a new AuthorDao with an attached configuration
    • Method Detail

      • fetchRangeOfId

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

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

        public Author fetchOneById​(Integer value)
        Fetch a unique record that has ID = value
      • fetchOptionalById

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

        public List<Author> fetchRangeOfFirstName​(String lowerInclusive,
                                                  String upperInclusive)
        Fetch records that have FIRST_NAME BETWEEN lowerInclusive AND upperInclusive
      • fetchByFirstName

        public List<Author> fetchByFirstName​(String... values)
        Fetch records that have FIRST_NAME IN (values)
      • fetchRangeOfLastName

        public List<Author> fetchRangeOfLastName​(String lowerInclusive,
                                                 String upperInclusive)
        Fetch records that have LAST_NAME BETWEEN lowerInclusive AND upperInclusive
      • fetchByLastName

        public List<Author> fetchByLastName​(String... values)
        Fetch records that have LAST_NAME IN (values)
      • fetchRangeOfDateOfBirth

        public List<Author> fetchRangeOfDateOfBirth​(LocalDate lowerInclusive,
                                                    LocalDate upperInclusive)
        Fetch records that have DATE_OF_BIRTH BETWEEN lowerInclusive AND upperInclusive
      • fetchByDateOfBirth

        public List<Author> fetchByDateOfBirth​(LocalDate... values)
        Fetch records that have DATE_OF_BIRTH IN (values)
      • fetchRangeOfYearOfBirth

        public List<Author> fetchRangeOfYearOfBirth​(Integer lowerInclusive,
                                                    Integer upperInclusive)
        Fetch records that have YEAR_OF_BIRTH BETWEEN lowerInclusive AND upperInclusive
      • fetchByYearOfBirth

        public List<Author> fetchByYearOfBirth​(Integer... values)
        Fetch records that have YEAR_OF_BIRTH IN (values)
      • fetchRangeOfAddress

        public List<Author> fetchRangeOfAddress​(String lowerInclusive,
                                                String upperInclusive)
        Fetch records that have ADDRESS BETWEEN lowerInclusive AND upperInclusive
      • fetchByAddress

        public List<Author> fetchByAddress​(String... values)
        Fetch records that have ADDRESS IN (values)