projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9450: 22 May 2004 Kevin Rosenberg
[clsql.git]
/
tests
/
test-fddl.lisp
diff --git
a/tests/test-fddl.lisp
b/tests/test-fddl.lisp
index 32e645bb277135ae9201299e2c7ff1f4aa86e0e7..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" "company" "ea_join" "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
@@
-81,19
+81,21
@@
;; Attribute types are vendor specific so need to test a range
(deftest :fddl/attributes/3
;; 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)