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(); }
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(); }
public function testInsertAtTop() { $t = new Table12(); $t->setTitle('new'); $t->setScopeValue(1); $t->insertAtTop(); $this->assertEquals(1, $t->getRank(), 'insertAtTop() sets the position to 1'); $this->assertTrue($t->isNew(), 'insertAtTop() doesn\'t save the object'); $t->save(); $expected = array(1 => 'new', 2 => 'row1', 3 => 'row2', 4 => 'row3', 5 => 'row4'); $this->assertEquals($expected, $this->getFixturesArrayWithScope(1), 'insertAtTop() shifts the entire suite'); $expected = array(1 => 'row5', 2 => 'row6'); $this->assertEquals($expected, $this->getFixturesArrayWithScope(2), 'insertAtTop() leaves other suites unchanged'); }
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'); }