Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

GSQL supports easier access to databases using Groovy.

Groovy supports a few neat ways to work with SQL more easily and to make SQL more Groovy.
You can perform queries and SQL statements, passing in variables easily with proper handling of statements, connections and exception handling thanks to closures.

In the above example, you can refer to the various columns by name, using the property syntax on the row variable (e.g. it.name) or you can refer to the columns by their index (e.g. it0) For example

Or you can create a DataSet which allows you to query SQL using familar closure syntax so that the same query could work easily on in memory objects or via SQL. e.g.

The source code can be found here :

  • Error rendering macro 'link' : Link needs a name and a URL as arguments.

Examples

Here's an example of using Groovy SQL along with

Error rendering macro 'link' : Link needs a name and a URL as arguments.
.

This could generate, dynamically something like

There's an example

Error rendering macro 'link' : Link needs a name and a URL as arguments.
all of these query mechanisms in action.

Stored procedure support

SqlGeneratorTest Example:

  • No labels