function Test_of_countBySql() { $AkTestUser = new AkTestUser(); $this->assertEqual($AkTestUser->countBySql("SELECT COUNT(*) FROM ak_test_users"), count($AkTestUser->find())); $this->assertEqual($AkTestUser->countBySql("SELECT COUNT(*) FROM ak_test_users WHERE first_name = 'Tim'"), count($AkTestUser->findAll("first_name = 'Tim'"))); }
public function Test_of_findBySql() { $Users = new AkTestUser(); $FoundUsers = $Users->findBySql("SELECT * FROM ak_test_users WHERE first_name = 'Hilario'"); $this->assertTrue($FoundUsers[0]->last_name == 'Hervás Añó'); $FoundUsers = $Users->findBySql(array("SELECT * FROM ak_test_users WHERE first_name = ?", array('Hilario'))); $this->assertTrue($FoundUsers[0]->last_name == 'Hervás Añó'); $FoundUsers = $Users->findBySql(array("SELECT * FROM ak_test_users WHERE first_name = ?", 'Hilario')); $this->assertTrue($FoundUsers[0]->last_name == 'Hervás Añó'); $FoundUsers = $Users->findBySql(array("SELECT * FROM ak_test_users WHERE last_name = ?", array('last_name' => 'Ferrer Martínez'))); $this->assertTrue($FoundUsers[0]->first_name == 'Bermi'); $FoundUsers = $Users->findBySql(array("SELECT * FROM ak_test_users WHERE last_name = ? AND first_name = ?", array('Ferrer Martínez', 'Bermi'))); $this->assertTrue($FoundUsers[0]->first_name == 'Bermi'); $FoundUsers = $Users->findBySql("SELECT * FROM ak_test_users", 6); $this->assertEqual(count($FoundUsers), 6); $this->assertErrorPattern("/DEPRECATED WARNING.*findBySql.*/"); $FoundUsers = $Users->findBySql("SELECT * FROM ak_test_users", 6, 6); $this->assertEqual(count($FoundUsers), 3); $this->assertErrorPattern("/DEPRECATED WARNING.*findBySql.*/"); $FoundUsers = $Users->findBySql("SELECT * FROM ak_test_users WHERE iad=123"); $this->assertEqual(count($FoundUsers), 0); $this->assertError(); }
function Test_of_findBySql() { $Users = new AkTestUser(); $FoundUsers = $Users->findBySql("SELECT * FROM ak_test_users WHERE first_name = 'Hilario'"); $this->assertTrue($FoundUsers[0]->last_name == 'Hervás Añó'); $FoundUsers = $Users->findBySql(array("SELECT * FROM ak_test_users WHERE first_name = ?",array('Hilario'))); $this->assertTrue($FoundUsers[0]->last_name == 'Hervás Añó'); $FoundUsers = $Users->findBySql(array("SELECT * FROM ak_test_users WHERE first_name = ?",'Hilario')); $this->assertTrue($FoundUsers[0]->last_name == 'Hervás Añó'); $FoundUsers = $Users->findBySql(array("SELECT * FROM ak_test_users WHERE last_name = ?",array('last_name'=>'Ferrer Martínez'))); $this->assertTrue($FoundUsers[0]->first_name == 'Bermi'); $FoundUsers = $Users->findBySql(array("SELECT * FROM ak_test_users WHERE last_name = ? AND first_name = ?",array('Ferrer Martínez','Bermi'))); $this->assertTrue($FoundUsers[0]->first_name == 'Bermi'); $FoundUsers = $Users->findBySql("SELECT * FROM ak_test_users",6); $this->assertEqual(count($FoundUsers), 6); $FoundUsers = $Users->findBySql("SELECT * FROM ak_test_users",6,6); $this->assertEqual(count($FoundUsers), 3); }
function Test_of_get_and_set_DisplayField() { $AkTestField = new AkTestField(); $this->assertEqual($AkTestField->getDisplayField(), 'id'); $AkTestField->setDisplayField('text_field'); $this->assertEqual($AkTestField->getDisplayField(), 'text_field'); $AkTestUser = new AkTestUser(); $this->assertEqual($AkTestUser->getDisplayField(), 'id'); $AkTestUser->addCombinedAttributeConfiguration('name', "%s %s", 'first_name', 'last_name'); $this->assertEqual($AkTestUser->getDisplayField(), 'name'); $AkTestField->setDisplayField('invalid_field'); $this->assertEqual($AkTestUser->getDisplayField(), 'name'); }
public function __construct() { $this->setTableName("ak_test_members"); parent::__construct(@(array) func_get_args()); }