Object Oriented Data Manipulation Language (OODML)

Object Oriented Data Manipulation Language (OODML) provides a Common Lisp Object System (CLOS) interface to SQL databases. View classes are defined with the OODDL interface and objects are read and written with the OODML.

The main function for reading data with the OODML is the select function. The select is also used in the FDML. However, when select is given a view class name, it returns a list of instances of view classes.

View class instances can be updated to reflect any changes in the database with the functions update-slot-from-record and update-instance-from-records.

To update the database to reflect changes made to instances of view classes, use the functions update-records-from-instance, update-record-from-slot, and update-record-from-slots.

The function delete-instance-records deletes the records corresponding to an instance of a view class.

Table of Contents

*DB-AUTO-SYNC* — Enables SQL storage during Lisp object creation.
*DEFAULT-CACHING* — Controls the default caching behavior.
*DEFAULT-UPDATE-OBJECTS-MAX-LEN* — The default maximum number of objects each query to perform a join
INSTANCE-REFRESHED — User hook to call on object refresh.
DELETE-INSTANCE-RECORDS — Delete SQL records represented by a View Class object.
UPDATE-RECORDS-FROM-INSTANCE — Update database from view class object.
UPDATE-RECORD-FROM-SLOT — Updates database from slot value.
UPDATE-RECORD-FROM-SLOTS — Update database from slots of view class object.
UPDATE-INSTANCE-FROM-RECORDS — Update slot values from database.
UPDATE-SLOT-FROM-RECORD — Update objects slot from database.
UPDATE-OBJECTS-JOINS — Updates joined slots of objects.