Python build_engine Examples

Example #1

File: populate_baseball_dbase.py Project: andrewkittredge/baseball_stats_schema

def main():
    global db_password
    db_password = sys.argv[1]

    engine = sql_alchemy_utils.build_engine(db_password)
    session = sql_alchemy_utils.build_session(engine)

    for player, stats in get_all_player_stats():
        if stats: #Batters only, not getting pitchers now.
            write_player_and_stats(session, player, stats)

    return 0

Example #2

File: baseball_stats_models.py Project: andrewkittredge/baseball_stats_schema

def reload_schema(db_password):
    engine = build_engine(db_password)
    Base.metadata.bind = engine
    Base.metadata.drop_all()
    Base.metadata.create_all()

Example #3

File: baseball_stats_models.py Project: andrewkittredge/baseball_stats_schema

def load_schema():
    engine = build_engine(db_password)
    Base.metadata.create_all(engine)