[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 instance &key database
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 instance slot &key database
update-record-from-slots instance slots &key database
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 instance
Deletes the records represented by instance from the database associated with it. If instance has no associated database, delete-instance-records
signals an error.