Advertisement
Guest User

Untitled

a guest
Feb 20th, 2020
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.37 KB | None | 0 0
  1.     #Удаляем старые записи между start_dt и end_dt
  2.     for table_data in(dash_engagement, dash_visits):
  3.       query = '''DELETE FROM table_data WHERE dt BETWEEN '{}'::TIMESTAMP AND '{}'::TIMESTAMP'''.format(start_dt, end_dt)
  4.       engine.execute(query)
  5.  
  6.       table_data.to_sql(name = table_data, con = engine, if_exists = 'append', index = False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement