def process(self, element):
db_args = dict(element)
table_name = db_args.pop('table_name')
db = SqlAlchemyDB(**db_args)
db.start_session()
try:
for record in db.read(table_name):
yield record
except:
raise
finally:
db.close_session()
class _WriteToRelationalDBFn(DoFn):
def __init__(self, source_config, table_config, *args, **kwargs):
super(_WriteToRelationalDBFn, self).__init__(*args, **kwargs)
self.source_config = source_config
self.table_config = table_config
def start_bundle(self):
self._db = SqlAlchemyDB(self.source_config)
self._db.start_session()
def process(self, element):
assert isinstance(element, dict)
self._db.write_record(self.table_config, element)
def finish_bundle(self):
self._db.close_session()
def start_bundle(self):
self._db = SqlAlchemyDB(self.source_config)
self._db.start_session()