public function testUpdateCount() { $group_member_dao = new GroupMemberMySQLDAO(); $group_member_dao->insert('1234', '55555555', 'twitter'); $group_member_dao->insert('1234', '66666666', 'twitter'); $group_membership_count_dao = new GroupMembershipCountMySQLDAO(); $result = $group_membership_count_dao->updateCount('1234', 'twitter'); $this->assertEqual($result, 1, 'One count inserted'); $sql = 'SELECT count FROM ' . $this->table_prefix . 'group_member_count WHERE '; $sql .= 'member_user_id = :member_user_id AND network = :network '; $sql .= 'ORDER BY `date` DESC LIMIT 1'; $stmt = GroupMembershipCountMySQLDAO::$PDO->prepare($sql); $stmt->execute(array(':member_user_id' => '1234', ':network' => 'twitter')); $data = $stmt->fetch(PDO::FETCH_ASSOC); $this->assertEqual($data['count'], 2, 'Current group membership count is 2'); }
public function testInsert() { $this->assertEqual($this->DAO->insert($user_id = '1623457890', $group_id = '18864710', 'twitter'), 1); $this->assertTrue($this->DAO->isGroupMemberInStorage($user_id = '1623457890', $group_id = '18864710', 'twitter')); }