private static Launchables LoadFFDeliciousBookmarks(File file) { using (var connection = new Connection(file)) { SQLiteDataReader keywordsReader = connection.ExecuteQuery("SELECT name as title, url, shortcut as keyword FROM bookmarks where title is not null and keyword <> ''"); var bookmarks = new Launchables(); while (keywordsReader.Read()) bookmarks.AddRange(CreateBookmarks(keywordsReader["title"].ToString(), keywordsReader["url"].ToString(), keywordsReader["keyword"].ToString())); var tagsReader = connection.ExecuteQuery("SELECT name, rowid from tags"); while (tagsReader.Read()) { if (!tagsReader["name"].ToString().StartsWith("shortcut:")) bookmarks.Add(new DeliciousTag(tagsReader["name"].ToString(), int.Parse(tagsReader["rowid"].ToString()), file)); } return bookmarks; } }
private static Launchables LoadFF3Bookmarks(File file) { using (var connection = new Connection(file)) { var reader = connection.ExecuteQuery( "select b.title, p.url,k.keyword from moz_places p join moz_bookmarks b on p.id = b.fk left outer join moz_keywords k on keyword_id = k.id where b.title is not null"); var bookmarks = new Launchables(); while (reader.Read()) { if (!reader["url"].ToString().StartsWith("place:")) bookmarks.AddRange(CreateBookmarks(reader["title"].ToString(), reader["url"].ToString(), reader["keyword"].ToString())); } return bookmarks; } }