public function testIsNewLicense()
{
$groupId = 401;
$this->testDb->createPlainTables(array('license_ref'));
$this->testDb->insertData_license_ref();
$this->dbManager->queryOnce("CREATE TABLE license_candidate AS SELECT *,{$groupId} group_fk FROM license_ref LIMIT 1");
$licCandi = $this->dbManager->getSingleRow("SELECT * FROM license_candidate", array(), __METHOD__ . '.candi');
$this->dbManager->queryOnce("DELETE FROM license_ref WHERE rf_pk={$licCandi['rf_pk']}");
$licRef = $this->dbManager->getSingleRow("SELECT * FROM license_ref LIMIT 1", array(), __METHOD__ . '.ref');
$licDao = new LicenseDao($this->dbManager);
/* test the test but do not count assert */
assertThat($this->dbManager->getSingleRow("SELECT count(*) cnt FROM license_ref WHERE rf_shortname=\$1", array($licCandi['rf_shortname']), __METHOD__ . '.check'), is(equalTo(array('cnt' => 0))));
$this->assertCountBefore++;
/* test the DAO */
assertThat($licDao->isNewLicense($licRef['rf_shortname'], $groupId), equalTo(FALSE));
assertThat($licDao->isNewLicense($licRef['rf_shortname'], 0), equalTo(FALSE));
assertThat($licDao->isNewLicense($licCandi['rf_shortname'], $groupId), equalTo(FALSE));
assertThat($licDao->isNewLicense($licCandi['rf_shortname'], $groupId + 1), equalTo(TRUE));
assertThat($licDao->isNewLicense($licCandi['rf_shortname'], 0), equalTo(TRUE));
assertThat($licDao->isNewLicense('(a new shortname)', $groupId), equalTo(TRUE));
assertThat($licDao->isNewLicense('(a new shortname)', 0), equalTo(TRUE));
$this->addToAssertionCount(\Hamcrest\MatcherAssert::getCount() - $this->assertCountBefore);
}