def _add_table(session, url, name): try: import_datafiles([url], True, name, None, PGMethods, **settings.DBSETTINGS) except: traceback.print_exc() execute_state_machine(db_session, name)
def import_file_w_dbtruck(self, table_name, file_path): from dbtruck.dbtruck import import_datafiles from dbtruck.util import get_logger from dbtruck.exporters.pg import PGMethods dbsettings = { 'dbname': self.repo_base, 'hostname': self.host, 'username': self.user, 'password': self.password, 'port': self.port, } create_new = True errfile = None return import_datafiles([file_path], create_new, table_name, errfile, PGMethods, **dbsettings)
def import_file_w_dbtruck(self, table_name, file_path): # dbtruck is not tested for safety. At all. It's currently disabled # in the project RogerTangos 2015-12-09 from dbtruck.dbtruck import import_datafiles # from dbtruck.util import get_logger from dbtruck.exporters.pg import PGMethods dbsettings = { 'dbname': self.repo_base, 'hostname': self.host, 'username': self.user, 'password': self.password, 'port': self.port, } create_new = True errfile = None return import_datafiles([file_path], create_new, table_name, errfile, PGMethods, **dbsettings)