X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-fddl.lisp;h=ab3da3bdf44ba5f835993391014ea05ad1a12a6d;hb=3a3ccc7a171dc4c6c10bc7e3fea8461fca6dc51b;hp=e84bdad2b1fade6c49a95116deb7f7ac2d44876a;hpb=9f88a2a19d13afb9ab7f35ad1df522d00301b56d;p=clsql.git diff --git a/tests/test-fddl.lisp b/tests/test-fddl.lisp index e84bdad..ab3da3b 100644 --- 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<)) - "address" "company" "employee" "employee_address" "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 @@ -64,9 +64,9 @@ (sort (mapcar #'string-downcase (clsql:list-attributes [employee] - :owner *test-database-user*)) + :owner *test-database-user*)) #'string<)) - "birthday" "companyid" "email" "emplid" "first_name" "groupid" "height" + "birthday" "ecompanyid" "email" "emplid" "first_name" "groupid" "height" "last_name" "managerid" "married") (deftest :fddl/attributes/2 @@ -76,12 +76,12 @@ (clsql:list-attribute-types [employee] :owner *test-database-user*)) #'string<)) - "birthday" "companyid" "email" "emplid" "first_name" "groupid" "height" + "birthday" "ecompanyid" "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 - (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 @@ -112,7 +112,7 @@ 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]