Avatar for Username

Търсене в помощните статии

Избягвайте измамите при поддръжката. Никога няма да ви помолим да се обадите или изпратите SMS на телефонен номер или да споделите лична информация. Моля, докладвайте подозрителна активност на "Докладване за злоупотреба".

Научете повече

Тази тема беше архивирана. Моля, задайте нов въпрос ако имате нужда от помощ.

In places.sqlite which bookmarks are "live bookmarks"?

  • 2 отговора
  • 3 имат този проблем
  • 1 изглед
  • Последен отговор от cor-el

THUFIR
THUFIR
more options

I'm interested in querying places.sqlite for all the live bookmarks, however, I'm not familiar with this database. I exported the moz_places table, and ran grep on the insert statements:

INSERT INTO "moz_places" VALUES(25010,'https://www.google.com/search?client=ubuntu&channel=fs&q=rss+cnn&ie=utf-8&oe=utf-8',NULL,'moc.elgoog.www.',1,1,0,NULL,100,1413097582782753,'f0M0e2nfq_VJ'); INSERT INTO "moz_places" VALUES(25011,'https://www.google.ca/search?client=ubuntu&channel=fs&q=rss+cnn&ie=utf-8&oe=utf-8&gfe_rd=cr&ei=bCg6VJ3VG4aV8Qf3l4GIBQ','rss cnn - Google Search','ac.elgoog.www.',1,0,0,29,100,1413097582971572,'wSZXfXwlnA1D'); INSERT INTO "moz_places" VALUES(25012,'http://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CB8QFjAA&url=http%3A%2F%2Fwww.cnn.com%2Fservices%2Frss%2F&ei=bCg6VKnXI6T2iwKU6IDwCA&usg=AFQjCNHn-O_p5INKrhV93aMu0ixmtAJ98w&sig2=b9tUj8pmaxx8zm0RGU3yCw&bvm=bv.77161500,d.cGE&cad=rjt',NULL,'ac.elgoog.www.',1,0,0,22,100,1413097587642068,'HRefGS2PSAEM'); INSERT INTO "moz_places" VALUES(25013,'http://www.cnn.com/services/rss/','RSS (Really Simple Syndication) - CNN.com','moc.nnc.www.',1,0,0,1344,100,1413097588038096,'p9dKse4VE4U1'); INSERT INTO "moz_places" VALUES(25014,'http://rss.cnn.com/rss/cnn_topstories.rss','CNN.com - Top Stories','moc.nnc.ssr.',1,0,0,NULL,100,1413097596372991,'qq77Qsma7m5p'); thufir@dur:~/rss$ thufir@dur:~/rss$ cat moz_places.sql | grep "cnn"


so, those look like they're from the CNN feed -- good.

How would I do a proper query of the database for any and all such "live" bookmarks?

I'm interested in querying places.sqlite for all the live bookmarks, however, I'm not familiar with this database. I exported the moz_places table, and ran grep on the insert statements: INSERT INTO "moz_places" VALUES(25010,'https://www.google.com/search?client=ubuntu&channel=fs&q=rss+cnn&ie=utf-8&oe=utf-8',NULL,'moc.elgoog.www.',1,1,0,NULL,100,1413097582782753,'f0M0e2nfq_VJ'); INSERT INTO "moz_places" VALUES(25011,'https://www.google.ca/search?client=ubuntu&channel=fs&q=rss+cnn&ie=utf-8&oe=utf-8&gfe_rd=cr&ei=bCg6VJ3VG4aV8Qf3l4GIBQ','rss cnn - Google Search','ac.elgoog.www.',1,0,0,29,100,1413097582971572,'wSZXfXwlnA1D'); INSERT INTO "moz_places" VALUES(25012,'http://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CB8QFjAA&url=http%3A%2F%2Fwww.cnn.com%2Fservices%2Frss%2F&ei=bCg6VKnXI6T2iwKU6IDwCA&usg=AFQjCNHn-O_p5INKrhV93aMu0ixmtAJ98w&sig2=b9tUj8pmaxx8zm0RGU3yCw&bvm=bv.77161500,d.cGE&cad=rjt',NULL,'ac.elgoog.www.',1,0,0,22,100,1413097587642068,'HRefGS2PSAEM'); INSERT INTO "moz_places" VALUES(25013,'http://www.cnn.com/services/rss/','RSS (Really Simple Syndication) - CNN.com','moc.nnc.www.',1,0,0,1344,100,1413097588038096,'p9dKse4VE4U1'); INSERT INTO "moz_places" VALUES(25014,'http://rss.cnn.com/rss/cnn_topstories.rss','CNN.com - Top Stories','moc.nnc.ssr.',1,0,0,NULL,100,1413097596372991,'qq77Qsma7m5p'); thufir@dur:~/rss$ thufir@dur:~/rss$ cat moz_places.sql | grep "cnn" so, those look like they're from the CNN feed -- good. How would I do a proper query of the database for any and all such "live" bookmarks?

Променено на от NoahSUMO

Всички отговори (2)

guigs
guigs
more options

This might be better question on stackoverflow.com, but would a search for "rss" in the url string column be good?

http://stackoverflow.com/questions/13.../fastest-way-to-search-through-strings-stored-in-sqlite-database

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

You can use the SQLite Manager extension to generate a list.

  1. Open Profile Directory -> places.sqlite -> Go
  2. Hit the "Execute SQL" tab
  3. Use a SELECT like this: 
SELECT moz_bookmarks.id, moz_bookmarks.title, moz_items_annos.content
FROM moz_bookmarks, moz_items_annos, moz_anno_attributes
WHERE (moz_bookmarks.id = moz_items_annos.item_id) AND (moz_items_annos.anno_attribute_id = moz_anno_attributes.id) AND (moz_anno_attributes.name LIKE 'livemark/feedURI')
ORDER BY moz_bookmarks.id ASC