[Mondrian] Running the JUnit tests

Patrick Leckey patl at seewind.com
Tue Mar 20 14:18:36 EDT 2012


Hi,

So in the course of writing some tests, we've had to make changes to FoodMart (added 2 columns to the "store" table, and added a new dimension), in order to properly test the new closure table behaviour we're working on.

Couple of questions:

1) Are changes to FoodMart SQL OK? (as long as they don't break any other tests, of course)

2) There are about 17 tests that fail with changes to the FoodMart.xml schema (addition of another dimension).  Is there an easy way to update the *.ref.xml files with the new discover query results, or do you pretty much copy & paste the results of actually running those queries?

Thanks,
Pat

On 2012-03-15, at 11:38 AM, Luc Boudreau wrote:

> That's one of our skeletons in the closet. The test suite has some
> failures on PgSQL. We don't officially support PgSQL, mostly because
> of a lack of community interest. Seems like everyone uses
> Oracle/MySQL/Greenplum/MsSQL.
> 
> Here's the cotnents of my mondrian.properties file.
> 
> # native stuff
> mondrian.native.crossjoin.enable=true
> mondrian.native.topcount.enable=true
> mondrian.native.filter.enable=true
> mondrian.native.nonempty.enable=true
> mondrian.rolap.groupingsets.enable=true
> #agg stuff
> mondrian.rolap.aggregates.Use=false
> mondrian.rolap.aggregates.Read=false
> # naming stuff
> mondrian.olap.SsasCompatibleNaming=false
> # data stuff
> mondrian.foodmart.jdbcURL=jdbc:oracle:thin:foodmart/foodmart@//:1521/XE
> mondrian.foodmart.jdbcUser=foodmart
> mondrian.foodmart.jdbcPassword=foodmart
> mondrian.jdbcDrivers=oracle.jdbc.OracleDriver
> 
> I personally run the test suite against MySQL and Oracle. It gives me
> a good enough coverage. Not all tests ared designed to run against all
> databases, so it is important to test all changes against at least two
> of the official supported DBs.
> 
> To run the test suite, I usually run it in Eclipse (launch from
> mondrian.test.Main). From ant, I'm not exactly sure what are the exact
> targets to run, but I can guess you will need to setup things by
> running "ant" then call "ant test".
> 
> Luc
> 
> On Wed, Mar 14, 2012 at 6:17 PM, Patrick Leckey <patl at seewind.com> wrote:
>> We're trying to get our CI box to build and test our local working copies of Mondrian, but we're having some issue with the tests.
>> 
>> We run PostgreSQL as a back-end and so we're setting up the tests to run against that.
>> 
>> Currently our Jenkins job executes:
>> - Drop the current foodmart database
>> - Run the load-foodmart ant task
>> - Run the junit-main ant task
>> 
>> This is generating different results from the tests we see run on the public Pentaho CI server.  We get an exception right off the bat (form the PG JDBC driver) saying it can't login as "bogususer".  Then a lot of the output looks similar, and the jobs hang - no processes running on the PG server, but JUnit does not complete.
>> 
>> If we change the junit-main task to the test task, it seems to complete but unlike the 8 failures and 0 errors on Pentaho CI, we get 24 failures and 3 errors.  Checking the PostgreSQL logs, it seems to mostly be SQL syntax errors (and the "bogususer" error).
>> 
>> I do notice the Pentaho CI build runs the tests against MySQL and not PostgreSQL.  Are they designed to only be run against MySQL?  If I threw JBoss on our CI box, could we run them against the Derby DB? (I mostly just don't want to setup a MySQL instance on that box)
>> 
>> test.properties and mondrian.properties are both setup in the Jenkins workspace folder and found by the build, all info in them looks correct (mondrian.test.connectString is picked up, etc.).
>> 
>> This is being run on a clean check-out of //open/mondrian from this morning, no changes at all except to the test.properties and mondrian.properties files.
>> 
>> Thanks,
>> Pat
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian



More information about the Mondrian mailing list