projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9325: * db-*/*-loader.lisp: Load 64-bit libraries on 64-bit platorms
[clsql.git]
/
tests
/
test-init.lisp
diff --git
a/tests/test-init.lisp
b/tests/test-init.lisp
index a1f700e90c0f5374cf8d6ce087df1c2458c19cab..9cf50ff6b2508d47dc58e1942f8d522c835d5cd7 100644
(file)
--- a/
tests/test-init.lisp
+++ b/
tests/test-init.lisp
@@
-16,7
+16,7
@@
(in-package #:clsql-tests)
(in-package #:clsql-tests)
-(defvar *report-stream*
nil
"Stream to send text report.")
+(defvar *report-stream*
*standard-output*
"Stream to send text report.")
(defvar *sexp-report-stream* nil "Stream to send sexp report.")
(defvar *rt-connection*)
(defvar *rt-fddl*)
(defvar *sexp-report-stream* nil "Stream to send sexp report.")
(defvar *rt-connection*)
(defvar *rt-fddl*)
@@
-124,9
+124,7
@@
:db-info (:join-class employee
:home-key (companyid groupid)
:foreign-key (ecompanyid groupid)
:db-info (:join-class employee
:home-key (companyid groupid)
:foreign-key (ecompanyid groupid)
- :set t)))
- (:base-table company))
-
+ :set t))))
(def-view-class address ()
((addressid
(def-view-class address ()
((addressid
@@
-147,17
+145,17
@@
:type (string 30)
:initarg :city)
(postal-code
:type (string 30)
:initarg :city)
(postal-code
- :column
"zip"
+ :column
zip
:type integer
:void-value 0
:type integer
:void-value 0
- :initarg :postal-code)))
+ :initarg :postal-code))
+ (:base-table addr))
;; many employees can reside at many addressess
(def-view-class employee-address ()
;; many employees can reside at many addressess
(def-view-class employee-address ()
- ((aemplid :type integer
- :initarg :emplid)
- (aaddressid :type integer
- :initarg :addressid)
+ ((aemplid :type integer :initarg :emplid)
+ (aaddressid :type integer :initarg :addressid)
+ (verified :type boolean :initarg :verified)
(address :db-kind :join
:db-info (:join-class address
:home-key aaddressid
(address :db-kind :join
:db-info (:join-class address
:home-key aaddressid
@@
-344,16
+342,20
@@
:addressid 2)
employee-address1 (make-instance 'employee-address
:emplid 1
:addressid 2)
employee-address1 (make-instance 'employee-address
:emplid 1
- :addressid 1)
+ :addressid 1
+ :verified t)
employee-address2 (make-instance 'employee-address
:emplid 2
employee-address2 (make-instance 'employee-address
:emplid 2
- :addressid 2)
+ :addressid 2
+ :verified t)
employee-address3 (make-instance 'employee-address
:emplid 3
employee-address3 (make-instance 'employee-address
:emplid 3
- :addressid 1)
+ :addressid 1
+ :verified nil)
employee-address4 (make-instance 'employee-address
:emplid 1
employee-address4 (make-instance 'employee-address
:emplid 1
- :addressid 2)
+ :addressid 2
+ :verified nil)
employee-address5 (make-instance 'employee-address
:emplid 3
:addressid 2)
employee-address5 (make-instance 'employee-address
:emplid 3
:addressid 2)
@@
-537,11
+539,16
@@
(clsql-base::in test :fdml/select/1))
(push (cons test "fancy math not supported") skip-tests))
((and (eql *test-database-type* :sqlite)
(clsql-base::in test :fdml/select/1))
(push (cons test "fancy math not supported") skip-tests))
((and (eql *test-database-type* :sqlite)
- (clsql-base::in test :fddl/view/4 :fdml/select/10))
+ (clsql-base::in test :fddl/view/4 :fdml/select/10
+ :fdml/select/21))
(push (cons test "not supported by sqlite") skip-tests))
(push (cons test "not supported by sqlite") skip-tests))
+ ((and (eql *test-database-underlying-type* :mysql)
+ (clsql-base::in test :fdml/select/22 :fdml/query/5
+ :fdml/query/7 :fdml/query/8))
+ (push (cons test "not supported by mysql") skip-tests))
(t
(push test-form test-forms)))))
(t
(push test-form test-forms)))))
- (values (nreverse test-forms) (nreverse skip-tests))))
+
(values (nreverse test-forms) (nreverse skip-tests))))
(defun rl ()
(defun rl ()
@@
-550,3
+557,10
@@
(disconnect :database *default-database*))
(test-connect-to-database :postgresql (car (postgresql-spec (read-specs))))
(test-initialise-database))
(disconnect :database *default-database*))
(test-connect-to-database :postgresql (car (postgresql-spec (read-specs))))
(test-initialise-database))
+
+(defun rlm ()
+ "Rapid load for interactive testing."
+ (when *default-database*
+ (disconnect :database *default-database*))
+ (test-connect-to-database :mysql (car (mysql-spec (read-specs))))
+ (test-initialise-database))