function test_cleanUp()
{
$registry = Registry::getInstance();
$setup = $registry->get(self::REG_KEY);
Stage::delete($setup['stageId']);
Lesson::delete($setup['lessonId']);
Course::delete($setup['courseId']);
Admin::delete($setup['ownerId']);
$db = $registry->get(Stage::DB);
$db->query("DELETE FROM `" . StageL10n::TABLE . "` WHERE `description` LIKE 'unitTest%'");
$db->query("DELETE FROM `" . Stage::TABLE . "` WHERE `name` LIKE 'unitTest%'");
$registry->set(self::REG_KEY, null);
}
function delete()
{
Course::delete(intval($_GET['id']));
header('Location: ' . $_SERVER['HTTP_REFERER']);
exit;
}
function test_cleanUp()
{
$registry = Registry::getInstance();
$setup = $registry->get(self::REG_KEY);
Material::delete($setup['id']);
Stage::delete($setup['stageId']);
Lesson::delete($setup['lessonId']);
Course::delete($setup['courseId']);
Admin::delete($setup['ownerId']);
$db = $registry->get(Material::DB);
$db->query("DELETE FROM `" . MaterialL10n::TABLE . "` WHERE `parent_id`={$setup['id']}") or die($db->lastError);
# $db->query("DELETE FROM `".MaterialL10n::TABLE."` WHERE `original_file_name`='gcode.gif'") or die($db->lastError);
$db->query("DELETE FROM `" . Material::TABLE . "` WHERE `name` LIKE 'unitTest%'") or die($db->lastError);
$db->query("DELETE FROM `" . Stage::TABLE . "` WHERE `name` LIKE 'unitTest%'") or die($db->lastError);
$db->query("DELETE FROM `" . Exercise::TABLE . "` WHERE `name` LIKE 'unitTest%'") or die($db->lastError);
$db->query("DELETE FROM `" . Lesson::TABLE . "` WHERE EXISTS(SELECT * FROM `" . LessonL10n::TABLE . "` `s` WHERE `parent_id`=`" . Lesson::TABLE . "`.`id` AND `s`.`name` LIKE 'unitTest%')") or die($db->lastError);
$registry->set(self::REG_KEY, null);
}
function test_CourseDelete()
{
$registry = Registry::getInstance();
$setup = $registry->get(self::REG_KEY);
Course::delete($setup['id']);
$course = new Course($setup['id']);
$this->assertNotEquals($setup['id'], $course->id, "Delete does not working ({$setup['id']})");
$db = $registry->get(Course::DB);
$cnt = $db->getValue("SELECT IFNULL(COUNT(*), 0) as `cnt` FROM `" . CourseL10n::TABLE . "` WHERE `parent_id`={$setup['id']}");
$this->assertEquals(0, $cnt, "Delete does not remove localization data ({$setup['id']})");
}
