r9485: 26 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 415af2a2b81a3c5f9b562de889f47c20a21411e5..489b50b280ca53cfe79f2d9be30a8e81f4c5b709 100644 (file)
--- a/tests/test-init.lisp
+++ b/tests/test-init.lisp
@@ -30,6 +30,7 @@
 (defvar *test-database-type* nil)
 (defvar *test-database-underlying-type* nil)
 (defvar *test-database-user* nil)
+(defvar *test-start-utime* nil)
 
 (defclass thing ()
   ((extraterrestrial :initform nil :initarg :extraterrestrial)))
@@ -40,6 +41,7 @@
    (married :db-kind :base :accessor married :type boolean
             :initarg :married)
    (birthday :type clsql:wall-time :initarg :birthday)
+   (bd-utime :type clsql:universal-time :initarg :bd-utime)
    (hobby :db-kind :virtual :initarg :hobby :initform nil)))
   
 (def-view-class employee (person)
@@ -236,7 +238,9 @@
     (clsql:create-view-from-class 'employee-address)
     (clsql:create-view-from-class 'big))
 
-  (let ((*db-auto-sync* t))
+  (setq *test-start-utime* (get-universal-time))
+  (let* ((*db-auto-sync* t)
+        (now-time (clsql:utime->time *test-start-utime*)))
     (setf company1 (make-instance 'company
                                  :presidentid 1
                                  :companyid 1
@@ -247,7 +251,8 @@
                                   :groupid 1
                                   :married t 
                                   :height (1+ (random 1.00))
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Vladamir"
                                   :last-name "Lenin"
                                   :email "lenin@soviet.org"
@@ -257,7 +262,8 @@
                                   :groupid 1
                                   :height (1+ (random 1.00))
                                   :married t 
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Josef"
                                   :last-name "Stalin"
                                   :email "stalin@soviet.org"
@@ -268,7 +274,8 @@
                                   :groupid 1
                                   :height (1+ (random 1.00))
                                   :married t 
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Leon"
                                   :last-name "Trotsky"
                                   :email "trotsky@soviet.org"
@@ -279,7 +286,8 @@
                                   :groupid 1
                                   :height (1+ (random 1.00))
                                   :married nil
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Nikita"
                                   :last-name "Kruschev"
                                   :email "kruschev@soviet.org"
@@ -290,7 +298,8 @@
                                   :groupid 1
                                   :married nil
                                   :height (1+ (random 1.00))
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Leonid"
                                   :last-name "Brezhnev"
                                   :email "brezhnev@soviet.org"
@@ -301,7 +310,8 @@
                                   :groupid 1
                                   :married nil
                                   :height (1+ (random 1.00))
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Yuri"
                                   :last-name "Andropov"
                                   :email "andropov@soviet.org"
@@ -312,7 +322,8 @@
                                   :groupid 1
                                   :height (1+ (random 1.00))
                                   :married nil
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Konstantin"
                                   :last-name "Chernenko"
                                   :email "chernenko@soviet.org"
@@ -323,7 +334,8 @@
                                   :groupid 1
                                   :height (1+ (random 1.00))
                                   :married nil
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Mikhail"
                                   :last-name "Gorbachev"
                                   :email "gorbachev@soviet.org"
@@ -334,7 +346,8 @@
                                   :groupid 1 
                                   :married nil
                                   :height (1+ (random 1.00))
-                                  :birthday (clsql:get-time)
+                                  :bd-utime *test-start-utime*
+                                  :birthday now-time
                                   :first-name "Boris"
                                   :last-name "Yeltsin"
                                   :email "yeltsin@soviet.org"
@@ -345,7 +358,8 @@
                                    :groupid 1
                                    :married nil
                                    :height (1+ (random 1.00))
-                                   :birthday (clsql:get-time)
+                                   :bd-utime *test-start-utime*
+                                   :birthday now-time
                                    :first-name "Vladamir"
                                    :last-name "Putin"
                                    :email "putin@soviet.org"