X-Git-Url: https://git.cweiske.de/grauphel.git/blobdiff_plain/21e7415fe5a418ef6dd7f29d3749b11cc9adaa7d..6c8ad60e9888fa5625dad2460ca073f93ac1ae0d:/lib/notestorage.php diff --git a/lib/notestorage.php b/lib/notestorage.php index 7449417..fb68030 100644 --- a/lib/notestorage.php +++ b/lib/notestorage.php @@ -189,6 +189,22 @@ class NoteStorage \OC_DB::executeAudited($sql, $params); } + /** + * Delete synchronization data for the given user. + * + * @param SyncData $syncdata Synchronization data object + * + * @return void + */ + public function deleteSyncData() + { + \OC_DB::executeAudited( + 'DELETE FROM `*PREFIX*grauphel_syncdata`' + . ' WHERE `syncdata_user` = ?', + array($this->username) + ); + } + /** * Load a note from the storage. * @@ -225,7 +241,7 @@ class NoteStorage 'tags' => array(), ); } - + return $this->noteFromRow($row); } @@ -280,6 +296,20 @@ class NoteStorage ); } + /** + * Delete all notes from storage. + * + * @return void + */ + public function deleteAll() + { + \OC_DB::executeAudited( + 'DELETE FROM `*PREFIX*grauphel_notes`' + . ' WHERE `note_user` = ?', + array($this->username) + ); + } + /** * Load notes for the given user in short form. * Optionally only those changed after $since revision @@ -398,15 +428,15 @@ class NoteStorage { return array( 'note_guid' => $note->guid, - 'note_title' => $note->title, + 'note_title' => (string) $note->title, - 'note_content' => $note->{'note-content'}, - 'note_content_version' => $note->{'note-content-version'}, + 'note_content' => (string) $note->{'note-content'}, + 'note_content_version' => (string) $note->{'note-content-version'}, 'note_create_date' => $note->{'create-date'}, 'note_last_change_date' => $note->{'last-change-date'}, 'note_last_metadata_change_date' => $note->{'last-metadata-change-date'}, - + 'note_open_on_startup' => (int) $note->{'open-on-startup'}, 'note_pinned' => (int) $note->pinned, 'note_tags' => json_encode($note->tags),