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 testClosure()
{
$model = new Product();
$model->setAttributes(['name' => '12']);
$this->assertFalse($model->isValid());
$this->assertTrue($model->hasErrors());
$this->assertTrue($model->hasErrors('name'));
$this->assertEquals(['name' => ['Minimal length < 3']], $model->getErrors());
$this->assertEquals(['Minimal length < 3'], $model->getErrors('name'));
$model->clearErrors('name');
$this->assertEquals([], $model->getErrors());
}
public function testDelete()
{
$this->assertEquals(0, Search::query('observer')->count());
$p = Product::first();
$p->name = 'observer';
$p->save();
$this->assertEquals(1, Search::query('observer')->count());
$p->delete();
$this->assertEquals(0, Search::query('observer')->count());
}
public function testIssue64()
{
$this->assertEquals(1, Category::objects()->count());
$this->assertEquals(2, Product::objects()->count());
$this->assertEquals(2, ProductList::objects()->count());
$category = Category::objects()->get();
$this->assertEquals(2, $category->products->count());
$this->assertEquals(1, $category->products->filter(['name' => 'bar'])->count());
$this->assertEquals(2, $category->products->filter(['lists__name' => 'test'])->count());
$this->assertEquals(1, $category->products->filter(['lists__name' => 'asd'])->count());
$this->assertEquals("SELECT `tests_product_1`.* FROM `tests_product` `tests_product_1` LEFT OUTER JOIN `tests_product_tests_product_list` `tests_product_tests_product_list_2` ON `tests_product_1`.`id` = `tests_product_tests_product_list_2`.`product_id` LEFT OUTER JOIN `tests_product_list` `tests_product_list_3` ON `tests_product_tests_product_list_2`.`product_list_id` = `tests_product_list_3`.`id` WHERE ((`tests_product_1`.`category_id`='1')) AND ((`tests_product_list_3`.`name`='asd')) GROUP BY `tests_product_1`.`id`", $category->products->filter(['lists__name' => 'asd'])->allSql());
}
public function testSync()
{
$product = new Product();
$this->assertEquals(6, count($product->getFieldsInit()));
$models = [new ProductList(), new Category(), new User(), $product];
$sync = new Sync($models);
$sync->delete();
foreach ($models as $model) {
$this->assertFalse($sync->hasTable($model));
}
// Create all tables. If table exists - skip.
$sync->create();
foreach ($models as $model) {
$this->assertTrue($sync->hasTable($model));
}
// Remove all tables. If table does not exists - skip.
$sync->delete();
foreach ($models as $model) {
$this->assertFalse($sync->hasTable($model));
}
}
public function setUp()
{
parent::setUp();
Product::unguard();
$this->existed[] = Product::create(['name' => 'p1']);
$this->existed[] = Product::create(['name' => 'p2']);
$this->existed[] = Product::create(['name' => 'p3']);
$this->notFilled = new Product();
$this->notFilled->id = $this->existed[2]->id;
$this->notExisted = new Product();
$this->notExisted->id = 999;
}
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 static function getFields()
{
return ['customer' => ['class' => ForeignField::className(), 'modelClass' => Customer::className()], 'products' => ['class' => ManyToManyField::className(), 'modelClass' => Product::className()], 'discount' => ['class' => IntField::className(), 'null' => true]];
}
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 static function getFields()
{
return ['name' => ['class' => CharField::className()], 'products' => ['class' => HasManyField::className(), 'modelClass' => Product::className(), 'null' => true, 'relatedName' => 'category', 'editable' => false]];
}
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));
}
public function testQ()
{
$qs = Product::objects()->filter([new OrQ([['name' => 'vasya', 'id__lte' => 7], ['name' => 'petya', 'id__gte' => 4]])]);
$this->assertEquals("SELECT `tests_product_1`.* FROM `tests_product` `tests_product_1` WHERE (((`tests_product_1`.`name`='vasya') AND ((`tests_product_1`.`id` <= 7))) OR ((`tests_product_1`.`name`='petya') AND ((`tests_product_1`.`id` >= 4))))", $qs->allSql());
$qs = Product::objects()->filter([new OrQ([['name' => 'vasya', 'id__lte' => 7], ['name' => 'petya', 'id__gte' => 4]]), 'price__gte' => 200]);
$this->assertEquals("SELECT `tests_product_1`.* FROM `tests_product` `tests_product_1` WHERE (((`tests_product_1`.`name`='vasya') AND ((`tests_product_1`.`id` <= 7))) OR ((`tests_product_1`.`name`='petya') AND ((`tests_product_1`.`id` >= 4)))) AND ((`tests_product_1`.`price` >= 200))", $qs->allSql());
$qs = Product::objects()->filter([new AndQ([['name' => 'vasya', 'id__lte' => 7], ['name' => 'petya', 'id__gte' => 4]]), 'price__gte' => 200]);
$this->assertEquals("SELECT `tests_product_1`.* FROM `tests_product` `tests_product_1` WHERE (((`tests_product_1`.`name`='vasya') AND ((`tests_product_1`.`id` <= 7))) AND ((`tests_product_1`.`name`='petya') AND ((`tests_product_1`.`id` >= 4)))) AND ((`tests_product_1`.`price` >= 200))", $qs->allSql());
}
public static function getFields()
{
return ['name' => ['class' => CharField::className()], 'products' => ['class' => ManyToManyField::className(), 'modelClass' => Product::className()], 'date_action' => ['class' => DateTimeField::className(), 'required' => false, 'null' => true]];
}
public function testAllSql()
{
$qs = Product::objects()->filter(['id' => 1]);
$this->assertEquals("SELECT \"tests_product_1\".* FROM \"tests_product\" \"tests_product_1\" WHERE ((\"tests_product_1\".\"id\"=1))", $qs->getSql());
$this->assertEquals("SELECT \"tests_product_1\".* FROM \"tests_product\" \"tests_product_1\" WHERE ((\"tests_product_1\".\"id\"=1))", $qs->allSql());
$this->assertEquals("SELECT COUNT(*) FROM \"tests_product\" \"tests_product_1\" WHERE ((\"tests_product_1\".\"id\"=1))", $qs->countSql());
}
