INNER CODE UNIT · Python

end_time

KiranGershenfeld/VisualizingTwitchCommunities · AtlasGeneration/Python/Main.py:23

        end_time = start_time - datetime.timedelta(days=30)

        OM = OverlapsManager(start_time=start_time, end_time=end_time, db_url=os.environ.get("DB_URL"))
        OM.run()
        OM.dump_overlaps_to_db()

    #Get newest batch_id
    engine = sql.create_engine(os.environ.get("DB_URL"))
    metadata_obj = sql.MetaData()
    overlaps_table = sql.Table("channel_overlaps", metadata_obj, autoload_with=engine)
    
    stmt = sql.select(func.max(overlaps_table.c.batch_id))

    with engine.connect() as conn:
        res = conn.execute(stmt).fetchall()

    batch_id = res[0][0]
    print(batch_id)

View source record →