[teiid-issues] [JBoss JIRA] (TEIID-2285) Enhance Loopback Translator to retrieve custom data

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2285:
---------------------------------------

> To have hard coded data is not a good solution too, because you would need them to be stored in memory, which would influence the test. 

That is an implementation choice. You could just as easily backend into a caching system after loading the results from files (see also Van's byteman based results replacement tool).  Using hard-coded results can also just be an override aspect, for example our internal HardCodedDataManager can optionally return a dummy row if there is no data supplied for the give command. 

> Also it is needed to disable some capabilites of loopback translator so that teiid engine can perform comparing, joining, filtering etc. of data generated by the translator.

Ideally that would be based upon allowing the translator to act as a delegating translator - to mimic another built-in translator - and/or with additional settable properties - rather than just hardcoding to disabled.  I don't see changes along these lines in the pull request.

> Please, look at the modified translator and if you like it we can create pull request. 

As an incremental change to the current loopback, it would be fine to add these additional properties.  For some distinct/join scenarios this would allow for simple testing.  Although with capabilities disabled, you may also want to consider modifications such as looking at the table/column metadata to better mimic the situation without requiring separately configured translators.  

                
> Enhance Loopback Translator to retrieve custom data
> ---------------------------------------------------
>
>                 Key: TEIID-2285
>                 URL: https://issues.jboss.org/browse/TEIID-2285
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>    Affects Versions: 8.2
>            Reporter: Filip Nguyen
>            Assignee: Filip Nguyen
>            Priority: Minor
>             Fix For: Open To Community
>
>
> Loopback Translator was identified as suitable way of testing Teiid engine performance. It would be nice if the Translator would mimic database behavior better in some aspects:
> * Possibility to define what data will be retrieved in the columns
> * Possibility of Unique data in column to mimic database generator

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira