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 testGetNewMembershipsByDate()
{
$new_groups = $this->DAO->getNewMembershipsByDate('twitter', '1234567890');
$this->assertEqual(count($new_groups), 1);
$this->assertEqual($new_groups[0]->id, 3);
$this->assertEqual($new_groups[0]->group_id, '19554710');
$this->assertEqual($new_groups[0]->group_name, '@userx/anotherlist');
$this->assertEqual($new_groups[0]->is_active, 1);
}
public function testFindStalestMemberships()
{
$stale_group = $this->DAO->findStalestMemberships($user_id = '1234567890', 'twitter');
$this->assertTrue(is_object($stale_group));
$this->assertEqual(get_class($stale_group), 'Group');
$this->assertEqual($stale_group->group_id, '19994710');
$this->DAO->update($user_id = '1234567890', $stale_group->group_id, 'twitter');
$stale_group = $this->DAO->findStalestMemberships($user_id = '1234567890', 'twitter');
$this->assertNull($stale_group);
}
public function testGetNewMembershipsSince()
{
$new_groups = $this->DAO->getNewMembershipsSince('twitter', '1234567890', date('Y-m-d', strtotime('-3 days')));
$this->assertEqual(count($new_groups), 2);
$this->assertEqual($new_groups[0]->id, 3);
$this->assertEqual($new_groups[0]->group_id, '19554710');
$this->assertEqual($new_groups[0]->group_name, '@userx/anotherlist');
$this->assertEqual($new_groups[0]->is_active, 1);
$this->assertEqual($new_groups[1]->id, 1);
$this->assertEqual($new_groups[1]->group_id, '18864710');
$this->assertEqual($new_groups[1]->group_name, '@someguy/a-list');
$this->assertEqual($new_groups[1]->is_active, 1);
$new_groups = $this->DAO->getNewMembershipsSince('twitter', '999', date('Y-m-d', strtotime('-3 days')));
$this->assertEqual(count($new_groups), 0);
$new_groups = $this->DAO->getNewMembershipsSince('facebook', '1234567890', date('Y-m-d', strtotime('-3 days')));
$this->assertEqual(count($new_groups), 0);
}
