r9222: new debian package

[clsql.git] / tests / test-basic.lisp

diff --git a/tests/test-basic.lisp b/tests/test-basic.lisp
index 34b3f25ffe60bbf9d43db3fc5281ac66b84e1b2f..aff45cb6ffab18cabf7fd5b8c50185aea3446312 100644 (file)
--- a/tests/test-basic.lisp
+++ b/tests/test-basic.lisp
@@ -38,22 +38,24 @@
   (append
    (test-basic-forms-untyped)
    '(
   (append
    (test-basic-forms-untyped)
    '(

-     (deftest BASIC/TYPE/1
+     (deftest :BASIC/TYPE/1

        (let ((results '()))
          (dolist (row (query "select * from TYPE_TABLE" :result-types :auto)
                    results)
            (destructuring-bind (int float bigint str) row
              (push (list (integerp int)
                          (typep float 'double-float)
        (let ((results '()))
          (dolist (row (query "select * from TYPE_TABLE" :result-types :auto)
                    results)
            (destructuring-bind (int float bigint str) row
              (push (list (integerp int)
                          (typep float 'double-float)

-                         (if (member *test-database-type* '(:odbc :aodbc))  
-                             t
+                         (if (and (eq :odbc *test-database-type*)
+                                  (eq :postgresql *test-database-underlying-type*))
+                             ;; ODBC/Postgresql returns bigints as strings
+                             (stringp bigint)

                            (integerp bigint))
                          (stringp str))
                    results))))
       ((t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t)))
     
 
                            (integerp bigint))
                          (stringp str))
                    results))))
       ((t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t)))
     
 

-     (deftest BASIC/TYPE/2
+     (deftest :BASIC/TYPE/2

         (let ((results '()))
           (dolist (row (query "select * from TYPE_TABLE" :result-types :auto)
                     results)
         (let ((results '()))
           (dolist (row (query "select * from TYPE_TABLE" :result-types :auto)
                     results)


@@ -69,14 +71,14 @@
      )))
 
 (defun test-basic-forms-untyped ()
      )))
 
 (defun test-basic-forms-untyped ()

-  '((deftest BASIC/SELECT/1
+  '((deftest :BASIC/SELECT/1

        (let ((rows (query "select * from TYPE_TABLE" :result-types :auto)))
          (values 
           (length rows)
           (length (car rows))))
       11 4)
     
        (let ((rows (query "select * from TYPE_TABLE" :result-types :auto)))
          (values 
           (length rows)
           (length (car rows))))
       11 4)
     

-    (deftest BASIC/SELECT/2
+    (deftest :BASIC/SELECT/2

        (let ((results '()))
          (dolist (row (query "select * from TYPE_TABLE" :result-types nil)
                    results)
        (let ((results '()))
          (dolist (row (query "select * from TYPE_TABLE" :result-types nil)
                    results)


@@ -88,7 +90,7 @@
                    results))))
       ((t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t)))
     
                    results))))
       ((t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t) (t t t t)))
     

-    (deftest BASIC/SELECT/3
+    (deftest :BASIC/SELECT/3

        (let ((results '()))
          (dolist (row (query "select * from TYPE_TABLE" :result-types nil)
                    results)
        (let ((results '()))
          (dolist (row (query "select * from TYPE_TABLE" :result-types nil)
                    results)


@@ -102,10 +104,11 @@
                    results))))
       ((t t) (t t) (t t) (t t) (t t) (t t) (t t) (t t) (t t) (t t) (t t)))
 
                    results))))
       ((t t) (t t) (t t) (t t) (t t) (t t) (t t) (t t) (t t) (t t) (t t)))
 

-    (deftest BASIC/MAP/1
+    (deftest :BASIC/MAP/1

        (let ((results '())
              (rows (map-query 'vector #'list "select * from TYPE_TABLE" 
                               :result-types nil)))
        (let ((results '())
              (rows (map-query 'vector #'list "select * from TYPE_TABLE" 
                               :result-types nil)))

+         (declare (array rows))

          (dotimes (i (length rows) results)
            (push
             (list
          (dotimes (i (length rows) results)
            (push
             (list


@@ -120,7 +123,7 @@
             results)))
       ((t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t)))
     
             results)))
       ((t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t)))
     

-    (deftest BASIC/MAP/2
+    (deftest :BASIC/MAP/2

        (let ((results '())
              (rows (map-query 'list #'list "select * from TYPE_TABLE" 
                               :result-types nil)))
        (let ((results '())
              (rows (map-query 'list #'list "select * from TYPE_TABLE" 
                               :result-types nil)))


@@ -138,7 +141,7 @@
             results)))
       ((t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t)))
 
             results)))
       ((t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t) (t 4 t t)))
 

-    (deftest BASIC/DO/1
+    (deftest :BASIC/DO/1

        (let ((results '()))
          (do-query ((int float bigint str) "select * from TYPE_TABLE")
            (push (list (double-float-equal 
        (let ((results '()))
          (do-query ((int float bigint str) "select * from TYPE_TABLE")
            (push (list (double-float-equal 


@@ -165,10 +168,6 @@
   (let ((*read-default-float-format* 'double-float))
     (coerce (read-from-string num-str) 'double-float)))
 
   (let ((*read-default-float-format* 'double-float))
     (coerce (read-from-string num-str) 'double-float)))
 

-(defun test-table-row (row types)
-)
-
-

 (defun double-float-equal (a b)
   (if (zerop a)
       (if (zerop b)
 (defun double-float-equal (a b)
   (if (zerop a)
       (if (zerop b)