/** * 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; } }