Skip to content

examples package: Using SQL services

SQL services are special services that execute SQL statements.

Under the sqlServices.sql code directory in the examples package are example SQL services that demonstrate how to perform simple and batch SQL operations in Gloop. To show how SQL services work with regular services, some sample services are provided under sqlServices.invoke, which invoke the provided 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 services can invoke Gloop SQL services to perform database operations.