public function testInit() { $this->assertEquals(5, Product::objects()->count()); $this->assertEquals(1, Category::objects()->count()); $this->assertEquals(1, User::objects()->count()); $this->assertEquals(1, Customer::objects()->count()); $this->assertEquals(1, Order::objects()->count()); $this->assertEquals(5, Order::objects()->get(['pk' => 1])->products->count()); $this->assertEquals(1, ProductList::objects()->count()); }
public function testLookupsClean() { $filter = ['user__groups__name__endswith' => 's']; $count = 3; $qs = Customer::objects()->filter($filter); // $sql = "SELECT COUNT(DISTINCT `tests_customer_1`.`id`) FROM `tests_customer` `tests_customer_1` LEFT OUTER JOIN `tests_user` `tests_user_2` ON `tests_customer_1`.`user_id` = `tests_user_2`.`id` LEFT OUTER JOIN `tests_membership` `tests_membership_3` ON `tests_user_2`.`id` = `tests_membership_3`.`user_id` LEFT OUTER JOIN `tests_group` `tests_group_4` ON `tests_membership_3`.`group_id` = `tests_group_4`.`id` WHERE (`tests_group_4`.`name` LIKE '%s')"; // $this->assertEquals($sql, $qs->countSql()); $this->assertEquals($count, $qs->count()); $this->assertEquals($count, count($qs->all())); }
public function testForeignLookup() { $addresses = Customer::objects()->order(['-user__username', '-address'])->all(); $this->assertEquals(count($addresses), 3); $this->assertEquals($addresses[0]->address, 'Max home'); $this->assertEquals($addresses[1]->address, 'Anton work'); $this->assertEquals($addresses[2]->address, 'Anton home'); $addresses = Customer::objects()->order(['user__username', 'address'])->all(); $this->assertEquals(count($addresses), 3); $this->assertEquals($addresses[0]->address, 'Anton home'); $this->assertEquals($addresses[1]->address, 'Anton work'); $this->assertEquals($addresses[2]->address, 'Max home'); }
public function testIssue63() { $this->assertEquals(2, User::objects()->count()); foreach (User::objects()->all() as $i => $user) { $customer = Customer::objects()->get(['pk' => $i + 1]); $customer->user = $user; $customer->save(['user']); } $this->assertEquals(2, Customer::objects()->count()); list($first, $last) = Customer::objects()->order(['pk'])->asArray()->all(); $this->assertEquals(['id' => 1, 'user_id' => 1, 'address' => 'foo'], $first); $this->assertEquals(['id' => 2, 'user_id' => 2, 'address' => 'bar'], $last); $this->assertEquals(1, Customer::objects()->filter(['user__username' => 'foo'])->count()); $this->assertEquals(1, Customer::objects()->filter(['user__username' => 'bar'])->count()); }
public function testValuesList() { $group = new Group(); $group->name = 'Administrators'; $group->save(); $groupProg = new Group(); $groupProg->name = 'Programmers'; $groupProg->save(); $anton = new User(); $anton->username = '******'; $anton->password = '******'; $anton->save(); $groupProg->users->link($anton); $anton_home = new Customer(); $anton_home->address = "Anton home"; $anton_home->user = $anton; $anton_home->save(); $anton_work = new Customer(); $anton_work->address = "Anton work"; $anton_work->user = $anton; $anton_work->save(); $max = new User(); $max->username = '******'; $max->password = '******'; $max->save(); $group->users->link($max); $max_home = new Customer(); $max_home->address = "Max home"; $max_home->user = $max; $max_home->save(); $values = Customer::objects()->valuesList(['address', 'user__username']); $this->assertEquals([['address' => 'Anton home', 'user__username' => 'Anton'], ['address' => "Anton work", 'user__username' => 'Anton'], ['address' => "Max home", 'user__username' => 'Max']], $values); $this->assertEquals([['address' => 'Anton home', 'user__username' => 'Anton'], ['address' => "Anton work", 'user__username' => 'Anton'], ['address' => "Max home", 'user__username' => 'Max']], Customer::objects()->valuesList(['address', 'user__username'])); $this->assertEquals(['Anton', 'Anton', 'Max'], Customer::objects()->valuesList(['user__username'], true)); }
public function testCreate() { $user = User::objects()->get(['pk' => 1]); Customer::objects()->create(['user' => $user, 'address' => 'Broadway']); Customer::objects()->create(['user_id' => $user->id, 'address' => 'Broadway']); $address1 = Customer::objects()->get(['pk' => 3]); $address2 = Customer::objects()->get(['pk' => 4]); $this->assertEquals($user->id, $address1->user->id); $this->assertEquals($user->id, $address2->user_id); }