|
Last change
on this file was 2, checked in by Yuri Dario, 15 years ago |
|
Initial import for vendor code.
|
-
Property svn:eol-style
set to
native
|
|
File size:
697 bytes
|
| Line | |
|---|
| 1 | import sqlite3
|
|---|
| 2 |
|
|---|
| 3 | FIELD_MAX_WIDTH = 20
|
|---|
| 4 | TABLE_NAME = 'people'
|
|---|
| 5 | SELECT = 'select * from %s order by age, name_last' % TABLE_NAME
|
|---|
| 6 |
|
|---|
| 7 | con = sqlite3.connect("mydb")
|
|---|
| 8 |
|
|---|
| 9 | cur = con.cursor()
|
|---|
| 10 | cur.execute(SELECT)
|
|---|
| 11 |
|
|---|
| 12 | # Print a header.
|
|---|
| 13 | for fieldDesc in cur.description:
|
|---|
| 14 | print fieldDesc[0].ljust(FIELD_MAX_WIDTH) ,
|
|---|
| 15 | print # Finish the header with a newline.
|
|---|
| 16 | print '-' * 78
|
|---|
| 17 |
|
|---|
| 18 | # For each row, print the value of each field left-justified within
|
|---|
| 19 | # the maximum possible width of that field.
|
|---|
| 20 | fieldIndices = range(len(cur.description))
|
|---|
| 21 | for row in cur:
|
|---|
| 22 | for fieldIndex in fieldIndices:
|
|---|
| 23 | fieldValue = str(row[fieldIndex])
|
|---|
| 24 | print fieldValue.ljust(FIELD_MAX_WIDTH) ,
|
|---|
| 25 |
|
|---|
| 26 | print # Finish the row with a newline.
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
