*/
class NoteStorage
{
+ /**
+ * @var \OCP\IDBConnection
+ */
+ protected $db;
+
protected $urlGen;
protected $username;
public function __construct($urlGen)
{
- $this->urlGen = $urlGen;
+ $this->urlGen = $urlGen;
+ $this->db = \OC::$server->getDatabaseConnection();
}
public function setUsername($username)
public function getTags()
{
- $result = \OC_DB::executeAudited(
+ $result = $this->db->executeQuery(
'SELECT `note_tags` FROM `*PREFIX*grauphel_notes`'
. ' WHERE note_user = ?',
array($this->username)
);
$tags = array();
- while ($row = $result->fetchRow()) {
+ while ($row = $result->fetch()) {
$tags = array_merge($tags, json_decode($row['note_tags']));
}
return array_unique($tags);
*/
public function loadSyncData()
{
- $row = \OC_DB::executeAudited(
+ $row = $this->db->executeQuery(
'SELECT * FROM `*PREFIX*grauphel_syncdata`'
. ' WHERE `syncdata_user` = ?',
array($this->username)
- )->fetchRow();
+ )->fetch();
if ($row === false) {
$syncdata = $this->getNewSyncData();
*/
public function saveSyncData(SyncData $syncdata)
{
- $row = \OC_DB::executeAudited(
+ $row = $this->db->executeQuery(
'SELECT * FROM `*PREFIX*grauphel_syncdata`'
. ' WHERE `syncdata_user` = ?',
array($this->username)
- )->fetchRow();
+ )->fetch();
if ($row === false) {
//INSERT
$params = array_values($data);
$params[] = $this->username;
}
- \OC_DB::executeAudited($sql, $params);
+ $this->db->executeQuery($sql, $params);
}
/**
*/
public function deleteSyncData()
{
- \OC_DB::executeAudited(
+ $this->db->executeQuery(
'DELETE FROM `*PREFIX*grauphel_syncdata`'
. ' WHERE `syncdata_user` = ?',
array($this->username)
*/
public function load($guid, $createNew = true)
{
- $row = \OC_DB::executeAudited(
+ $row = $this->db->executeQuery(
'SELECT * FROM `*PREFIX*grauphel_notes`'
. ' WHERE `note_user` = ? AND `note_guid` = ?',
array($this->username, $guid)
- )->fetchRow();
+ )->fetch();
if ($row === false) {
if (!$createNew) {
*/
public function loadGuidByTitle($title)
{
- $row = \OC_DB::executeAudited(
+ $row = $this->db->executeQuery(
'SELECT note_guid FROM `*PREFIX*grauphel_notes`'
. ' WHERE `note_user` = ? AND `note_title` = ?',
array($this->username, htmlspecialchars($title))
- )->fetchRow();
+ )->fetch();
if ($row === false) {
return null;
}
}
- $result = \OC_DB::executeAudited(
+ $result = $this->db->executeQuery(
'SELECT `note_guid`, `note_title`'
. ' FROM `*PREFIX*grauphel_notes`'
. ' WHERE note_user = ?'
);
$notes = array();
- while ($row = $result->fetchRow()) {
+ while ($row = $result->fetch()) {
$notes[] = $row;
}
return $notes;
*/
public function save($note)
{
- $row = \OC_DB::executeAudited(
+ $row = $this->db->executeQuery(
'SELECT * FROM `*PREFIX*grauphel_notes`'
. ' WHERE `note_user` = ? AND `note_guid` = ?',
array($this->username, $note->guid)
- )->fetchRow();
+ )->fetch();
$data = $this->rowFromNote($note);
if ($row === false) {
$params[] = $this->username;
$params[] = $note->guid;
}
- \OC_DB::executeAudited($sql, $params);
+ $this->db->executeQuery($sql, $params);
}
/**
*/
public function delete($guid)
{
- \OC_DB::executeAudited(
+ $this->db->executeQuery(
'DELETE FROM `*PREFIX*grauphel_notes`'
. ' WHERE `note_user` = ? AND `note_guid` = ?',
array($this->username, $guid)
*/
public function deleteAll()
{
- \OC_DB::executeAudited(
+ $this->db->executeQuery(
'DELETE FROM `*PREFIX*grauphel_notes`'
. ' WHERE `note_user` = ?',
array($this->username)
$sql .= ' AND note_tags LIKE ?';
}
- $result = \OC_DB::executeAudited($sql, $sqlData);
+ $result = $this->db->executeQuery($sql, $sqlData);
$notes = array();
- while ($row = $result->fetchRow()) {
+ while ($row = $result->fetch()) {
$note = array(
'guid' => $row['note_guid'],
'ref' => array(
*/
public function loadNotesFull($since = null)
{
- $result = \OC_DB::executeAudited(
+ $result = $this->db->executeQuery(
'SELECT * FROM `*PREFIX*grauphel_notes`'
. ' WHERE note_user = ?',
array($this->username)
);
$notes = array();
- while ($row = $result->fetchRow()) {
+ while ($row = $result->fetch()) {
if ($since !== null && $row['note_last_sync_revision'] <= $since) {
continue;
}
namespace OCA\Grauphel\Lib;
/**
- * Token store
+ * OAuth token store
*
* @category Tools
* @package Grauphel
*/
class TokenStorage
{
+ /**
+ * @var \OCP\IDBConnection
+ */
+ protected $db;
+
+ public function __construct($urlGen)
+ {
+ $this->db = \OC::$server->getDatabaseConnection();
+ }
+
/**
* Delete token
*
*/
public function delete($type, $tokenKey)
{
- \OC_DB::executeAudited(
+ $this->db->executeQuery(
'DELETE FROM `*PREFIX*grauphel_oauth_tokens`'
. ' WHERE `token_key` = ? AND `token_type` = ?',
array($tokenKey, $type)
*/
public function store(Token $token)
{
- \OC_DB::executeAudited(
+ $this->db->executeQuery(
'INSERT INTO `*PREFIX*grauphel_oauth_tokens`'
. '(`token_user`, `token_type`, `token_key`, `token_secret`, `token_verifier`, `token_callback`, `token_client`, `token_lastuse`)'
. ' VALUES(?, ?, ?, ?, ?, ?, ?, ?)',
*/
public function load($type, $tokenKey)
{
- $tokenRow = \OC_DB::executeAudited(
+ $tokenRow = $this->db->executeQuery(
'SELECT * FROM `*PREFIX*grauphel_oauth_tokens`'
. ' WHERE `token_key` = ? AND `token_type` = ?',
array($tokenKey, $type)
- )->fetchRow();
+ )->fetch();
if ($tokenRow === false) {
throw new OAuthException(
*/
public function loadForUser($username, $type)
{
- $result = \OC_DB::executeAudited(
+ $result = $this->db->executeQuery(
'SELECT * FROM `*PREFIX*grauphel_oauth_tokens`'
. ' WHERE `token_user` = ? AND `token_type` = ?',
array($username, $type)
);
$tokens = array();
- while ($tokenRow = $result->fetchRow()) {
+ while ($tokenRow = $result->fetch()) {
$tokens[] = $this->fromDb($tokenRow);
}
*/
public function updateLastUse($tokenKey)
{
- \OC_DB::executeAudited(
+ $this->db->executeQuery(
'UPDATE `*PREFIX*grauphel_oauth_tokens`'
. ' SET `token_lastuse` = ? WHERE `token_key` = ?',
array(