Next Prev Up Top Contents Index

15.4.3 Object-Oriented Data Manipulation Language (OODML)

The OODML is designed to be powerful and expressive, while remaining familiar to users of the FDML. To achieve this aim, some of the functions and macros in the SQL interface have been overloaded -- particularly the select function and the iteration constructs.

list-classes

Function

list-classes &key database

The list-classes function returns a list of the class objects of the CLOS classes which have been defined by def-view-class for database .

select

Function

select selections
 &rest args
 &key all
 set-operation
 distinct
 from
 where
       group-by
 having
 order-by
 database

The select function is common across the both the functional and object-oriented SQL interfaces. If selections refers to a view class by supplying its symbolic name then the select operation becomes object-oriented -- returning a list of instances instead of a list of attributes. The symbol slot-value is a valid SQL operator for use within the where clause.

15.4.3.1 Examples

15.4.3.2 Iteration


LispWorks User Guide - 14 Dec 2001

Next Prev Up Top Contents Index