r8903: fixes for AllegroCL/Lispworks/OpenMCL
[clsql.git] / base / package.lisp
1 ;;;; -*- Mode: LISP; Syntax: ANSI-Common-Lisp; Base: 10 -*-
2 ;;;; *************************************************************************
3 ;;;; FILE IDENTIFICATION
4 ;;;;
5 ;;;; Name:          package.lisp
6 ;;;; Purpose:       Package definition for base (low-level) SQL interface
7 ;;;; Programmers:   Kevin M. Rosenberg based on
8 ;;;;                Original code by Pierre R. Mai 
9 ;;;; Date Started:  Feb 2002
10 ;;;;
11 ;;;; $Id$
12 ;;;;
13 ;;;; This file, part of CLSQL, is Copyright (c) 2002-2004 by Kevin M. Rosenberg
14 ;;;; and Copyright (c) 1999-2001 by Pierre R. Mai
15 ;;;;
16 ;;;; CLSQL users are granted the rights to distribute and use this software
17 ;;;; as governed by the terms of the Lisp Lesser GNU Public License
18 ;;;; (http://opensource.franz.com/preamble.html), also known as the LLGPL.
19 ;;;; *************************************************************************
20
21 (in-package #:cl-user)
22
23 ;;;; This file makes the required package definitions for CLSQL's
24 ;;;; core packages.
25
26 (eval-when (:compile-toplevel :load-toplevel :execute)
27 (defpackage #:clsql-base-sys
28   (:use #:cl)
29   (:export
30      ;; "Private" exports for use by interface packages
31      #:check-connection-spec
32      #:database-type-load-foreign
33      #:database-type-library-loaded ;; KMR - Tests if foreign library okay
34      #:database-initialize-database-type
35      #:database-connect
36      #:database-disconnect
37      #:database-query
38      #:database-execute-command
39      #:database-query-result-set
40      #:database-dump-result-set
41      #:database-store-next-row
42      
43      ;; For UncommonSQL support
44      #:database-list-tables
45      #:database-list-attributes
46      #:database-attribute-type
47      #:database-create-sequence 
48      #:database-drop-sequence
49      #:database-sequence-next
50      #:sql-escape
51      #:database-sequence-last
52      #:database-set-sequence-position
53      #:database-list-attributes
54      #:database-list-sequences
55      #:database-list-indexes
56      #:database-list-views
57      
58      ;; Support for pooled connections
59      #:database-type
60      
61      ;; Large objects (Marc B)
62      #:database-create-large-object
63      #:database-write-large-object
64      #:database-read-large-object
65      #:database-delete-large-object
66      
67      ;; Shared exports for re-export by CLSQL-BASE
68      .
69      #1=(#:clsql-condition
70          #:clsql-error
71          #:clsql-simple-error
72          #:clsql-warning
73          #:clsql-simple-warning
74          #:clsql-invalid-spec-error
75          #:clsql-invalid-spec-error-connection-spec
76          #:clsql-invalid-spec-error-database-type
77          #:clsql-invalid-spec-error-template
78          #:clsql-connect-error
79          #:clsql-connect-error-database-type
80          #:clsql-connect-error-connection-spec
81          #:clsql-connect-error-errno
82          #:clsql-connect-error-error
83          #:clsql-sql-error
84          #:clsql-sql-error-database
85          #:clsql-sql-error-expression
86          #:clsql-sql-error-errno
87          #:clsql-sql-error-error
88          #:clsql-database-warning
89          #:clsql-database-warning-database
90          #:clsql-database-warning-message
91          #:clsql-exists-condition
92          #:clsql-exists-condition-new-db
93          #:clsql-exists-condition-old-db
94          #:clsql-exists-warning
95          #:clsql-exists-error
96          #:clsql-closed-error
97          #:clsql-closed-error-database
98          #:clsql-sql-syntax-error
99          #:clsql-type-error
100          
101          #:*loaded-database-types*
102          #:reload-database-types
103          #:*default-database-type*
104          #:*initialized-database-types*
105          #:initialize-database-type
106          #:*connect-if-exists*
107          #:*default-database*
108          #:connected-databases
109          #:database
110          #:database-name
111          #:closed-database
112          #:find-database
113          #:database-name-from-spec
114
115          ;; accessors for database class
116          #:name
117          #:connection-spec
118          #:transaction
119          #:transaction-level
120          #:conn-pool
121          #:command-recording-stream
122          #:result-recording-stream
123          #:view-classes
124          
125          ;; utils.lisp
126          #:number-to-sql-string
127          #:float-to-sql-string
128          #:sql-escape-quotes
129          
130          ;; time.lisp
131          #:bad-component
132          #:current-day
133          #:current-month
134          #:current-year
135          #:day-duration
136          #:db-timestring
137          #:decode-duration
138          #:decode-time
139          #:duration
140          #:duration+
141          #:duration<
142          #:duration<=
143          #:duration=
144          #:duration>
145          #:duration>=
146          #:duration-day
147          #:duration-hour
148          #:duration-minute
149          #:duration-month
150          #:duration-second
151          #:duration-year
152          #:duration-reduce                
153          #:format-duration
154          #:format-time
155          #:get-time
156          #:interval-clear
157          #:interval-contained
158          #:interval-data
159          #:interval-edit
160          #:interval-end
161          #:interval-match
162          #:interval-push
163          #:interval-relation
164          #:interval-start
165          #:interval-type
166          #:make-duration
167          #:make-interval
168          #:make-time
169          #:merged-time
170          #:midnight
171          #:month-name
172          #:parse-date-time
173          #:parse-timestring
174          #:print-date
175          #:roll
176          #:roll-to
177          #:time
178          #:time+
179          #:time-
180          #:time-by-adding-duration
181          #:time-compare
182          #:time-difference
183          #:time-dow
184          #:time-element
185          #:time-max
186          #:time-min
187          #:time-mjd
188          #:time-msec
189          #:time-p
190          #:time-sec
191          #:time-well-formed
192          #:time-ymd
193          #:time<
194          #:time<=
195          #:time=
196          #:time>
197          #:time>=
198          #:timezone
199          #:universal-time
200          #:wall-time
201          #:wall-timestring
202          #:week-containing
203
204          ;; recording.lisp -- SQL I/O Recording 
205          #:record-sql-comand
206          #:record-sql-result
207          #:add-sql-stream                 ; recording  xx
208          #:delete-sql-stream              ; recording  xx
209          #:list-sql-streams               ; recording  xx
210          #:sql-recording-p                ; recording  xx
211          #:sql-stream                     ; recording  xx
212          #:start-sql-recording            ; recording  xx
213          #:stop-sql-recording             ; recording  xx
214
215          ;; database.lisp -- Connection
216          #:*default-database-type*                ; clsql-base xx
217          #:*default-database*             ; classes    xx
218          #:connect                                ; database   xx
219          #:*connect-if-exists*            ; database   xx
220          #:connected-databases            ; database   xx
221          #:database                       ; database   xx
222          #:database-name                     ; database   xx
223          #:disconnect                     ; database   xx
224          #:reconnect                         ; database
225          #:find-database                     ; database   xx
226          #:status                            ; database   xx
227          #:with-database
228          #:with-default-database
229          #:disconnect-pooled
230
231          ;; basic-sql.lisp
232          #:query
233          #:execute-command
234          #:write-large-object
235          #:read-large-object
236          #:delete-large-object
237          #:do-query
238          #:map-query
239
240          ;; Transactions
241          #:with-transaction
242          #:commit-transaction
243          #:rollback-transaction
244          #:add-transaction-commit-hook
245          #:add-transaction-rollback-hook
246          #:commit                            ; transact   xx
247          #:rollback                       ; transact   xx
248          #:with-transaction               ; transact   xx               .
249          #:start-transaction                 ; transact   xx
250          #:in-transaction-p                  ; transact   xx
251          #:database-start-transaction
252          #:database-abort-transaction
253          #:database-commit-transaction
254          #:transaction-level
255          #:transaction
256
257          ))
258     (:documentation "This is the INTERNAL SQL-Interface package of CLSQL-BASE."))
259
260 (defpackage #:clsql-base
261     (:import-from #:clsql-base-sys . #1#)
262     (:export . #1#)
263     (:documentation "This is the SQL-Interface package of CLSQL-BASE."))
264 );eval-when
265
266