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);
}
