1 ;;;; -*- Mode: LISP; Syntax: ANSI-Common-Lisp; Base: 10 -*-
2 ;;;; *************************************************************************
3 ;;;; FILE IDENTIFICATION
6 ;;;; Purpose: SQL utility functions
7 ;;;; Programmer: Kevin M. Rosenberg
8 ;;;; Date Started: Mar 2002
12 ;;;; This file, part of CLSQL, is Copyright (c) 2002-2004 by Kevin M. Rosenberg
14 ;;;; CLSQL users are granted the rights to distribute and use this software
15 ;;;; as governed by the terms of the Lisp Lesser GNU Public License
16 ;;;; (http://opensource.franz.com/preamble.html), also known as the LLGPL.
17 ;;;; *************************************************************************
19 (in-package #:clsql-base-sys)
21 (defun number-to-sql-string (num)
26 (float-to-sql-string (coerce num 'double-float)))
28 (float-to-sql-string num))))
30 (defun float-to-sql-string (num)
31 "Convert exponent character for SQL"
32 (let ((str (write-to-string num :readably t)))
35 (substitute #\e #\f str))
37 (substitute #\e #\d str))
39 (substitute #\e #\l str))
41 (substitute #\e #\S str))
43 (substitute #\e #\F str))
45 (substitute #\e #\D str))
47 (substitute #\e #\L str))
49 (substitute #\e #\S str))
53 (defun sql-escape (identifier)
54 "Change hyphens to underscores, ensure string"
55 (let* ((unescaped (etypecase identifier
56 (symbol (symbol-name identifier))
58 (escaped (make-string (length unescaped))))
59 (dotimes (i (length unescaped))
60 (setf (char escaped i)
61 (cond ((equal (char unescaped i) #\-)
65 (char unescaped i)))))
69 (defun sql-escape-quotes (s)
70 "Escape quotes for SQL string writing"
71 (substitute-string-for-char s #\' "''"))
73 (defun substitute-string-for-char (procstr match-char subst-str)
74 "Substitutes a string for a single matching character of a string"
75 (let ((pos (position match-char procstr)))
78 (subseq procstr 0 pos) subst-str
79 (substitute-string-for-char
80 (subseq procstr (1+ pos)) match-char subst-str))