Code: Select all
<?php
set_include_path("library/");
require_once 'members.php';
require_once 'PHPUnit/Framework/TestCase.php';
require_once 'PHPUnit.php';
print("<b>TEST CASE FOR MEMBERS CLASS</b>");
class MembersTest extends PHPUnit_TestCase {
public function cleanup()
{
$qdel=mysql_query("SELECT * FROM members");
if(mysql_num_rows($qdel)>0)
{
$del=mysql_query("TRUNCATE members");
}
}
public function testing_insert()
{
$this->cleanup();
$newins=new Members;
$actual=$newins->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$expected='insert';
$this->assertEquals($expected, $actual, "COULD NOT INSERT");
$this->cleanup();
}
public function testing_insertNotable()
{
$this->cleanup();
$newinsnot=new Members;
$actual_INoTable=$newinsnot->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','');
$this->assertNull($actual_NoTable, "INSERTING WITHOUT TABLE NAME");
$this->cleanup();
}
public function testing_update()
{
$this->cleanup();
$newupdate=new Members;
$newupdate->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberidU=mysql_insert_id();
$actual_Update=$newupdate->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123456','true',$memberidU,'members');
$expupdte='update';
$this->assertEquals($expupdte, $actual_Update, "COULD NOT UPDATE");
$this->cleanup();
}
public function testing_updateNoTable()
{
$this->cleanup();
$newupdatenot=new Members;
$newupdatenot->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberidUnot=mysql_insert_id();
$actual_UpdateNotable=$newupdatenot->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123456','true',$memberidU,'');
$this->assertNull($actual_UpdateNotable, "UPDATING WITHOUT TABLE NAME");
$this->cleanup();
}
public function testing_insertData()
{
$this->cleanup();
$newinsertdata=new Members;
$dbActualinsertd=$newinsertdata->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberid_insertd=mysql_insert_id();
$resExpectedInsertd=array((string)$memberid_insertd,'1','a','c','d','e','f','123','h','123','j','123','false');
$query=mysql_query("SELECT * FROM members WHERE memberId=$memberid_insertd");
$resActualInsertd=mysql_fetch_row($query);
$this->assertEquals($resExpectedInsertd,$resActualInsertd, "COULD NOT INSERT DATA.");
$this->cleanup();
}
public function testing_updateData()
{
$this->cleanup();
$newupdatedata=new Members;
$newupdatedata->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberid_updated=mysql_insert_id();
$dbExpectedupdated=array((string)$memberid_updated,'2','b','d','e','f','g','456','i','456','k','456','true');
$newupdatedata->AddOrUpdateMember('2','b','d','e','f','g','456','i','456','k','456','true',$memberid_updated,'members');
$q1=mysql_query("SELECT * FROM members WHERE memberId=$memberid_updated");
$dbActualupdated=mysql_fetch_row($q1);
$this->assertEquals($dbExpectedupdated, $dbActualupdated, "COULD NOT UPDATE DATA");
$this->cleanup();
}
public function test_GetMemberDetails()
{
$this->cleanup();
$newGetMemberDetails=new Members;
$newGetMemberDetails->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$IdGetMemberDetails=mysql_insert_id();
$query_Get=mysql_query("SELECT * FROM members WHERE memberId=$IdGetMemberDetails");
$Expected_res=mysql_fetch_array($query_Get);
$Actual_res=$newGetMemberDetails->GetMemberDetails($IdGetMemberDetails,'members');
$this->assertEquals($Expected_res, $Actual_res, "COULD NOT UPDATE DATA");
$this->cleanup();
}
public function test_GetMemberDetailsNoT()
{
$this->cleanup();
$newGetMemberDetailsNoT=new Members;
$newGetMemberDetailsNoT->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$IdGetMemberDetailsNoT=mysql_insert_id();
$Actual_resNoT=$newGetMemberDetailsNoT->GetMemberDetails($IdGetMemberDetailsNoT,'');
$this->assertNull($Actual_resNoT, "UPDATING WITHOUT TABLE NAME");
$this->cleanup();
}
public function test_GetMemberDetailsNoId()
{
$this->cleanup();
$newGetMemberDetailsNoId=new Members;
$newGetMemberDetailsNoId->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$IdGetMemberDetailsNoId=mysql_insert_id();
$Actual_resNoId=$newGetMemberDetailsNoId->GetMemberDetails($IdGetMemberDetailsNoId,'');
$this->assertNull($Actual_resNoId, "UPDATING WITHOUT TABLE NAME");
$this->cleanup();
}
public function test_DeleteNoid()
{
$this->cleanup();
$newDelNoId=new Members;
$dbActualDelNoId=$newDelNoId->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','true','','members');
$memberid_DeleteNoId=mysql_insert_id();
$queryDelNoId=mysql_query("SELECT * FROM members WHERE memberId=$memberid_DeleteNoId");
$arrExp_delNoId=mysql_fetch_array($queryDelNoId);
$newDelNoId->DeleteMember('','members');
$queryDelNoId1=mysql_query("SELECT * FROM members WHERE memberId=$memberid_DeleteNoId");
$arrActual_delNoId=mysql_fetch_array($queryDelNoId1);
$this->assertEquals($arrExp_delNoId, $arrActual_delNoId, "DELETING WITHOUT MEMBERID");
$this->cleanup();
}
public function test_Delete()
{
$this->cleanup();
$newDel=new Members;
$dbActualDel=$newDel->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','true','','members');
$memberid_Delete=mysql_insert_id();
$queryDel=mysql_query("SELECT * FROM members");
while($del=mysql_fetch_array($queryDel))
{
$arrExp_del[]=mysql_fetch_array($queryDel);
}
$newDel->DeleteMember($memberid_Delete,'members');
$queryDelA=mysql_query("SELECT * FROM members");
while($delA=mysql_fetch_array($queryDelA))
{
$arrExp_delA[]=mysql_fetch_array($delA);
}
if(count($arrExp_del)>0 && count($arrExp_delA==0))
{
$DelExp=0;
}
$this->assertEquals($DelExp, count($arrExp_delA), "DELETING WITHOUT TABLE NAME");
$this->cleanup();
}
public function test_DeleteNotable()
{
$this->cleanup();
$newDelNoTable=new Members;
$dbActualDelNoTable=$newDelNoTable->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','true','','members');
$memberid_DeleteNoTable=mysql_insert_id();
$queryDelNoTable=mysql_query("SELECT * FROM members WHERE memberId=$memberid_DeleteNoTable");
$arrExp_delNoTable=mysql_fetch_array($queryDelNoTable);
$newDelNoTable->DeleteMember($memberid_DeleteNoTable,'');
$queryDelNoTable1=mysql_query("SELECT * FROM members WHERE memberId=$memberid_DeleteNoTable");
$arrActual_delNoTable=mysql_fetch_array($queryDelNoTable1);
$this->assertEquals($arrExp_delNoTable, $arrActual_delNoTable, "DELETING WITHOUT TABLE NAME");
$this->cleanup();
}
public function test_EnableMember()
{
$this->cleanup();
$newEnable=new Members;
$newEnable->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberidEnable=mysql_insert_id();
$queryEnable=mysql_query("SELECT * FROM members WHERE memberId=$memberidEnable");
$queryresEnable=mysql_fetch_array($queryEnable);
$newEnable->EnableMember($memberidEnable, 'members');
$expectedEnable='true';
$queryEnable1=mysql_query("SELECT * FROM members WHERE memberId=$memberidEnable");
$queryresEnable1=mysql_fetch_array($queryEnable1);
$actualEnable=$queryresEnable1['enableFlag'];
$this->assertEquals($expectedEnable,$actualEnable, "COULD NOT ENABLE");
$this->cleanup();
}
public function test_EnableMemberNoMemberid()
{
$this->cleanup();
$newEnableNoId=new Members;
$newEnableNoId->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberidEnableNoId=mysql_insert_id();
$queryEnableNoId=mysql_query("SELECT * FROM members WHERE memberId=$memberidEnableNoId");
$queryresEnableNoId=mysql_fetch_array($queryEnableNoId);
$expectedEnableNoId=$queryresEnableNoId['enableFlag'];
$newEnableNoId->EnableMember('', 'members');
$queryEnableNoId1=mysql_query("SELECT * FROM members WHERE memberId=$memberidEnableNoId");
$queryresEnableNoId1=mysql_fetch_array($queryEnableNoId1);
$actualEnableNoId=$queryresEnableNoId1['enableFlag'];
$this->assertEquals($expectedEnableNoId,$actualEnableNoId, "ENABLING WITHOUT MEMBERID");
$this->cleanup();
}
public function test_EnableMemberNoTable()
{
$this->cleanup();
$newEnableNoTable=new Members;
$newEnableNoTable->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberidEnableNoTable=mysql_insert_id();
$queryEnableNoTable=mysql_query("SELECT * FROM members WHERE memberId=$memberidEnableNoTable");
$queryresEnableNoTable=mysql_fetch_array($queryEnableNoTable);
$expectedEnableNoT=$queryresEnableNoTable['enableFlag'];
$newEnableNoTable->EnableMember('', 'members');
$queryEnableNoTable1=mysql_query("SELECT * FROM members WHERE memberId=$memberidEnableNoTable");
$queryresEnableNoTable1=mysql_fetch_array($queryEnableNoTable1);
$actualEnableNoT=$queryresEnableNoTable1['enableFlag'];
$this->assertEquals($expectedEnableNoT,$actualEnableNoT, "ENABLING WITHOUT TABLE NAME");
$this->cleanup();
}
public function test_DisableMember()
{
$this->cleanup();
$newDisable=new Members;
$newDisable->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','true','','members');
$memberidDisable=mysql_insert_id();
$queryDisable=mysql_query("SELECT * FROM members WHERE memberId=$memberidDisable");
$queryresDisable=mysql_fetch_array($queryDisable);
$newDisable->DisableMember($memberidDisable, 'members');
$expectedDisable='false';
$queryDisable1=mysql_query("SELECT * FROM members WHERE memberId=$memberidDisable");
$queryresDisable1=mysql_fetch_array($queryDisable1);
$actualDisable=$queryresDisable1['enableFlag'];
$this->assertEquals($expectedDisable,$actualDisable, "COULD NOT DISABLE");
$this->cleanup();
}
public function test_DisableMemberNoMemberid()
{
$this->cleanup();
$newDisableNoId=new Members;
$newDisableNoId->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberidDisableNoId=mysql_insert_id();
$queryDisableNoId=mysql_query("SELECT * FROM members WHERE memberId=$memberidDisableNoId");
$queryresDisableNoId=mysql_fetch_array($queryDisableNoId);
$expectedDisableNoId=$queryresDisableNoId['enable'];
$newDisableNoId->DisableMember('', 'members');
$queryDisableNoId1=mysql_query("SELECT * FROM members WHERE memberId=$memberidDisableNoId");
$queryresDisableNoId1=mysql_fetch_array($queryDisableNoId1);
$actualDisalbeNoId=$queryresDisableNoId1['enable'];
$this->assertEquals($expectedDisableNoId,$actualDisalbeNoId, "DISABLING WITHOUT MEMBERID");
$this->cleanup();
}
public function test_DisableMemberNoTable()
{
$this->cleanup();
$newDisableNoTable=new Members;
$newDisableNoTable->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
$memberidDisableNoTable=mysql_insert_id();
$queryDisableNoTable=mysql_query("SELECT * FROM members WHERE memberId=$memberidDisableNoTable");
$queryresDisableNoTable=mysql_fetch_array($queryDisableNoTable);
$expectedDisableNoT=$queryresDisableNoTable['enable'];
$newDisableNoTable->DisableMember('', 'members');
$queryDisableNoTable1=mysql_query("SELECT * FROM members WHERE memberId=$memberidDisableNoTable");
$queryresDisableNoTable1=mysql_fetch_array($queryDisableNoTable1);
$actualDisableNoT=$queryresDisableNoTable1['enable'];
$this->assertEquals($expectedDisableNoT,$actualDisableNoT, "DISABLING WITHOUT TABLE NAME");
$this->cleanup();
}
public function test_GetMemberList()
{
$this->cleanup();
$newGetMemberListTest=new Members;
for($i=0;$i<=2;$i++){
$newGetMemberListTest->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
}
$query_get=mysql_query("SELECT * FROM members");
while($res=mysql_fetch_array($query_get))
{
$arrExpected[]=$res;
}
$arrActual=$newGetMemberListTest->GetMemberList('members');
$this->assertEquals($arrExpected,$arrActual, "COULD NOT FETCH DATA");
$this->cleanup();
}
public function test_GetMemberListNoTable()
{
$this->cleanup();
$newGetMemberListTest=new Members;
for($i=0;$i<=2;$i++){
$newGetMemberListTest->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
}
$expGetMemListNoTable=array();
$arrActualNoTable=$newGetMemberListTest->GetMemberList('');
$this->assertEquals($expGetMemListNoTable,$arrActualNoTable, "RETRIVING DATA WITHOUT TABLE NAME");
$this->cleanup();
}
public function test_DeleteAll()
{
$this->cleanup();
$newDeleteAll=new Members;
for($i=0;$i<=6;$i++){
$newDeleteAll->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
}
$queryDeleteAll=mysql_query("SELECT * FROM members");
while($resDeleteAll=mysql_fetch_array($queryDeleteAll))
{
$resD[]=$resDeleteAll;
}
$befdel=count($resD);
$newDeleteAll->DeleteAll('members');
$queryDeleteAll1=mysql_query("SELECT * FROM members");
while($resDeleteAll1=mysql_fetch_array($queryDeleteAll1))
{
$resD1[]=$resDeleteAll1;
}
$aftdel=count($resD1);
if($befdel>0 && aftdel==0)
{
$expDeleteAll=0;
}
$this->assertEquals($expDeleteAll,$aftdel, "COULD NOT DELETE DATA");
$this->cleanup();
}
public function test_DeleteAllNoTable()
{
$this->cleanup();
$newDeleteAllNoT=new Members;
for($i=0;$i<=6;$i++){
$newDeleteAllNoT->AddOrUpdateMember('1','a','c','d','e','f','123','h','123','j','123','false','','members');
}
$queryDeleteAllNoT=mysql_query("SELECT * FROM members");
while($resDeleteAllNoT=mysql_fetch_array($queryDeleteAllNoT))
{
$resDNoT[]=$resDeleteAllNoT;
}
$newDeleteAllNoT->DeleteAll('');
$queryDeleteAllNoT1=mysql_query("SELECT * FROM members");
while($resDeleteAllNoT1=mysql_fetch_array($queryDeleteAllNoT1))
{
$resDNoT1[]=$resDeleteAllNoT1;
}
$this->assertEquals($resDNoT,$resDNoT1, "DELETING DATA WITHOUT TABLE NAME");
$this->cleanup();
}
}
$suite = new PHPUnit_TestSuite('MembersTest');
$result = PHPUnit::run($suite);
print $result->toHTML();
?>
So, what's wrong with the above code. if i had to isolate. anything how to do that?