projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9368: initial port to uffi
[clsql.git]
/
tests
/
test-fddl.lisp
diff --git
a/tests/test-fddl.lisp
b/tests/test-fddl.lisp
index e84bdad2b1fade6c49a95116deb7f7ac2d44876a..32e645bb277135ae9201299e2c7ff1f4aa86e0e7 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" "employee_address
" "type_table")
+ "addr
" "company" "ea_join" "employee
" "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,7
+76,7
@@
(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
"last_name" "managerid" "married")
;; Attribute types are vendor specific so need to test a range
@@
-112,7
+112,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]