- (mysql-types (mapcar 'clsql-type->mysql-type types))
- field-vec num-fields is-null-ptr output-bind length-ptr)
-
- (print 'a)
- (dotimes (i (length types))
- (let* ((binding (uffi:deref-array input-bind '(:array mysql-bind) i)))
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-type)
- (nth i mysql-types))
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-length) 0)))
-
- (print 'b)
- (unless (uffi:null-pointer-p rs)
- (setq field-vec (mysql-fetch-fields rs)
- num-fields (mysql-num-fields rs)
- is-null-ptr (uffi:allocate-foreign-object :byte num-fields)
- output-bind (uffi:allocate-foreign-object 'mysql-bind num-fields)
- length-ptr (uffi:allocate-foreign-object :unsigned-long num-fields))
- (dotimes (i num-fields)
- (declare (fixnum i))
- (let* ((field (uffi:deref-array field-vec '(:array mysql-field) i))
- (type (uffi:get-slot-value field mysql-field 'type))
- (binding (uffi:deref-array output-bind '(:array mysql-bind) i)))
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-type) type)
-
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-length) 0)
- #+need-to-allocate-foreign-object-for-this
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::is-null)
- (+ i (uffi:pointer-address is-null-ptr)))
- #+need-to-allocate-foreign-object-for-this
- (setf (uffi:get-slot-value binding 'mysql-bind 'length)
- (+ (* i 8) (uffi:pointer-address length-ptr)))
-
- (case type
- ((#.mysql-field-types#var-string #.mysql-field-types#string
- #.mysql-field-types#tiny-blob #.mysql-field-types#blob
- #.mysql-field-types#medium-blob #.mysql-field-types#long-blob)
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-length) 1024)
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
- (uffi:allocate-foreign-object :unsigned-char 1024)))
- (#.mysql-field-types#tiny
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
- (uffi:allocate-foreign-object :byte)))
- (#.mysql-field-types#short
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
- (uffi:allocate-foreign-object :short)))
- (#.mysql-field-types#long
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
- ;; segfaults if supply :int on amd64
- (uffi:allocate-foreign-object :long)))
- #+64bit
- (#.mysql-field-types#longlong
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
- (uffi:allocate-foreign-object :long)))
- (#.mysql-field-types#float
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
- (uffi:allocate-foreign-object :float)))
- (#.mysql-field-types#double
- (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
- (uffi:allocate-foreign-object :double)))
- ((#.mysql-field-types#time #.mysql-field-types#date
- #.mysql-field-types#datetime #.mysql-field-types#timestamp)
- (uffi:allocate-foreign-object 'mysql-time))
- (t
- (error "mysql type ~D not supported." type)))))
-
- (unless (zerop (mysql-stmt-bind-result stmt output-bind))
- (mysql-stmt-close stmt)
- (error 'sql-database-error
- :error-id (mysql-stmt-errno stmt)
- :message (uffi:convert-from-cstring
- (mysql-stmt-error stmt)))))
-
- (make-instance 'mysql-stmt
- :database database
- :stmt stmt
- :num-fields num-fields
- :input-bind input-bind
- :output-bind output-bind
- :result-set rs
- :result-types result-types
- :length-ptr length-ptr
- :is-null-ptr is-null-ptr
- :types mysql-types
- :field-names field-names)))))
+ (mysql-types (mapcar 'clsql-type->mysql-type types))
+ field-vec num-fields is-null-ptr output-bind length-ptr)
+
+ (print 'a)
+ (dotimes (i (length types))
+ (let* ((binding (uffi:deref-array input-bind '(:array mysql-bind) i)))
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-type)
+ (nth i mysql-types))
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-length) 0)))
+
+ (print 'b)
+ (unless (uffi:null-pointer-p rs)
+ (setq field-vec (mysql-fetch-fields rs)
+ num-fields (mysql-num-fields rs)
+ is-null-ptr (uffi:allocate-foreign-object :byte num-fields)
+ output-bind (uffi:allocate-foreign-object 'mysql-bind num-fields)
+ length-ptr (uffi:allocate-foreign-object :unsigned-long num-fields))
+ (dotimes (i num-fields)
+ (declare (fixnum i))
+ (let* ((field (uffi:deref-array field-vec '(:array mysql-field) i))
+ (type (uffi:get-slot-value field 'mysql-field 'type))
+ (binding (uffi:deref-array output-bind '(:array mysql-bind) i)))
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-type) type)
+
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-length) 0)
+ #+need-to-allocate-foreign-object-for-this
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::is-null)
+ (+ i (uffi:pointer-address is-null-ptr)))
+ #+need-to-allocate-foreign-object-for-this
+ (setf (uffi:get-slot-value binding 'mysql-bind 'length)
+ (+ (* i 8) (uffi:pointer-address length-ptr)))
+
+ (case type
+ ((#.mysql-field-types#var-string #.mysql-field-types#string
+ #.mysql-field-types#tiny-blob #.mysql-field-types#blob
+ #.mysql-field-types#medium-blob #.mysql-field-types#long-blob)
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer-length) 1024)
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
+ (uffi:allocate-foreign-object :unsigned-char 1024)))
+ (#.mysql-field-types#tiny
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
+ (uffi:allocate-foreign-object :byte)))
+ (#.mysql-field-types#short
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
+ (uffi:allocate-foreign-object :short)))
+ (#.mysql-field-types#long
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
+ ;; segfaults if supply :int on amd64
+ (uffi:allocate-foreign-object :long)))
+ #+64bit
+ (#.mysql-field-types#longlong
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
+ (uffi:allocate-foreign-object :long)))
+ (#.mysql-field-types#float
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
+ (uffi:allocate-foreign-object :float)))
+ (#.mysql-field-types#double
+ (setf (uffi:get-slot-value binding 'mysql-bind 'mysql::buffer)
+ (uffi:allocate-foreign-object :double)))
+ ((#.mysql-field-types#time #.mysql-field-types#date
+ #.mysql-field-types#datetime #.mysql-field-types#timestamp)
+ (uffi:allocate-foreign-object 'mysql-time))
+ (t
+ (error "mysql type ~D not supported." type)))))
+
+ (unless (zerop (mysql-stmt-bind-result stmt output-bind))
+ (mysql-stmt-close stmt)
+ (error 'sql-database-error
+ :error-id (mysql-stmt-errno stmt)
+ :message (uffi:convert-from-cstring
+ (mysql-stmt-error stmt)))))
+
+ (make-instance 'mysql-stmt
+ :database database
+ :stmt stmt
+ :num-fields num-fields
+ :input-bind input-bind
+ :output-bind output-bind
+ :result-set rs
+ :result-types result-types
+ :length-ptr length-ptr
+ :is-null-ptr is-null-ptr
+ :types mysql-types
+ :field-names field-names)))))