build a json from list of objects in groovy

Question

I want to build a json from a list of objects. So far I am able to produce only 1 object into json. What am i missing? Is there a better way to transform list of objects into json?

private static List<ProductAlertsResponse> executeSelection(String query)
{
    List<ProductAlertsResponse> prodAlerts=new ArrayList<ProductAlertsResponse>()
    sql.eachRow(query)
    {
        ProductAlertsResponse prodAlert=new ProductAlertsResponse((String)it.id,(String)it.name,(String)it.description,(String)it.active,(String)it.release_date)

        //I was converting it into a List before, but then I thought it would be better to do with list of classes
        /*String[] rows=new String[5]
        rows[0]=(String)it.id
        rows[1]=(String)it.name
        rows[2]=(String)it.description
        rows[3]=(String)it.active
        rows[4]=(String)it.release_date

        result.add(rows)*/

/*Also feel free to comment is this right way to put in list (above commented code)*/

        prodAlerts.add(prodAlert)
    }
    return prodAlerts
}

static main(args) {
    AppProperties.load()
    sql= Sql.newInstance("jdbc:oracle:thin:@"+AppProperties.get("hostname")+":"+AppProperties.get("port")+":"+AppProperties.get("service"), AppProperties.get("username"), AppProperties.get("password"),"oracle.jdbc.OracleDriver")

    List result=executeSelection("select ID,NAME,DESCRIPTION,ACTIVE,RELEASE_DATE from productinfo where ACTIVE='A'")

    def builder = new groovy.json.JsonBuilder()

    def root=builder.response{

        product_alerts{
            result.each{
                //JsonOutput.toJson(it)
                id  it.getId()
                name it.getName()
                description it.getDescription()
                active it.getActive()
            }

        }

    }
    println builder.toPrettyString()
}

My output

{
    "response": {
        "product_alerts": {
            "id": "6",
            "name": "ABC1",
            "description": "Test2",
            "active": "A"
        }
    }
}

score 4 · Accepted Answer · 2012-01-20 07:53:20Z

4

Use def builder = new groovy.json.JsonBuilder(result)

Update

Try this

def json = new groovy.json.JsonBuilder()
def result1 = json {
     response result
}
println json.toPrettyString()

edited Jan 20, 2012 at 7:53

answered Jan 20, 2012 at 7:40

user801116

Sign up to request clarification or add additional context in comments.

3 Comments

AabinGunz Over a year ago

Thanks.. at the least it is now transforming all the objects into json. What if I want to have a root tag response?

OverZealous Over a year ago

Just a tip, another way if you simply need to add the root node is to use: new groovy.json.JsonBuilder([response: result]).

AabinGunz Over a year ago

@OverZealous: Thanks nice tip, also can you please take a look at a continuation question here?

Collectives™ on Stack Overflow

build a json from list of objects in groovy

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related