Forum Discussion

martinrampton's avatar
martinrampton
Occasional Contributor
7 years ago

Retreiving data from Mongo db using Groovy and assigning it to a test case property

Hi, I'm looking to create a test step that can connect to MongoDB, run a query, and then assign the result to a test case property. I have the connection working and I can retrieve a result as a row ...
Groovy
MongoDB
SoapUI
  • TNeuschwanger's avatar
    TNeuschwanger
    7 years ago

    hello martinrampton,

     

    that query looks a little out of place...   Maybe just stick with the collection to debug for a little bit then add the query.

    .

    .

    def db = mongo.getDB('digital')
    def collection = db.getCollection('QuoteSummary')

    log.info collection.find().first();

    // or

    Document myDoc = collection.find().first();

    log.info myDoc.toString();

    // or

    log.info myDoc.toJson();
    .

    .

    if you can identify content in the collection, you can start forming query.

    i.e.

    myDoc = collection.find(eq("workReferenceNo", "GPE0024879")).first();

    log.info myDoc.toString();

    // or

    log.info myDoc.toJson();

Karsa's avatar
Karsa
Visitor
Hi

I used the below code you have mentioned

Document myDoc=collection.find().first()

If I used first() or last() function it works fine. I pull the first or last document from the collection. However if I try to use just find() I’m not able to retrieve ALL the documents that match the query I pass in the file. Can you please help? What is the code to pull all the docs from the collection.
TNeuschwanger's avatar
TNeuschwanger
Champion Level 1
6 years ago

Hello Karsa,

I don't know the answer...  I would look at the ".each" on a collection.  I am only speculating that you could use similar iteration techniques that are used on lists or maps.

i.e.

collection.each {

   Document myDoc = it;

   ...  do something with individual document  ...   

};

 

Regards,

Todd