function test_find_by_pks_with_invalid() { $deps = DepartmentRecord::finder()->findAllByPks(4, 2, 14); $this->assertEqual(count($deps), 2); $this->assertEqual($deps[0]->department_id, 2); $this->assertEqual($deps[1]->department_id, 4); }
function test_delete_by_pks() { $finder = DepartmentRecord::finder(); $this->assertEquals($finder->deleteByPk(100), 0); $this->assertEquals($finder->deleteByPk(100, 101), 0); $this->assertEquals($finder->deleteByPk(array(100, 101)), 0); }
function test_orderby_only_desc() { $criteria = new TActiveRecordCriteria(); $criteria->OrdersBy['name'] = 'desc'; $records = DepartmentRecord::finder()->findAll($criteria); $this->assertEqual(count($records), 8); $this->assertEqual($records[7]->name, '+GX Service'); $this->assertEqual($records[0]->name, 'Marketing'); }
function test_dynamic_delete_by() { $finder = DepartmentRecord::finder(); //$finder->RecordManager->OnDelete[] = array($this, 'assertDeleteSql'); $this->assertEquals($finder->deleteByName('tasds'), 0); }
function test_count_without_parameter() { $finder = DepartmentRecord::finder(); $this->assertEquals($finder->count(), 8); }
function test_find_by_array_parameter() { $department = DepartmentRecord::finder()->find('department_id < ? AND "order" > ?', array(5, 2)); $this->assertNotNull($department); }
function test_find_by_sql() { $deps = DepartmentRecord::finder()->findBySql('SELECT * FROM departments'); $this->assertTrue(count($deps) > 0); }