specific query

[Conway, Mike]

An often requested feature, specific query, is now in the development branch of jargon.  This is useful for developing queries of the iRODS catalog that are not served through the GenQuery facility.  Specific query allows a rodsadmin to register an alias and a parameterized sql select statement that can then be referenced by alias and arguments, or by the query string and arguments.

The full power of SQL is available for complex metadata queries, or for introducing more efficient queries at 'hot spots' in an application.  The 'ils –LA' fix recently done for iPlant is one of the first places where this will be employed.  

This is in the 'development' branch of jargon, per this feature request: https://code.renci.org/gf/project/jargon/tracker/?action=TrackerItemEdit&tracker_item_id=6&start=0

Note that this is implemented in the SpecificQueryAO with facilities to query, manage, and execute specific query. There is also a new shell script in jargon-core that can provision your iRODS zone with a few specific queries used internally. I still have one final task, to write some tests that do query paging and closing operations, but otherwise it's there to try.  The development branch in git is slated to become the Jargon 3.2 release.  

Next on the plate is Java support for PAM authentication.  We'll be working on this this week as the highest priority.

Cheers

MC

---------------------

Mike Conway

Interface and Java API/Integration Developer  – DICE

www.irods.org

skype:michael.c.conway

LinkedIn: http://www.linkedin.com/pub/mike-conway/5/78a/231

[Conway, Mike]

PS I want to recognize Lisa Stillwell at RENCI for helping develop the specific query facilities and tests, as well as Wayne who did the core server implementation!

Cheers

MC

---------------------

Mike Conway

Interface and Java API/Integration Developer  – DICE

www.irods.org

skype:michael.c.conway

LinkedIn: http://www.linkedin.com/pub/mike-conway/5/78a/231

--
"iRODS: the Integrated Rule-Oriented Data-management System; A community driven, open source, data grid software solution" https://www.irods.org
 
iROD-Chat: http://groups.google.com/group/iROD-Chat

[Julien Thibault]

Hi Mike,
Is this gonna cover case-insensitive queries on AVUs or is this part
of a different AO?

~Julien

2012/8/27 Conway, Mike <michael...@unc.edu>:

[Conway, Mike]

Hi Julien, that's different, it's part of genquery (the thing that iquest
uses). This will be in shortly, I plan on having support for case
insensitive for the 3.2 release coming up.

MC

---------------------
Mike Conway
Interface and Java API/Integration Developer ­ DICE
www.irods.org

skype:michael.c.conway
LinkedIn: http://www.linkedin.com/pub/mike-conway/5/78a/231

[Conway, Mike]

Hi Jeff,

I actually have the code for doing GSS in but need some help testing it.  That can be in 3.2 as 'experimental' and I'd like to see if there are folks who have that environment that can help test.  I have a start at the kerberos as well, but that also needs some additional work.  I can try to have these as early access for 3.2 but it's a place where the community can help, as I don't really have a rich environment to test those things fully.

I had factored things out in Jargon so that the authentication process was pluggable, and the PAM was going to be the first formally defined plug-in after the standard iRODS auth, with GSS and Kerberos next, based on user requests I had received.

Cheers,

MC

---------------------

Mike Conway

Interface and Java API/Integration Developer  – DICE

www.irods.org

skype:michael.c.conway

LinkedIn: http://www.linkedin.com/pub/mike-conway/5/78a/231

From: Jeff Muller <jeff....@gmail.com>
Reply-To: <irod...@googlegroups.com>
Date: Tue, 28 Aug 2012 00:29:54 -0700
To: <irod...@googlegroups.com>
Subject: [iROD-Chat:8543] Re: specific query

When you say PAM support in Jargon is next, does this mean that Kerberos/GSS will be supported in 3.2?

Thanks in advance,
Jeff