r9288: 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)

[clsql.git] / tests / test-init.lisp

diff --git a/tests/test-init.lisp b/tests/test-init.lisp
index a1f700e90c0f5374cf8d6ce087df1c2458c19cab..c899867e2ea46dd2ffce5563906231ec40615e59 100644 (file)
--- a/tests/test-init.lisp
+++ b/tests/test-init.lisp
@@ -124,9 +124,7 @@
     :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
@@ -150,14 +148,14 @@
     :column "zip"
     :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 ()
-  ((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
@@ -344,16 +342,20 @@
                                  :addressid 2)
          employee-address1 (make-instance 'employee-address
                                           :emplid 1
-                                          :addressid 1)
+                                          :addressid 1
+                                          :verified t)
          employee-address2 (make-instance 'employee-address
                                           :emplid 2
-                                          :addressid 2)
+                                          :addressid 2
+                                          :verified t)
          employee-address3 (make-instance 'employee-address
                                           :emplid 3
-                                          :addressid 1)
+                                          :addressid 1
+                                          :verified nil)
          employee-address4 (make-instance 'employee-address
                                           :emplid 1
-                                          :addressid 2)
+                                          :addressid 2
+                                          :verified nil)
          employee-address5 (make-instance 'employee-address
                                           :emplid 3
                                           :addressid 2)
@@ -550,3 +552,10 @@
       (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))