[JBoss JIRA] Created: (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure statements for RestEasy XML, File Translator and Web Service Translator procedures
11 p.m.
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
11:02 p.m.
New subject: [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
11:08 p.m.
New subject: [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:
---------------------------------------
Example of the Web Service Translator procedure is:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM TABLE(EXEC StateService.invoke(binding => 'SOAP11', request
=> '<states:GetAllStateInfo
xmlns:states="http://www.teiid.org/stateService/"/>')) AS response,
TABLE(EXEC StateServiceXML.GetAllStateInfo.extract_AllStateInfo(response.result)) AS t;
END
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
4:49 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-987) m
[
https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-987:
----------------------------------
Summary: m (was: Add ability to edit/generate Create Virtual Procedure statements
for RestEasy XML, File Translator and Web Service Translator procedures)
Assignee: Mark Drilling
Not sure how to implement this feature. Maybe an extension point that returns an
action/wizard based on a LanguageObject or some other SQL context.
If a virtual procedure is the target, then user could chose to
"create/replace/edit" a simple SELECT XXXXX XXXX statement based on a wizard
rather than SQL
m
-
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
Assignee: Mark Drilling
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
1:42 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
[
https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-987:
----------------------------------
Summary: Add ability to edit/generate Create Virtual Procedure SQL statements for
RestEasy XML, File and Web Service Translator procedures (was: m)
Add ability to edit/generate Create Virtual Procedure SQL statements
for RestEasy XML, File 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
Assignee: Mark Drilling
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
6:12 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
[
https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-987:
----------------------------------
Fix Version/s: 8.0
(was: 7.5)
Add ability to edit/generate Create Virtual Procedure SQL statements
for RestEasy XML, File 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
Assignee: Mark Drilling
Fix For: 8.0
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
2:34 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
[
https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-987:
----------------------------------
Fix Version/s: 7.6
(was: 8.0)
Add ability to edit/generate Create Virtual Procedure SQL statements
for RestEasy XML, File 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
Assignee: Mark Drilling
Fix For: 7.6
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
6:21 p.m.
New subject: [JBoss JIRA] (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
[
https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-987:
----------------------------------
Fix Version/s: 7.7
(was: 7.6)
We added file/xml importers which produce some of these targeted SQL transformations.
Still need to investigate how to best approach editing this SQL and how to expose options
to user, probably in T-Editor.
Pushing to 7.7 or later
Add ability to edit/generate Create Virtual Procedure SQL statements
for RestEasy XML, File 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
Assignee: Mark Drilling
Fix For: 7.7
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.
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
6:23 p.m.
New subject: [JBoss JIRA] (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
[
https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-987:
----------------------------------
Fix Version/s: 7.7.1
Add ability to edit/generate Create Virtual Procedure SQL statements
for RestEasy XML, File 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
Assignee: Mark Drilling
Fix For: 7.7, 7.7.1
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.
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
3:03 p.m.
New subject: [JBoss JIRA] (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
[
https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-987:
----------------------------------
Fix Version/s: 8.0
(was: 7.7)
(was: 7.7.1)
Add ability to edit/generate Create Virtual Procedure SQL statements
for RestEasy XML, File 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
Assignee: Mark Drilling
Fix For: 8.0
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.
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
4524
days inactive
4764
days old
teiid-designer-issues@lists.jboss.org
9 comments
2 participants
participants (2)
-
Barry LaFond (JIRA) -
Barry LaFond (Updated) (JIRA)