lundi 4 avril 2016

Google Chrome: How to find out the name of Transition from its id in History sql-lite db

I am reading Google Chrome History from its Sql-Lite Db.

Table Name: Visits Structure:

+-----+------------------+-----------+-----+--------+-----+
| "0" | "id"             | "INTEGER" | "0" | "NULL" | "1" |
| "1" | "url"            | "INTEGER" | "1" | "NULL" | "0" |
| "2" | "visit_time"     | "INTEGER" | "1" | "NULL" | "0" |
| "3" | "from_visit"     | "INTEGER" | "0" | "NULL" | "0" |
| "4" | "transition"     | "INTEGER" | "1" | "0"    | "0" |
| "5" | "segment_id"     | "INTEGER" | "0" | "NULL" | "0" |
| "6" | "visit_duration" | "INTEGER" | "1" | "0"    | "0" |
+-----+------------------+-----------+-----+--------+-----+

I was trying to find out what does transition means then I found the link : Page Transitions and according to it Google Chrome stores a transition value which identifies the type of transition between pages. These are stored in the history database to separate visits, and are reported by the renderer for page navigations.

There are many types of transitions like LINK, TYPED etc...

In sql lite table Google Chrome integer values.

enter image description here

Problem

How to figure out the Transition from the integer value??

There are some more tables in the DB but none of them contains any table representing the meaning of these values.

Other tables are:

enter image description here

Aucun commentaire:

Enregistrer un commentaire