protected function populateTable12()
{
/* List used for tests
scope=1 scope=2 scope=null
row1 row5 row7
row2 row6 row8
row3 row9
row4 row10
*/
Table12Peer::doDeleteAll();
$t1 = new Table12();
$t1->setRank(1);
$t1->setScopeValue(1);
$t1->setTitle('row1');
$t1->save();
$t2 = new Table12();
$t2->setRank(4);
$t2->setScopeValue(1);
$t2->setTitle('row4');
$t2->save();
$t3 = new Table12();
$t3->setRank(2);
$t3->setScopeValue(1);
$t3->setTitle('row2');
$t3->save();
$t4 = new Table12();
$t4->setRank(1);
$t4->setScopeValue(2);
$t4->setTitle('row5');
$t4->save();
$t5 = new Table12();
$t5->setRank(3);
$t5->setScopeValue(1);
$t5->setTitle('row3');
$t5->save();
$t6 = new Table12();
$t6->setRank(2);
$t6->setScopeValue(2);
$t6->setTitle('row6');
$t6->save();
$t7 = new Table12();
$t7->setRank(1);
$t7->setTitle('row7');
$t7->save();
$t8 = new Table12();
$t8->setRank(2);
$t8->setTitle('row8');
$t8->save();
$t9 = new Table12();
$t9->setRank(3);
$t9->setTitle('row9');
$t9->save();
$t10 = new Table12();
$t10->setRank(4);
$t10->setTitle('row10');
$t10->save();
}
protected function populateTable12()
{
/* List used for tests
scope=1 scope=2
row1 row5
row2 row6
row3
row4
*/
Table12Peer::doDeleteAll();
$t1 = new Table12();
$t1->setRank(1);
$t1->setScopeValue(1);
$t1->setTitle('row1');
$t1->save();
$t2 = new Table12();
$t2->setRank(4);
$t2->setScopeValue(1);
$t2->setTitle('row4');
$t2->save();
$t3 = new Table12();
$t3->setRank(2);
$t3->setScopeValue(1);
$t3->setTitle('row2');
$t3->save();
$t4 = new Table12();
$t4->setRank(1);
$t4->setScopeValue(2);
$t4->setTitle('row5');
$t4->save();
$t5 = new Table12();
$t5->setRank(3);
$t5->setScopeValue(1);
$t5->setTitle('row3');
$t5->save();
$t6 = new Table12();
$t6->setRank(2);
$t6->setScopeValue(2);
$t6->setTitle('row6');
$t6->save();
}
/**
* @expectedException PropelException
*/
public function testMoveToNewObject()
{
$t = new Table12();
$t->moveToRank(2);
}
public function testGetMaxRank()
{
$this->assertEquals(4, Table12Query::create()->getMaxRank(1), 'getMaxRank() returns the maximum rank in the scope');
$this->assertEquals(2, Table12Query::create()->getMaxRank(2), 'getMaxRank() returns the maximum rank in the scope');
// delete one
$t4 = Table12Query::create()->findOneByRank(4, 1);
$t4->delete();
$this->assertEquals(3, Table12Query::create()->getMaxRank(1), 'getMaxRank() returns the maximum rank');
// add one
$t = new Table12();
$t->setMyScopeColumn(1);
$t->save();
$this->assertEquals(4, Table12Query::create()->getMaxRank(1), 'getMaxRank() returns the maximum rank');
// delete all
Table12Query::create()->deleteAll();
$this->assertNull(Table12Query::create()->getMaxRank(1), 'getMaxRank() returns null for empty tables');
// add one
$t = new Table12();
$t->setMyScopeColumn(1);
$t->save();
$this->assertEquals(1, Table12Query::create()->getMaxRank(1), 'getMaxRank() returns the maximum rank');
}
