Module: QueryConstants

Included in:

BookmarksReader

Defined in:

lib/fundler/fundler_utils.rb

Overview

Schema

References

stackoverflow.com/questions/464516/firefox-bookmarks-sqlite-structure developer.mozilla.org/en-US/docs/Places developer.mozilla.org/en-US/docs/Retrieving_part_of_the_bookmarks_tree developer.mozilla.org/en-US/docs/XPCOM_Interface_Reference/nsINavBookmarksService davidkoepi.wordpress.com/2010/11/27/firefoxforensics/

Queries

select moz_places.url, moz_bookmarks.title from moz_places,moz_bookmarks where moz_places.id = moz_bookmarks.fk and moz_bookmarks.title != ”;

select keyword,url from moz_keywords left join moz_bookmarks on (moz_keywords.id = keyword_id) left join moz_places on (fk = moz_places.id);

select moz_places.url, datetime((moz_historyvisits.visit_date/1000000), ‘unixepoch’, ‘localtime’), moz_historyvisits.visit_type from moz_places, moz_historyvisits where moz_historyvisits.place_id = moz_places.id order by moz_historyvisits.visit_date desc;

Constant Summary

BOOKMARKS_QUERY =

all bookmarks

"  SELECT DISTINCT\n      moz_places.url AS url,\n      moz_bookmarks.title AS title,\n      moz_bookmarks.id AS id,\n      moz_items_annos.content AS description\n  FROM\n      moz_places,\n      moz_bookmarks,\n      moz_items_annos,\n      moz_anno_attributes\n  WHERE\n      moz_anno_attributes.name = 'bookmarkProperties/description' AND\n      moz_items_annos.anno_attribute_id = moz_anno_attributes.id AND\n      moz_items_annos.item_id = moz_bookmarks.id AND\n      moz_places.id = moz_bookmarks.fk AND\n      moz_places.id IN (\n              SELECT DISTINCT fk \n              FROM moz_bookmarks\n              WHERE parent IN (\n                  SELECT moz_bookmarks.id\n                  FROM moz_bookmarks, moz_bookmarks_roots\n                  WHERE moz_bookmarks_roots.root_name = 'tags'\n                  AND moz_bookmarks.parent = moz_bookmarks_roots.folder_id\n              )\n          )\n  ORDER BY UPPER(moz_bookmarks.title) ASC\n"

QUERY_FOR_TAGS =

tag.id|tag.title

"  SELECT id, title FROM moz_bookmarks WHERE parent = 4;\n"

QUERY_BY_TAG =

all bookmarks with the “given” tag.id

"  SELECT moz_places.id, moz_places.url, moz_places.title, moz_bookmarks.parent    \n  FROM moz_places    \n  LEFT OUTER JOIN moz_bookmarks    \n  ON moz_places.id = moz_bookmarks.fk    \n  WHERE moz_bookmarks.parent = @tag_id;\n"

QUERY_FOR_SIMPLE_BOOKMARKS =

bookmark.id|bookmark.fk|bookmark.title …

> 1933|1387|SQLite Home Page

…

"  SELECT id,fk,title FROM moz_bookmarks WHERE parent = 2;\n"

QUERY_FOR_LINK =

select the link between bookmars and tags fk_id = 1387

> 1934|1387|1144

"  SELECT id,fk,parent FROM moz_bookmarks WHERE title is null AND fk = @fk_id;\n"

QUERY_FOR_TAG_BY_ID =

tag.id|tag.title parent = 1144

> 1144|coding

"  SELECT id, title FROM moz_bookmarks WHERE parent = 4 AND id = @parent;\n"