0

I've been looking for a unit-testing framework for Cerner CCL (now with Oracle), and it looks like one does exist here:

https://github.com/cerner/cclunit-framework/blob/main/doc/CCLUNITTESTS.md

For those not familiar, Cerner CCL is structured very similarly to SQL, and also contains report-writing features.

What I'm curious about is how to unit-test query data (result-sets returned with a CCL query). Getting into specifics about the Cerner framework is likely a stretch-goal, but if we can't find an answer there, I wonder how this would typically be done with SQL?

This particular testing framework seems to be geared around subroutines / functions, aka asserting the results of functions. So how would one test a CCL (or SQL) query?

Improve this question
2
  • This might not be well received because it's in the vein of tool recommendations rather than a cut & dried reproducible problem. Commented Dec 5, 2023 at 15:39
  • How I've always done unit testing is just having a collection of plain old .sql files with test cases return such that an empty result is a pass. Then using python, ruby, or some other flexible language to orchestrate the tests and prepare reports. Commented Dec 5, 2023 at 15:42
Related questions
1990
How to query MongoDB with "like"
705
C# "internal" access modifier when doing unit testing
237
Unit testing void methods?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.