You can incrementally add CSV files as tables to your datasets
/**
* Gets the data set to be loaded into the database during setup
*
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*
* @since 3.1
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_menu', JPATH_TEST_DATABASE . '/jos_menu.csv');
$dataSet->addTable('jos_menu_types', JPATH_TEST_DATABASE . '/jos_menu_types.csv');
return $dataSet;
}
private function getCsvDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet();
$dataSet->addTable("class", D_DIR . 'class.csv');
$dataSet->addTable("user", D_DIR . 'user.csv');
$dataSet->addTable("address", D_DIR . 'address.csv');
return $dataSet;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*
* @since 3.2
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_users', JPATH_TEST_DATABASE . '/jos_users.csv');
$dataSet->addTable('jos_content', JPATH_TEST_DATABASE . '/jos_content.csv');
//$dataSet->addTable('jos_ucm_base', JPATH_TEST_DATABASE . '/jos_ucm_history.csv');
return $dataSet;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*
* @since 3.1
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_extensions', JPATH_TEST_DATABASE . '/jos_extensions.csv');
$dataSet->addTable('jos_finder_terms_common', JPATH_TEST_DATABASE . '/jos_finder_terms_common.csv');
$dataSet->addTable('jos_finder_types', JPATH_TEST_DATABASE . '/jos_finder_types.csv');
return $dataSet;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return CSV database tables
*
* @since 11.4
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_assets', dirname(__DIR__) . '/stubs/jos_assets.csv');
$dataSet->addTable('jos_categories', dirname(__DIR__) . '/stubs/jos_categories.csv');
$dataSet->addTable('jos_content', dirname(__DIR__) . '/stubs/jos_content.csv');
return $dataSet;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return CSV database tables
*
* @since 11.4
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_extensions', __DIR__ . '/stubs/jos_extensions.csv');
return $dataSet;
}
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_categories', JPATH_TESTS . '/stubs/jos_categories.csv');
$dataSet->addTable('jos_assets', JPATH_TESTS . '/stubs/jos_assets.csv');
$dataSet->addTable('jos_menu', JPATH_TESTS . '/stubs/jos_menu.csv');
return $dataSet;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*
* @since 12.2
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_users', JPATH_TEST_DATABASE . '/jos_users.csv');
$dataSet->addTable('jos_user_usergroup_map', JPATH_TEST_DATABASE . '/jos_user_usergroup_map.csv');
$dataSet->addTable('jos_usergroups', JPATH_TEST_DATABASE . '/jos_usergroups.csv');
return $dataSet;
}
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet();
$dataSet->addTable('post', 'csv/post.csv');
$dataSet->addTable('post_comment', 'csv/post_comment.csv');
$dataSet->addTable('current_visitors', 'csv/current_visitors.csv');
return $dataSet;
}
protected function getDataSet()
{
$dataset = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(';', "'");
$dataset->addTable('polling_messages', dirname(__FILE__) . '/fixtures/polling_messages.csv');
$dataset->addTable('polling_users', dirname(__FILE__) . '/fixtures/polling_users.csv');
$dataset->addTable('sessions', dirname(__FILE__) . '/fixtures/sessions.csv');
return $dataset;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return CSV database tables
*
* @since 11.4
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$stubpath = JPATH_TESTS . '/suites/unit/joomla/table/stubs';
$dataSet->addTable('jos_assets', $stubpath . '/jos_assets.csv');
$dataSet->addTable('jos_categories', $stubpath . '/jos_categories.csv');
$dataSet->addTable('jos_content', __DIR__ . '/stubs/jos_content.csv');
return $dataSet;
}
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$refreshTestNames = array('testGetPath', 'testMove', 'testMoveByReference', 'testDelete', 'testStore', 'testGetRootId', 'testOrderUp', 'testRebuild', 'testRebuildPath', 'testSaveorder');
if (in_array($this->name, $refreshTestNames)) {
$dataSet->addTable('jos_categories', JPATH_BASE . '/tests/unit/stubs/jos_categories.csv');
$dataSet->addTable('jos_assets', JPATH_BASE . '/tests/unit/stubs/jos_assets.csv');
$dataSet->addTable('jos_menu', JPATH_BASE . '/tests/unit/stubs/jos_menu.csv');
}
return $dataSet;
}
public function testCSVDataSet()
{
$table1MetaData = new PHPUnit_Extensions_Database_DataSet_DefaultTableMetaData('table1', array('table1_id', 'column1', 'column2', 'column3', 'column4'));
$table2MetaData = new PHPUnit_Extensions_Database_DataSet_DefaultTableMetaData('table2', array('table2_id', 'column5', 'column6', 'column7', 'column8'));
$table1 = new PHPUnit_Extensions_Database_DataSet_DefaultTable($table1MetaData);
$table2 = new PHPUnit_Extensions_Database_DataSet_DefaultTable($table2MetaData);
$table1->addRow(array('table1_id' => 1, 'column1' => 'tgfahgasdf', 'column2' => 200, 'column3' => 34.64, 'column4' => 'yghkf;a hahfg8ja h;'));
$table1->addRow(array('table1_id' => 2, 'column1' => 'hk;afg', 'column2' => 654, 'column3' => 46.54, 'column4' => '24rwehhads'));
$table1->addRow(array('table1_id' => 3, 'column1' => 'ha;gyt', 'column2' => 462, 'column3' => 1654.4, 'column4' => 'asfgklg'));
$table2->addRow(array('table2_id' => 1, 'column5' => 'fhah', 'column6' => 456, 'column7' => 46.5, 'column8' => 'fsdb, ghfdas'));
$table2->addRow(array('table2_id' => 2, 'column5' => 'asdhfoih', 'column6' => 654, 'column7' => 'blah', 'column8' => '43asd "fhgj" sfadh'));
$table2->addRow(array('table2_id' => 3, 'column5' => 'ajsdlkfguitah', 'column6' => 654, 'column7' => 'blah', 'column8' => 'thesethasdl
asdflkjsadf asdfsadfhl "adsf, halsdf" sadfhlasdf'));
$expectedDataSet = new PHPUnit_Extensions_Database_DataSet_DefaultDataSet(array($table1, $table2));
$csvDataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet();
$csvDataSet->addTable('table1', dirname(__FILE__) . '/../_files/CsvDataSets/table1.csv');
$csvDataSet->addTable('table2', dirname(__FILE__) . '/../_files/CsvDataSets/table2.csv');
PHPUnit_Extensions_Database_TestCase::assertDataSetsEqual($expectedDataSet, $csvDataSet);
}
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_assets', JPATH_BASE . '/tests/unit/stubs/jos_assets.csv');
$dataSet->addTable('jos_categories', JPATH_BASE . '/tests/unit/stubs/jos_categories.csv');
$dataSet->addTable('jos_usergroups', JPATH_BASE . '/tests/unit/stubs/jos_usergroups.csv');
$dataSet->addTable('jos_user_usergroup_map', JPATH_BASE . '/tests/unit/stubs/jos_user_usergroup_map.csv');
$dataSet->addTable('jos_users', JPATH_BASE . '/tests/unit/stubs/jos_users.csv');
return $dataSet;
}
public function loadDatasetFile($filename, $format = '')
{
if ($format == '') {
// try to deduce format from filename/extension
$info = pathinfo($filename);
$format = $info['extension'];
if (substr($filename, -9, 9) == '.flat.xml') {
$format = 'flatxml';
}
}
if ($format == '') {
// absolute default
$format = 'yaml';
}
switch ($format) {
case "flatxml":
$ds = new \PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet($filename);
break;
case "csv":
if ($this->tablename == '') {
throw new \InvalidArgumentException('You need to specify a tablename for .csv datasets');
}
$ds = new \PHPUnit_Extensions_Database_DataSet_CsvDataSet(';');
$ds->addTable($this->tablename, $filename);
break;
case "yml":
case "yaml":
$ds = new \PHPUnit_Extensions_Database_DataSet_YamlDataSet($filename, new YamlParser());
break;
case "xml":
$ds = new \PHPUnit_Extensions_Database_DataSet_XmlDataSet($filename);
break;
default:
throw new \InvalidArgumentException('Unsupported format: ' . $format);
break;
}
$this->dataset = $ds;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*
* @since 11.4
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_assets', JPATH_TEST_DATABASE . '/jos_assets.csv');
$dataSet->addTable('jos_categories', JPATH_TEST_DATABASE . '/jos_categories.csv');
$dataSet->addTable('jos_content', JPATH_TEST_DATABASE . '/jos_content.csv');
$dataSet->addTable('jos_tags', JPATH_TEST_DATABASE . '/jos_tags.csv');
return $dataSet;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*
* @since 3.1
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_categories', JPATH_TEST_DATABASE . '/jos_categories.csv');
$dataSet->addTable('jos_languages', JPATH_TEST_DATABASE . '/jos_languages.csv');
$dataSet->addTable('jos_users', JPATH_TEST_DATABASE . '/jos_users.csv');
$dataSet->addTable('jos_viewlevels', JPATH_TEST_DATABASE . '/jos_viewlevels.csv');
return $dataSet;
}
public function testSetActiveUsers()
{
$this->object->set_active_users(array(1, 2, 3));
$csv_dataset = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(';', "'");
$csv_dataset->addTable('polling_users', dirname(__FILE__) . '/fixtures/polling_users_after_set.csv');
$database_dataset = new PHPUnit_Extensions_Database_DataSet_DataSetFilter($this->getConnection()->createDataSet(array('polling_users')), array('polling_users' => array('timestamp')));
$this->assertDataSetsEqual($csv_dataset, $database_dataset);
$this->object->set_active_users(array());
$csv_dataset = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(';', "'");
$csv_dataset->addTable('polling_users', dirname(__FILE__) . '/fixtures/polling_users_empty.csv');
$database_dataset = new PHPUnit_Extensions_Database_DataSet_DataSetFilter($this->getConnection()->createDataSet(array('polling_users')), array('polling_users' => array('timestamp')));
$this->assertDataSetsEqual($csv_dataset, $database_dataset);
}
/**
* Test that modifying a Moodle user also updates the corresponding PM user.
*/
public function test_modifyingmoodleuserupdatespmuser()
{
global $CFG, $DB;
require_once $CFG->dirroot . '/admin/tool/uploaduser/locallib.php';
$this->load_csv_data();
// Update a record.
$src = new stdClass();
$src->id = 100;
$src->firstname = 'Testuser';
$src->lastname = 'One';
$src->profile_field_sometext = 'boo';
$src->profile_field_sometextfrompm = 'bla';
$DB->update_record('user', $src);
$mdluser = $DB->get_record('user', array('id' => 100));
$mcopy = clone $src;
$mcopy = uu_pre_process_custom_profile_data($mcopy);
profile_save_data($mcopy);
events_trigger('user_updated', $mdluser);
// Read the PM user and compare.
$retr = new user(103, null, array(), false, array());
$retr->reset_custom_field_list();
$this->assertEquals($mdluser->firstname, $retr->firstname);
$this->assertEquals($mdluser->lastname, $retr->lastname);
// Check custom fields.
$result = new PHPUnit_Extensions_Database_DataSet_DefaultDataSet();
$result->addTable(new moodle_recordset_phpunit_datatable(field_data_int::TABLE, $DB->get_recordset(field_data_int::TABLE, null, '', 'contextid, fieldid, data')));
$result->addTable(new moodle_recordset_phpunit_datatable(field_data_char::TABLE, $DB->get_recordset(field_data_char::TABLE, null, '', 'contextid, fieldid, data')));
$result->addTable(new moodle_recordset_phpunit_datatable(field_data_text::TABLE, $DB->get_recordset(field_data_text::TABLE, null, '', 'contextid, fieldid, data')));
$usercontext = \local_elisprogram\context\user::instance(103);
$dataset = new PHPUnit_Extensions_Database_DataSet_CsvDataSet();
$dataset->addTable(field_data_int::TABLE, elispm::file('tests/fixtures/user_field_data_int.csv'));
$dataset->addTable(field_data_char::TABLE, elispm::file('tests/fixtures/user_field_data_char.csv'));
$dataset->addTable(field_data_text::TABLE, elispm::file('tests/fixtures/user_field_data_text.csv'));
$dataset = new PHPUnit_Extensions_Database_DataSet_ReplacementDataSet($dataset);
$dataset->addFullReplacement('##USERCTXID##', $usercontext->id);
$dataset->addFullReplacement('##USERCTXLVL##', CONTEXT_ELIS_USER);
// Only the first text field should be changed; everything else should be the same.
$dataset->addFullReplacement('First text entry field', $src->profile_field_sometext);
$ret = $dataset->addFullReplacement('Second text entry field', $src->profile_field_sometextfrompm);
$this->assertDataSetsEqual($dataset, $result);
}
/**
* Creates a new CsvDataSet from the given array of csv files. (absolute paths.)
*
* @param array $files array tablename=>cvsfile
* @param string $delimiter
* @param string $enclosure
* @param string $escape
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*/
protected function createCsvDataSet($files, $delimiter = ',', $enclosure = '"', $escape = '"') {
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet($delimiter, $enclosure, $escape);
foreach($files as $table=>$file) {
$dataSet->addTable($table, $file);
}
return $dataSet;
}
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet();
$dataSet->addTable('makes', dirname(__FILE__) . "\\makes_Stale.csv");
return $dataSet;
}
protected function createIterator($reverse = FALSE) {
$innerIterator = parent::createIterator($reverse);
return new PHPUnit_Extensions_Database_DataSet_ReplacementTableIterator($innerIterator, array('NULL' => NULL), array());
}
/**
* @covers ::update
*/
public function testUpdate()
{
$carTable = new CarTable($this->pdo);
$cars = $carTable->findAll();
$this->assertCount(2, $cars);
/**
* Alter first car
*/
$firstCar = $cars[0];
$this->assertFalse($firstCar->isAltered());
$firstCar->set('horsepower', 21);
$this->assertTrue($firstCar->isAltered());
$carTable->update($firstCar);
/**
* Alter second car
*/
$secondCar = $cars[1];
$this->assertFalse($secondCar->isAltered());
$secondCar->set('horsepower', 41);
$this->assertTrue($secondCar->isAltered());
$carTable->update($secondCar);
/**
* Assert data set
*/
$expectedCsvDataSet = new \PHPUnit_Extensions_Database_DataSet_CsvDataSet();
$expectedCsvDataSet->addTable('cars', dirname(__FILE__) . '/../Fixture/cars_after-update.csv');
$expectedDataSet = new \PHPUnit_Extensions_Database_DataSet_DataSetFilter($expectedCsvDataSet);
$expectedDataSet->setExcludeColumnsForTable('cars', ['modified', 'created']);
$dataSet = new \PHPUnit_Extensions_Database_DataSet_QueryDataSet($this->getConnection());
$dataSet->addTable('cars', 'SELECT * FROM `cars`');
$dataSet = new \PHPUnit_Extensions_Database_DataSet_DataSetFilter($dataSet);
$dataSet->setExcludeColumnsForTable('cars', ['modified', 'created']);
$this->assertDataSetsEqual($expectedDataSet, $dataSet);
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*
* @since 3.2
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_extensions', JPATH_TEST_DATABASE . '/jos_extensions.csv');
$dataSet->addTable('jos_menu', JPATH_TEST_DATABASE . '/jos_menu.csv');
$dataSet->addTable('jos_menu_types', JPATH_TEST_DATABASE . '/jos_menu_types.csv');
$dataSet->addTable('jos_template_styles', JPATH_TEST_DATABASE . '/jos_template_styles.csv');
$dataSet->addTable('jos_usergroups', JPATH_TEST_DATABASE . '/jos_usergroups.csv');
$dataSet->addTable('jos_users', JPATH_TEST_DATABASE . '/jos_users.csv');
$dataSet->addTable('jos_viewlevels', JPATH_TEST_DATABASE . '/jos_viewlevels.csv');
return $dataSet;
}
/**
* Gets the data set to be loaded into the database during setup
*
* @return PHPUnit_Extensions_Database_DataSet_CsvDataSet
*
* @since 12.3
*/
protected function getDataSet()
{
$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');
$dataSet->addTable('jos_dbtest_composite', __DIR__ . '/stubs/jos_dbtest_composite.csv');
$dataSet->addTable('jos_assets', __DIR__ . '/stubs/jos_assets_composite.csv');
$dataSet->addTable('jos_session', __DIR__ . '/stubs/jos_session.csv');
return $dataSet;
}
/**
* Test that you can delete a user set and all its user subsets
*/
public function test_deleterecordcandeleteusersubsets()
{
global $DB;
$this->load_csv_data();
accesslib_clear_all_caches(true);
// Make sure all the contexts are created, so that we can find the children.
for ($i = 1; $i <= 4; $i++) {
$clustercontextinstance = \local_elisprogram\context\userset::instance($i);
}
// Delete a record.
$src = new userset(2, null, array(), false, array());
$src->deletesubs = true;
$src->delete();
// Read it back.
$recordset = $DB->get_recordset(userset::TABLE, null, '', 'name,display,parent,depth,id');
$result = new moodle_recordset_phpunit_datatable(userset::TABLE, $recordset);
$dataset = new PHPUnit_Extensions_Database_DataSet_CsvDataSet();
$dataset->addTable(userset::TABLE, elispm::file('tests/fixtures/userset_delete_subset_b_test_result.csv'));
$this->assertTablesEqual($dataset->getTable(userset::TABLE), $result);
}
/**
* @return \PHPUnit_Extensions_Database_DataSet_ITable
*/
public function toPhpUnitTable()
{
$dataSet = new \PHPUnit_Extensions_Database_DataSet_CsvDataSet();
$dataSet->addTable($this->getTable()->getFullName(), $this->getTable()->getDataPath());
return $dataSet->getTable($this->getTable()->getFullName());
}
