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: 8 814
Version BonitaBPM Version Post date Download Link to content
1.10.0 7.12.x, 7.11.x, 7.10.x, 7.9.x, 7.8.x 2021-Aug-26 Download
355 downloads
Release note
1.9 7.12.x, 7.11.x, 7.10.x, 7.9.x 2021-May-06 Download
402 downloads
Release note
1.8.1 7.11.x, 7.10.x, 7.9.x, 7.8.x 2021-Jan-13 Download
418 downloads
Release note
1.7.0 7.11.x, 7.10.x, 7.9.x, 7.8.x 2020-Sep-04 Download
478 downloads
Release note
1.6.3 7.9.x 2019-Oct-16 Download
552 downloads
Release note
1.6.2 7.7.x 2018-Nov-30 Download
759 downloads
Release note
1.6 7.7.x, 7.6.x, 7.5.x 2018-Aug-15 Download
605 downloads
Release note
1.3 7.6.x, 7.5.x, 7.4.x, 7.3.x, 7.2.x 2017-Dec-12 Download
930 downloads
Release note
1.2 7.x 2016-Dec-08 Download
1553 downloads
Release note
1.1 7.3.x, 7.2.x 2016-Nov-02 Download
1322 downloads
Release note
1.0 7.x 2016-Oct-01 Download
1440 downloads
Release note
Notifications