public function testSimple() { $categoryToys = new Category(['name' => 'Toys']); $this->assertTrue($categoryToys->getIsNewRecord()); $categoryToys->save(); $this->assertFalse($categoryToys->getIsNewRecord()); $category_animals = new Category(); $category_animals->name = 'Animals'; $category_animals->save(); $db = ConnectionManager::getDb(); $tableSql = $db->schema->quoteColumnName('tests_product'); $tableAliasSql = $db->schema->quoteColumnName('tests_product_1'); $categoryIdSql = $db->schema->quoteColumnName('category_id'); $this->assertEquals("SELECT COUNT(*) FROM {$tableSql} {$tableAliasSql} WHERE ({$tableAliasSql}.{$categoryIdSql}='1')", $categoryToys->products->countSql()); $this->assertEquals(0, $categoryToys->products->count()); $product_bear = new Product(['category' => $categoryToys, 'name' => 'Bear', 'price' => 100, 'description' => 'Funny white bear']); $product_bear->save(); $this->assertEquals(1, $categoryToys->products->count()); $product_rabbit = new Product(['category' => $category_animals, 'name' => 'Rabbit', 'price' => 110, 'description' => 'Rabbit with carrot']); $product_rabbit->save(); $this->assertEquals(1, $categoryToys->products->count()); $product_rabbit->category = $categoryToys; $product_rabbit->save(); $this->assertEquals(2, $categoryToys->products->count()); }
public function testCreate() { $this->assertEquals(0, Search::query('observer')->count()); $p = new Product(); $p->name = 'observer'; $p->publish = 1; $p->save(); $this->assertEquals(1, Search::query('observer')->count()); }
public function setUp() { parent::setUp(); $category = new Category(['name' => 'cat']); $category->save(); $product1 = new Product(['name' => 'foo', 'category' => $category]); $product1->save(); $product2 = new Product(['name' => 'bar', 'category' => $category]); $product2->save(); $list = new ProductList(['name' => 'test']); $list->save(); $list->products->link($product1); $list->products->link($product2); $list = new ProductList(['name' => 'asd']); $list->save(); $list->products->link($product1); }
public function setUp() { parent::setUp(); $category = new Category(); $category->name = 'test'; $category->save(); $user = new User(); $user->password = 123456; $user->username = '******'; $user->save(); $customer = new Customer(); $customer->user = $user; $customer->address = 'example super address'; $customer->save(); $products = []; foreach ([1, 2, 3, 4, 5] as $i) { $product = new Product(); $product->name = $i; $product->price = $i; $product->description = $i; $product->category = $category; $product->save(); $products[] = $product; } $order1 = new Order(); $order1->customer = $customer; $order1->save(); foreach ($products as $p) { $order1->products->link($p); } $order2 = new Order(); $order2->customer = $customer; $order2->discount = 1; $order2->save(); $order2->products = $products; $order2->save(); }
public function setUp() { parent::setUp(); $category = new Category(); $category->name = 'test'; $category->save(); $product_list = new ProductList(); $product_list->name = 'First product list'; $product_list->date_action = '2014-04-29 10:35:45'; $product_list->save(); $user = new User(); $user->password = 123456; $user->username = '******'; $user->save(); $customer = new Customer(); $customer->user = $user; $customer->address = 'example super address'; $customer->save(); $products = []; foreach ([1, 2, 3, 4, 5] as $i) { $product = new Product(); $product->name = $i; $product->price = $i; $product->description = $i; $product->category = $category; $product->save(); $products[] = $product; } $order = new Order(); $order->customer = $customer; $order->save(); $order->products = $products; $order->save(); $model = new Category(); $this->prefix = $model->getDb()->tablePrefix; }
public function testSetter() { $model = new Product(); $model->name = 'example'; $this->assertEquals('example', $model->name); $this->assertEquals('SIMPLE', $model->type); $model->type = '123'; $this->assertEquals('123', $model->type); $category = new Category(); $category->name = 'Toys'; $category->save(); $product = new Product(); $product->name = 'Bear'; $product->price = 100; $product->description = 'Funny white bear'; $this->assertNull($product->category); $this->assertNull($product->category_id); $this->assertEquals(1, $category->pk); // Also working // $product->category = $category; $product->category_id = $category->pk; $this->assertEquals(['id', 'name'], $category->attributes()); $this->assertEquals(['id', 'name', 'price', 'description', 'category_id'], $product->attributes()); $this->assertEquals(1, $product->category_id); $this->assertEquals(1, $product->getAttribute('category_id')); $product->save(); $this->assertInstanceOf('\\Tests\\Models\\Category', $product->category); $this->assertTrue(is_numeric($product->category_id)); }
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)); }