コード例 #1
0
ファイル: CountTest.php プロジェクト: satinjeet/typeoform
 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);
 }
コード例 #2
0
ファイル: UpdateTest.php プロジェクト: satinjeet/typeoform
 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);
 }
コード例 #3
0
ファイル: FindTest.php プロジェクト: satinjeet/typeoform
 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);
 }
コード例 #4
0
ファイル: InsertTest.php プロジェクト: satinjeet/typeoform
 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);
 }
コード例 #5
0
ファイル: DeleteTest.php プロジェクト: satinjeet/typeoform
 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);
 }
コード例 #6
0
ファイル: QueryTest.php プロジェクト: satinjeet/typeoform
 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);
 }
コード例 #7
0
ファイル: FindAllTest.php プロジェクト: satinjeet/typeoform
 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);
 }