sqlite_cursor.h revision 0529e5d033099cbfc42635f6f6183833b09dff6e
15821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Copyright (c) 2012 The Chromium Authors. All rights reserved.
25821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Use of this source code is governed by a BSD-style license that can be
35821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// found in the LICENSE file.
45821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
55821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#ifndef CHROME_BROWSER_HISTORY_ANDROID_SQLITE_CURSOR_H_
65821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#define CHROME_BROWSER_HISTORY_ANDROID_SQLITE_CURSOR_H_
75821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
85821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include <jni.h>
95821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include <vector>
105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/android/scoped_java_ref.h"
125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/basictypes.h"
135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/gtest_prod_util.h"
145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/memory/scoped_ptr.h"
15868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles)#include "base/strings/string16.h"
165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "base/synchronization/waitable_event.h"
175d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)#include "base/task/cancelable_task_tracker.h"
185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/common/cancelable_request.h"
195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/favicon/favicon_service.h"
205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/history/android/android_history_provider_service.h"
215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/history/history_types.h"
225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// This class is JNI implementation of
245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// org.chromium.chrome.database.SqliteCursor, it uses the AndroidStatement to
255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// iterate among the result rows. This is not thread safe, all methods should
265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// be called from the same non-UI thread which typical is the Java thread.
275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)//
285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// This class can not be in history namespace because the class name has to
295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// match to the generated sqlite_cursor_jni.h.
305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)class SQLiteCursor {
315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) public:
325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Mapping to the column type definitions in java.sql.Types.
335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  enum JavaColumnType {
345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    BLOB = 2004,
355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    LONG_VAR_CHAR = -1,
365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    NULL_TYPE = 0,
375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    NUMERIC = 2,
385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    DOUBLE = 8,
395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  };
405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // This class is intended to be used only in unit tests.
425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  //
435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // There are 2 threads in unit test, one is the UI thread, another is the DB
445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // thread, after the task posted into UI thread, the MessageLoop needs to run
455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // to execute the task. The OnPostMoveToTask() and the OnPostGetFaviconTask()
465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // give unit tests a chance to run the message loop before event_.Wait is
475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // invoked, The OnGetMoveToResult() and OnGetFaviconResult() is used to notify
485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // the test observer in the UI thread when the task's result comes back, it
495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // calls MessageLoop::Quit() to exit the loop, then the event.Wait() is
505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // called. Basically, Two threads are used to simulate 3 threads' behavior
515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // here.
525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // The whole observer design is only for test purpose and should only be used
535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // in unit test.
545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  class TestObserver {
555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)   public:
565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    TestObserver();
575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // Notify the MoveTo task has been posted to UI thread.
595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    virtual void OnPostMoveToTask() = 0;
605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // Notify the MoveTo result has been gotten in UI thread.
615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    virtual void OnGetMoveToResult() = 0;
625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // Notify the GetFavicon task has been posted to UI thread.
635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    virtual void OnPostGetFaviconTask() = 0;
645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // Notify the GetFavicon result has been gotten in UI thread.
655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    virtual void OnGetFaviconResult() = 0;
665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)   protected:
685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    virtual ~TestObserver();
695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  };
705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns org.chromium.chrome.SQLiteCursor java object by creating
725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // SQLitCursor native and java objects, then bind them together.
735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  static base::android::ScopedJavaLocalRef<jobject> NewJavaSqliteCursor(
745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      JNIEnv* env,
755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      const std::vector<std::string>& column_names,
765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      history::AndroidStatement* statement,
775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      AndroidHistoryProviderService* service,
785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      FaviconService* favicon_service);
795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  static bool RegisterSqliteCursor(JNIEnv* env);
815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // JNI methods -----------------------------------------------------------
835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns the result row count.
855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  jint GetCount(JNIEnv* env, jobject obj);
865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns the result's columns' name.
885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  base::android::ScopedJavaLocalRef<jobjectArray> GetColumnNames(
895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      JNIEnv* env,
905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      jobject obj);
915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns the given column value as jstring.
935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  base::android::ScopedJavaLocalRef<jstring> GetString(JNIEnv* env,
945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                                                       jobject obj,
955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                                                       jint column);
965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns the given column value as jlong.
985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  jlong GetLong(JNIEnv* env, jobject obj, jint column);
995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns the given column value as int.
1015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  jint GetInt(JNIEnv* env, jobject obj, jint column);
1025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns the given column value as double.
1045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  jdouble GetDouble(JNIEnv* env, jobject obj, jint column);
1055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns the given column value as jbyteArray.
1075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  base::android::ScopedJavaLocalRef<jbyteArray> GetBlob(JNIEnv* env,
1085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                                                        jobject obj,
1095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                                                        jint column);
1105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Return JNI_TRUE if the give column value is NULL, JNI_FALSE otherwise.
1125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  jboolean IsNull(JNIEnv* env, jobject obj, jint column);
1135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Moves the cursor to |pos|, returns new position.
1155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // If the returned position is not equal to |pos|, then the cursor points to
1165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // the last row.
1175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  jint MoveTo(JNIEnv* env, jobject obj, jint pos);
1185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Returns the type of column.
1205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  jint GetColumnType(JNIEnv* env, jobject obj, jint column);
1215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Called from Java to relase this object.
1235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void Destroy(JNIEnv* env, jobject obj);
1245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) private:
1265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  FRIEND_TEST_ALL_PREFIXES(SQLiteCursorTest, Run);
1275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // |column_names| is the column names of this cursor, the sequence of name
1295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // should match the sql query's projection name.
1305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // |statement| is query's statement which bound the variables. This class
1315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // take the ownership of |statement|.
1325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  SQLiteCursor(const std::vector<std::string>& column_names,
1335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)               history::AndroidStatement* statement,
1345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)               AndroidHistoryProviderService* service,
1355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)               FaviconService* favicon_service);
1365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  virtual ~SQLiteCursor();
1385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
139868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles)  // Destory SQLiteCursor object on UI thread. All cleanup need finish in UI
140868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles)  // thread.
141868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles)  void DestroyOnUIThread();
142868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles)
1435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // This method is for testing only.
1445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void set_test_observer(TestObserver* test_observer) {
1455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    test_observer_ = test_observer;
1465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Get Favicon from history backend.
1490529e5d033099cbfc42635f6f6183833b09dff6eBen Murdoch  bool GetFavicon(favicon_base::FaviconID id,
1505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                  std::vector<unsigned char>* image_data);
1515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void GetFaviconForIDInUIThread(
1530529e5d033099cbfc42635f6f6183833b09dff6eBen Murdoch      favicon_base::FaviconID id,
1545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      const FaviconService::FaviconRawCallback& callback);
1555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1562a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)  // The callback function of FaviconService::GetLargestRawFaviconForID().
1570529e5d033099cbfc42635f6f6183833b09dff6eBen Murdoch  void OnFaviconData(const favicon_base::FaviconBitmapResult& bitmap_result);
1585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // The callback function of MoveTo().
16090dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  void OnMoved(AndroidHistoryProviderService::Handle handle, int pos);
1615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  JavaColumnType GetColumnTypeInternal(int column);
1635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Runs the MoveStatement on UI thread.
1655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void RunMoveStatementOnUIThread(int pos);
1665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // The current row position, '-1' means the position before the first one.
1685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int position_;
1695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  base::WaitableEvent event_;
1715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // The wrapped history::AndroidStatement.
1735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  history::AndroidStatement* statement_;
1745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Result set columns' name
1765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  const std::vector<std::string> column_names_;
1775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidHistoryProviderService* service_;
1795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  FaviconService* favicon_service_;
1815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1822a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)  // Live on UI thread.
1832a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)  scoped_ptr<CancelableRequestConsumer> consumer_;
1845d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)  scoped_ptr<base::CancelableTaskTracker> tracker_;
1855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // The count of result rows.
1875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int count_;
1885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // The favicon image.
1900529e5d033099cbfc42635f6f6183833b09dff6eBen Murdoch  favicon_base::FaviconBitmapResult favicon_bitmap_result_;
1915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  TestObserver* test_observer_;
1935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  DISALLOW_COPY_AND_ASSIGN(SQLiteCursor);
1955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)};
1965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#endif  // CHROME_BROWSER_HISTORY_ANDROID_SQLITE_CURSOR_H_
198