X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;ds=sidebyside;f=tests%2Ftest-fddl.lisp;h=301c37c0af89f440ac8dd135253ac9ef331a60fe;hb=4d46d4d631cad1c4fe3accbe99f4182d975fd678;hp=7623b4bcc134ca2b803facb682eda24377c0e858;hpb=3310e4f8fcec920ce6d3d60878f13899746c70c7;p=clsql.git diff --git a/tests/test-fddl.lisp b/tests/test-fddl.lisp index 7623b4b..301c37c 100644 --- a/tests/test-fddl.lisp +++ b/tests/test-fddl.lisp @@ -59,6 +59,27 @@ (clsql:drop-table [foo] :if-does-not-exist :ignore)))) "comments" "height" "id" "name") +(deftest :fddl/table/4 + (values + (clsql:table-exists-p "MyMixedCase") + (progn + (clsql:create-table "MyMixedCase" '(([a] integer))) + (clsql:table-exists-p "MyMixedCase")) + (progn + (clsql:drop-table "MyMixedCase") + (clsql:table-exists-p "MyMixedCase"))) + nil t nil) + +(deftest :fddl/table/5 + (prog1 + (progn + (clsql:create-table "MyMixedCase" '(([a] integer))) + (clsql:execute-command "insert into MyMixedCase values (5)") + (clsql:insert-records :into "MyMixedCase" :values '(6)) + (clsql:select [a] :from "MyMixedCase" :order-by '((a :asc)))) + (clsql:drop-table "MyMixedCase")) + ((5) (6))) + (deftest :fddl/attributes/1 (apply #'values (sort