Use AgRest to return Cayenne Object

[Jorge-Fern]

Not really sure where to ask this, but here it goes. Sorry if this is not the right place.

I have some requests that have to make complex actions so I would like to use cayenne directly to do the hardwork and then use arrest to send the objet as a response.

Something like this.

 //get new context from the existing runtime
 ObjectContext cont = MyBootApp.cayenneRuntime.newContext();

 //get a object from db
 var user = SQLSelect.query(User.class, "select * from user where id = $iduser")
        .param("iduser", userid)
        .selectOne(cont);


 //do my stuff (simple example)

 user.getCars().forEach( car -> {
         car.setStolen(true);
         mailService.sendLocation(user.getmail(),  car.getLastLocation());
         //etc...
            
 });


  //not real code here, just what I would like to do
  AgRequest request = AgJaxrs.request(config)
                .addIncludes(includes)  //possible set includes and excludes like always
                .build();


  return AgJaxrs.parseObject(user)
                .request(request)
                .get();

is it possible to do something like this?

[stariy95]

Hi @Jorge-Fern

I got something like this in my project. That just sorts data in the response, but this should also allow to add/change data completely.

protected DataResponse<Project> fetchProjects(String include) {
    AgRequest request = AgJaxrs.request(configuration).addInclude(include).build();
    return AgJaxrs.select(Project.class, configuration)
                .stage(SelectStage.FETCH_DATA, new MavenProjectSorter(mavenService))
                .request(request)
                .get();
}

static class MavenProjectSorter implements Consumer<SelectContext<Project>> {
    // ...
    @Override
    public void accept(SelectContext<Project> context) {
        RootResourceEntity<Project> entity = context.getEntity();
        // response data is redefined here
        entity.setData(mavenService.sortProjects(entity.getData()));
    }
}

You could also play with the SelectStage.ASSEMBLE_QUERY stage, that would allow to shape the Cayenne query itself.