+(defun make-test-float (i)
+ (* i (expt 10 (* i 4))))
+
+(defun create-test-table (db)
+ (ignore-errors
+ (clsql:execute-command
+ "DROP TABLE test_clsql" :database db))
+ (clsql:execute-command
+ "CREATE TABLE test_clsql (n integer, flt float, flt_str CHAR(20))"
+ :database db)
+ (dotimes (i 11)
+ (let ((n (- i 5)))
+ (clsql:execute-command
+ (format nil "INSERT INTO test_clsql VALUES (~a,~a,'~a')"
+ n (clsql:number-to-sql-string (make-test-float n))
+ (clsql:number-to-sql-string (make-test-float n)))
+ :database db))))
+
+(defun drop-test-table (db)
+ (clsql:execute-command "DROP TABLE test_clsql"))