Example #1
0
 public function testUpdatePivots()
 {
     $cat = Category::findByPK(2);
     $cat->items[0]->publish = '2000-10-10';
     $cat->items[1]->publish = '2000-10-11';
     $cat->save();
     $this->assertSelectAll(Category::getTableName(), [['__id' => 1, 'num' => 1], ['__id' => 2, 'num' => 2], ['__id' => 3, 'num' => 3], ['__id' => 4, 'num' => 4]]);
     $this->assertSelectAll(Item::getTableName(), [['__id' => 1, 'num' => 1], ['__id' => 2, 'num' => 2], ['__id' => 3, 'num' => 3], ['__id' => 4, 'num' => 4]]);
     $this->assertSelectAll('cats_to_items', [['__id' => 1, '__category_id' => 1, '__item_id' => 1, 'publish' => '2000-01-01'], ['__id' => 2, '__category_id' => 2, '__item_id' => 2, 'publish' => '2000-10-10'], ['__id' => 3, '__category_id' => 2, '__item_id' => 3, 'publish' => '2000-10-11'], ['__id' => 4, '__category_id' => 3, '__item_id' => 2, 'publish' => '2000-03-02']]);
 }