Support the creation of JSON Data Services using JDBC queries

amila avataramila created an issue

A nice to have feature would be to quickly create JSON Data Services using JDBC queries specified as simple SQL

For example, one should be able to define the following pattern for a URL, and specify an SQL query that will provide the result. The result should be qutomatically converted into JSON. In future, this should support XML and other message formats as well

"/getPermanentEmployees" -> "select * from employee where permanent = 1" "/getTaxPayers" -> "select * from employee where salary > 20000" "/getEmployee?{id:INTEGER}" -> "select * from employee where employeeId = :id" "/byDeptAndDivision/{department:INTEGER}/{division:INTEGER}?{age:INTEGER},{sex:VARCHAR}" -> "select * from employee where division = :division and department = :department and sex = :sex and age > :age" "/{id:INTEGER}" -> "select * from employee where employeeId = :id"

Comments (1)

  1. Log in to comment
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.