DSApi (Database APIs)

This section described database APIs. Each database API is a static method of a Java class called DSApi.

Some database APIs take a special parameter called auditMsg. It is optional. It is used to create an audit-log of database operations. When it is provided its behavior is as follows:

• If auditMsg is non-blank then the provided string is logged into a special table called AuditLog_tbl.

• If auditMsg is provided buts its value in an empty string or a string with the value "true", the system generates the log message which corresponds to the operation. For example, "Deleted <id of the record>.

• Each log message has a timestamp, user-id of the user if the operation is performed in the context of a user.

Each database API is a static method of a special Java class called DSApi.

Primary Key

Each table created using Trillo Workbench creates the following columns. Each column except the id column is optional (can be removed). The column id is required for all newly created tables. Its type is BigInteger and it is auto-assigned by the database.

The list of columns (attributes assigned to the class) automatically created for a table is as follows:

Name	Type	Description
id	BigInteger	The primary key of record, auto-assigned
createdAt	BigInteger	The time of the creation of the record in UTC (epoch)
updatedAt	BigInteger	The time the record was updated last.
deleted	Boolean	Trillo APIs "delete" do not delete a record. They mark the record as deleted. APIs A flag to indicate this record is logically deleted. It will be opaque in all queries and API unless a special flag is used to included deleted items.
deletedAt	BigInteger	The time the record was deleted.