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 &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 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.