public function Test_of_updateAll_with_binds()
{
$Users = new AkTestUser();
$modified_entries = $Users->updateAll("first_name = 'new_test_name', country = '50'", array("first_name = ?", 'test_name'));
$this->assertEqual($modified_entries, 3);
$FoundUsers = $Users->find(5, 6, 7);
foreach ($FoundUsers as $FoundUser) {
$this->assertEqual($FoundUser->first_name, 'new_test_name');
$this->assertEqual($FoundUser->country, 50);
}
}
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'")));
}
function Test_of_updateAll()
{
$Users = new AkTestUser();
$modified_entries = $Users->updateAll("first_name = 'test_name', country = '50'", "first_name = 'NEW TEST NAME'");
$this->assertEqual($modified_entries, 3);
$FoundUsers = $Users->find(5, 6, 7);
foreach ($FoundUsers as $FoundUser) {
$this->assertEqual($FoundUser->first_name, 'test_name');
$this->assertEqual($FoundUser->country, 50);
}
}
