public function testGetMaxRank()
{
$this->assertEquals(4, SortableTable11Query::create()->getMaxRank(), 'getMaxRank() returns the maximum rank');
$t4 = SortableTable11Query::retrieveByRank(4);
$t4->delete();
$this->assertEquals(3, SortableTable11Query::create()->getMaxRank(), 'getMaxRank() returns the maximum rank');
SortableTable11TableMap::doDeleteAll();
$this->assertNull(SortableTable11Query::create()->getMaxRank(), 'getMaxRank() returns null for empty tables');
}
public function testParameters()
{
$table11 = SortableTable11TableMap::getTableMap();
$this->assertEquals(count($table11->getColumns()), 3, 'Sortable adds one columns by default');
$this->assertTrue(method_exists('Propel\\Tests\\Bookstore\\Behavior\\SortableTable11', 'getRank'), 'Sortable adds a rank column by default');
$table12 = SortableTable12TableMap::getTableMap();
$this->assertEquals(count($table12->getColumns()), 4, 'Sortable does not add a column when it already exists');
$this->assertTrue(method_exists('Propel\\Tests\\Bookstore\\Behavior\\SortableTable12', 'getPosition'), 'Sortable allows customization of rank_column name');
}
protected function populateTable11()
{
SortableTable11TableMap::doDeleteAll();
$t1 = new SortableTable11();
$t1->setRank(1);
$t1->setTitle('row1');
$t1->save();
$t2 = new SortableTable11();
$t2->setRank(4);
$t2->setTitle('row4');
$t2->save();
$t3 = new SortableTable11();
$t3->setRank(2);
$t3->setTitle('row2');
$t3->save();
$t4 = new SortableTable11();
$t4->setRank(3);
$t4->setTitle('row3');
$t4->save();
}
public function testRemoveFromList()
{
$t2 = SortableTable11Query::retrieveByRank(2);
$res = $t2->removeFromList();
$this->assertTrue($res instanceof Table11, 'removeFromList() returns the current object');
$this->assertNull($res->getRank(), 'removeFromList() resets the object\'s rank');
SortableTable11TableMap::clearInstancePool();
$expected = array(1 => 'row1', 2 => 'row2', 3 => 'row3', 4 => 'row4');
$this->assertEquals($expected, $this->getFixturesArray(), 'removeFromList() does not change the list until the object is saved');
$t2->save();
SortableTable11TableMap::clearInstancePool();
$expected = array(null => 'row2', 1 => 'row1', 2 => 'row3', 3 => 'row4');
$this->assertEquals($expected, $this->getFixturesArray(), 'removeFromList() changes the list once the object is saved');
}
