public function testQueryWithParamsAndTypes() { $repository = new UserRepository($this->createDB(), 'typeoform\\User\\User', 'user'); $repository->create(array('username' => 'Testusername1', 'password' => 'testpassword1'))->save(); $repository->create(array('username' => 'Testusername2', 'password' => 'testpassword2'))->save(); $count = $repository->count('WHERE username = ?', array('Testusername1'), array(\PDO::PARAM_STR)); $this->assertEquals($count, 1); }
public function testUpdate() { $repository = new UserRepository($this->createDB(), 'typeoform\\User\\User', 'user'); $user = $repository->create(array('username' => 'Testusername', 'password' => 'testpassword')); $user->save(); $user->isAdmin = 1; $success = $user->save(); $user2 = $repository->find(1); $this->assertTrue($success); $this->assertEquals($user2->isAdmin, 1); }
public function testFindByWhere() { $repository = new UserRepository($this->createDB(), 'typeoform\\User\\User', 'user'); $user1 = $repository->create(array('username' => 'Testusername', 'password' => 'testpassword')); $success = $user1->save(); $user2 = $repository->find(array('username' => 'Testusername', 'password' => 'testpassword')); $this->assertInstanceOf('typeoform\\User\\User', $user2); $this->assertEquals($user1->userID, $user2->userID); $this->assertEquals($user1->username, $user2->username); $this->assertEquals($user1->password, $user2->password); }
public function testAlternativeInsert() { $repository = new UserRepository($this->createDB(), 'typeoform\\User\\User', 'user'); $user = $repository->create(array('username' => 'Testusername', 'password' => 'testpassword')); $success = $user->save(); $this->assertTrue($success); $this->assertInstanceOf('typeoform\\User\\User', $user); $this->assertEquals($user->username, 'Testusername'); $this->assertEquals($user->password, 'testpassword'); $this->assertEquals($user->userID, 1); $this->assertEquals($user->getPrimaryKey(), $user->userID); }
public function testDelete() { $repository = new UserRepository($this->createDB(), 'typeoform\\User\\User', 'user'); $user = $repository->create(array('username' => 'Testusername', 'password' => 'testpassword')); $user->save(); $count_before = $repository->count(); $success = $user->delete(); $count_after = $repository->count(); $this->assertTrue($success); $this->assertEquals($count_before, 1); $this->assertEquals($count_after, 0); $this->assertEquals($user->userID, 0); }
public function testQueryWithParamsAndTypes() { $repository = new UserRepository($this->createDB(), 'typeoform\\User\\User', 'user'); $user1 = $repository->create(array('username' => 'Testusername1', 'password' => 'testpassword1')); $user1->save(); $user2 = $repository->create(array('username' => 'Testusername2', 'password' => 'testpassword2')); $user2->save(); $users = $repository->query('WHERE username = ?', array('Testusername1'), array(\PDO::PARAM_STR)); $this->assertEquals(count($users), 1); $this->assertInstanceOf('typeoform\\User\\User', $users[0]); $this->assertEquals($user1->userID, $users[0]->userID); $this->assertEquals($user1->username, $users[0]->username); $this->assertEquals($user1->password, $users[0]->password); }
public function testFindAllWhereInOrder() { $repository = new UserRepository($this->createDB(), 'typeoform\\User\\User', 'user'); $user1 = $repository->create(array('username' => 'Testusername1', 'password' => 'testpassword1', 'isAdmin' => 1)); $user1->save(); $user2 = $repository->create(array('username' => 'Testusername2', 'password' => 'testpassword2', 'isAdmin' => 1)); $user2->save(); $users = $repository->findAll(array('isAdmin' => 1), 'ORDER BY userID DESC'); $this->assertEquals(count($users), 2); $this->assertInstanceOf('typeoform\\User\\User', $users[0]); $this->assertEquals($user1->userID, $users[1]->userID); $this->assertEquals($user1->username, $users[1]->username); $this->assertEquals($user1->password, $users[1]->password); $this->assertEquals($user1->isAdmin, $users[1]->isAdmin); $this->assertEquals($user2->userID, $users[0]->userID); $this->assertEquals($user2->username, $users[0]->username); $this->assertEquals($user2->password, $users[0]->password); $this->assertEquals($user2->isAdmin, $users[0]->isAdmin); }