nsPlacesAutoComplete - /* * * * * * * * * * * * * * * * * *...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
/* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*- * vim: sw=2 ts=2 sts=2 expandtab * ***** BEGIN LICENSE BLOCK ***** * Version: MPL 1.1/GPL 2.0/LGPL 2.1 * * The contents of this file are subject to the Mozilla Public License Version * 1.1 (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * http://www.mozilla.org/MPL/ * * Software distributed under the License is distributed on an "AS IS" basis, * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License * for the specific language governing rights and limitations under the * License. * * The Original Code is mozilla.org code. * * The Initial Developer of the Original Code is * Mozilla Corporation. * Portions created by the Initial Developer are Copyright (C) 2008 * the Initial Developer. All Rights Reserved. * * Contributor(s): * Shawn Wilsher <me@shawnwilsher.com> (Original Author) * * Alternatively, the contents of this file may be used under the terms of * either the GNU General Public License Version 2 or later (the "GPL"), or * the GNU Lesser General Public License Version 2.1 or later (the "LGPL"), * in which case the provisions of the GPL or the LGPL are applicable instead * of those above. If you wish to allow use of your version of this file only * under the terms of either the GPL or the LGPL, and not to allow others to * use your version of this file under the terms of the MPL, indicate your * decision by deleting the provisions above and replace them with the notice * and other provisions required by the GPL or the LGPL. If you do not delete * the provisions above, a recipient may use your version of this file under * the terms of any one of the MPL, the GPL or the LGPL. * * ***** END LICENSE BLOCK ***** */ Components.utils.import("resource://gre/modules/XPCOMUtils.jsm"); //////////////////////////////////////////////////////////////////////////////// //// Constants const Cc = Components.classes; const Ci = Components.interfaces; const Cr = Components.results; // This is just a helper for the next constant. function book_tag_sql_fragment(aName, aColumn, aForTag) { return ["(", "SELECT ", aColumn, " ", "FROM moz_bookmarks b ", "JOIN moz_bookmarks t ", "ON t.id = b.parent ", "AND t.parent ", (aForTag ? "" : "!"), "= :parent ", "WHERE b.type = ", Ci.nsINavBookmarksService.TYPE_BOOKMARK, " ", "AND b.fk = h.id ",
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
(aForTag ? "AND LENGTH(t.title) > 0" : "ORDER BY b.lastModified DESC LIMIT 1"), ") AS ", aName].join(""); } // This SQL query fragment provides the following: // - the parent folder for bookmarked entries (kQueryIndexParent) // - the bookmark title, if it is a bookmark (kQueryIndexBookmarkTitle) // - the tags associated with a bookmarked entry (kQueryIndexTags) const kBookTagSQLFragment = book_tag_sql_fragment("parent", "b.parent", false) + ", " + book_tag_sql_fragment("bookmark", "b.title", false) + ", " + book_tag_sql_fragment("tags", "GROUP_CONCAT(t.title, ',')", true);
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 19

nsPlacesAutoComplete - /* * * * * * * * * * * * * * * * * *...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online