/**
* Initialise database connection.
*/
private static function _init()
{
self::$_dbc = new mysqli_Extended(DBI::HOST, DBI::USER, DBI::PASSWORD, DBI::DB);
if (self::$_dbc->connect_error) {
die('Connect Error (' . self::$_dbc->connect_errno . ') ' . self::$_dbc->connect_error);
}
#print __CLASS__ . ': '. self::$_dbc->client_info . "\n";
}
public function testInsert()
{
for ($i = 0; $i < self::NUM_ROWS; $i++) {
$data = array('title' => "'" . 'title-' . $i . "'", 'lastmodified' => time());
array_push($this->insert_data, $data);
$this->assertTrue((bool) TlonData::insert($this->table, array_values($data)));
}
}
/**
* check(): Check if nonce exists (having deleted stale ones); if it is, delete it and return true.
* @param string $nonce Nonce to check.
* @return bool
*/
public static function check($nonce)
{
self::clean();
if (TlonData::select(self::$TABLE, 'nonce', $nonce)) {
TlonData::delete(self::$TABLE, TlonDataComparison::equals('nonce', $nonce));
return true;
} else {
return false;
}
}
public static function getByGroupnameDocumentID($groupname, $did)
{
$gds = TlonData::selectConds(self::$TABLE, array(TlonDataComparison::equals('document_id', $did), TlonDataComparison::equals('groupname', $groupname)));
return $gds ? $gds[0] : false;
}
public static function modify($groupname, $info)
{
return TlonData::update(self::$TABLE, TlonDataComparison::set('info', $info), TlonDataComparison::equals('groupname', $groupname));
}
public static function updateAll($username, $time)
{
return TlonData::update(self::$TABLE, TlonDataComparison::set('last_updated', $time), TlonDataComparison::equals('username', $username));
}
public static function updateLastModified($id)
{
return TlonData::update(self::$TABLE, TlonDataComparison::set('lastmodified', time()), TlonDataComparison::equals('id', $id));
}
public static function setApplied($message_id)
{
return TlonData::update(self::$TABLE, TlonDataComparison::set('applied', 1), TlonDataComparison::equals('message_id', $message_id));
}
public static function getByGroupname($groupname)
{
return TlonData::select(self::$TABLE, 'groupname', $groupname);
}
/**
* @param string $username User name.
* @return string New authentication token.
*/
public static function updateAuthTokenByUsername($username)
{
if ($user = self::getByUsername($username)) {
$auth = self::makeAuthToken();
return TlonData::update(self::$TABLE, TlonDataComparison::set('auth_token', $auth), TlonDataComparison::equals('username', $username)) ? $auth : false;
} else {
return false;
}
}
