diff options
Diffstat (limited to 'Doc/includes/sqlite3/simple_tableprinter.py')
-rw-r--r-- | Doc/includes/sqlite3/simple_tableprinter.py | 25 |
1 files changed, 0 insertions, 25 deletions
diff --git a/Doc/includes/sqlite3/simple_tableprinter.py b/Doc/includes/sqlite3/simple_tableprinter.py deleted file mode 100644 index 9be6e4f..0000000 --- a/Doc/includes/sqlite3/simple_tableprinter.py +++ /dev/null @@ -1,25 +0,0 @@ -import sqlite3 - -FIELD_MAX_WIDTH = 20 - -con = sqlite3.connect("mydb") -cur = con.cursor() -cur.execute("select * from lang order by name, first_appeared") - -# Print a header. -for fieldDesc in cur.description: - print(fieldDesc[0].ljust(FIELD_MAX_WIDTH), end=' ') -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), end=' ') - - print() # Finish the row with a newline. - -con.close() |