From 2b5ff5d48b4ec80e0e0e18188689edefaeefe91d Mon Sep 17 00:00:00 2001
From: Christian Weiske <cweiske@cweiske.de>
Date: Fri, 24 Oct 2014 08:54:35 +0200
Subject: Implement note search

---
 lib/notestorage.php | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)

(limited to 'lib/notestorage.php')

diff --git a/lib/notestorage.php b/lib/notestorage.php
index 0aeef9e..951bf06 100644
--- a/lib/notestorage.php
+++ b/lib/notestorage.php
@@ -271,6 +271,29 @@ class NoteStorage
         return $row['note_guid'];
     }
 
+    /**
+     * Search for a note
+     *
+     * @param string $query Query string
+     *
+     * @return array Database rows with note_guid and note_title
+     */
+    public function search($query)
+    {
+        $result = \OC_DB::executeAudited(
+            'SELECT `note_guid`, `note_title`'
+            . ' FROM `*PREFIX*grauphel_notes`'
+            . ' WHERE note_user = ? AND note_title LIKE ?',
+            array($this->username, '%' . $query . '%')
+        );
+
+        $notes = array();
+        while ($row = $result->fetchRow()) {
+            $notes[] = $row;
+        }
+        return $notes;
+    }
+
     /**
      * Save a note into storage.
      *
-- 
cgit v1.2.3