In this week’s module, you will find a History database  Download History database that was taken from Google Chrome. You will be using this History file to get the list of Web addresses that the user has visited.

You will write a program that will take this database file and extract the Web addresses that the user visited, the number of times the page was visited and the last time it was visited. The last time will not be readable by humans but you don’t have to worry about converting it for the purposes of this program. The schema from the database is below. Find the correct table that you need to query and the correct columns from that table.

Include the attribution block and document your code. Use self-documenting variable names. Make your output look presentable and also make sure that it can be understood by someone who doesn’t know what the purpose of the program is (in other words, don’t just dump the output to the screen without some description of it somewhere in the output).

CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);

CYBR-260: SECURITY SCRIPTING WITH PYTHON-ENTIRE COURSE HELP-CHAMPLAIN COLLEGE

CREATE TABLE urls(id INTEGER PRIMARY KEY,url LONGVARCHAR,title LONGVARCHAR,visit_count INTEGER DEFAULT 0 NOT NULL,typed_count INTEGER DEFAULT 0 NOT NULL,last_visit_time INTEGER NOT NULL,hidden INTEGER DEFAULT 0 NOT NULL,favicon_id INTEGER DEFAULT 0 NOT NULL);

CREATE TABLE visits(id INTEGER PRIMARY KEY,url INTEGER NOT NULL,visit_time INTEGER NOT NULL,from_visit INTEGER,transition INTEGER DEFAULT 0 NOT NULL,segment_id INTEGER,visit_duration INTEGER DEFAULT 0 NOT NULL);

CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL);

CREATE INDEX visits_url_index ON visits (url);

CREATE INDEX visits_from_index ON visits (from_visit);

CREATE INDEX visits_time_index ON visits (visit_time);

CREATE TABLE keyword_search_terms (keyword_id INTEGER NOT NULL,url_id INTEGER NOT NULL,lower_term LONGVARCHAR NOT NULL,term LONGVARCHAR NOT NULL);

CYBR-260: SECURITY SCRIPTING WITH PYTHON-ENTIRE COURSE HELP-CHAMPLAIN COLLEGE

CREATE TABLE downloads (id INTEGER PRIMARY KEY,current_path LONGVARCHAR NOT NULL,target_path LONGVARCHAR NOT NULL,start_time INTEGER NOT NULL,received_bytes INTEGER NOT NULL,total_bytes INTEGER NOT NULL,state INTEGER NOT NULL,danger_type INTEGER NOT NULL, interrupt_reason INTEGER NOT NULL,end_time INTEGER NOT NULL,opened INTEGER NOT NULL,referrer VARCHAR NOT NULL,by_ext_id VARCHAR NOT NULL,by_ext_name VARCHAR NOT NULL,etag VARCHAR NOT NULL,last_modified VARCHAR NOT NULL, mime_type VARCHAR(255) NOT NULL DEFAULT “”, original_mime_type VARCHAR(255) NOT NULL DEFAULT “”);

CREATE TABLE downloads_url_chains (id INTEGER NOT NULL,chain_index INTEGER NOT NULL,url LONGVARCHAR NOT NULL, PRIMARY KEY (id, chain_index) );

CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NULL);

CREATE INDEX segments_name ON segments(name);

CREATE INDEX segments_url_id ON segments(url_id);