function testForceToLoadSomeLazyAttributes() { $object1 = $this->_createActiveRecord('Some annotation', 'Some content'); $object2 = $this->_createActiveRecord('Some other annotation', 'Some other content'); $query = lmbARQuery::create('LazyTestOneTableObject', $params = array('with_lazy_attributes' => array('annotation'))); $arr = $query->fetch()->getArray(); $this->assertTrue(array_key_exists('annotation', $arr[0]->exportRaw())); $this->assertFalse(array_key_exists('content', $arr[0]->exportRaw())); $this->assertTrue(array_key_exists('annotation', $arr[1]->exportRaw())); $this->assertFalse(array_key_exists('content', $arr[1]->exportRaw())); }
static function createCoreARQueryForRelation($relation_info, $conn, $params = array()) { $class = $relation_info['class']; $object = new $class(); $table = $conn->quoteIdentifier($object->getTableName()); $join_table = $conn->quoteIdentifier($relation_info['table']); $foreign_field = $conn->quoteIdentifier($relation_info['foreign_field']); $primary_field = $conn->quoteIdentifier($object->getPrimaryKeyName()); $sql = "SELECT %fields% FROM {$table} INNER JOIN {$join_table} ON {$table}.{$primary_field} = {$join_table}.{$foreign_field}" . " %tables% %left_join% %where% %group% %having% %order%"; $query = lmbARQuery::create($class, $params, $conn, $sql); $fields = $object->getDbTable()->getColumnsForSelect(); foreach ($fields as $field => $alias) { $query->addField($field, $alias); } return $query; }
/** * Finds a collection of records(not lmbActiveRecord objects!) from database table * @param string|object filtering criteria * @param array sort params * @return iterator */ function findAllRecords($criteria = null, $sort_params = array()) { $query = lmbARQuery::create(get_class($this), $params = array('criteria' => $criteria, 'sort' => $sort_params), $this->_db_conn); return $query->fetch($decorate = false); }
function testGroup() { $course1 = $this->creator->createCourse(); $lecture1 = $this->creator->createLecture($course1); $lecture2 = $this->creator->createLecture($course1); $course2 = $this->creator->createCourse(); $lecture3 = $this->creator->createLecture($course2); $lecture4 = $this->creator->createLecture($course2); $query = lmbARQuery::create('LectureForTest', array('group' => 'course.id'), $this->conn); $rs = $query->eagerJoin('course')->fetch(); $this->assertEqual($rs->count(), 2); $arr = $rs->getArray(); $this->assertEqual(count($arr), 2); $this->assertEqual($arr[0]->getTitle(), $lecture1->getTitle()); $this->assertEqual($arr[1]->getTitle(), $lecture3->getTitle()); }
static function createCoreARQueryForRelation($relation_info, $conn, $params = array()) { return lmbARQuery::create($relation_info['class'], $params, $conn); }