@RestResource(path="/sql", title="SQL query service", description="Executes queries against the local derby \'$C{SqlQueryResource/connectionUrl}\' database", htmldoc=, swagger=) public class SqlQueryResource extends BasicRestServlet
Modifier and Type | Class and Description |
---|---|
static class |
SqlQueryResource.PostInput
The parsed form post
|
Constructor and Description |
---|
SqlQueryResource() |
Modifier and Type | Method and Description |
---|---|
Div |
get(String sql) |
void |
initConnection(RestContextBuilder builder)
Initializes the registry URL and rest client.
|
List<Object> |
post(SqlQueryResource.PostInput in) |
getOptions
destroy, getContext, getPath, getProperties, getRequest, getResponse, getServletConfig, init, log, log, log, log, logObjects, service, setContext, setRestResourceResolver
doDelete, doGet, doHead, doOptions, doPost, doPut, doTrace, getLastModified, service
public SqlQueryResource()
@RestHook(value=INIT) public void initConnection(RestContextBuilder builder) throws Exception
builder
- The resource config.Exception
@RestMethod(summary="Display the query entry page") public Div get(@Query(name="sql",description="Text to prepopulate the SQL query field with.",example="select * from sys.systables") String sql)
@RestMethod(summary="Execute one or more queries") @Response(description="Query results.\nEach entry in the array is a result of one query.\nEach result can be a result set (for queries) or update count (for updates).") public List<Object> post(@Body(description="Query input",example="{sql:\'select * from sys.systables\',pos:1,limit:100}") SqlQueryResource.PostInput in) throws BadRequest
BadRequest
Copyright © 2018 Apache. All rights reserved.