Store

Simple Data Store functionality based on Hibernate framework.

Overview

• Module: db/store
• Definition: https://github.com/eclipse/dirigible/issues/2485
• Source: /db/store.js
• Status: beta
• Group: core

Basic Usage

ECMA6

import { store } from "sdk/db";
import { response } from "sdk/http";

let entry = { 'name': 'John', 'address': 'Sofia, Bulgaria' };

store.save('Customer', entry);

let list = store.list('Customer');

response.println(JSON.stringify(list));
response.flush();
response.close();

The Entity description in the Hibernate xml or json format (e.g. Customer.hbm.xml as XML or Customer.entity as JSON)

XML

<hibernate-mapping>

    <class entity-name="Customer">

        <id name="id" type="long" column="ID">
            <generator class="sequence" />
        </id>

        <property name="name" column="NAME" type="string" />

        <property name="address" column="ADDRESS" type="string" />

    </class>

</hibernate-mapping>

Functions

---

Function	Description	Returns
save(name, entry)	Save the entry in the collection with name	-
list(name)	List all the entris in the collection with name	Array of Objects
get(name, id)	Get the entry from the collection with name by its id	Object
deleteEntry(name, id)	Delete the entry from the collection with name by its id	-