Example #1
0
 public function Test_of_sanitizeConditions()
 {
     $AkTestUser = new AkTestUser();
     $sql = 'SELECT * FROM ak_test_users';
     $copy = $sql;
     $conditions = "last_name = 'Ferrer' AND country = 25";
     $sql = $AkTestUser->sanitizeConditions($sql, $conditions);
     $this->assertEqual($sql, $copy . ' WHERE ' . $conditions);
     $AkTestMember = new AkTestMember();
     $sql = 'SELECT * FROM ak_test_members, ak_test_users';
     $copy = $sql;
     $conditions = "ak_test_users.last_name = 'Ferrer' AND ak_test_users.country = 25";
     $AkTestMember->setInheritanceColumn('role');
     $this->assertEqual($AkTestMember->getInheritanceColumn(), 'role');
     $sql = $AkTestMember->sanitizeConditions($sql, $conditions);
     $this->assertEqual($sql, $copy . " WHERE ( ak_test_members.role = 'Ak test member' )  AND (" . $conditions . ")");
 }