Skip to content

Home

Development

IDEs

API Explorer

Releases

Release notes

Martini Runtime

Martini Desktop

Martini Online

Feature requests

Bug reports

examples package: Using Gloop SQL services

Gloop SQL services are special Gloop services that execute SQL statements.

Under the sqlServices.sql code package in the examples package are example Gloop SQL services that demonstrate how to perform simple and batch SQL operations in Gloop. To show how Gloop SQL services work with regular Gloop services, some sample Gloop services are provided under sqlServices.invoke, which invoke the provided Gloop SQL services.

Related articles

Please see the following articles for more information:

Try it!

In the Navigator, expand the examples package and navigate to the code folder, then expand the sqlServices package. This package contains files and directories as shown below:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
examples
├── ...
└── code
    └── sqlServices
        ├── conf
        ├── invoke
        │   ├── multiple
        │   │   ├── InvokeMultipleAdditionalDataDelete.gloop
        │   │   ├── InvokeMultipleAdditionalDataInsert.gloop
        │   │   ├── InvokeMultipleAdditionalDataSelect.gloop
        │   │   ├── InvokeMultipleAdditionalDataUpdate.gloop
        │   │   ├── InvokeMultipleNameDelete.gloop
        │   │   ├── InvokeMultipleNameInsert.gloop
        │   │   ├── InvokeMultipleNameSelect.gloop
        │   │   ├── InvokeMultipleNameUpdate.gloop
        │   ├── single
        │      ├── InvokeSingleAdditionalDataDelete.gloop
        │      ├── InvokeSingleAdditionalDataInsert.gloop
        │      ├── InvokeSingleAdditionalDataSelect.gloop
        │      ├── InvokeSingleAdditionalDataUpdate.gloop
        │      ├── InvokeSingleNameDelete.gloop
        │      ├── InvokeSingleNameInsert.gloop
        │      ├── InvokeSingleNameSelect.gloop
        │      ├── InvokeSingleNameUpdate.gloop
        │   └── InsertNameWithAdditionalData.gloop
        ├── model
        └── sql
            ├── multiple
            │   ├── DeleteMultipleAdditionalData.gloop
            │   ├── DeleteMultipleNames.gloop
            │   ├── InsertMultipleAdditionalData.gloop
            │   ├── InsertMultipleNames.gloop
            │   ├── SelectMultipleAdditionalData.gloop
            │   ├── SelectMultipleNames.gloop
            │   ├── UpdateMultipleAdditionalData.gloop
            │   └── UpdateMultipleNames.gloop
            └── single
                ├── DeleteSingleAdditionalData.gloop
                ├── DeleteSingleName.gloop
                ├── InsertSingleAdditionalData.gloop
                ├── InsertSingleName.gloop
                ├── SelectSingleAdditionalData.gloop
                ├── SelectSingleName.gloop
                ├── UpdateSingleAdditionalData.gloop
                └── UpdateSingleName.gloop

BLOB and CLOB usage

Services that demonstrate BLOB and CLOB usage (in HSQL) are also included. You'll be able to tell which services these are as they have a a AdditionalData suffix on their names. Different database servers may handle BLOBS and CLOBS differently, so please refer to your chosen database server's documentation on how it handles BLOBs and CLOBs.

Open the services under sqlServices.sql to see how the SQL services are defined in order to perform CRUD operations against a database. Open and run the services under sqlServices.invoke to see how regular Gloop services can invoke Gloop SQL services to perform database operations.