(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
;; 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
- (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
- (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
- (and (member (clsql:attribute-type [height] [employee]) '(:float :float8)) t)
+ (and (member (clsql:attribute-type [height] [employee]) '(:float :float8 :number)) t)
t)