#!/usr/bin/env python
from contextlib import closing
import pymysql


with closing(pymysql.connect(
    host="localhost",
    db="presidents",
    user="scripts",
    passwd="scripts"
)) as myconn:
    mycursor = myconn.cursor()

    for party_name in 'Whig', 'Federalist':
        print(party_name.upper() + ':')

        mycursor.execute('''
        select lastname, firstname
        from presidents
        where party = %s
        ''', party_name)

        print(mycursor.fetchall())
        print()
        print(mycursor.description)

        # for row in mycursor.fetchall():
        #     print(row)
        # print('-' * 60)
