CYBR 260 Week 6 Programming Assignment History Database

Description

In this week’s module, you will find a History database  downloadthat 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);
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);
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);
SCREENSHOTS
SOLUTION
PAYMENT
CYBR 260 Week 6
CYBR 260 Assignment 6
The solution includes Python code, report and screenshots.
Attachments [Move over files to preview content of those files]
CYBR_260_Assignment_6.zip (217.32 KB)
Assignment6.py
CYBR-260-Week-6-Screenshot-1.png
CYBR-260-Week-6-Screenshot-2.png
CYBR_260_Assignment6_Report.docx
History.db
Preview Assignment6.py
xxx xxxxxx xx xxxxx xxx xxxx xxx xxxxxxx xxx xxx xxxx xxxx xx xxx xxxxxxx.
xxxxxx:
xxxxx xxx xxxxxxx, xxxxxx xx xxxxxxx, xxxx xxxx
“””
xxxxxx xxxxxx3
def get_all_visit_logs(cursor): “”” function: get_all_visit_logs purpose: query to database to get all visit logs inputs: cursor returns: array of logs “”” cur.execute(“SELECT url, visit_time FROM visits”) rows = cur.fetchall() array = [] for row in rows:
xxxxx.xxxxxx({
‘xxx’: xxx[0],
‘xxxxx_xxxx’: xxx[1],
})
# xxx xxx
xxxxxx xxxxx
Price: $25
Buy Now
Checkout
Added to cart
Add to Cart
Checkout
Added to cart
You May Also Like:
CYBR 260 Week 1 Programming Assignment Name and Three Numbers
CYBR 260 Week 2 Programming Assignment Average Grades
CYBR 260 Week 3 Programming Assignment Master Boot Record
CYBR 260 Week 4 Programming Assignment Master Boot Record Part 2
CYBR 260 Week 5 Programming Assignment Registry
CYBR 260 Week 7 Programming Assignment Sqlite Database