class FullContact_Client:
def __init__(self):
self.fc = FullContact('ab76dbb1c4b8c50f')
def searchbyemail(self, email):
return self.fc.get(email=email)
def get_identity(config, email):
fc = FullContact(config['FC_KEY'])
db = divan.Database(config['DB_URI'],
config['DB_NAME'],
auth=(config['DB_USER'],
config['DB_PASS']))
try:
res = db.get_or_create()
assert res.status_code in [200, 201]
except AssertionError:
return res.status_code, res.json()
else:
res = db.get(email)
if res.status_code == 200:
return res.status_code, res.json()
else:
profile = fc.get(email=email)
if profile['status'] == 200:
profile['_id'] = email
res = db.post(params=profile)
return res.status_code, profile
else:
return profile['status'], profile
def hello():
first_name = request.form['firstName']
last_name = request.form['lastName']
company_url = request.form['companyUrl']
source = "Ad Hoc"
api_key = "ddb2740f8d2338c78497519c13cc7076"
params = {
'key': api_key,
'domain': company_url,
'first': first_name,
'last': last_name
}
toofr_url = "http://toofr.com/api/guess?"
test = requests.get(toofr_url, params=params)
toofr_data = test.json()
try:
toofr_email = toofr_data['response']['email']
except:
toofr_email = None
try:
toofr_confidence = toofr_data['response']['confidence']
except:
toofr_confidence = None
toofr_data = pd.DataFrame(columns=('toofr_email', 'first_name',
'last_name', 'toofr_confidence',
'company_url', 'source'))
existing_records_final_links = len(toofr_data)
toofr_data.loc[existing_records_final_links] = [
toofr_email, first_name, last_name, toofr_confidence, company_url,
source
]
toofr_data.to_sql("investor_toofr_data",
con=conn,
flavor='mysql',
if_exists='append',
index=False)
query = '''
select td.id,td.toofr_email as email
from investor_toofr_data td
having td.id = (select max(id)
from investor_toofr_data);'''
toofr_data = psql.read_frame(query, conn)
toofr_data_dict = {}
toofr_data_dict = toofr_data.set_index('id').to_dict()
toofr_data_dict = toofr_data_dict['email']
for key, value in toofr_data_dict.items():
fc = FullContact('76152464a239f71c')
print key, value
person_profile = fc.get(email=value)
if person_profile['status'] == 200:
rep_gender = None
rep_location = None
rep_klout_score = None
rep_klout_topic = None
rep_facebook_url = None
rep_facebook_followers = None
rep_facebook_following = None
rep_linkedin_url = None
rep_twitter_url = None
rep_twitter_followers = None
rep_twitter_following = None
rep_angellist_url = None
rep_angellist_followers = None
try:
rep_gender = person_profile['demographics']['gender']
except:
print 'gender_missing'
try:
rep_location = person_profile['demographics'][
'locationGeneral']
except:
print 'location_missing'
try:
rep_klout_score = person_profile['digitalFootprint']['scores'][
0]['value']
except:
print 'klout score missing'
try:
rep_klout_topic = person_profile['digitalFootprint']['topics'][
0]['value']
except:
print 'klout topic missing'
try:
rep_social_profiles = person_profile['socialProfiles']
if len(rep_social_profiles) > 0:
for i in xrange(0, len(rep_social_profiles)):
if rep_social_profiles[i]['typeName'] == 'Facebook':
try:
rep_facebook_url = rep_social_profiles[i][
'url']
except:
print 'facebook url missing'
try:
rep_facebook_followers = rep_social_profiles[
i]['followers']
except:
print 'facebook followers missing'
try:
rep_facebook_following = rep_social_profiles[
i]['following']
except:
print 'facebook following missing'
if rep_social_profiles[i]['typeName'] == 'LinkedIn':
try:
rep_linkedin_url = rep_social_profiles[i][
'url']
except:
print 'linkedin url missing'
if rep_social_profiles[i]['typeName'] == 'Twitter':
try:
rep_twitter_url = rep_social_profiles[i]['url']
except:
print 'twitter url missing'
try:
rep_twitter_followers = rep_social_profiles[i][
'followers']
except:
print 'twitter followers missing'
try:
rep_twitter_following = rep_social_profiles[i][
'following']
except:
print 'twitter following missing'
if rep_social_profiles[i]['typeName'] == 'AngelList':
try:
rep_angellist_url = rep_social_profiles[i][
'url']
except:
print 'angel list url missing'
try:
rep_angellist_followers = rep_social_profiles[
i]['followers']
except:
print 'angel list followers missing'
except:
print 'no social profile found'
data = pd.DataFrame(
columns=('toofr_id', 'rep_gender', 'rep_location',
'rep_klout_score', 'rep_klout_topic',
'rep_facebook_url', 'rep_facebook_followers',
'rep_facebook_following', 'rep_linkedin_url',
'rep_twitter_url', 'rep_twitter_followers',
'rep_twitter_following', 'rep_angellist_url',
'rep_angellist_followers'))
existing_records_final_links = len(data)
data.loc[existing_records_final_links] = [
key, rep_gender, rep_location, rep_klout_score,
rep_klout_topic, rep_facebook_url, rep_facebook_followers,
rep_facebook_following, rep_linkedin_url, rep_twitter_url,
rep_twitter_followers, rep_twitter_following,
rep_angellist_url, rep_angellist_followers
]
data = data.where(pd.notnull(data), None)
data.to_sql('fullcontact',
con=conn,
flavor='mysql',
if_exists='append',
index=False)
return render_template('form_action.html',
firstName=first_name,
lastName=last_name)
def hello():
first_name = request.form["firstName"]
last_name = request.form["lastName"]
company_url = request.form["companyUrl"]
source = "Ad Hoc"
api_key = "ddb2740f8d2338c78497519c13cc7076"
params = {"key": api_key, "domain": company_url, "first": first_name, "last": last_name}
toofr_url = "http://toofr.com/api/guess?"
test = requests.get(toofr_url, params=params)
toofr_data = test.json()
try:
toofr_email = toofr_data["response"]["email"]
except:
toofr_email = None
try:
toofr_confidence = toofr_data["response"]["confidence"]
except:
toofr_confidence = None
toofr_data = pd.DataFrame(
columns=("toofr_email", "first_name", "last_name", "toofr_confidence", "company_url", "source")
)
existing_records_final_links = len(toofr_data)
toofr_data.loc[existing_records_final_links] = [
toofr_email,
first_name,
last_name,
toofr_confidence,
company_url,
source,
]
toofr_data.to_sql("investor_toofr_data", con=conn, flavor="mysql", if_exists="append", index=False)
query = """
select td.id,td.toofr_email as email
from investor_toofr_data td
having td.id = (select max(id)
from investor_toofr_data);"""
toofr_data = psql.read_frame(query, conn)
toofr_data_dict = {}
toofr_data_dict = toofr_data.set_index("id").to_dict()
toofr_data_dict = toofr_data_dict["email"]
for key, value in toofr_data_dict.items():
fc = FullContact("76152464a239f71c")
print key, value
person_profile = fc.get(email=value)
if person_profile["status"] == 200:
rep_gender = None
rep_location = None
rep_klout_score = None
rep_klout_topic = None
rep_facebook_url = None
rep_facebook_followers = None
rep_facebook_following = None
rep_linkedin_url = None
rep_twitter_url = None
rep_twitter_followers = None
rep_twitter_following = None
rep_angellist_url = None
rep_angellist_followers = None
try:
rep_gender = person_profile["demographics"]["gender"]
except:
print "gender_missing"
try:
rep_location = person_profile["demographics"]["locationGeneral"]
except:
print "location_missing"
try:
rep_klout_score = person_profile["digitalFootprint"]["scores"][0]["value"]
except:
print "klout score missing"
try:
rep_klout_topic = person_profile["digitalFootprint"]["topics"][0]["value"]
except:
print "klout topic missing"
try:
rep_social_profiles = person_profile["socialProfiles"]
if len(rep_social_profiles) > 0:
for i in xrange(0, len(rep_social_profiles)):
if rep_social_profiles[i]["typeName"] == "Facebook":
try:
rep_facebook_url = rep_social_profiles[i]["url"]
except:
print "facebook url missing"
try:
rep_facebook_followers = rep_social_profiles[i]["followers"]
except:
print "facebook followers missing"
try:
rep_facebook_following = rep_social_profiles[i]["following"]
except:
print "facebook following missing"
if rep_social_profiles[i]["typeName"] == "LinkedIn":
try:
rep_linkedin_url = rep_social_profiles[i]["url"]
except:
print "linkedin url missing"
if rep_social_profiles[i]["typeName"] == "Twitter":
try:
rep_twitter_url = rep_social_profiles[i]["url"]
except:
print "twitter url missing"
try:
rep_twitter_followers = rep_social_profiles[i]["followers"]
except:
print "twitter followers missing"
try:
rep_twitter_following = rep_social_profiles[i]["following"]
except:
print "twitter following missing"
if rep_social_profiles[i]["typeName"] == "AngelList":
try:
rep_angellist_url = rep_social_profiles[i]["url"]
except:
print "angel list url missing"
try:
rep_angellist_followers = rep_social_profiles[i]["followers"]
except:
print "angel list followers missing"
except:
print "no social profile found"
data = pd.DataFrame(
columns=(
"toofr_id",
"rep_gender",
"rep_location",
"rep_klout_score",
"rep_klout_topic",
"rep_facebook_url",
"rep_facebook_followers",
"rep_facebook_following",
"rep_linkedin_url",
"rep_twitter_url",
"rep_twitter_followers",
"rep_twitter_following",
"rep_angellist_url",
"rep_angellist_followers",
)
)
existing_records_final_links = len(data)
data.loc[existing_records_final_links] = [
key,
rep_gender,
rep_location,
rep_klout_score,
rep_klout_topic,
rep_facebook_url,
rep_facebook_followers,
rep_facebook_following,
rep_linkedin_url,
rep_twitter_url,
rep_twitter_followers,
rep_twitter_following,
rep_angellist_url,
rep_angellist_followers,
]
data = data.where(pd.notnull(data), None)
data.to_sql("fullcontact", con=conn, flavor="mysql", if_exists="append", index=False)
return render_template("form_action.html", firstName=first_name, lastName=last_name)
