/Doc/includes/sqlite3/simple_tableprinter.py
http://unladen-swallow.googlecode.com/ · Python · 26 lines · 17 code · 6 blank · 3 comment · 3 complexity · 3007cb9f0958b7bc9e7ea3b2bd31d842 MD5 · raw file
- import sqlite3
- FIELD_MAX_WIDTH = 20
- TABLE_NAME = 'people'
- SELECT = 'select * from %s order by age, name_last' % TABLE_NAME
- con = sqlite3.connect("mydb")
- cur = con.cursor()
- cur.execute(SELECT)
- # Print a header.
- for fieldDesc in cur.description:
- print fieldDesc[0].ljust(FIELD_MAX_WIDTH) ,
- print # Finish the header with a newline.
- print '-' * 78
- # For each row, print the value of each field left-justified within
- # the maximum possible width of that field.
- fieldIndices = range(len(cur.description))
- for row in cur:
- for fieldIndex in fieldIndices:
- fieldValue = str(row[fieldIndex])
- print fieldValue.ljust(FIELD_MAX_WIDTH) ,
- print # Finish the row with a newline.