projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9427: 22 May 2004 Kevin Rosenberg
[clsql.git]
/
tests
/
test-fddl.lisp
diff --git
a/tests/test-fddl.lisp
b/tests/test-fddl.lisp
index 4315f88ae19a3fade918ae0a08d9b838537aa55c..7623b4bcc134ca2b803facb682eda24377c0e858 100644
(file)
--- a/
tests/test-fddl.lisp
+++ b/
tests/test-fddl.lisp
@@
-28,7
+28,7
@@
(sort (mapcar #'string-downcase
(clsql:list-tables :owner *test-database-user*))
#'string<))
(sort (mapcar #'string-downcase
(clsql:list-tables :owner *test-database-user*))
#'string<))
- "addr
ess" "company" "employee
" "type_table")
+ "addr
" "company" "ea_join" "employee" "type_bigint
" "type_table")
;; create a table, test for its existence, drop it and test again
(deftest :fddl/table/2
;; create a table, test for its existence, drop it and test again
(deftest :fddl/table/2
@@
-64,9
+64,9
@@
(sort
(mapcar #'string-downcase
(clsql:list-attributes [employee]
(sort
(mapcar #'string-downcase
(clsql:list-attributes [employee]
- :owner *test-database-user*))
+ :owner *test-database-user*))
#'string<))
#'string<))
- "birthday" "companyid" "email" "emplid" "first_name" "groupid" "height"
+ "birthday" "
e
companyid" "email" "emplid" "first_name" "groupid" "height"
"last_name" "managerid" "married")
(deftest :fddl/attributes/2
"last_name" "managerid" "married")
(deftest :fddl/attributes/2
@@
-76,24
+76,26
@@
(clsql:list-attribute-types [employee]
:owner *test-database-user*))
#'string<))
(clsql:list-attribute-types [employee]
:owner *test-database-user*))
#'string<))
- "birthday" "companyid" "email" "emplid" "first_name" "groupid" "height"
+ "birthday" "
e
companyid" "email" "emplid" "first_name" "groupid" "height"
"last_name" "managerid" "married")
;; Attribute types are vendor specific so need to test a range
(deftest :fddl/attributes/3
"last_name" "managerid" "married")
;; Attribute types are vendor specific so need to test a range
(deftest :fddl/attributes/3
- (and (member (clsql:attribute-type [emplid] [employee]) '(:int :integer :int4)) t)
+ (and (member (clsql:attribute-type [emplid] [employee]) '(:int :integer :int4
:number
)) t)
t)
(deftest :fddl/attributes/4
t)
(deftest :fddl/attributes/4
- (clsql:attribute-type [first-name] [employee])
- :varchar 30 nil 1)
+ (multiple-value-bind (type length scale nullable)
+ (clsql:attribute-type [first-name] [employee])
+ (values (clsql-sys:in type :varchar :varchar2) length scale nullable))
+ t 30 nil 1)
(deftest :fddl/attributes/5
(deftest :fddl/attributes/5
- (and (member (clsql:attribute-type [birthday] [employee]) '(:datetime :timestamp)) t)
+ (and (member (clsql:attribute-type [birthday] [employee]) '(:datetime :timestamp
:date
)) t)
t)
(deftest :fddl/attributes/6
t)
(deftest :fddl/attributes/6
- (and (member (clsql:attribute-type [height] [employee]) '(:float :float8)) t)
+ (and (member (clsql:attribute-type [height] [employee]) '(:float :float8
:number
)) t)
t)
t)
@@
-112,7
+114,7
@@
t nil)
;; create a view, list its attributes and drop it
t nil)
;; create a view, list its attributes and drop it
-(when (clsql-
base
:db-type-has-views? *test-database-underlying-type*)
+(when (clsql-
sys
:db-type-has-views? *test-database-underlying-type*)
(deftest :fddl/view/2
(progn (clsql:create-view [lenins-group]
:as [select [first-name] [last-name] [email]
(deftest :fddl/view/2
(progn (clsql:create-view [lenins-group]
:as [select [first-name] [last-name] [email]