X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=sql%2Fusql.cl;h=1141dc0e1f33847f896b005f857c0866a3f1dd7d;hp=85e7b7780a7404dba0893949d1fb109e19e0541e;hb=998937376fa6f9ce29bd3c7954fb0ebca91c37d7;hpb=5829838b970346a58f75683ecba005007414edb9 diff --git a/sql/usql.cl b/sql/usql.cl index 85e7b77..1141dc0 100644 --- a/sql/usql.cl +++ b/sql/usql.cl @@ -8,7 +8,7 @@ ;;;; Programmers: Kevin M. Rosenberg and onShore Development Inc ;;;; Date Started: Mar 2002 ;;;; -;;;; $Id: usql.cl,v 1.4 2002/04/06 22:27:41 kevin Exp $ +;;;; $Id: usql.cl,v 1.11 2002/09/17 17:16:43 kevin Exp $ ;;;; ;;;; This file, part of CLSQL, is Copyright (c) 2002 by Kevin M. Rosenberg ;;;; and onShore Development Inc @@ -45,51 +45,6 @@ keyword argument :database specifies the database to query, defaulting to *default-database*." (database-attribute-type attribute table database)) -(defun add-attribute (table attribute &key (database *default-database*)) - "Add the ATTRIBUTE to TABLE. The ATTRIBUTE sepcification must -include a type argument. The optional keyword argument :database -specifies the database to operation on, defaulting to -*default-database*." - (database-add-attribute table attribute database)) - -(defun rename-attribute (table oldatt newname - &key (database *default-database*)) - (error "(rename-attribute ~a ~a ~a ~a) is not implemented" table oldatt newname database)) - - -(defclass %sql-expression () - ()) - -;; For SQL Identifiers of generic type -(defclass sql-ident (%sql-expression) - ((name - :initarg :name - :initform "NULL")) - (:documentation "An SQL identifer.")) - -(defmethod make-load-form ((sql sql-ident) &optional environment) - (declare (ignore environment)) - (with-slots (name) - sql - `(make-instance 'sql-ident :name ',name))) - - -;; KMR -- change aref to more specific char -(defun sql-escape (identifier) - (let* ((unescaped (etypecase identifier - (symbol (symbol-name identifier)) - (string identifier))) - (escaped (make-string (length unescaped)))) - (dotimes (i (length unescaped)) - (setf (char escaped i) - (cond ((equal (char unescaped i) #\-) - #\_) - ;; ... - (t - (char unescaped i))))) - escaped)) - - (defun create-sequence (name &key (database *default-database*)) (database-create-sequence name database)) @@ -99,37 +54,4 @@ specifies the database to operation on, defaulting to (defun sequence-next (name &key (database *default-database*)) (database-sequence-next name database)) -(defclass sql-value-exp (%sql-expression) - ((modifier - :initarg :modifier - :initform nil) - (components - :initarg :components - :initform nil)) - (:documentation - "An SQL value expression.") - ) - -(defclass sql-typecast-exp (sql-value-exp) - () - (:documentation - "An SQL typecast expression.") - ) -(defvar +null-string+ "NULL") - -(defvar *sql-stream* nil - "stream which accumulates SQL output") - -(defclass %sql-expression () - ()) - -(defmethod output-sql ((expr %sql-expression) &optional - (database *default-database*)) - (declare (ignore database)) - (write-string +null-string+ *sql-stream*)) - -(defmethod print-object ((self %sql-expression) stream) - (print-unreadable-object - (self stream :type t) - (write-string (sql-output self) stream)))