public function testInWhere()
{
$this->object->inWhere("abc, def");
$result = $this->object->getDbComponent()->getWherePart();
$compare = " IN (abc, def)";
$this->assertEquals($compare, $result);
}
public function testGetStatement3()
{
$columns1 = array(0 => 'attendent.id', 1 => 'attendent.img', 2 => 'attendent.name', 3 => 'award.name', 4 => 'award.annotation', 5 => 'activity_mng.attend_date');
$joinTables1 = array(0 => 'activity_mng', 1 => 'award');
$this->object->select($columns1, 'attendent')->innerJoin($joinTables1)->joinOn("`award`.`id` = `activity_mng`.`award_id`")->andJoinOn("`attendent`.`id` = `activity_mng`.`attendent_id`")->where("`activity_id` = 5")->andWhere("`award_id` > 0");
$result = $this->object->getDbComponent()->getStatement();
$compare = "SELECT attendent.id, attendent.img, attendent.name, award.name, award.annotation, activity_mng.attend_date FROM `attendent` INNER JOIN `activity_mng` INNER JOIN `award` ON `award`.`id` = `activity_mng`.`award_id` AND `attendent`.`id` = `activity_mng`.`attendent_id` WHERE (`activity_id` = 5) AND (`award_id` > 0)";
$this->assertEquals($compare, $result);
}
public function testCount()
{
$pdoResult = $this->object->getDbComponent()->execute("SELECT COUNT(*) FROM activity");
$result = NULL;
$count = 0;
foreach ($pdoResult as $row) {
if ($count == 0) {
$result = $row;
}
}
$compare = 3;
$this->assertEquals($compare, $result["COUNT(*)"]);
}
