14.4.3.1 Examples

[select 'employee]

--> #<SQL-OBJECT-QUERY (EMPLOYEE)>

(select 'employee 

        :where [= [slot-value 'employee 'employee-job]

                  "SALESMAN"])

((#<db-instance EMPLOYEE 8067092>) 

 (#<db-instance EMPLOYEE 8069536>)

 (#<db-instance EMPLOYEE 8069176>))

(list-classes)

(#<db-class EMPLOYEE> #<db-class DEPARTMENT>)

In the following generic functions, instance is an instance of a def-view-class representing a record in a database.

update-records-from-instance

Generic function

Updates the record in database represented by instance . If the instance is already associated with a database, that database is used and database is ignored. If instance is not yet associated with a database, a record is created for instance in the appropriate table of database and the instance becomes associated with that database.

update-record-from-slot

Generic function

update-record-from-slots

Generic function

Updates the individual data item from slot or list of slots for instance . As with update-records-from-instance , database is only used if instance is not yet associated with a database, in which case a record is created in database . Only slot or slots are initialized in this case; other columns in the underlying database receive default values. Slots are the CLOS slot names; the corresponding column names are derived from the view class definition.

delete-instance-records

Generic function

Deletes the records represented by instance from the database associated with it. If instance has no associated database, delete-instance-records signals an error.