Skip to content

Overview

Concepts and Principles

Development

Overview

IDEs

API Explorer

Releases

Release Notes

TORO Integrate

Coder Studio

Coder Cloud

Bug Reports

Search

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 sample 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 are also included.

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.