Page Gasoline : Rest SQL DataSource + Admin page

  • Register a SQL Query, then execute if via a REST CALL (useful in a Form or a Page) - no development
  • Handle multiple data sources
  • Check performance on execution
  • Configure access on each SQL request, one by one
  • Simulation mode: if you don't have access to the database on your development platform, use the simulation method

screenshoot_list.jpg

For each query, define an ID, a SQL request, an explanation, a datasource. A Delay can be include in the request, to verify how your form will handle a slow query.

screenshoot_query.jpg

Query can contains parameters : just reference it using the format " :" like select username from user_ where country = :countrycode

Then, give the parameters value in the REST CALL: queryid=12&countrycode=FR

screenshoot_RESTCALL.jpg

Category: 
Licence: 
LGPL v3

Downloads

Total downloads: 4 463
Version BonitaBPM Version Post date Download Link
1.7.0 7.11.x, 7.10.x, 7.9.x, 7.8.x 2020-Sep-04 Download
19 downloads
Release note
1.6.3 7.9.x 2019-Oct-16 Download
151 downloads
Release note
1.6.2 7.7.x 2018-Nov-30 Download
210 downloads
Release note
1.6 7.7.x, 7.6.x, 7.5.x 2018-Aug-15 Download
269 downloads
Release note
1.3 7.6.x, 7.5.x, 7.4.x, 7.3.x, 7.2.x 2017-Dec-12 Download
594 downloads
Release note
1.2 7.x 2016-Dec-08 Download
1197 downloads
Release note
1.1 7.3.x, 7.2.x 2016-Nov-02 Download
974 downloads
Release note
1.0 7.x 2016-Oct-01 Download
1049 downloads
Release note
Notifications