X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-connection.lisp;h=25c8b733c38f76b6f2d7162d5659071c0b4be7ba;hb=550692f8d4ee3f416aa82a47712f257c535ad00e;hp=7f5a7864967310dac8cead368645d402daf35cc2;hpb=8a8ee2d7d791b7a3efaed06420802a925d16fca3;p=clsql.git

diff --git a/tests/test-connection.lisp b/tests/test-connection.lisp
index 7f5a786..25c8b73 100644
--- a/tests/test-connection.lisp
+++ b/tests/test-connection.lisp
@@ -5,7 +5,7 @@
 ;;;; Created: 30/03/2004
 ;;;; Updated: $Id$
 ;;;;
-;;;; Tests for CLSQL database connections. 
+;;;; Tests for CLSQL database connections.
 ;;;;
 ;;;; This file is part of CLSQL.
 ;;;;
@@ -18,7 +18,7 @@
 
 (setq *rt-connection*
       '(
-	
+
 (deftest :connection/1
     (let ((database (clsql:find-database
                      (clsql:database-name clsql:*default-database*)
@@ -27,13 +27,32 @@
   t)
 
 (deftest :connection/2
-    (clsql-sys::string-to-list-connection-spec 
+    (clsql-sys::string-to-list-connection-spec
      "localhost/dbname/user/passwd")
   ("localhost" "dbname" "user" "passwd"))
 
 (deftest :connection/3
-    (clsql-sys::string-to-list-connection-spec 
+    (clsql-sys::string-to-list-connection-spec
      "dbname/user@hostname")
   ("hostname" "dbname" "user"))
 
+(deftest :connection/execute-command
+    ;;check that we can issue basic commands.
+    (values
+      (clsql-sys:execute-command "CREATE TABLE DUMMY (foo integer)")
+      (clsql-sys:execute-command "DROP TABLE DUMMY"))
+  nil nil)
+
+(deftest :connection/query
+    ;;check that we can do a basic query
+    (first (clsql:query "SELECT 1" :flatp t :field-names nil))
+  1)
+
+(deftest :connection/query-command
+    ;;queries that are commands (no result set) shouldn't cause breakage
+    (values
+      (clsql-sys:query "CREATE TABLE DUMMY (foo integer)")
+      (clsql-sys:query "DROP TABLE DUMMY"))
+  nil nil)
+
 ))