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

import sqlite3
import sys

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

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

if __name__ == "__main__":
    listfriends()