diff V2/runme.py @ 6:3d5ca8e78f8f

update to pDOB parsing, fixing some bugs

--- a/V2/runme.py	Mon Dec 11 13:23:54 2017 +0000
+++ b/V2/runme.py	Mon Dec 18 17:41:16 2017 +0000
@@ -5,27 +5,31 @@
 import time
 import csv
 import random
+import pdb
+import os
+import pickle
 from HTMLParser import HTMLParser
 # from lxml import html
 from bs4 import BeautifulSoup
 
 def parsePage(resp):
+	# pdb.set_trace()
+	person = dict()
 	soup = BeautifulSoup(resp.content, 'lxml')
 	tcCell = soup.find_all('div', attrs={'class':'tc'})
 	for cell in tcCell:
-		person = dict()
 		tableCell = cell.find_all('td');
 		if len(tableCell) > 2:
 			C = tableCell[0].strong.contents[0].encode('utf-8')
 			D = tableCell[2].strong.contents[0].encode('utf-8')
-			print (C,D)
+			# print (C,D)
 			A = re.search("\/>(.*)<br/>.*\(([0-9]*)\\xc2\\xb0([0-9]*)(.*)\)",str(tableCell[1]))
 			# A0 = A.group(1)
 			# A1 = A.group(2).split('\xc2\xb0')[0]
 			# A2 = A.group(2).split('\xc2\xb0')[1].split('\xe2')[0]
-			print (A.group(1),A.group(2),A.group(3))
+			# print (A.group(1),A.group(2),A.group(3))
 			person[(C,D)] = (A.group(1),A.group(2),A.group(3))
-		return person
+	return person
 
 
 def setURL(p):
@@ -41,14 +45,8 @@
 	# url = "https://horoscopes.astro-seek.com/calculate-love-compatibility/?send_calculation=1&muz_narozeni_den=1&muz_narozeni_mesic=1&muz_narozeni_rok=1970&muz_narozeni_hodina=00&muz_narozeni_minuta=00&muz_narozeni_city=London%2C+United+Kingdom&muz_narozeni_mesto_hidden=London&muz_narozeni_stat_hidden=GB&muz_narozeni_podstat_kratky_hidden=England&muz_narozeni_podstat_hidden=England&muz_narozeni_podstat2_kratky_hidden=Greater+London&muz_narozeni_podstat3_kratky_hidden=undefined&muz_narozeni_input_hidden=&muz_narozeni_sirka_stupne=51&muz_narozeni_sirka_minuty=30&muz_narozeni_sirka_smer=0&muz_narozeni_delka_stupne=0&muz_narozeni_delka_minuty=8&muz_narozeni_delka_smer=1&muz_narozeni_timezone_form=auto&muz_narozeni_timezone_dst_form=auto&send_calculation=1&zena_narozeni_den=1&zena_narozeni_mesic=1&zena_narozeni_rok=1970&zena_narozeni_hodina=00&zena_narozeni_minuta=00&zena_narozeni_city=Berlin%2C+Germany&zena_narozeni_mesto_hidden=Berlin&zena_narozeni_stat_hidden=DE&zena_narozeni_podstat_kratky_hidden=Berlin&zena_narozeni_podstat_hidden=Berlin&zena_narozeni_podstat2_kratky_hidden=undefined&zena_narozeni_podstat3_kratky_hidden=undefined&zena_narozeni_input_hidden=&zena_narozeni_sirka_stupne=52&zena_narozeni_sirka_minuty=31&zena_narozeni_sirka_smer=0&zena_narozeni_delka_stupne=13&zena_narozeni_delka_minuty=24&zena_narozeni_delka_smer=0&zena_narozeni_timezone_form=auto&zena_narozeni_timezone_dst_form=auto&switch_interpretations=0&house_system=placidus&uhel_orbis=#tabs_redraw"
 	# payload = {'muz_narozeni_den':'1','muz_narozeni_mesic':'1','muz_narozeni_rok':'1970'}
 	url = 'https://horoscopes.astro-seek.com/calculate-love-compatibility/'
