def addcrime(crime,rawaddress,city,department,crimedate,crimetime):
c = crimes()
a = addresses()
_crimetime = crimetime.split('-')[0].split(' ')[0]
_ampm = crimetime.split('-')[0].split(' ')[1]
if _ampm == "p.m.":
_crimetime = "{0}:{1}:00".format(int(_crimetime.split(':')[0])+12,_crimetime.split(':')[1])
d = crimedate.split('/')
_crimedate = "{0}-{1}-{2}".format(d[2],d[0],d[1])
fulladdress = ""
lat = 0
lng = 0
zipcode = ""
if True:
#if c.checkexists(crime,rawaddress,city,department,_crimedate,_crimetime) == False:
valid,fulladdress,lat,lng,zipcode = a.getbyrawaddress(rawaddress)
if valid == False:
_address = "{0}, {1}, NY".format(rawaddress,city)
_json = geocodemq(_address)
_fulladdress,lat,lng,zipcode = pulldata(_json)
fulladdress = "{0}{1}".format(rawaddress,_fulladdress)
#if(crimedate.split('/')[2] == "2013"):
#json = geocode("{0},{1}, NY".format(rawaddress,city))
#f _json['status'] != 'OK':
# raise Exception("Google API says 'NO MORE!'")
#ulladdress = _json['results'][0]['formatted_address']
#at = _json['results'][0]['geometry']['location']['lat']
#ng = _json['results'][0]['geometry']['location']['lng']
#ipcode = ""
#or comp in _json['results'][0]['address_components']:
# if comp['types'][0] == "postal_code":
# zipcode = comp['long_name']
# break
print "adding: {0},{1},{2},{3},{4},{5},{6},{7},{8},{9}".format(crime,rawaddress,fulladdress,lat,lng,zipcode,city,department,_crimedate,_crimetime)
c.add(crime,rawaddress,fulladdress,lat,lng,zipcode,city,department,_crimedate,_crimetime)
a.add(rawaddress,fulladdress,lat,lng,zipcode)
else:
print "crime already saved, ignoring ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9})".format(crime,rawaddress,fulladdress,lat,lng,zipcode,city,department,_crimedate,_crimetime)
raise Exception("Debug, Stop.")
