Skip to content

Overview

Development

Overview

IDEs

API Explorer

examples Package: Using Gloop SQL Services

Introduction

Gloop SQL services are special Gloop services that specifically perform SQL operations.

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

Related articles

Please see the following articles for more information:

Try It!

Under the Coder Navigator, expand the examples package entry 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 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.