-	mDay = random.randint(1,29)
-	mMonth = random.randint(1,12)
-	mYear = random.randint(1,100)+1917
-	fDay = random.randint(1,29)
-	fMonth = random.randint(1,12)
-	fYear = random.randint(1,100)+1917
-
-	payload = {'?send_calculation':'1','muz_narozeni_den':mDay,'muz_narozeni_mesic':mMonth,'muz_narozeni_rok':mYear,'zena_narozeni_den':fDay,'zena_narozeni_mesic':fMonth,'zena_narozeni_rok':fYear}
+	# payload = {'send_calculation':'1','muz_narozeni_den':mDay,'muz_narozeni_mesic':mMonth,'muz_narozeni_rok':mYear,'zena_narozeni_den':fDay,'zena_narozeni_mesic':fMonth,'zena_narozeni_rok':fYear}
+	payload = dp.makePayload(p)
 	return (url,payload)
 
 def requestURL(url,payload):
@@ -56,40 +54,81 @@
 	time.sleep(5)
 	return r
 
-# def parseCSV(filename):
-# 	stream = csv.DictReader(open(filename,'rb'))
-# 	dictList = []
-# 	for line in stream:
-# 		dictList.append(regulateData(line))
+def makeURLPayload(url,payload):
+	url += '?'
+	for p in payload:
+		url += '&' + str(p)
+		url += '=' + str(payload[p])
+	return url
 
-# 	# dictList = headerParse(dictList)
-# 	# dictList = validateData(dictList)
-# 	return dictList
-
-def printToFile(filename,data):
+def printToFile(filename,data,removeAdds):
+	if removeAdds == True:
+		del data['DOB']
+		del data['TOB']
+		del data['pDOB']
+		del data['pTOB']
+		del data['COB']
+		del data['pCOB']
+		del data['horiscope']
 	keys = data[0].keys()
 	with open(filename,'w') as stream:
 		dict_writer = csv.DictWriter(stream, keys)
 		dict_writer.writeheader()
 		dict_writer.writerows(data)
 
+def loadPick(filename):
+	with open(filename, 'rb') as handle:
+		b = pickle.load(handle)
+	return b
+
+def savePick(filename,data):
+	with open(filename, 'wb') as handle:
+		pickle.dump(data,handle)
+
+def tempPF(fName,data):
+	f__ = open(fName,'w')
+	f__.write(data)
+	f__.close()
+
 def testMain():
 	people = dp.parseCSV('individuals.csv')
 
 def _main():
+	pickFile = 'outData.pick'
 	# people = dict()
-	people = dp.parseCSV('individuals.csv')
+	if not os.path.exists(pickFile):
+		print 'reParse file'
+		people = dp.parseCSV('individuals.csv')
+		savePick(pickFile,people)
+	else:
+		print 'read in ' + pickFile
+		people = loadPick(pickFile)
+
 	horiscopeList = []
-	# people = [1,2,3,4,5]
 	for person in people:
-		print 'parsing person '+ person['ID']
-		url,payload = setURL('')
-		resp = requestURL(url,payload)
-		
-		person['horiscope'] = parsePage(resp)
-		horiscopeList.append(person)
+		if person['pDOB'] is None or person['pDOB'] == '':
+			print 'SKIPPING person '+ person['ID'] + ' pDOB is None'
+		else:
+			print 'parsing person '+ person['ID']
+			url,payload = setURL(person)
+			resp = requestURL(url,payload)
+			person['horiscope'] = parsePage(resp)
+			if not person['horiscope']: # debug if dict is empty
+				print 'attempt failed,  try again'
+				url,payload = setURL(person)
+				resp = requestURL(url,payload)
+				person['horiscope'] = parsePage(resp)
+				if not person['horiscope']:
+					print 'attempt two failed'
+					# pdb.set_trace()
+			for d in person['horiscope'].keys():
+				person[d] = person['horiscope'][d]
+			horiscopeList.append(person)
+			savePick(pickFile,person)
 	print horiscopeList
-	printToFile('outputdata.csv',horiscopeList)
+	savePick(pickFile,person)
+	savePick('2'+pickFile,horiscopeList)
+	printToFile('final_'+outFile,horiscopeList)
 
 if __name__ == "__main__":
-	testMain()
+	_main()