places.py

import populartimes
from datetime import datetime
from itertools import cycle
from sqlalchemy import create_engine, Column, Integer, DateTime, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
import time
import os


#Configure Database
if "DATABASE_URL" in os.environ:
        engine = create_engine(os.environ["DATABASE_URL"], max_overflow = -1)
else:
    with open("database.txt") as f:
        engine = create_engine(f.readline(), max_overflow = -1)
Session = sessionmaker(bind=engine)
Base = declarative_base()

class Entry(Base):
    __tablename__ = 'entries'
    __table_args__ = {'extend_existing': True}
    id = Column(Integer, primary_key=True)
    place_name = Column(String)
    place_id = Column(String)
    place_normal = Column(Integer)
    place_current_popularity = Column(Integer)
    created_ts = Column('created_on', DateTime, default=datetime.now)

    def __init__(self, place_name, place_id, place_normal,place_current_popularity):
        self.place_name = place_name
        self.place_id = place_id
        self.place_normal = place_normal
        self.place_current_popularity = place_current_popularity
Base.metadata.create_all(engine)

#populartimes.get_id(next(api_keys), "ChIJdRuke6ZXn0cRUxrxk9-6NFg")
#Iterate over Places
def api_call():
    #Enable Key Cycling
    with open("api_keys.txt") as f:
        api_keys = cycle([key.strip() for key in f.readlines()])

    place_ids = [
    "ChIJuVGxxf51nkcRwhxFwvIr7EM",
    "ChIJ4dic-71RqEcRZIsmE3K6r-0",
    "ChIJmY9JK6Ulv0cRkNik00YUhZU",
    "ChIJmZ8cBbbCuEcRecCyfQofums",
    "ChIJ4___HmbPCUcRN5Ub3P2ZfmQ",
    "ChIJ25xRQB9OqEcRiDCQLqrmcbA",
    "ChIJX34c7jLbmUcRhaEUxVf0H3w",
    "ChIJraB7riH4pkcRGXSvqsL52lM",
    "ChIJcaYkt1gXuUcRPhoGAkKO10k",
    "ChIJe9nAXKZXn0cRGUlOPBMiDIo",
    "ChIJDSw1eVUJvUcRWndDicZ7OLo",
    "ChIJext9rehXn0cRUISYYjjnrnE"
    ]
    session = Session()
    for x, place_id in enumerate(place_ids):

        time.sleep(80)
        try:
            key = next(api_keys)
            data = populartimes.get_id(key, place_id)
        except Exception as e:
            print(e)
            print("Error with key: " + key)
            continue
        print(data["name"])
        if "current_popularity" in data:
            entry = Entry(
                data["name"],
                data["id"],
                data["populartimes"][datetime.now().weekday()]["data"][datetime.now().hour],
                data["current_popularity"]
            )
            session.add(entry)
        else:
            print("No Popularity-Data for " + data["name"])
    session.commit()
    #Lets us know how many Calls we have made so far.
    print("There are now " + str(session.query(Entry).count()) + " Entries in the Database")
    session.close()