def write(self): print( f'Writing {len(self.rows):,} rows to {IpedsCharge.__tablename__} table in database.' ) session = Session() if len(self.rows) > 0: try: for row in self.rows: _ = session.query(IpedsCharge).filter( IpedsCharge.unitid == row.unitid, IpedsCharge.date_key == row.date_key).delete( synchronize_session=False) session.bulk_save_objects(self.rows) session.commit() except Exception as e: print(f'An error occurred:\n{str(e)}.') session.rollback() print('No changes were made to the database due to error.') else: print('Rows successfully written to database.') else: print('No rows were available to insert.') session.close()
def write(self): session = Session() if len(self.rows) > 0: try: _ = session.query(self.rows[0].__class__).filter(self.rows[0].__class__.date_key==self.date_key).delete(synchronize_session=False) session.bulk_save_objects(self.rows) session.commit() except Exception as e: print(f'An error occurred:\n{str(e)}.') session.rollback() print('No changes were made to the database due to error.') else: print('Rows successfully written to database.') else: print('No rows were available to insert.') session.close()