Skip to content

Home

Introduction

Development

IDEs

Services

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 commands.

Under sqlServices.sql of 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 provided Gloop SQL services.

Related articles

Please see the following articles for more information:

Try it!

Under the Navigator, expand the examples package and navigate to the code folder. Afterwards, look for the sqlServices package. This package contains files and directories 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 via the AdditionalData suffix. Different database servers 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 the database. Open and run the services under sqlServices.invoke to see how other Gloop services can invoke Gloop SQL services to perform database operations.