[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=12713701#comment-12713701 ] 

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

Thanks Steve. I realized that I did the check for parameter for return but did not account in the execute call.

Q1) What I meant is the DDL is defined per model, and security information need to be defined per VDB, for that global scope Teiid does not have means to define this extension metadata other than vdb.xml properties. I did not like defining security extensions on vdb.xml

I was planning on "HTTPBasic" as default, but right now I have commented it out for feed back. 

Good suggestion about getConnection, will implement that.
                
> 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