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))
84 (defun position-char (char string start max)
86 (declare (optimize (speed 3) (safety 0) (space 0))
87 (fixnum start max) (simple-string string))
88 (do* ((i start (1+ i)))
91 (when (char= char (schar string i)) (return i))))
93 (defun delimited-string-to-list (string &optional (separator #\space)
95 "Split a string with delimiter, from KMRCL."
96 (declare (optimize (speed 3) (safety 0) (space 0) (compilation-speed 0))
98 (type character separator))
99 (do* ((len (length string))
102 (end (position-char separator string pos len)
103 (position-char separator string pos len)))
106 (push (subseq string pos) output)
107 (when (or (not skip-terminal) (zerop len))
110 (declare (type fixnum pos len)
111 (type (or null fixnum) end))
112 (push (subseq string pos end) output)
113 (setq pos (1+ end))))
115 (defun string-to-list-connection-spec (str)
116 (let ((at-pos (position-char #\@ str 0 (length str))))
118 ((and at-pos (> (length str) at-pos))
119 ;; Connection spec is SQL*NET format
120 (cons (subseq str (1+ at-pos))
121 (delimited-string-to-list (subseq str 0 at-pos) #\/)))
123 (delimited-string-to-list str #\/)))))
126 (eval-when (:compile-toplevel :load-toplevel :execute)
127 (unless (find-package '#:excl.osi)
130 (defun command-output (control-string &rest args)
131 ;; Concatenates output and error since Lispworks combines
132 ;; these, thus CLSQL can't depend upon separate results
133 (multiple-value-bind (output error status)
134 (apply #'%command-output control-string args)
136 (concatenate 'string (if output output "")
140 (defun read-stream-to-string (in)
141 (with-output-to-string (out)
142 (let ((eof (gensym)))
143 (do ((line (read-line in nil eof)
144 (read-line in nil eof)))
146 (format out "~A~%" line)))))
149 (defun %command-output (control-string &rest args)
150 "Interpolate ARGS into CONTROL-STRING as if by FORMAT, and
151 synchronously execute the result using a Bourne-compatible shell,
152 returns (VALUES string-output error-output exit-status)"
153 (let ((command (apply #'format nil control-string args)))
155 (let ((process (sb-ext:run-program
158 :input nil :output :stream :error :stream)))
160 (sb-impl::process-output process)
161 (sb-impl::process-error process)
162 (sb-impl::process-exit-code process)))
165 (let ((process (ext:run-program
168 :input nil :output :stream :error :stream)))
170 (ext::process-output process)
171 (ext::process-error process)
172 (ext::process-exit-code process)))
175 (multiple-value-bind (output error status)
176 (excl.osi:command-output command :whole t)
177 (values output error status))
180 ;; BUG: Lispworks combines output and error streams
181 (let ((output (make-output-string-stream)))
184 (system:call-system-showing-output
186 :shell-type "/bin/sh"
187 :output-stream output)))
188 (values (get-output-string output) nil status))
192 ;; BUG: CLisp doesn't allow output to user-specified stream
196 (ext:run-shell-command command :output :terminal :wait t))
199 (let* ((process (ccl:run-program
202 :input nil :output :stream :error :stream
204 (output (read-stream-to-string (ccl::external-process-output-stream process)))
205 (error (read-stream-to-string (ccl::external-process-error-stream process))))
206 (close (ccl::external-process-output-stream process))
207 (close (ccl::external-process-error-stream process))
210 (nth-value 1 (ccl::external-process-status process))))
212 #-(or openmcl clisp lispworks allegro scl cmu sbcl)
213 (error "COMMAND-OUTPUT not implemented for this Lisp")