#! /usr/bin/python
__author__="J Dean Brock"

import sqlite3
import sys

def listfriendsof(friend):
    sqlDBname = 'social.sqlite3'
    sqlDBquery = """SELECT B.name
     FROM Highschooler A, Highschooler B, Friend F
     WHERE A.ID = F.ID1 AND B.ID = F.ID2 AND A.name = ? ;"""

    try:
        conn = sqlite3.connect(sqlDBname)
    except sqlite3.Error as e:
        print 'Connection to {0} failed'.format(sqlDBname)
        print e.args[0]
        return
    friendtuples = [(friend)] ;
    print 'Friends of {0}'.format(friend)
    for row in conn.execute(sqlDBquery, [(friend)]):
        print '   {0}'.format(row[0])

if __name__ == "__main__":
    if len(sys.argv)<=1:
        print 'Get a friend'
    else:
        listfriendsof(sys.argv[1])