public function testRootsStaticWithCustomOrder() { $category = OrderedCategory::create(array('name' => 'A new root is born')); $category->syncOriginal(); // ¿? --> This should be done already !? $roots = OrderedCategory::roots()->get(); $this->assertCount(3, $roots); $this->assertEquals($category, $roots->first()); }
public function run() { DB::table('categories')->delete(); OrderedCategory::unguard(); OrderedCategory::create(array('id' => 1, 'name' => 'Root Z', 'lft' => 1, 'rgt' => 10, 'depth' => 0)); OrderedCategory::create(array('id' => 2, 'name' => 'Child C', 'lft' => 2, 'rgt' => 3, 'depth' => 1, 'parent_id' => 1)); OrderedCategory::create(array('id' => 3, 'name' => 'Child G', 'lft' => 4, 'rgt' => 7, 'depth' => 1, 'parent_id' => 1)); OrderedCategory::create(array('id' => 4, 'name' => 'Child G.1', 'lft' => 5, 'rgt' => 6, 'depth' => 2, 'parent_id' => 3)); OrderedCategory::create(array('id' => 5, 'name' => 'Child A', 'lft' => 8, 'rgt' => 9, 'depth' => 1, 'parent_id' => 1)); OrderedCategory::create(array('id' => 6, 'name' => 'Root A', 'lft' => 11, 'rgt' => 12, 'depth' => 0)); OrderedCategory::reguard(); if (DB::connection()->getDriverName() === 'pgsql') { $tablePrefix = DB::connection()->getTablePrefix(); $sequenceName = $tablePrefix . 'categories_id_seq'; DB::connection()->statement('ALTER SEQUENCE ' . $sequenceName . ' RESTART WITH 7'); } }