26 lines
563 B
Python
26 lines
563 B
Python
#!/usr/bin/env python
|
|
|
|
import sqlite3
|
|
|
|
s3conn = sqlite3.connect("../DATA/presidents.db")
|
|
|
|
c = s3conn.cursor()
|
|
|
|
|
|
def row_as_dict(cursor):
|
|
'''Generate rows as dictionaries'''
|
|
column_names = [desc[0] for desc in cursor.description]
|
|
for cursor_row in cursor.fetchall():
|
|
row_dict = dict(zip(column_names, cursor_row))
|
|
yield row_dict
|
|
|
|
|
|
# select first name, last name from all presidents
|
|
num_recs = c.execute('''
|
|
select lastname, firstname
|
|
from presidents
|
|
''')
|
|
|
|
for row in row_as_dict(c):
|
|
print(row['firstname'], row['lastname'])
|