;;;; *************************************************************************
;;;; FILE IDENTIFICATION
;;;;
-;;;; Name: tables.cl
+;;;; Name: tables.lisp
;;;; Purpose: Table creation tests in CLSQL
;;;; Programmer: Kevin M. Rosenberg
;;;; Date Started: Mar 2002
;;; (:postgresql ("localhost" "another-db" "user2" "dont-tell"))
;;; (:postgresql-socket ("pg-server" "a-db-name" "user" "secret-password")))
-(in-package :clsql-tests)
+(in-package #:clsql-classic-tests)
(defvar *config-pathname*
(make-pathname :default (user-homedir-pathname)
(unwind-protect
(progn
(create-test-table db)
- (dolist (row (query "select * from test_clsql" :database db :types :auto))
+ (dolist (row (query "select * from test_clsql" :database db :result-types :auto))
(test-table-row row :auto type))
- (dolist (row (query "select * from test_clsql" :database db :types nil))
+ (dolist (row (query "select * from test_clsql" :database db :result-types nil))
(test-table-row row nil type))
(loop for row across (map-query 'vector #'list "select * from test_clsql"
- :database db :types :auto)
+ :database db :result-types :auto)
do (test-table-row row :auto type))
(loop for row across (map-query 'vector #'list "select * from test_clsql"
- :database db :types nil)
+ :database db :result-types nil)
do (test-table-row row nil type))
(loop for row in (map-query 'list #'list "select * from test_clsql"
- :database db :types nil)
+ :database db :result-types nil)
do (test-table-row row nil type))
(loop for row in (map-query 'list #'list "select * from test_clsql"
- :database db :types :auto)
+ :database db :result-types :auto)
do (test-table-row row :auto type))
(test (map-query nil #'list "select * from test_clsql"
- :database db :types :auto)
+ :database db :result-types :auto)
nil
:fail-info "Expected NIL result from map-query nil")
(do-query ((int float bigint str) "select * from test_clsql")
(test-table-row (list int float bigint str) nil type))
- (do-query ((int float bigint str) "select * from test_clsql" :types :auto)
+ (do-query ((int float bigint str) "select * from test_clsql" :result-types :auto)
(test-table-row (list int float bigint str) :auto type))
(drop-test-table db)
)
i (clsql:number-to-sql-string (sqrt i))
(clsql:number-to-sql-string (sqrt i)))
db))
- (let ((res (clsql-mysql::database-query-result-set "select * from test_clsql" db :full-set t :types nil)))
+ (let ((res (clsql-mysql::database-query-result-set "select * from test_clsql" db :full-set t :result-types nil)))
(setq result (mysql:mysql-num-rows
(clsql-mysql::mysql-result-set-res-ptr res)))
(clsql-mysql::database-dump-result-set res db))
(unwind-protect
(progn
(create-test-table db)
- (dolist (row (query "select * from test_clsql" :database db :types :auto))
+ (dolist (row (query "select * from test_clsql" :database db :result-types :auto))
(test-table-row row :auto type))
- (dolist (row (query "select * from test_clsql" :database db :types nil))
+ (dolist (row (query "select * from test_clsql" :database db :result-types nil))
(test-table-row row nil type))
(loop for row across (map-query 'vector #'list "select * from test_clsql"
- :database db :types :auto)
+ :database db :result-types :auto)
do (test-table-row row :auto type))
(loop for row across (map-query 'vector #'list "select * from test_clsql"
- :database db :types nil)
+ :database db :result-types nil)
do (test-table-row row nil type))
(loop for row in (map-query 'list #'list "select * from test_clsql"
- :database db :types nil)
+ :database db :result-types nil)
do (test-table-row row nil type))
(loop for row in (map-query 'list #'list "select * from test_clsql"
- :database db :types :auto)
+ :database db :result-types :auto)
do (test-table-row row :auto type))
(test (map-query nil #'list "select * from test_clsql"
- :database db :types :auto)
+ :database db :result-types :auto)
nil
:fail-info "Expected NIL result from map-query nil")
(do-query ((int float bigint str) "select * from test_clsql")
(test-table-row (list int float bigint str) nil type))
- (do-query ((int float bigint str) "select * from test_clsql" :types :auto)
+ (do-query ((int float bigint str) "select * from test_clsql" :result-types :auto)
(test-table-row (list int float bigint str) :auto type))
(drop-test-table db)
)