[teiid-issues] [JBoss JIRA] (TEIID-2158) Generate a Rest based service automatically based on deployed VDB

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-2158:
----------------------------------

    Attachment: rest.patch


This looks good. Here's a patch with some possible refinements to handle return parameters and charsets.  

I don't think that the explicit parameter transformation handling is needed as we will already convert if possible to the correctly typed literal.

What do you mean in question 1 in reference to DDL?  

What security would be in effect with the current code?  There wouldn't be any correct?  

Do we need an abstract getConnection method?  Seems like you could just pass the vdbname/version in the execute method.  That could also give you more control over how the connection is created, if pass through is needed etc.

We may also still be able to do some form of connection pooling, either on a per vdb basis and use identity assertion, or globably and add an enhancement to switch vdbs as well.
                
> Generate a Rest based service automatically based on deployed VDB
> -----------------------------------------------------------------
>
>                 Key: TEIID-2158
>                 URL: https://issues.jboss.org/browse/TEIID-2158
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Server
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>              Labels: jax-rs, resteasy, teiid
>             Fix For: 8.2
>
>         Attachments: rest.patch
>
>
> Currently to enable REST based services on top of the VDB, Designer provides a mechanism for user to define metadata on the procedure and gives hooks to generate Rest service based WAR file to deploy into a application server.
> To support OpenShift efforts it would be good to provide this functionality out of box, when Teiid is deployed into the JBoss AS (never in embedded). 
> To define a scenario, 
> - user creates a VDB and defines one or more models 
> - then user creates a virtual procedure with following metadata in the options clause
>     REST:METHOD =  GET|PUT|POST|DELETE (mandatory)
>     REST:URI    =  uri (mandatory)
>     REST:PRODUCES = xml|json|text (optional, if omitted will be calculated from procedures return parameter)
>     REST:CHARSET = character set (optional) (ex:US-ASCII, UTF-8 etc. In cases where the binary data is returned this character set will be used to convert) 
> where REST namesspace is defined as 
>     SET NAMESPACE 'http://teiid.org/rest' AS REST;
>  - user deploys a VDB
>  - a jax-rs based war is created and deployed automatically at the end of vdb deployment
>  - if vdb is un-deployed, this jax-rs war will also be undeployed
> Questions?
> 1) Should this enforce HTTPBasic Auth by default? since Teiid does not have a way define the DDL based metadata this is difficult.
> 2) Apart from above procedures, does a generic procedure that executes a add-hoc query helpful? The restriction here is the results will be in a pre-defined format not user defined.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira