topic Open SQL test double frameqork in Application Development and Automation Discussions

Open SQL test double frameqork

jrgkraus — Mon, 02 Dec 2019 16:55:59 GMT

I read about this framework (represented by the class cl_osql_test_environment). Trying to do some tests, I found out, that it is not present in our system (ABAP Stack 750). With which release will it be available?

Re: Open SQL test double frameqork

matt — Mon, 02 Dec 2019 21:25:02 GMT

My initial answer "752" was deemed too short. But in any case the generic answer to "when will it be available" is

In a release higher than you're likely to see in your career.

But only when I'm feeling especially grumpy. What I do in 750 and below is encapsulate all db accesses - and indeed all SAP FM and Method calls - into a local data access class, lcl_dao, which is implemented wrt an interface, lif_dao. Then I can create ltd_dao and inject that into the class I want to test.

Re: Open SQL test double frameqork

jrgkraus — Tue, 03 Dec 2019 08:38:05 GMT

Yeah, that's similar to my approach. This fails of course in multilevel testing. If I want to stub a DB read that occurs in a class that depends on a class, that depends on the class under test, It would have come in handy to be able to double the SQL read with test data.