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

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12714106#comment-12714106 ] 

Ramesh Reddy commented on TEIID-2158:
-------------------------------------

* Localized the "getConnection" call.
* Added HTTPBasic authentication, with option to turn it off. Check the document for the allowed properties.
* With HttpBasic security, pass-through-authentication can be added as an option. Be sure to configure the embedded transport with security-domain before you can do that
* Added an implicit rest service at URI "/query", that takes a parameter named "sql" with inbound SQL statement that takes a sql command that must generates a XML document or JSON document. See document for an example. BTW, this only works with "POST" method.
                
> 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