DB layer 2.0 functional testing

Warning: This page is no longer in use. The information contained on the page should NOT be seen as relevant or reliable.

Moodle 2.0

Functional unit tests can be used to test the interaction of Moodle and database, it is testing following:

• SQL database server
• PHP database driver
• Moodle DB connection settings, driver configuration and server settings
• Moodle DDL generator
• Moodle DML driver

You can test current database specified in config.php, you can also specify other DB servers via following config.php settings, for example:

$CFG->func_test_db_1 = array("native", "mysqli", "localhost", "root", "yourpassword", "moodle", "tst_", array('dbengine'=>'InnoDB'));
$CFG->func_test_db_2 = array("native", "mysqli", "localhost", "root", "yourpassword", "moodle2", "tst_", array('dbengine'=>'MyISAM'));
$CFG->func_test_db_3 = array("native", "pgsql", "localhost", "moodleuser", "yourpassword", "moodle2", "tst_", NULL);
$CFG->func_test_db_4 = array("native", "mssql", "192.168.15.41", "sa", "yourpassword", "moodle", "tst_", NULL);

DDL tests

All DDL test must pass on any production server.

DML tests

Ideally all DML tests should pass on production servers.

Common problems:

• MySQL MyISAM engine does ACID compliant and does not support transactions, please consider upgrading to InnoDB.
• MySQL supports only a limited number of collations, this may cause significant problems for non-english languages
• Oracle is known to fail in multiple tests (work in progress)