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/history/android/android_history_provider_service.h" 19cedac228d2dd51db4b79ea1e72c7f249408ee061Torne (Richard Coles)#include "components/favicon_base/favicon_callback.h" 201320f92c476a1ad9d19dba2a48c72b75566198e9Primiano Tucci#include "components/history/core/browser/history_types.h" 21cedac228d2dd51db4b79ea1e72c7f249408ee061Torne (Richard Coles) 22cedac228d2dd51db4b79ea1e72c7f249408ee061Torne (Richard Coles)class FaviconService; 235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// This class is JNI implementation of 255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// org.chromium.chrome.database.SqliteCursor, it uses the AndroidStatement to 265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// iterate among the result rows. This is not thread safe, all methods should 275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// be called from the same non-UI thread which typical is the Java thread. 285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// 295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// This class can not be in history namespace because the class name has to 305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// match to the generated sqlite_cursor_jni.h. 315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)class SQLiteCursor { 325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) public: 335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Mapping to the column type definitions in java.sql.Types. 345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) enum JavaColumnType { 355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) BLOB = 2004, 365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) LONG_VAR_CHAR = -1, 375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) NULL_TYPE = 0, 385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) NUMERIC = 2, 395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) DOUBLE = 8, 405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) }; 415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This class is intended to be used only in unit tests. 435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // 445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // There are 2 threads in unit test, one is the UI thread, another is the DB 455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // thread, after the task posted into UI thread, the MessageLoop needs to run 465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // to execute the task. The OnPostMoveToTask() and the OnPostGetFaviconTask() 475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // give unit tests a chance to run the message loop before event_.Wait is 485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // invoked, The OnGetMoveToResult() and OnGetFaviconResult() is used to notify 495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // the test observer in the UI thread when the task's result comes back, it 505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // calls MessageLoop::Quit() to exit the loop, then the event.Wait() is 515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // called. Basically, Two threads are used to simulate 3 threads' behavior 525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // here. 535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // The whole observer design is only for test purpose and should only be used 545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // in unit test. 555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) class TestObserver { 565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) public: 575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) TestObserver(); 585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Notify the MoveTo task has been posted to UI thread. 605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) virtual void OnPostMoveToTask() = 0; 615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Notify the MoveTo result has been gotten in UI thread. 625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) virtual void OnGetMoveToResult() = 0; 635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Notify the GetFavicon task has been posted to UI thread. 645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) virtual void OnPostGetFaviconTask() = 0; 655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Notify the GetFavicon result has been gotten in UI thread. 665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) virtual void OnGetFaviconResult() = 0; 675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) protected: 695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) virtual ~TestObserver(); 705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) }; 715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns org.chromium.chrome.SQLiteCursor java object by creating 735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // SQLitCursor native and java objects, then bind them together. 745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) static base::android::ScopedJavaLocalRef<jobject> NewJavaSqliteCursor( 755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) JNIEnv* env, 765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) const std::vector<std::string>& column_names, 775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) history::AndroidStatement* statement, 785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) AndroidHistoryProviderService* service, 795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) FaviconService* favicon_service); 805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) static bool RegisterSqliteCursor(JNIEnv* env); 825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // JNI methods ----------------------------------------------------------- 845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns the result row count. 865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jint GetCount(JNIEnv* env, jobject obj); 875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns the result's columns' name. 895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) base::android::ScopedJavaLocalRef<jobjectArray> GetColumnNames( 905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) JNIEnv* env, 915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jobject obj); 925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns the given column value as jstring. 945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) base::android::ScopedJavaLocalRef<jstring> GetString(JNIEnv* env, 955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jobject obj, 965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jint column); 975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns the given column value as jlong. 995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jlong GetLong(JNIEnv* env, jobject obj, jint column); 1005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns the given column value as int. 1025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jint GetInt(JNIEnv* env, jobject obj, jint column); 1035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns the given column value as double. 1055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jdouble GetDouble(JNIEnv* env, jobject obj, jint column); 1065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns the given column value as jbyteArray. 1085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) base::android::ScopedJavaLocalRef<jbyteArray> GetBlob(JNIEnv* env, 1095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jobject obj, 1105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jint column); 1115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Return JNI_TRUE if the give column value is NULL, JNI_FALSE otherwise. 1135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jboolean IsNull(JNIEnv* env, jobject obj, jint column); 1145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Moves the cursor to |pos|, returns new position. 1165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // If the returned position is not equal to |pos|, then the cursor points to 1175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // the last row. 1185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jint MoveTo(JNIEnv* env, jobject obj, jint pos); 1195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Returns the type of column. 1215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) jint GetColumnType(JNIEnv* env, jobject obj, jint column); 1225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Called from Java to relase this object. 1245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) void Destroy(JNIEnv* env, jobject obj); 1255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) private: 1275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) FRIEND_TEST_ALL_PREFIXES(SQLiteCursorTest, Run); 1285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |column_names| is the column names of this cursor, the sequence of name 1305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // should match the sql query's projection name. 1315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // |statement| is query's statement which bound the variables. This class 1325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // take the ownership of |statement|. 1335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) SQLiteCursor(const std::vector<std::string>& column_names, 1345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) history::AndroidStatement* statement, 1355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) AndroidHistoryProviderService* service, 1365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) FaviconService* favicon_service); 1375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) virtual ~SQLiteCursor(); 1395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 140868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles) // Destory SQLiteCursor object on UI thread. All cleanup need finish in UI 141868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles) // thread. 142868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles) void DestroyOnUIThread(); 143868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles) 1445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // This method is for testing only. 1455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) void set_test_observer(TestObserver* test_observer) { 1465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) test_observer_ = test_observer; 1475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) } 1485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Get Favicon from history backend. 1500529e5d033099cbfc42635f6f6183833b09dff6eBen Murdoch bool GetFavicon(favicon_base::FaviconID id, 1515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) std::vector<unsigned char>* image_data); 1525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) void GetFaviconForIDInUIThread( 1540529e5d033099cbfc42635f6f6183833b09dff6eBen Murdoch favicon_base::FaviconID id, 155f8ee788a64d60abd8f2d742a5fdedde054ecd910Torne (Richard Coles) const favicon_base::FaviconRawBitmapCallback& callback); 1565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1572a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // The callback function of FaviconService::GetLargestRawFaviconForID(). 158f8ee788a64d60abd8f2d742a5fdedde054ecd910Torne (Richard Coles) void OnFaviconData(const favicon_base::FaviconRawBitmapResult& bitmap_result); 1595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // The callback function of MoveTo(). 161116680a4aac90f2aa7413d9095a592090648e557Ben Murdoch void OnMoved(int pos); 1625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) JavaColumnType GetColumnTypeInternal(int column); 1645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Runs the MoveStatement on UI thread. 1665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) void RunMoveStatementOnUIThread(int pos); 1675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // The current row position, '-1' means the position before the first one. 1695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) int position_; 1705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) base::WaitableEvent event_; 1725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // The wrapped history::AndroidStatement. 1745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) history::AndroidStatement* statement_; 1755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) // Result set columns' name 1775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) const std::vector<std::string> column_names_; 1785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) AndroidHistoryProviderService* service_; 1805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) FaviconService* favicon_service_; 1825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) 1832a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles) // Live on UI thread. 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. 190f8ee788a64d60abd8f2d742a5fdedde054ecd910Torne (Richard Coles) favicon_base::FaviconRawBitmapResult 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