protected function getDataSet() {
$csvDataSet = new OBM_Database_CsvDataSet(';');
$csvDataSet->addEntityTable('Domain', 'domain', dirname(__FILE__).'/db_data/Domain.csv');
$csvDataSet->addEntityTable('UserObm', 'user', dirname(__FILE__).'/db_data/UserObm.csv');
$csvDataSet->addEntityTable('UGroup', 'group', dirname(__FILE__).'/db_data/UGroup.csv');
$csvDataSet->addEntityTable('Host', 'host', dirname(__FILE__).'/db_data/Host.csv');
$csvDataSet->addEntityTable('MailShare', 'mailshare', dirname(__FILE__).'/db_data/MailShare.csv');
$csvDataSet->addTable('of_usergroup', dirname(__FILE__).'/db_data/of_usergroup.csv');
return $csvDataSet;
}
protected function getDataSet() {
$csvDataSet = new OBM_Database_CsvDataSet(';');
$csvDataSet->addEntityTable('Domain', 'domain', dirname(__FILE__).'/db_data/Domain.csv');
$csvDataSet->addEntityTable('UserObm', 'user', dirname(__FILE__).'/db_data/UserObm.csv');
$csvDataSet->addEntityTable('UGroup', 'group', dirname(__FILE__).'/db_data/UGroup.csv');
$csvDataSet->addEntityTable('CV', 'cv', dirname(__FILE__).'/db_data/Cv.csv');
$csvDataSet->addTable('of_usergroup', dirname(__FILE__).'/db_data/of_usergroup.csv');
return $csvDataSet;
}
public function execute(PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection,
PHPUnit_Extensions_Database_DataSet_IDataSet $dataSet) {
$truncate = new PHPUnit_Extensions_Database_Operation_Truncate(true);
$truncate->setCascade(true);
$dataset = new OBM_Database_CsvDataSet(';');
$dataset->addTable('Entity');
$truncate->execute($connection, $dataset);
$pdo = $connection->getConnection(); // we retrieve the PDO object
parent::execute($connection, $dataSet);
$dsIterator = $dataSet->getIterator();
foreach ($dsIterator as $table) {
$tableName = $table->getTableMetaData()->getTableName();
if ($dataSet->isEntityTable($tableName)) {
$entities = $dataSet->getEntityName($tableName);
if(!is_array($entities)) $entities = array($entities);
foreach($entities as $entity) {
for ($i = 1; $i <= $table->getRowCount(); $i++) {
$pdo->exec('INSERT INTO Entity (entity_mailing) VALUES (TRUE)');
$entityId = $pdo->lastInsertId();
$query = 'INSERT INTO '.ucfirst($entity).'Entity ('.$entity.'entity_entity_id, '.$entity.'entity_'.$entity.'_id )
SELECT MAX(entity_id), '.$i.' FROM Entity';
$pdo->exec($query);
}
}
}
}
}
protected function getDataSet() {
$csvDataSet = new OBM_Database_CsvDataSet(';');
$csvDataSet->addTable('Entity');
$csvDataSet->addTable('Domain');
$csvDataSet->addTable('DomainEntity');
$csvDataSet->addTable('UserObm');
$csvDataSet->addTable('UserEntity');
$csvDataSet->addTable('UserObmPref');
$csvDataSet->addTable('UGroup');
$csvDataSet->addTable('GroupEntity');
$csvDataSet->addTable('Resource');
$csvDataSet->addTable('ResourceEntity');
$csvDataSet->addTable('EventCategory1');
$csvDataSet->addTable('Event');
$csvDataSet->addTable('EventLink');
$csvDataSet->addTable('EventException');
$csvDataSet->addTable('of_usergroup');
$csvDataSet->addTable('EntityRight');
return $csvDataSet;
}
