X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Foodml.lisp;h=b570cedcbb96d6aa8e6ac9b10012ae33e47d2f71;hb=80c2194145d2cd215dd94f2dc71afee14719c194;hp=7bf7d5bf77db5adcb9bed1ca976ca7082a2afebb;hpb=29184a377bfebf51266104aadafc5fe422cbd791;p=clsql.git diff --git a/sql/oodml.lisp b/sql/oodml.lisp index 7bf7d5b..b570ced 100644 --- a/sql/oodml.lisp +++ b/sql/oodml.lisp @@ -287,23 +287,25 @@ :av-pairs record-values :database database) - (when pk-slot - (if (or (and (listp (view-class-slot-db-constraints pk-slot)) - (member :auto-increment (view-class-slot-db-constraints pk-slot))) - (eql (view-class-slot-db-constraints pk-slot) :auto-increment)) - (unless pk - (let ((db-pk (car (query "SELECT LAST_INSERT_ID();" - :flatp t :field-names nil - :database database)))) - (setf pk db-pk - (slot-value - obj (slot-definition-name pk-slot)) db-pk))) - - (setf pk (or pk - (slot-value - obj (slot-definition-name pk-slot)))))) + (when (and pk-slot (not pk)) + (setf pk (if (or (member :auto-increment (listify (view-class-slot-db-constraints pk-slot))) + (not (null (view-class-slot-autoincrement-sequence pk-slot)))) + (setf (slot-value obj (slot-definition-name pk-slot)) + (database-last-auto-increment-id database + table + pk-slot))))) + (setf pk (or pk + (slot-value + obj (slot-definition-name pk-slot))))) (when (eql this-class nil) - (setf (slot-value obj 'view-database) database))))))) + (setf (slot-value obj 'view-database) database)))))) + ;; handle slots with defaults + (dolist (slot slots) + (when (and (slot-exists-p slot 'db-constraints) + (listp (view-class-slot-db-constraints slot)) + (member :default (view-class-slot-db-constraints slot))) + (update-slot-from-record obj (slot-definition-name slot)))) + pk)) (defmethod delete-instance-records ((instance standard-db-object))