DB layer 2.0 functional testing: Difference between revisions
From MoodleDocs
No edit summary |
No edit summary |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{{Template:Development:dmllib 2.0}}{{Moodle_2.0}} | {{Template:WillNotMigrate}} | ||
{{Template:Development:dmllib 2.0}}{{Moodle_2.0}} | |||
Functional unit tests can be used to test the interaction of Moodle and database, it is testing following: | Functional unit tests can be used to test the interaction of Moodle and database, it is testing following: | ||
| Line 9: | Line 11: | ||
You can test current database specified in config.php, you can also specify other DB servers via following config.php settings, for example: | You can test current database specified in config.php, you can also specify other DB servers via following config.php settings, for example: | ||
< | <syntaxhighlight lang="php"> | ||
$CFG->func_test_db_1 = array("native", "mysqli", "localhost", "root", "yourpassword", "moodle", "tst_", array('dbengine'=>'InnoDB')); | $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_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_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); | $CFG->func_test_db_4 = array("native", "mssql", "192.168.15.41", "sa", "yourpassword", "moodle", "tst_", NULL); | ||
</ | </syntaxhighlight> | ||
== DDL tests == | == DDL tests == | ||
Latest revision as of 08:10, 10 February 2025
| 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)
