r9519: add prepared statements for postgresql

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

diff --git a/tests/test-internal.lisp b/tests/test-internal.lisp
new file mode 100644 (file)
index 0000000..a67cc87
--- /dev/null
+++ b/tests/test-internal.lisp
@@ -0,0 +1,44 @@
+;;;; -*- Mode: LISP; Syntax: ANSI-Common-Lisp; Base: 10 -*-
+;;;; *************************************************************************
+;;;; FILE IDENTIFICATION
+;;;;
+;;;; Name:    test-internal.lisp
+;;;; Purpose: Tests for internal clsql functions
+;;;; Author:  Kevin M. Rosenberg
+;;;; Created: May 2004
+;;;;
+;;;; $Id: test-basic.lisp 9450 2004-05-23 10:51:02Z kevin $
+;;;;
+;;;; This file, part of CLSQL, is Copyright (c) 2004 by Kevin M. Rosenberg
+;;;;
+;;;; 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)
+
+(setq *rt-internal*
+  '(
+    (deftest :int/convert/1
+       (clsql-sys::prepared-sql-to-postgresql-sql "SELECT FOO FROM BAR")
+      "SELECT FOO FROM BAR")
+    
+    (deftest :int/convert/2
+       (clsql-sys::prepared-sql-to-postgresql-sql "SELECT FOO FROM BAR WHERE ID=?")
+      "SELECT FOO FROM BAR WHERE ID=$1")
+    
+    (deftest :int/convert/3
+       (clsql-sys::prepared-sql-to-postgresql-sql "SELECT FOO FROM \"BAR\" WHERE ID=? AND CODE=?")
+      "SELECT FOO FROM \"BAR\" WHERE ID=$1 AND CODE=$2")
+    
+    (deftest :int/convert/4
+       (clsql-sys::prepared-sql-to-postgresql-sql "SELECT FOO FROM BAR WHERE ID=\"Match?\" AND CODE=?")
+      "SELECT FOO FROM BAR WHERE ID=\"Match?\" AND CODE=$1")
+    
+    (deftest :int/convert/5
+       (clsql-sys::prepared-sql-to-postgresql-sql "SELECT 'FOO' FROM BAR WHERE ID='Match?''?' AND CODE=?")
+      "SELECT 'FOO' FROM BAR WHERE ID='Match?''?' AND CODE=$1")
+    
+    ))
+