X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=tests%2Ftest-fddl.lisp;h=04d310ec86454fadfe7e22463bc76c10ff2e3f8c;hb=ac8069e4f04d9c4faa41664cb8ee1ec83df0e67f;hp=a1044045a2b2035f51e16370081379def3a11042;hpb=66ed75626689968e1faa7603a36954ef4364b2e2;p=clsql.git diff --git a/tests/test-fddl.lisp b/tests/test-fddl.lisp index a104404..04d310e 100644 --- a/tests/test-fddl.lisp +++ b/tests/test-fddl.lisp @@ -1,19 +1,19 @@ ;;;; -*- Mode: LISP; Syntax: ANSI-Common-Lisp; Base: 10 -*- -;;;; ====================================================================== -;;;; File: test-fddl.lisp -;;;; Authors: Marcus Pearce and Kevin Rosenberg -;;;; Created: 30/03/2004 -;;;; Updated: $Id$ +;;;; ************************************************************************* +;;;; FILE IDENTIFICATION ;;;; -;;;; Tests for the CLSQL Functional Data Definition Language -;;;; (FDDL). +;;;; Name: test-fddl.lisp +;;;; Purpose: Tests for the CLSQL Functional Data Definition Language +;;;; Authors: Marcus Pearce and Kevin M. Rosenberg +;;;; Created: March 2004 ;;;; ;;;; This file is part of CLSQL. ;;;; ;;;; CLSQL users are granted the rights to distribute and use this software ;;;; as governed by the terms of the Lisp Lesser GNU Public License ;;;; (http://opensource.franz.com/preamble.html), also known as the LLGPL. -;;;; ====================================================================== +;;;; ************************************************************************* + (in-package #:clsql-tests) @@ -174,7 +174,8 @@ B varchar(32))") (deftest :fddl/attributes/5 (with-dataset *ds-fddl* - (and (member (clsql:attribute-type [d] [alpha]) '(:datetime :timestamp :date)) t)) + (and (member (clsql:attribute-type [d] [alpha]) + '(:datetime :timestamp :date :smalldatetime)) t)) t) (deftest :fddl/attributes/6 @@ -236,7 +237,7 @@ B varchar(32))") (let ((result (list ;; Shouldn't exist - (clsql:select [a] [c] + (clsql:select [a] [c] :from [v1] :where [= [a] -1]) ;; Should exist @@ -263,11 +264,11 @@ B varchar(32))") (clsql:list-attributes [v1])) #'string<) ;; Shouldn't exist - (clsql:select [x] [y] + (clsql:select [x] [y] :from [v1] :where [= [x] -1]) ;; Should exist - (car (clsql:select [x] [y] + (car (clsql:select [x] [y] :from [v1] :where [= [x] 1]))))) @@ -402,7 +403,7 @@ B varchar(32))") (clsql:index-exists-p [bar] ) (clsql:index-exists-p [bar] :owner *test-database-user*) (clsql:index-exists-p [bar] :owner *test-false-database-user*) - + (length (clsql-sys:list-indexes :on [alpha])) (length (clsql-sys:list-indexes :on [alpha] :owner *test-database-user*)) (length (clsql-sys:list-indexes :on [alpha] :owner *test-false-database-user*)) @@ -421,7 +422,7 @@ B varchar(32))") (clsql:sequence-exists-p [foo]) (clsql:sequence-exists-p [foo] :owner *test-database-user*) (clsql:sequence-exists-p [foo] :owner *test-false-database-user*) - + (progn (clsql:drop-sequence [foo] :if-does-not-exist :ignore) (clsql:sequence-exists-p [foo] ))))