<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">As part of <a href="http://jira.pentaho.com/browse/MONDRIAN-2483" class="">http://jira.pentaho.com/browse/MONDRIAN-2483</a>, in order to make it easier to test multiple databases, I propose to restructure the parameters that define test databases. For example, the following would be in build.properties:<div class=""><br class=""></div><div class="">mondrian.test.hsqldb.jdbcDrivers=org.hsqldb.jdbcDriver</div><div class="">mondrian.test.hsqldb.foodmart.url=jdbc:hsqldb:res:foodmart<br class="">mondrian.test.hsqldb.foodmart.user=FOODMART<br class="">mondrian.test.hsqldb.foodmart.password=FOODMART<br class=""></div><div class=""><div class="">mondrian.test.mysql.jdbcDrivers=com.mysql.jdbc.Driver</div><div class="">mondrian.test.mysql.foodmart.url=jdbc:mysql://localhost:3306/foodmart<br class="">mondrian.test.mysql.foodmart.user=foodmart<br class="">mondrian.test.mysql.foodmart.password=foodmart<br class=""></div></div><div class=""><br class=""></div><div class="">...and properties for any other databases you want to test.</div><div class=""><br class=""></div><div class="">If you specify -Dmondrian.test.db=hsqldb or do not specify -Dmondrian.test.db it will run against hsqldb.</div><div class="">If you run the test suite with -Dmondrian.test.db=mysql it would use MySQL.</div><div class=""><br class=""></div><div class="">The effect is that we can switch among several databases using just one command-line property.</div><div class=""><br class=""></div><div class="">The Vagrant DB would use port 3306 for MySQL by default. But if that port was taken, you would just need to change it in Vagrantfile and change one line of build.properties.</div><div class=""><br class=""></div><div class="">The database’s JDBC driver must be on the class path. But that’s easy to achieve these days now we’re using Maven.</div><div class=""><br class=""></div><div class="">Julian</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div><blockquote type="cite" class=""><div class="">On Apr 22, 2016, at 1:54 AM, Ramazzina, Sergio <<a href="mailto:sergio.ramazzina@serasoft.it" class="">sergio.ramazzina@serasoft.it</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">+1</div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Thu, Apr 21, 2016 at 9:34 PM, Julian Hyde <span dir="ltr" class=""><<a href="mailto:julianhyde@gmail.com" target="_blank" class="">julianhyde@gmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class=""><div class="">I propose to create a Vagrant VM that contains each database that we would like to test Mondrian against.</div><div class=""><br class=""></div>One of the challenges of developing/testing Mondrian is that you have to populate a FoodMart database first. In Calcite we had the same problem, but one of our developers neatly solved it by creating a vagrant VM that populated each required database[1]. We could do the same for Mondrian: the initial set would be, say, MySQL, PostgreSQL, Apache Hive.<div class=""><br class=""></div><div class="">For the Mondrian 4 branch I would go further, and make the default database embedded hsqldb, so Mondrian could build & test with no setup, just “mvn install”. Anyone who wanted to run the integration tests would do “mvn install” on the vagrant repo, would would start and populate the VM, and would run “mvn -Pit install” to enable the integration tests against all of the various databases.<div class=""><br class=""></div><div class="">What do y’all think?</div><div class=""><br class=""></div><div class="">Julian</div><div class=""><br class=""></div><div class="">[1] <a href="https://github.com/vlsi/calcite-test-dataset/" target="_blank" class="">https://github.com/vlsi/calcite-test-dataset/</a></div></div></div><br class="">_______________________________________________<br class="">
Mondrian mailing list<br class="">
<a href="mailto:Mondrian@pentaho.org" class="">Mondrian@pentaho.org</a><br class="">
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank" class="">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br class="">
<br class=""></blockquote></div><br class=""><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div class="gmail_signature"><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class="">Best Regards/Distinti Saluti<br class=""><br class=""><b class="">Sergio Ramazzina</b><br class=""><b class="">SeraSoft S.r.l. - Your BIntelligence Partner</b><br class=""><br class="">Via Milano 78<br class="">20013 Magenta (MI) - ITALY<br class="">mobile : +39 347 2103689<br class="">Tel: +39 02 87158700<br class="">Fax: +39 02 87151947<br class="">website: <a href="http://www.serasoft.it/" target="_blank" class="">http://www.serasoft.it</a> - email : <a href="mailto:sergio.ramazzina@serasoft.it" target="_blank" class="">sergio.ramazzina@serasoft.it</a><br class="">skype : sramazzina - Follow me on twitter: sramazzina<br class="">View my profile on LinkedIn: <a href="http://www.linkedin.com/in/sramazzina" target="_blank" class="">http://www.linkedin.com/in/sramazzina</a><br class=""><div class=""><br class="">---------------------------------------------------------------------------------------------------------------<br class=""><span class="">RISERVATEZZA /
CONFIDENTIALITY</span><p class=""><span class="">In ottemperanza del D.
L.vo 196/2003 sulla tutela dei dati personali, le informazioni contenute in
questo messaggio sono strettamente riservate e sono esclusivamente indirizzate
al destinatario indicato,<span class=""> </span>tenendo
presente che qualsiasi uso, riproduzione o divulgazione di questo messaggio è
vietata. Nel caso in cui aveste ricevuto questa mail per errore, vogliate
avvertire il mittente al più presto a mezzo posta elettronica e distruggere il
presente messaggio.</span></p><div class=""><span class=""></span><br class="webkit-block-placeholder"></div><p style="font-size:small" class=""><span style="font-size:11pt" class="">ACCORDINGLY TO ITALIAN LAW 196/2003 CONCERNING PRIVACY, IF YOU ARE NOT THE ADDRESSEE YOU ARE HEREBY NOTIFIED THAT ANY DISCLOSURE, REPRODUCTION, DISTRIBUTION OR OTHER DISSEMINATION OR USE OF THIS COMMUNICATION IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS MESSAGE IN ERROR, YOU SHOULD DESTROY IT AND PLEASE NOTIFY US IMMEDIATELY BY EMAIL.</span></p><div class=""><span style="font-size:11pt" class=""><br class=""></span></div><div style="margin:0pt" name="sig_75f07fd644" class=""></div></div></div></div></div></div></div></div>
</div>
_______________________________________________<br class="">Mondrian mailing list<br class=""><a href="mailto:Mondrian@pentaho.org" class="">Mondrian@pentaho.org</a><br class="">http://lists.pentaho.org/mailman/listinfo/mondrian<br class=""></div></blockquote></div><br class=""></div></body></html>