Advertisement
12311k

Untitled

Mar 18th, 2020
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. for table_name, table_data in tables.items():
  2. query = '''
  3. DELETE FROM {} WHERE year_of_release BETWEEN '{}'::TIMESTAMP AND '{}'::TIMESTAMP
  4. '''.format(table_name, start_dt, end_dt)
  5. engine.execute(query)
  6.  
  7. table_data.to_sql(name=table_name, con=engine, if_exists='append', index=False)
  8.  
  9. print('All done.')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement