Hi Leonardo, Greatly appreciate your efforts to improve the tests. We actually do have similar type of integration tests for DSS. These can be found at the data services component [1] and also in the product [2]. Most of the tests are at the component, and at the product, we starts up the actual DSS server instance and do some calls to it, by using the shipped data services samples.
In the component also, even though it's not the final DSS server, we do start up a basic HTTP server with Axis2, and deploy the data services and run tests against it. At the moment, we've these tests for H2, MySQL and Oracle (recently added, yet to commit). So where you should probably check is the component tests, where we've a specific structure and order to the tests that are implemented by different DBMSs. Basically, there's a set of abstract classes at "org.wso2.carbon.dataservices.core.test.sql", which provides the actual test logic, and those are extended by DBMS specific implementations (separate Java packages) , which includes the dbs files for that specific DBMS. It's not mandatory to reflect all the tests in the DBMS implementation, some DBMSs may not support some features another one provides, in those cases, you simply don't expose that. I'm guessing, you can get a clear understanding of this by looking at the code for tests there, and identify the pattern we've used. So it would be great if you can improve the tests there in the component tests. Better start off with MSSQL and Sybase perhaps. And try to particularly find any unique features that these DBMSs (ex:- Oracle Ref Cursors we've) will have, and that's not properly supported in DSS, and if that is so, we can implement those functionalities. And when you are done with the test implementation, you can create a JIRA as a product improvement, and attach a patch and we will be happy to add it to the code base. So at the end, these are effectively automated tests, that will run when the builds are happening, and also for the end-users convenience, you can still follow SOAPUI style tests by deploying the same data services used for the tests, if required. [1] https://svn.wso2.org/repos/wso2/trunk/carbon/components/data-services/org.wso2.carbon.dataservices.core/src/test [2] https://svn.wso2.org/repos/wso2/trunk/carbon/products/dss/modules/integration Cheers, Anjana. On Thu, Oct 6, 2011 at 10:37 PM, Leonardo <[email protected]> wrote: > Hi Anjana, > > On Thu, Oct 6, 2011 at 12:37 PM, Anjana Fernando <[email protected]> wrote: > > > Great to hear! .. DSS 2.6.2 (Carbon 3.2.3) is planned to release end of > > October. > > Cool! > > I am thinking to make a project to test features of the WSO2 Data > Services Server in differents databases. > > This project consist in create any services with various features: > > - stored procedures (with result returns, variable to input and output); > - select; > - insert; > - delete; > - update; > - etc. > > I started with MySQL, but I can develop in SQL Server (2000, 2005 and > 2008), Oracle (10g and 11g), PostgreSQL and Sybase. > > You know any project in style? > > -- > Att, > Leonardo Saraiva > > ........__Ô "chuva-ou-sol, > ....._ \ >_ peda-lã-moi-gual" > ....(_) / (_) (Tássia Arouche) > _______________________________________________ > Carbon-dev mailing list > [email protected] > http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev > -- *Anjana Fernando* Senior Software Engineer WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Carbon-dev mailing list [email protected] http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
