dimanche 14 juin 2015

How to display db table names

I trying to read the Firefox cookies.sqlite db. I copied the cookies.db to my desktop. I'm working with the db on my desktop.

I copied some code, but I'm not able to read what tables are in the db. get list of tables, db schema, dump etc in sqlite databases

I cannot get it to work.

Here is what I get in the terminal. I see the listing of the tables.

me $ ls cookies.sqlite 
cookies.sqlite
me $ sqlite3 cookies.sqlite
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite> .tables
moz_cookies
sqlite> .exit
me $ # I run my python script
me $ ./sqlTutorial.bash 
SQLite version: 3.8.10.2
table records...
[]
more table records...
me $ cat dump.sql
BEGIN TRANSACTION;
COMMIT;
me $ 

python code. All I want to do is display the tables in the cookie.sqlite db.

#! /bin/python 

import sqlite3 as lite
import sys

con = lite.connect('cookie.sqlite')

with con:

    cur = con.cursor()    
    cur.execute('SELECT SQLITE_VERSION()')

    data = cur.fetchone()

    print ("SQLite version: %s" % data)

print ("table records...")

cursor = con.cursor()
cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
print(cursor.fetchall())

print ("more table records...")

with open('dump.sql', 'w') as f:
    for line in con.iterdump():
        f.write('%s\n' % line)

Aucun commentaire:

Enregistrer un commentaire