import pycurl
import csv
from mydb import cursor
from MySQLdb import escape_string

class Body:
    def __init__(self):
        self.contents = ''

    def gotData(self, buffer):
        self.contents = self.contents + buffer

try:
    csvfile = sys.argv[1]
except:
    print "Usage %s CSVfile" % sys.argv[0]
    sys.exit(1)

reader = csv.reader(open(csvfile, 'r'))

for row in reader:

   try:
        **(location_id, vrm, valid_datetime) =  [x.decode('utf-8-sig') for x in row ]**
    except:
        print "Error with row: " % row
        sys.exit(3)

    **# Hack for Peel
      if (location_id == 295):
        location_id = "295"**

   curl = pycurl.Curl()
    body = Body()

    payload = [("fn", "addWhitelistEntryValue"),
        ("firstname", "WL"),
        ("surname", "USER"),
        ("vrm", vrm.encode('ascii', 'ignore')),
        ("locId", location_id.encode('ascii', 'ignore'))
        ]
    print payload