function cleanTables($connection)
{
$db = new lmbSimpleDb($connection);
foreach ($this->affected_tables as $table) {
$db->delete($table);
}
}
function lmb_tests_teardown_db()
{
$conn = lmbToolkit::instance()->getDefaultDbConnection();
lmb_require('limb/dbal/src/lmbSimpleDb.class.php');
$db = new lmbSimpleDb($conn);
$db->truncateDb();
echo "INFO: Database was cleaned up\n";
}
function testGetOffsetIsDecorated()
{
$course = $this->_createCourseWithTwoLectures();
$db = new lmbSimpleDb(lmbToolkit::instance()->getDefaultDbConnection());
$decorated = $db->select('lecture_for_test');
$iterator = new lmbARRecordSetDecorator($decorated, 'LectureForTest');
$this->assertEqual($iterator->at(0)->getCourse()->getTitle(), $course->getTitle());
$this->assertEqual($iterator[0]->getCourse()->getTitle(), $course->getTitle());
$this->assertEqual($iterator->at(1)->getCourse()->getTitle(), $course->getTitle());
$this->assertEqual($iterator[1]->getCourse()->getTitle(), $course->getTitle());
}
function testProcessPrefixedFieldsAsRelatedActiveRecords()
{
$course = $this->_createCourseWithTwoLectures();
$lecture = new LectureForTest();
$course_info = $lecture->getRelationInfo('course');
$conn = lmbToolkit::instance()->getDefaultDbConnection();
$db = new lmbSimpleDb($conn);
$sql = 'SELECT ' . $conn->quoteIdentifier("lecture_for_test") . '.*, ' . $conn->quoteIdentifier("course_for_test.id") . ' as ' . $conn->quoteIdentifier("course__id") . ', ' . $conn->quoteIdentifier("course_for_test.title") . ' as ' . $conn->quoteIdentifier("course__title") . '
FROM ' . $conn->quoteIdentifier("lecture_for_test") . ' LEFT JOIN ' . $conn->quoteIdentifier("course_for_test") . ' ON ' . $conn->quoteIdentifier("course_for_test.id") . ' = ' . $conn->quoteIdentifier("lecture_for_test.course_id");
$decorated = lmbDBAL::fetch($sql);
$iterator = new lmbARRecordSetJoinDecorator($decorated, new LectureForTest(), null, array('course' => $course_info));
// let's fetch all data in order to actually call rewind() and current();
$arr = $iterator->getArray();
// now let's remove everything from db tables so we can be sure that processing is correct
$db->delete('lecture_for_test');
$db->delete('course_for_test');
$this->assertEqual($arr[0]->get('course')->getTitle(), $course->getTitle());
$this->assertEqual($arr[1]->get('course')->getTitle(), $course->getTitle());
}
