[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure statements for RestEasy XML, File Translator and Web Service Translator procedures
[
https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-987:
---------------------------------------
The File Translator use-case does not involve a virtual procedure, but does require SQL
like:
SELECT EMP.lastName, EMP.firstName, EMP.middleName, EMP.empId, EMP.department,
EMP.annualSalary, EMP.title, EMP.homePhone, EMP.mgrId, EMP.street, EMP.city, EMP.state,
EMP.ZipCode FROM
(EXEC EmployeeData.getTextFiles('EmployeeData.txt')) AS f, TEXTTABLE(file
COLUMNS lastName string, firstName string, middleName string, empId biginteger, department
string, annualSalary double, title string, homePhone string, mgrId biginteger, street
string, city string, state string, ZipCode string HEADER 3) AS emp
Add ability to edit/generate Create Virtual Procedure statements for
RestEasy XML, File Translator and Web Service Translator procedures
----------------------------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-987
URL: https://issues.jboss.org/browse/TEIIDDES-987
Project: Teiid Designer
Issue Type: Enhancement
Components: Editors, Transformations
Affects Versions: 7.4
Reporter: Barry LaFond
Fix For: 7.5
Designer includes "Generate xxxx procedures" options in the New Model Wizard.
Also have a RestEasy use-case that requires getXXXX virtual procedures that contain SQL
like:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT XMLELEMENT(NAME parts, XMLAGG(XMLELEMENT(NAME part,
XMLFOREST(VirtualParts_Supplier.PARTS.PART_ID, VirtualParts_Supplier.PARTS.PART_NAME,
VirtualParts_Supplier.PARTS.PART_COLOR, VirtualParts_Supplier.PARTS.PART_WEIGHT)))) AS
result FROM VirtualParts_Supplier.PARTS WHERE VirtualParts_Supplier.getParts.partId_in =
VirtualParts_Supplier.PARTS.PART_ID;
END
Would be nice to have a framework where "wizards" can be accessed to
create/edit the content of this SQL if the basic structure is a Set Query (SELECT * FROM
XXX)for these specific use-cases.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira