This might be a good opportunity to remind you again of the possibility of switching from mocking (which is usually not recommended for non-trivial tests and non-quick-and-dirty-setups, see also comments in the doc or Javadoc) to integration testing using e.g. https://www.testcontainers.org. Just a thought :)
On Tue, Jun 22, 2021 at 10:29 PM Debapriya Patra <debapriya.pa...@gmail.com> wrote: > yes, when the courseId is passed it might be a match with course_id column > value or edu_custom_course_id column value and returns that row. Regarding > the fake UUID, yes, the same is being passed to the unit test case to match > the data. > > Thanks, > Deba > > On Tuesday, June 22, 2021 at 1:12:06 PM UTC-7 robjs...@gmail.com wrote: > >> From the original post >> >> select `content_management`.`edu_course_content`.`course_id`, >> `content_management`.`edu_course_content`.`edu_custom_course_id`, >> `content_management`.`edu_course_content`.`edu_content_id` from >> `content_management`.`edu_course_content` where >> (`content_management`.`edu_course_content`.`edu_content_id` in >> ('a32ba478-90d9-4c7c-85e9-2899bddab41f', >> 'a32ba478-90d9-4c7c-85e9-2899bddab42f') and >> (`content_management`.`edu_course_content`.`course_id` = ' >> *132ba478-90d9-4c7c-85e9-2899bddab41f*' or >> `content_management`.`edu_course_content`.`edu_custom_course_id` = ' >> *132ba478-90d9-4c7c-85e9-2899bddab41f*')) >> >> is it expected that the first course_id value will be used twice from the >> input data? >> >> > seq course_id edu_custom_course_id >> edu_content_id >> > ----- ------------------------------------- ----------------------- >> -------------------------------------- >> > 1 132ba478-90d9-4c7c-85e9-2899bddab41f null >> a32ba478-90d9-4c7c-85e9-2899bddab41f >> > 2 132ba478-90d9-4c7c-85e9-2899bddab41e null >> a32ba478-90d9-4c7c-85e9-2899bddab42f >> @ rows: 2 >> >> Looks like your faking UUIDs! This can lead to confusion. >> > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to jooq-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/a2014024-b2fd-4489-9e3e-b3c1ab0699e5n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/a2014024-b2fd-4489-9e3e-b3c1ab0699e5n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4R9MMmXkOHOEN6nqpVCyetuyxRBO2yEG0pvF0kT4reJg%40mail.gmail.com.