search_email.py

import sys

import dataset


filename = sys.argv[1].strip()

db = dataset.connect('mysql://user:password@localhost/ashley')
table = db['aminno_member_email']

with open(filename, 'r') as handle:
    for line in handle:
        line = line.strip()
        res = table.find_one(email=line)
        if res:
            print(res, res['pnum'])