topic Re: How Unit Test works on Open SQL? in Application Development and Automation Discussions

How Unit Test works on Open SQL?

ArcherZhang — Tue, 13 Jun 2017 03:06:26 GMT

Hi experts,

Say I want a DB handler class as below, in which method is pure Open SQL statement.

CLASS lcl_mara_db_handler IMPLEMETATION.

METHOD update_mara.

MODIFY mara FROM is_mara.

ENDMETHOD.

METHOD insert_mara.

INSERT.........

ENDMETHOD.

.......

ENDCLASS.

How can I write Unit Test first, as the decency is DB, do I need to consider that a different DB could return a different result? Or not necessary to consider the Unit Test on this leave?

BRs,

Archer

Re: How Unit Test works on Open SQL?

retired_member — Tue, 13 Jun 2017 04:13:33 GMT

For that, we have test seams and injections.

https://blogs.sap.com/2015/10/23/abap-news-for-750-test-seams-and-injections

Since you are with SAP, you might also check the 7.52 documentation for another new possibility.

Re: How Unit Test works on Open SQL?

Sandra_Rossi — Tue, 13 Jun 2017 05:41:08 GMT

OpenSQL gives the same result whatever the database is, that's the reason of being of OpenSQL (in answer to "do I need to consider that a different DB could return a different result?") I probably didn't get your point, sorry.

Re: How Unit Test works on Open SQL?

Sandra_Rossi — Tue, 13 Jun 2017 05:56:45 GMT

hmm can you tell more about that ("another new possibility"), Horst? 😄

Re: How Unit Test works on Open SQL?

retired_member — Tue, 13 Jun 2017 06:09:24 GMT

Nope. I'm not allowed to do so before 7.52 is available outside SAP.

But why not some teasing 😉

Re: How Unit Test works on Open SQL?

Sandra_Rossi — Tue, 13 Jun 2017 06:22:10 GMT

oh yes please please 🙂

Re: How Unit Test works on Open SQL?

retired_member — Tue, 13 Jun 2017 06:43:02 GMT

Don't Let Me Be Misunderstood ...

The teasing already happened by mentioning 7.52 at all ...

Re: How Unit Test works on Open SQL?

nomssi — Tue, 13 Jun 2017 17:27:58 GMT

Hi Sandra,

how to enable (integration) testing with OpenSQL? I would presume the ABAP Unit framework will be enhanced to

enable writing a fixture in the DB table
run the tests
delete the test data after LUW.

What do you think? Horst can vote me down to stop fake news 🙂

JNN

Re: How Unit Test works on Open SQL?

fabianlupa — Tue, 13 Jun 2017 18:20:44 GMT

I thought the test seam / injection thing was only a workaround to make legacy code testable without rewriting it.

In the example above I would have abstracted the functionality to an interface and implemented it twice, having a productive implementation that uses opensql and a (possibly local) test implementation with dummy data / return values (maybe even using cl_abap_testdouble). Is that not the recommended approach?

Re: How Unit Test works on Open SQL?

pokrakam — Tue, 13 Jun 2017 18:22:34 GMT

I would never have guessed that SAP would be working on another version 😉

Re: How Unit Test works on Open SQL?

pokrakam — Tue, 13 Jun 2017 18:25:10 GMT

One can "like" a comment, but one can only downvote an answer. One of the many peculiarities of the new SCN platform.

I like your thinking though, perhaps something like DB table overloading?

Re: How Unit Test works on Open SQL?

retired_member — Tue, 13 Jun 2017 18:46:29 GMT

Yeah, of course, but

Re: How Unit Test works on Open SQL?

Sandra_Rossi — Tue, 13 Jun 2017 18:54:42 GMT

You're probably right.

Re: How Unit Test works on Open SQL?

nomssi — Fri, 09 Feb 2018 13:49:44 GMT

Well horst.keller it is official now:

ABAP - Keyword Documentation → ABAP - Reference → Processing External Data → ABAP Database Accesses → Open SQL →Open SQL - System Classes → CL_OSQL_REPLACE - Replacement Service

I have found the class in Netweaver 7.51. Is it the same functionality?

JNN

Re: How Unit Test works on Open SQL?

retired_member — Fri, 09 Feb 2018 17:44:22 GMT

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abencl_osql_replace.htm

Point 11 under https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abennews-752-open_sql.htm

So, officially available with 7.52.

Re: How Unit Test works on Open SQL?

former_member269539 — Tue, 17 Dec 2019 02:49:59 GMT

maybe you can 'select' again after 'ins/del/upd' of D, and then compare the ACT and EXP in your test method. to verify if the update openSQL actually works.