public function testForeignKey() { $model = new Product(); $schema = $model->getTableSchema(); $this->assertTrue(isset($schema->columns['id'])); $this->assertTrue(isset($schema->columns['category_id'])); $fk = $model->getField("category"); $this->assertInstanceOf('\\Mindy\\Orm\\Fields\\ForeignField', $fk); $this->assertNull($model->category); }
public function testExtraLinkRecords() { $product = new Product(); $product->name = 'Bear'; $product->price = 100; $product->description = 'Funny white bear'; $product->save(); $list1 = new ProductList(); $list1->name = 'Toys'; $list1->save(); $list2 = new ProductList(); $list2->name = 'Trash'; $list2->save(); $this->assertEquals(1, Product::objects()->count()); $this->assertEquals(2, ProductList::objects()->count()); $tableName = $product->getField('lists')->getTableName(); $cmd = ConnectionManager::getDb()->createCommand("SELECT * FROM {$tableName}"); $all = $cmd->queryAll(); $this->assertEquals([], $all); $this->assertEquals(0, count($all)); $product->lists = [$list1]; $product->save(); $cmd = ConnectionManager::getDb()->createCommand("SELECT * FROM {$tableName}"); $all = $cmd->queryAll(); $this->assertEquals([['product_id' => 1, 'product_list_id' => 1]], $all); $this->assertEquals(1, count($all)); $product->lists = [$list2]; $product->save(); $cmd = ConnectionManager::getDb()->createCommand("SELECT * FROM {$tableName}"); $all = $cmd->queryAll(); $this->assertEquals([['product_id' => 1, 'product_list_id' => 2]], $all); $this->assertEquals(1, count($all)); $product->lists = [$list1]; $product->save(); $cmd = ConnectionManager::getDb()->createCommand("SELECT * FROM {$tableName}"); $all = $cmd->queryAll(); $this->assertEquals([['product_id' => 1, 'product_list_id' => 1]], $all); $this->assertEquals(1, count($all)); $product->lists = [$list1, $list1, $list1]; $product->save(); $cmd = ConnectionManager::getDb()->createCommand("SELECT * FROM {$tableName}"); $all = $cmd->queryAll(); $this->assertEquals([['product_id' => 1, 'product_list_id' => 1], ['product_id' => 1, 'product_list_id' => 1], ['product_id' => 1, 'product_list_id' => 1]], $all); $this->assertEquals(3, count($all)); }