Teiid regression testing

[atzakas]

Hi,

I recently started working with Teiid to create and deploy VDBs and I am currently exploring ways of how to automate the testing of the models.

In particular, I am interested in testing automation for the following:

1. metadata (ensure that the table and columns of the model match with those of the data sources),
2. data (performing bulk queries and validating them against known results)
3. Performance (comparing the performance of my queries every time the model is updated)
4. Load and concurrency testing

[rareddy]

You can essentially treat Teiid as RDBMS and do write tests accordingly, except for metadata.

1). On Admin API, there is getSchema function that returns a DDL of a model, that may be of help

2) As you found https://community.jboss.org/message/782876#782876, you can use tools like that, or write your own

3 & 4) Look at JMeter http://jmeter.apache.org/

Ramesh..

[jpmat]

I dig up this discussion since it's exactly what I'm looking for.

2) BQT looks good. Is it still used by Teiid developer as non regression test tool ?

For 3 & 4, surely JMeter is good tool.

One question related to 1): is there command line to compile the models, and output warnings + errors ?

Thanks in advance

Jean-Pierre

[rareddy]

Since initial comments on this thread, there has been many advancements

1) If you design the VDB as Dynamic VDB, then it is just simple XML file with DDL inside it. When you deploy it, it will show you any errors and such. Also, Teiid Designer team is working on VDB Workbench that works with Dynamic VDBs that does this validation.

2) Yes, we use BQT

Ramesh..