:initarg :groupid)
(first-name
:accessor first-name
- :type (string 30)
+ :type (varchar 30)
:initarg :first-name)
(last-name
:accessor last-name
- :type (string 30)
+ :type (varchar 30)
:initarg :last-name)
(email
:accessor employee-email
- :type (string 100)
+ :type (varchar 100)
:initarg :email)
(ecompanyid
:type integer
:type integer
:initarg :groupid)
(name
- :type (string 100)
+ :type (varchar 100)
:initarg :name)
(presidentid
:type integer
:type integer
:initarg :street-number)
(street-name
- :type (string 30)
+ :type (varchar 30)
:void-value ""
:initarg :street-name)
(city
:column "city_field"
:void-value "no city"
- :type (string 30)
+ :type (varchar 30)
:initarg :city)
(postal-code
:column zip
(ignore-errors (create-database spec :database-type db-type)))
(setf *test-database-type* db-type)
- (when (>= (length spec) 3)
- (setq *test-database-user* (third spec)))
+ (setf *test-database-user*
+ (cond
+ ((eq :oracle db-type) (second spec))
+ ((>= (length spec) 3) (third spec))))
;; Connect to the database
(clsql:connect spec
*** CLSQL ~A begun at ~A
*** ~A
*** ~A on ~A
-*** Database ~A backend~A.
+*** Database ~:@(~A~) backend~A.
******************************************************************************
"
report-type
(machine-type)
db-type
(if (not (eq db-type *test-database-underlying-type*))
- (format nil " with underlying type ~A"
+ (format nil " with underlying type ~:@(~A~)"
*test-database-underlying-type*)
"")
))
((and (null (clsql-sys:db-type-has-union? db-underlying-type))
(clsql-sys:in test :fdml/query/6 :fdml/select/31))
(push (cons test "union not supported") skip-tests))
+ ((and (eq *test-database-type* :oracle)
+ (clsql-sys:in test :fdml/query/8 :fdml/select/21))
+ (push (cons test "syntax not supported") skip-tests))
(t
(push test-form test-forms)))))
(values (nreverse test-forms) (nreverse skip-tests))))
-(defun rapid-load (type)
+(defun rapid-load (type &optional (position 0))
"Rapid load for interactive testing."
(when *default-database*
(disconnect :database *default-database*))
- (test-connect-to-database type (car (db-type-spec type (read-specs))))
- (test-initialise-database))
+ (test-connect-to-database type (nth position (db-type-spec type (read-specs))))
+ (test-initialise-database)
+ *default-database*)
(defun rl ()
(rapid-load :postgresql))