/**
* @param ilTermsOfServiceAcceptanceEntity $entity
*/
public function trackAcceptance(ilTermsOfServiceAcceptanceEntity $entity)
{
$query = 'SELECT id FROM tos_versions WHERE hash = %s AND lng = %s';
$res = $this->db->queryF($query, array('text', 'text'), array($entity->getHash(), $entity->getIso2LanguageCode()));
if ($this->db->numRows($res)) {
$row = $this->db->fetchAssoc($res);
$tosv_id = $row['id'];
} else {
$tosv_id = $this->db->nextId('tos_versions');
$this->db->insert('tos_versions', array('id' => array('integer', $tosv_id), 'lng' => array('text', $entity->getIso2LanguageCode()), 'src' => array('text', $entity->getSource()), 'src_type' => array('integer', $entity->getSourceType()), 'text' => array('clob', $entity->getText()), 'hash' => array('text', $entity->getHash()), 'ts' => array('integer', $entity->getTimestamp())));
}
$this->db->insert('tos_acceptance_track', array('tosv_id' => array('integer', $tosv_id), 'usr_id' => array('integer', $entity->getUserId()), 'ts' => array('integer', $entity->getTimestamp())));
}
/**
*
*/
public function testAcceptanceIsTrackedAndRefersToAnExistingTermsOfServicesVersion()
{
$entity = new ilTermsOfServiceAcceptanceEntity();
$entity->setUserId(666);
$entity->setIso2LanguageCode('de');
$entity->setSource('/path/to/file');
$entity->setSourceType(0);
$entity->setText('PHP Unit');
$entity->setTimestamp(time());
$entity->setHash(md5($entity->getText()));
$expected_id = 4711;
$database = $this->getMockBuilder('ilDB')->disableOriginalConstructor()->getMock();
$result = $this->getMockBuilder('MDB2_BufferedResult_mysqli')->disableOriginalConstructor()->getMock();
$database->expects($this->once())->method('queryF')->with('SELECT id FROM tos_versions WHERE hash = %s AND lng = %s', array('text', 'text'), array($entity->getHash(), $entity->getIso2LanguageCode()))->will($this->returnValue($result));
$database->expects($this->once())->method('numRows')->with($result)->will($this->returnValue(1));
$database->expects($this->once())->method('fetchAssoc')->with($result)->will($this->returnValue(array('id' => $expected_id)));
$expectedTracking = array('tosv_id' => array('integer', $expected_id), 'usr_id' => array('integer', $entity->getUserId()), 'ts' => array('integer', $entity->getTimestamp()));
$database->expects($this->once())->method('insert')->with('tos_acceptance_track', $expectedTracking);
$gateway = new ilTermsOfServiceAcceptanceDatabaseGateway($database);
$gateway->trackAcceptance($entity);
}
/**
*
*/
public function testEntityShouldReturnTimestampWhenTimestampIsSet()
{
$expected = time();
$entity = new ilTermsOfServiceAcceptanceEntity();
$entity->setTimestamp($expected);
$this->assertEquals($expected, $entity->getTimestamp());
}