Avatar for Username

Tìm kiếm hỗ trợ

Tránh các lừa đảo về hỗ trợ. Chúng tôi sẽ không bao giờ yêu cầu bạn gọi hoặc nhắn tin đến số điện thoại hoặc chia sẻ thông tin cá nhân. Vui lòng báo cáo hoạt động đáng ngờ bằng cách sử dụng tùy chọn "Báo cáo lạm dụng".

Tìm hiểu thêm

Chủ đề này đã được lưu trữ. Vui lòng hỏi một câu hỏi mới nếu bạn cần giúp đỡ.

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

  • 2 trả lời
  • 3 gặp vấn đề này
  • 1 lượt xem
  • Trả lời mới nhất được viết bởi 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?

Được chỉnh sửa bởi NoahSUMO vào

Tất cả các câu trả lời (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