def insert_overwrite_history(): engine = create_engine( f"postgresql://{config['db_username']}:{config['db_password']}@{config['db_host']}:{config['db_port']}/{config['db_name']}" ) df = get_p2p_overall_dataframe(all_dates_since_last_month(today())) df.to_sql("p2p_migration", engine, if_exists="replace", index=False, method="multi")
def insert_latest(): engine = create_engine( f"postgresql://{config['db_username']}:{config['db_password']}@{config['db_host']}:{config['db_port']}/{config['db_name']}" ) df = get_p2p_overall_dataframe() df.to_sql("p2p_migration", engine, if_exists="append", index=False, method="multi")
def insert_latest(): engine = create_engine( f"postgresql://{config['db_username']}:{config['db_password']}@{config['db_host']}:{config['db_port']}/{config['db_name']}" ) session_fact = sessionmaker(bind=engine) session = session_fact() last_sql_date = session.execute("SELECT MAX(m_date) from p2p_migration" ).fetchall()[0][0].strftime('%Y%m%d') print(last_sql_date) df = get_p2p_overall_dataframe( from_date_to_date(last_sql_date, yesterday())) print(df) df.to_sql("p2p_migration", engine, if_exists="append", index=False, method="multi")