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 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())
def index():
return make_response(response=BatchProcess.list())
