X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=tests%2Ftest-fddl.lisp;h=f5527c773f7cce25f3ff017cc3f6c40cddb7f28f;hp=55b2977e3428c750ac5196f5a4292ddae3d0fbfb;hb=d9f41af62750c622945bb17b622a39689ee5b840;hpb=ebfa7f4dffe513c639b84b28135c5bbc92d43d61

diff --git a/tests/test-fddl.lisp b/tests/test-fddl.lisp
index 55b2977..f5527c7 100644
--- a/tests/test-fddl.lisp
+++ b/tests/test-fddl.lisp
@@ -244,7 +244,7 @@
     (let ((names '("foo" foo [foo]))
           (result '()))
       (dolist (name names)
-        (clsql:create-index name :on [employee] :attributes '([emplid]))
+        (clsql:create-index name :on [employee] :attributes '([last-name]))
         (push (clsql:index-exists-p name :owner *test-database-user*) result)
 	(clsql:drop-index name :on [employee] :if-does-not-exist :ignore))
       (apply #'values result))
@@ -338,6 +338,24 @@
         (length (clsql:list-tables :owner nil))))
   t) 
 
-))
+(deftest :fddl/cache-table-queries/1 
+ (list 
+  (gethash "EMPLOYEE" (clsql-sys::attribute-cache clsql:*default-database*))
+  (progn 
+    (clsql:cache-table-queries "EMPLOYEE" :action t)
+    (gethash "EMPLOYEE" (clsql-sys::attribute-cache clsql:*default-database*)))
+  (progn 
+    (clsql:list-attribute-types "EMPLOYEE")
+    (not 
+     (null 
+      (cadr 
+       (gethash "EMPLOYEE" 
+                (clsql-sys::attribute-cache clsql:*default-database*))))))
+  (progn 
+    (clsql:cache-table-queries "EMPLOYEE" :action :flush)
+    (gethash "EMPLOYEE" (clsql-sys::attribute-cache clsql:*default-database*))))
+ (nil (t nil) t (t nil)))
+
+  ))
 
 #.(clsql:restore-sql-reader-syntax-state)