projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9211: add *backend-warning-behavior
[clsql.git]
/
tests
/
test-init.lisp
diff --git
a/tests/test-init.lisp
b/tests/test-init.lisp
index feee1d5ff328b9499ac31017536dfedc396bef28..eef4f888c44009906ae2c074951702cf83c3dfe9 100644
(file)
--- a/
tests/test-init.lisp
+++ b/
tests/test-init.lisp
@@
-34,24
+34,22
@@
((extraterrestrial :initform nil :initarg :extraterrestrial)))
(def-view-class person (thing)
((extraterrestrial :initform nil :initarg :extraterrestrial)))
(def-view-class person (thing)
- ((height :db-kind :base :accessor height :type float
:nulls-ok t
+ ((height :db-kind :base :accessor height :type float
:initarg :height)
:initarg :height)
- (married :db-kind :base :accessor married :type boolean
:nulls-ok t
+ (married :db-kind :base :accessor married :type boolean
:initarg :married)
:initarg :married)
- (birthday :
nulls-ok t :
type clsql-base:wall-time :initarg :birthday)
+ (birthday :type clsql-base:wall-time :initarg :birthday)
(hobby :db-kind :virtual :initarg :hobby :initform nil)))
(def-view-class employee (person)
((emplid
:db-kind :key
:db-constraints :not-null
(hobby :db-kind :virtual :initarg :hobby :initform nil)))
(def-view-class employee (person)
((emplid
:db-kind :key
:db-constraints :not-null
- :nulls-ok nil
:type integer
:initarg :emplid)
(groupid
:db-kind :key
:db-constraints :not-null
:type integer
:initarg :emplid)
(groupid
:db-kind :key
:db-constraints :not-null
- :nulls-ok nil
:type integer
:initarg :groupid)
(first-name
:type integer
:initarg :groupid)
(first-name
@@
-65,7
+63,6
@@
(email
:accessor employee-email
:type (string 100)
(email
:accessor employee-email
:type (string 100)
- :nulls-ok t
:initarg :email)
(companyid
:type integer)
:initarg :email)
(companyid
:type integer)
@@
-77,8
+74,7
@@
:foreign-key companyid
:set nil))
(managerid
:foreign-key companyid
:set nil))
(managerid
- :type integer
- :nulls-ok t)
+ :type integer)
(manager
:accessor employee-manager
:db-kind :join
(manager
:accessor employee-manager
:db-kind :join
@@
-160,8
+156,12
@@
(defun test-initialise-database ()
(test-basic-initialize)
(defun test-initialise-database ()
(test-basic-initialize)
- (clsql:create-view-from-class 'employee)
- (clsql:create-view-from-class 'company)
+ (let ((*backend-warning-behavior*
+ (if (member *test-database-type* '(:postgresql :postgresql-socket))
+ :ignore
+ :warn)))
+ (clsql:create-view-from-class 'employee)
+ (clsql:create-view-from-class 'company))
(setf company1 (make-instance 'company
:companyid 1
(setf company1 (make-instance 'company
:companyid 1
@@
-259,7
+259,7
@@
:first-name "Vladamir"
:last-name "Putin"
:email "putin@soviet.org"))
:first-name "Vladamir"
:last-name "Putin"
:email "putin@soviet.org"))
-
+
;; sleep to ensure birthdays are no longer at current time
(sleep 2)
;; sleep to ensure birthdays are no longer at current time
(sleep 2)
@@
-405,23
+405,23
@@
(let ((test (second test-form)))
(cond
((and (null (db-type-has-views? db-underlying-type))
(let ((test (second test-form)))
(cond
((and (null (db-type-has-views? db-underlying-type))
- (clsql-base
-sys
::in test :fddl/view/1 :fddl/view/2 :fddl/view/3 :fddl/view/4))
+ (clsql-base::in test :fddl/view/1 :fddl/view/2 :fddl/view/3 :fddl/view/4))
(push (cons test "views not supported") skip-tests))
((and (null (db-type-has-boolean-where? db-underlying-type))
(push (cons test "views not supported") skip-tests))
((and (null (db-type-has-boolean-where? db-underlying-type))
- (clsql-base
-sys
::in test :fdml/select/11 :oodml/select/5))
+ (clsql-base::in test :fdml/select/11 :oodml/select/5))
(push (cons test "boolean where not supported") skip-tests))
((and (null (db-type-has-subqueries? db-underlying-type))
(push (cons test "boolean where not supported") skip-tests))
((and (null (db-type-has-subqueries? db-underlying-type))
- (clsql-base
-sys
::in test :fdml/select/5 :fdml/select/10))
+ (clsql-base::in test :fdml/select/5 :fdml/select/10))
(push (cons test "subqueries not supported") skip-tests))
((and (null (db-type-transaction-capable? db-underlying-type
*default-database*))
(push (cons test "subqueries not supported") skip-tests))
((and (null (db-type-transaction-capable? db-underlying-type
*default-database*))
- (clsql-base
-sys
::in test :fdml/transaction/1 :fdml/transaction/2 :fdml/transaction/3 :fdml/transaction/4))
+ (clsql-base::in test :fdml/transaction/1 :fdml/transaction/2 :fdml/transaction/3 :fdml/transaction/4))
(push (cons test "transactions not supported") skip-tests))
((and (null (db-type-has-fancy-math? db-underlying-type))
(push (cons test "transactions not supported") skip-tests))
((and (null (db-type-has-fancy-math? db-underlying-type))
- (clsql-base
-sys
::in test :fdml/select/1))
+ (clsql-base::in test :fdml/select/1))
(push (cons test "fancy math not supported") skip-tests))
((and (eql *test-database-type* :sqlite)
(push (cons test "fancy math not supported") skip-tests))
((and (eql *test-database-type* :sqlite)
- (clsql-base
-sys
::in test :fddl/view/4 :fdml/select/10))
+ (clsql-base::in test :fddl/view/4 :fdml/select/10))
(push (cons test "not supported by sqlite") skip-tests))
(t
(push test-form test-forms)))))
(push (cons test "not supported by sqlite") skip-tests))
(t
(push test-form test-forms)))))