topic Re: How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()? in Nuxeo Forum

How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()?

rg1_ — Tue, 11 Jun 2013 19:07:04 GMT

I need to access the CoreSession for the Principal passed as a parameter into SQLQuery.Transformer.transform(Principal, SQLQuery). I was hoping that ((NuxeoPrincipal) principal).getModel().getCoreSession() would provide it but it is almost always null. Is there another way besides creating a new CoreSession?

Re: How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()?

adam_bo_ — Wed, 12 Jun 2013 13:18:43 GMT

You can use for instance the following code:

LoginContext loginContext = Framework.login();
RepositoryManager mgr = Framework.getService(RepositoryManager.class);
Repository repository = mgr.getDefaultRepository();
CoreSession session = null;
if (repository != null) {
    session = repository.open();
}
if (session == null) {
    log.error("session is null, exit connect");
}

Re: How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()?

rg1_ — Wed, 12 Jun 2013 19:01:34 GMT

I believe your code is creating a new CoreSession which I was hoping to avoid. Instead I would like to access the existing CoreSession already associated with the Principal.

Re: How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()?

Florent_Guillau — Wed, 19 Jun 2013 16:18:12 GMT

No CoreSession is available at this level, because the query transformers are called at a lower-level API level than CoreSession (from the QueryMakers inside VCS).

Re: How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()?

rg1_ — Wed, 19 Jun 2013 18:02:15 GMT

I need to access specific properties from the principal's UserProfile document from within my query transformer. Do you have a recommendation for how this would best be done?

Re: How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()?

bruce_Grant — Thu, 20 Jun 2013 13:21:32 GMT

What properties do you need to access?

Re: How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()?

rg1_ — Thu, 20 Jun 2013 14:54:53 GMT

My own custom properties.

Re: How to get a CoreSession within a SecurityPolicy SQLQuery.Transformer.transform()?

Florent_Guillau — Thu, 20 Jun 2013 15:56:18 GMT

The solution would be to update the Principal object directly with the properties you need at login, when the Principal is created. See how the MultiTenantUserManager does it for instance, to use another class than NuxeoPrincipalImpl.