function testFindFirstBySql() { $object1 = $this->creator->createOneTableObject(); $object2 = $this->creator->createOneTableObject(); $object = lmbActiveRecord::findFirstBySql('TestOneTableObject', 'select * from ' . lmbActiveRecord::getDefaultConnection()->quoteIdentifier("test_one_table_object") . ' order by ' . lmbActiveRecord::getDefaultConnection()->quoteIdentifier("id") . ' desc'); $this->assertEqual($object2->getId(), $object->getId()); //testing convenient alias $object = TestOneTableObject::findFirstBySql('select * from ' . lmbActiveRecord::getDefaultConnection()->quoteIdentifier("test_one_table_object") . ' order by ' . lmbActiveRecord::getDefaultConnection()->quoteIdentifier("id") . ' desc'); $this->assertEqual($object2->getId(), $object->getId()); }