import ast import pandas as pd import requests import time import traceback from sqlalchemy import * from sqlalchemy.orm import sessionmaker from sqlalchemy.ext.declarative import declarative_base import matplotlib import numpy as np import matplotlib.pyplot as plt import datetime import instaconfig instagram, database, search_tags = instaconfig.config() # Setup Tables and ORM engine = create_engine('mysql://%(user)s:%(pass)s@%(host)s' % database) # connect to server engine.execute('drop database %s' % database['name']) engine.execute('create database %s' % database['name']) # Select Database engine.execute('use %s' % database['name']) # select db # Build ORM Base = declarative_base()
import requests import csv import time from datetime import datetime, timedelta import traceback import instaconfig import isodate import sqlalchemy import pandas as pd instagram, database = instaconfig.config() # write list of posts to csv file, used below def read_write(result, writer): entries = [0, 0] for post in result['data']: try: if post['location'] is not None: if 'latitude' in post['location'].keys(): # some are missing row_dict = {'user_id': post['user']['id'], 'image_url': post['images']['standard_resolution']['url'], 'created_time': post['created_time'], 'lat': post['location']['latitude'], 'long': post['location']['longitude'], 'post_url': post['link'], 'id': post['id'], 'likes': post['likes']['count'] } # print datetime.fromtimestamp(int(post['created_time'])).isoformat() # add text if available