From 6f9d4bd7c401896814d499d7a5280f91c7ed9d3c Mon Sep 17 00:00:00 2001 From: Joe Onorato Date: Wed, 29 Sep 2010 17:43:46 -0700 Subject: Add a script to pull launcher.db off the device and pretty print an html file with the contents. Change-Id: I4640fad71e5f77e0dbcbe4df4204bf36a03d3562 --- print_db.py | 220 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 220 insertions(+) create mode 100755 print_db.py (limited to 'print_db.py') diff --git a/print_db.py b/print_db.py new file mode 100755 index 000000000..ebcba6cee --- /dev/null +++ b/print_db.py @@ -0,0 +1,220 @@ +#!/usr/bin/env python2.5 + +import cgi +import os +import shutil +import sys +import sqlite3 + +SCREENS = 5 +COLUMNS = 4 +ROWS = 4 +CELL_SIZE = 110 + +DIR = "db_files" +AUTO_FILE = DIR + "/launcher.db" +INDEX_FILE = DIR + "/index.html" + +def usage(): + print "usage: print_db.py launcher.db -- prints a launcher.db" + print "usage: print_db.py -- adb pulls a launcher.db from a device" + print " and prints it" + print + print "The dump will be created in a directory called db_files in cwd." + print "This script will delete any db_files directory you have now" + + +def make_dir(): + shutil.rmtree(DIR, True) + os.makedirs(DIR) + +def pull_file(fn): + print "pull_file: " + fn + rv = os.system("adb pull" + + " /data/data/com.android.launcher/databases/launcher.db" + + " " + fn); + if rv != 0: + print "adb pull failed" + sys.exit(1) + +def get_favorites(conn): + c = conn.cursor() + c.execute("SELECT * FROM favorites") + columns = [d[0] for d in c.description] + rows = [] + for row in c: + rows.append(row) + return columns,rows + +def print_intent(out, id, i, cell): + if cell: + out.write("""shortcut""" % ( + cgi.escape(cell, True) + )) + + +def print_icon(out, id, i, cell): + if cell: + icon_fn = "icon_%d.png" % id + out.write("""

""" % ( icon_fn )) + f = file(DIR + "/" + icon_fn, "w") + f.write(cell) + f.close() + +def print_cell(out, id, i, cell): + if not cell is None: + out.write(cgi.escape(str(cell))) + +FUNCTIONS = { + "intent": print_intent, + "icon": print_icon +} + +def process_file(fn): + print "process_file: " + fn + conn = sqlite3.connect(fn) + columns,rows = get_favorites(conn) + data = [dict(zip(columns,row)) for row in rows] + + out = file(INDEX_FILE, "w") + out.write(""" + + + + +""") + + # Data table + out.write("Favorites table
\n") + out.write(""" + + +""") + print_functions = [] + for col in columns: + print_functions.append(FUNCTIONS.get(col, print_cell)) + for i in range(0,len(columns)): + col = columns[i] + out.write(""" +""" % ( col )) + out.write(""" + +""") + for row in rows: + out.write(""" +""") + for i in range(0,len(row)): + cell = row[i] + # row[0] is always _id + out.write(""" +""") + out.write(""" +""") + out.write("""

%s
""") + print_functions[i](out, row[0], row, cell) + out.write("""

+""") + + # Pages + screens = [] + for i in range(0,SCREENS): + screen = [] + for j in range(0,ROWS): + m = [] + for k in range(0,COLUMNS): + m.append(None) + screen.append(m) + screens.append(screen) + occupied = "occupied" + for row in data: + screen = screens[row["screen"]] + # desktop + if row["container"] != -100: + continue + cellX = row["cellX"] + cellY = row["cellY"] + spanX = row["spanX"] + spanY = row["spanY"] + for j in range(cellY, cellY+spanY): + for k in range(cellX, cellX+spanX): + screen[j][k] = occupied + screen[cellY][cellX] = row + i=0 + for screen in screens: + out.write("
Screen %d
\n" % i) + out.write("\n") + for m in screen: + out.write(" \n") + for cell in m: + if cell is None: + out.write(" \n" % + (CELL_SIZE, CELL_SIZE)) + elif cell == occupied: + pass + else: + cellX = cell["cellX"] + cellY = cell["cellY"] + spanX = cell["spanX"] + spanY = cell["spanY"] + intent = cell["intent"] + if intent: + title = "title=\"%s\"" % cgi.escape(cell["intent"], True) + else: + title = "" + out.write((" \n") + out.write("\n") + out.write("

") % ( + spanX, spanY, + (CELL_SIZE*spanX), (CELL_SIZE*spanY), + title)) + itemType = cell["itemType"] + if itemType == 0: + out.write("""

\n""" % ( cell["_id"] )) + out.write("
\n") + out.write(cgi.escape(cell["title"]) + "
(app)") + elif itemType == 1: + out.write("""

\n""" % ( cell["_id"] )) + out.write("
\n") + out.write(cgi.escape(cell["title"]) + "
(shortcut)") + elif itemType == 2: + out.write("""folder""") + elif itemType == 3: + out.write("""live folder""") + elif itemType == 4: + out.write("widget %d
\n" % cell["appWidgetId"]) + elif itemType == 1000: + out.write("""clock""") + elif itemType == 1001: + out.write("""search""") + elif itemType == 1002: + out.write("""photo frame""") + else: + out.write("unknown type: %d" % itemType) + out.write("

\n") + i=i+1 + + out.write(""" + + +""") + + out.close() + +def main(argv): + if len(argv) == 1: + make_dir() + pull_file(AUTO_FILE) + process_file(AUTO_FILE) + elif len(argv) == 2: + make_dir() + process_file(argv[1]) + else: + usage() + +if __name__=="__main__": + main(sys.argv) -- cgit v1.2.3