def properties(self, server_group_id, server_id, database_id, external_table_id): try: response = Properties( render_template, self.connection, self.sql_template_path).retrieve(external_table_id) return make_response(response=response, status=200) except PropertiesTableNotFoundException: return make_json_response( data=gettext('Could not find the external table.'), status=404) except PropertiesException as exception: return exception.response_object
def properties(self, server_group_id, server_id, database_id, external_table_id): try: response = Properties(render_template, self.connection, self.sql_template_path).retrieve( external_table_id) return make_response( response=response, status=200) except PropertiesTableNotFoundException: return make_json_response( data=gettext('Could not find the external table.'), status=404 ) except PropertiesException as exception: return exception.response_object
def sql(self, server_group_id, server_id, database_id, external_table_id): """ This function will used to create all the child node within that collection. Here it will create all the foreign data wrapper node. Args: server_group_id: Server Group ID server_id: Server ID database_id: Database ID external_table_id: External Table ID """ sql = ReverseEngineerDDL(self.sql_template_path, render_template, self.connection, server_group_id, server_id, database_id).execute(external_table_id) return make_response(sql.strip('\n'))
def status(pid, out=-1, err=-1): """ Check the status of the process running in background. Sends back the output of stdout/stderr Fetches & sends STDOUT/STDERR logs for the process requested by client Args: pid: Process ID out: position of the last stdout fetched err: position of the last stderr fetched Returns: Status of the process and logs (if out, and err not equal to -1) """ try: process = BatchProcess(id=pid) return make_response(response=process.status(out, err)) except LookupError as lerr: return gone(errormsg=str(lerr))
def sql(self, server_group_id, server_id, database_id, external_table_id): """ This function will used to create all the child node within that collection. Here it will create all the foreign data wrapper node. Args: server_group_id: Server Group ID server_id: Server ID database_id: Database ID external_table_id: External Table ID """ sql = ReverseEngineerDDL(self.sql_template_path, render_template, self.connection, server_group_id, server_id, database_id).execute(external_table_id) return make_response( sql.strip('\n') )
def index(): return make_response(response=BatchProcess.list())