[
https://issues.jboss.org/browse/TEIIDDES-2454?page=com.atlassian.jira.plu...
]
Mark Drilling commented on TEIIDDES-2454:
-----------------------------------------
Here is example of DDL that gets created in webui.
-------------
{code:xml}
<model name="Test2" type="VIRTUAL" visible="true">
<description />
<metadata type="DDL">
<![CDATA[
CREATE VIEW SvcView (RowId integer PRIMARY KEY, ID_WORKSPACE string,ID_PANEL_PROVIDER
string) AS SELECT ROW_NUMBER() OVER (ORDER BY ID_WORKSPACE) ,
ID_WORKSPACE,ID_PANEL_PROVIDER FROM DASHB_ALLOWED_PANEL; SET NAMESPACE
'http://teiid.org/rest' AS REST; CREATE VIRTUAL PROCEDURE RestProc () RETURNS
(result XML) OPTIONS ("REST:METHOD" 'GET', "REST:URI"
'rest') AS BEGIN SELECT XMLELEMENT(NAME Elems, XMLAGG(XMLELEMENT(NAME Elem,
XMLFOREST(RowId,ID_WORKSPACE,ID_PANEL_PROVIDER)))) AS result FROM SvcView; END;
]]>
</metadata>
</model>
{code}
Create feature to generate REST-enabled virtual procedures from
selected views
------------------------------------------------------------------------------
Key: TEIIDDES-2454
URL:
https://issues.jboss.org/browse/TEIIDDES-2454
Project: Teiid Designer
Issue Type: Feature Request
Components: Modeling, Web Services Support
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 9.1, 9.0.2
The WebUI data service functionality features auto-generating a REST-enabled virtual
procedure which, when deployed in Teiid, get's exposed as a REST web service.
To facilitate this same functionality in Designer....
1) Create *Modeling > Create REST Procedures*
- enable only for Virtual Model selection or one or more virtual tables selected
2) Present a wizard containing a check-box list of views within the virtual model that
have NOT been
3) List would include SELECT ALL, DESELECT ALL buttons
- Could also use our Accumulator panel since some views may already have an associated
REST procedure.
4) May require one or more design-time only extension properties to keep track of what
views have generated REST procedures and which don't.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)