Added 'folder' column in virtual table.

chrome/browser/history/android/android_provider_backend.cc

 // Copyright (c) 2012 The Chromium Authors. All rights reserved.
 // Use of this source code is governed by a BSD-style license that can be
 // found in the LICENSE file.
 
 #include "chrome/browser/history/android/android_provider_backend.h"
 
 #include "base/i18n/case_conversion.h"
 #include "chrome/browser/bookmarks/bookmark_service.h"
 #include "chrome/common/chrome_notification_types.h"
 #include "chrome/browser/history/android/android_time.h"
@@ skipping 16 matching lines @@
 namespace {
 
 const char* kVirtualHistoryAndBookmarkTable =
     "SELECT android_urls.id AS _id, "
         "android_cache_db.bookmark_cache.created_time AS created, "
         "urls.title AS title, android_urls.raw_url AS url, "
         "urls.visit_count AS visits, "
         "android_cache_db.bookmark_cache.last_visit_time AS date, "
         "android_cache_db.bookmark_cache.bookmark AS bookmark, "
         "android_cache_db.bookmark_cache.favicon_id AS favicon, "
-        "urls.id AS url_id, urls.url AS urls_url "
+        "urls.id AS url_id, urls.url AS urls_url, "
+    // TODO (michaelbai) : Remove folder column once we remove it from Android
+    // framework.
+    // Android framework assumes 'folder' column exist in the table, the row is
+    // the bookmark once folder is 0, though it is not part of public API, it
+    // has to be added and set as 0 when the row is bookmark.
+        "(CASE WHEN android_cache_db.bookmark_cache.bookmark IS 0 "
+        "THEN 1 ELSE 0 END) as folder "
     "FROM (android_urls JOIN urls on (android_urls.url_id = urls.id) "
-        "LEFT JOIN android_cache_db.bookmark_cache AS bookmark_cache "
-        "on (android_urls.url_id = bookmark_cache.url_id))";
+        "LEFT JOIN android_cache_db.bookmark_cache "
+        "on (android_urls.url_id = android_cache_db.bookmark_cache.url_id))";
 
 const char * kURLUpdateClause =
     "SELECT urls.id, urls.last_visit_time, created_time, urls.url "
     "FROM urls LEFT JOIN "
         "(SELECT url as visit_url, min(visit_time) as created_time"
         " FROM visits GROUP BY url) ON (visit_url = urls.id) ";
 
 const char* kSearchTermUpdateClause =
     "SELECT keyword_search_terms.term, max(urls.last_visit_time) "
     "FROM keyword_search_terms JOIN urls ON "
@@ skipping 1079 matching lines @@
       return false;
 
     if (!history_db_->SetKeywordSearchTermsForURL(bookmark_row.url_id(),
                           values.template_url_id(), values.search_term()))
       return false;
   }
   return true;
 }
 
 }  // namespace history