/**
* Test methods that get DataObjects
* - DataObject::get()
* - All records of a DataObject
* - Filtering
* - Sorting
* - Joins
* - Limit
* - Container class
* - DataObject::get_by_id()
* - DataObject::get_by_url()
* - DataObject::get_one()
* - With and without caching
* - With and without ordering
*/
function testGet()
{
// Test getting all records of a DataObject
$comments = DataObject::get('PageComment');
$this->assertTrue($comments->Count() == 4);
// Test WHERE clause
$comments = DataObject::get('PageComment', 'Name="Bob"');
$this->assertTrue($comments->Count() == 2);
foreach ($comments as $comment) {
$this->assertTrue($comment->Name == 'Bob');
}
// Test sorting
$comments = DataObject::get('PageComment', '', 'Name ASC');
$this->assertTrue($comments->Count() == 4);
$this->assertTrue($comments->First()->Name == 'Bob');
$comments = DataObject::get('PageComment', '', 'Name DESC');
$this->assertTrue($comments->Count() == 4);
$this->assertTrue($comments->First()->Name == 'Joe');
// Test join
$comments = DataObject::get('PageComment', '`SiteTree`.Title="First Page"', '', 'INNER JOIN SiteTree ON PageComment.ParentID = SiteTree.ID');
$this->assertTrue($comments->Count() == 2);
$this->assertTrue($comments->First()->Name == 'Bob');
$this->assertTrue($comments->Last()->Name == 'Bob');
// Test limit
$comments = DataObject::get('PageComment', '', 'Name ASC', '', '1,2');
$this->assertTrue($comments->Count() == 2);
$this->assertTrue($comments->First()->Name == 'Bob');
$this->assertTrue($comments->Last()->Name == 'Jane');
// Test container class
$comments = DataObject::get('PageComment', '', '', '', '', 'DataObjectSet');
$this->assertTrue(get_class($comments) == 'DataObjectSet');
$comments = DataObject::get('PageComment', '', '', '', '', 'ComponentSet');
$this->assertTrue(get_class($comments) == 'ComponentSet');
// Test get_by_id()
$homepage = $this->objFromFixture('Page', 'home');
$page = DataObject::get_by_id('Page', $homepage->ID);
$this->assertTrue($page->Title == 'Home');
// Test get_by_url()
$page = DataObject::get_by_url('home');
$this->assertTrue($page->ID == $homepage->ID);
// Test get_one() without caching
$comment1 = DataObject::get_one('PageComment', 'Name="Joe"', false);
$comment1->Comment = "Something Else";
$comment2 = DataObject::get_one('PageComment', 'Name="Joe"', false);
$this->assertTrue($comment1->Comment != $comment2->Comment);
// Test get_one() with caching
$comment1 = DataObject::get_one('PageComment', 'Name="Jane"', true);
$comment1->Comment = "Something Else";
$comment2 = DataObject::get_one('PageComment', 'Name="Jane"', true);
$this->assertTrue((string) $comment1->Comment == (string) $comment2->Comment);
// Test get_one() with order by without caching
$comment = DataObject::get_one('PageComment', '', false, 'Name ASC');
$this->assertTrue($comment->Name == 'Bob');
$comment = DataObject::get_one('PageComment', '', false, 'Name DESC');
$this->assertTrue($comment->Name == 'Joe');
// Test get_one() with order by with caching
$comment = DataObject::get_one('PageComment', '', true, 'Name ASC');
$this->assertTrue($comment->Name == 'Bob');
$comment = DataObject::get_one('PageComment', '', true, 'Name DESC');
$this->assertTrue($comment->Name == 'Joe');
}
public function generateDataTreeHints()
{
$classes = ClassInfo::subclassesFor($this->stat('tree_class'));
$def['Root'] = array();
foreach ($classes as $class) {
$obj = singleton($class);
if ($obj instanceof HiddenClass) {
continue;
}
$allowedChildren = $obj->allowedChildren();
if ($allowedChildren != "none") {
$def[$class]['allowedChildren'] = $allowedChildren;
}
$def[$class]['defaultChild'] = $obj->defaultChild();
$def[$class]['defaultParent'] = isset(DataObject::get_by_url($obj->defaultParent())->ID) ? DataObject::get_by_url($obj->defaultParent())->ID : null;
if (is_array($allowedChildren)) {
foreach ($allowedChildren as $allowedChild) {
$def[$allowedChild]['allowedParents'][] = $class;
}
}
if ($obj->stat('can_be_root')) {
$def['Root']['allowedChildren'][] = $class;
}
}
// Put data hints into a script tag at the top
Requirements::customScript("siteTreeHints = " . $this->jsDeclaration($def) . ";");
}