function testFindBySql()
{
$object1 = $this->creator->createOneTableObject();
$object2 = $this->creator->createOneTableObject();
$rs = lmbActiveRecord::findBySql('TestOneTableObject', 'select * from ' . lmbActiveRecord::getDefaultConnection()->quoteIdentifier("test_one_table_object") . ' order by ' . lmbActiveRecord::getDefaultConnection()->quoteIdentifier("id") . ' desc');
$rs->rewind();
$this->assertEqual($object2->getId(), $rs->current()->getId());
$rs->next();
$this->assertEqual($object1->getId(), $rs->current()->getId());
$rs->next();
$this->assertFalse($rs->valid());
$this->assertEqual($rs->getIds(), array($object2->getId(), $object1->getId()));
//testing convenient alias
$rs = TestOneTableObject::findBySql('select * from ' . lmbActiveRecord::getDefaultConnection()->quoteIdentifier("test_one_table_object") . ' order by ' . lmbActiveRecord::getDefaultConnection()->quoteIdentifier("id") . ' desc');
$rs->rewind();
$this->assertEqual($object2->getId(), $rs->current()->getId());
$rs->next();
$this->assertEqual($object1->getId(), $rs->current()->getId());
$rs->next();
$this->assertFalse($rs->valid());
}
