class Oracle: def __init__(self, db_section, sync_section): self.c = ConfigDAO() self.db_section = db_section self.sync_section = sync_section self.conn = OracleDAO(self.c.config.get(db_section, "uri"), self.c.config.get(db_section, "username"), self.c.config.get(db_section, "password")) self.conn.execute_results_blob_as_bytes = True def load(self): if self.c.config.get(self.sync_section, "from query"): sql = self.c.config.get(self.sync_section, "from query") return self.conn.execute(sql) if self.c.config.get(self.sync_section, "from query file"): path = self.c.config.get(self.sync_section, "from query file") sql = FileDAO.read(path) Debug(sql) return self.conn.execute(sql) raise Exception("'from query' or 'from query file' must be defined")
class Oracle: def __init__(self, db_section, sync_section): self.c = ConfigDAO() self.db_section = db_section self.sync_section = sync_section self.conn = OracleDAO(self.c.config.get(db_section, "uri"), self.c.config.get(db_section, "username"), self.c.config.get(db_section, "password")) self.conn.execute_results_blob_as_bytes = True def load(self): return self.conn.execute(self.c.config.get(self.sync_section, "from query"))