Work with Database using Spock and Geb.

Question

I hope someone have already faced an issue to verify that application shows correct data from database. I reviewd how groovy used SQL, but I have no idea where and how I should do that. I'm just starting to use gradle+Spock+Geb for testing application. I have a few files where I described a couple of pages from application, a couple of modules and a file with spock specification. Where and how I need to connect to Oracle DB, use SQL and compare result's data with application's ones? P.S. I write everything in notepad++ and launch from command line writing 'gradlew firefoxTest'. Does exist any more comfortable way to work with gradle+spock+geb? Thanks in advance.

Were you able to find a way? – dmahapatro Aug 02 '13 at 01:34 — dmahapatro, Aug 02 '13 at 01:34
Unfortunately, we parted ways before I found the solution – Evgeniy Nov 05 '13 at 16:44 — Evgeniy, Nov 05 '13 at 16:44

score 0 · Answer 1 · answered Dec 30 '15 at 15:54

Because there are no other answers, I wanted to provide a solution someone at my company thought of. This assumes you already have a project that uses some sort of JDBC. In our case it is JDBI.

The idea is to extend Classloader and then use that to directly access the data access object class via the JVM. That idea should work.

I have not tested it out because it doesn't completely fit our use-case. I'll admit that this does not completely apply to your use case, but technically you could just run the jar of an existing project, which can access the database.

Work with Database using Spock and Geb.

1 Answers1