def set_country():
session = Session()
for follower in session.query(Follower).order_by(Follower.user_id):
if hasattr(follower, 'latitude') and hasattr(
follower, 'longitude') and follower.country is None:
country = locate_country(follower.latitude, follower.longitude)
if country:
follower.country = country
session.commit()
def with_country():
session = Session()
for follower in session.query(Follower).filter(
Follower.country != None).all():
print follower.country
count = session.query(Follower.country, func.count(
Follower.country)).group_by(Follower.country).all()
for el in count:
print el[0], el[1]
def load_geos_test():
session = Session()
for follower in session.query(Follower).order_by(Follower.user_id):
follower.geotag = get_geos(follower.user_id)
session.commit()
def test_func():
session = Session()
for follower in session.query(Follower).all():
print follower
def followers_from_db():
session = Session()
return session.query(Follower).order_by(Follower.user_id)
from sqlalchemy.orm import mapper
from lib import get_followers
from lib import get_geos
from follower import Follower
from instadb import geo_table
from instadb import Session
session = Session()
followed_by = get_followers('1921850126')
# mapper(Follower, geo_table)
# fill db with followers, step 1
for follower in followed_by:
print follower.id
session.add(Follower(user_id=follower.id))
session.commit()
#TODO fill DB with GEOS
# get_geos_for_followers(followed_by)
for follower in session.query(Follower).order_by(Follower.user_id):
location = get_geos(follower.user_id)
# if hasattr(location, 'id'):
# follower.location_id = location.id
if hasattr(location, 'point'):
if (location.point != None):
follower.latitude = location.point.latitude
follower.longitude = location.point.longitude
