r8926: add database-create database-destroy database-probe
[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      #:database-create
43      #:database-destroy
44      #:database-probe
45
46      #:database-list-tables
47      #:database-list-attributes
48      #:database-attribute-type
49      #:database-create-sequence 
50      #:database-drop-sequence
51      #:database-sequence-next
52      #:sql-escape
53      #:database-sequence-last
54      #:database-set-sequence-position
55      #:database-list-attributes
56      #:database-list-sequences
57      #:database-list-indexes
58      #:database-list-views
59      
60      ;; Support for pooled connections
61      #:database-type
62      
63      ;; Large objects (Marc B)
64      #:database-create-large-object
65      #:database-write-large-object
66      #:database-read-large-object
67      #:database-delete-large-object
68      
69      ;; Shared exports for re-export by CLSQL-BASE
70      .
71      #1=(#:clsql-condition
72          #:clsql-error
73          #:clsql-simple-error
74          #:clsql-warning
75          #:clsql-simple-warning
76          #:clsql-invalid-spec-error
77          #:clsql-invalid-spec-error-connection-spec
78          #:clsql-invalid-spec-error-database-type
79          #:clsql-invalid-spec-error-template
80          #:clsql-access-error
81          #:clsql-access-error-database-type
82          #:clsql-access-error-connection-spec
83          #:clsql-access-error-error
84          #:clsql-connect-error
85          #:clsql-connect-error-errno
86          #:clsql-sql-error
87          #:clsql-sql-error-database
88          #:clsql-sql-error-expression
89          #:clsql-sql-error-errno
90          #:clsql-sql-error-error
91          #:clsql-database-warning
92          #:clsql-database-warning-database
93          #:clsql-database-warning-message
94          #:clsql-exists-condition
95          #:clsql-exists-condition-new-db
96          #:clsql-exists-condition-old-db
97          #:clsql-exists-warning
98          #:clsql-exists-error
99          #:clsql-closed-error
100          #:clsql-closed-error-database
101          #:clsql-sql-syntax-error
102          #:clsql-type-error
103          
104          #:*loaded-database-types*
105          #:reload-database-types
106          #:*default-database-type*
107          #:*initialized-database-types*
108          #:initialize-database-type
109          #:*connect-if-exists*
110          #:*default-database*
111          #:connected-databases
112          #:database
113          #:database-name
114          #:closed-database
115          #:find-database
116          #:database-name-from-spec
117
118          ;; accessors for database class
119          #:name
120          #:connection-spec
121          #:transaction
122          #:transaction-level
123          #:conn-pool
124          #:command-recording-stream
125          #:result-recording-stream
126          #:view-classes
127          
128          ;; utils.lisp
129          #:number-to-sql-string
130          #:float-to-sql-string
131          #:sql-escape-quotes
132          
133          ;; time.lisp
134          #:bad-component
135          #:current-day
136          #:current-month
137          #:current-year
138          #:day-duration
139          #:db-timestring
140          #:decode-duration
141          #:decode-time
142          #:duration
143          #:duration+
144          #:duration<
145          #:duration<=
146          #:duration=
147          #:duration>
148          #:duration>=
149          #:duration-day
150          #:duration-hour
151          #:duration-minute
152          #:duration-month
153          #:duration-second
154          #:duration-year
155          #:duration-reduce                
156          #:format-duration
157          #:format-time
158          #:get-time
159          #:interval-clear
160          #:interval-contained
161          #:interval-data
162          #:interval-edit
163          #:interval-end
164          #:interval-match
165          #:interval-push
166          #:interval-relation
167          #:interval-start
168          #:interval-type
169          #:make-duration
170          #:make-interval
171          #:make-time
172          #:merged-time
173          #:midnight
174          #:month-name
175          #:parse-date-time
176          #:parse-timestring
177          #:print-date
178          #:roll
179          #:roll-to
180          #:time
181          #:time+
182          #:time-
183          #:time-by-adding-duration
184          #:time-compare
185          #:time-difference
186          #:time-dow
187          #:time-element
188          #:time-max
189          #:time-min
190          #:time-mjd
191          #:time-msec
192          #:time-p
193          #:time-sec
194          #:time-well-formed
195          #:time-ymd
196          #:time<
197          #:time<=
198          #:time=
199          #:time>
200          #:time>=
201          #:timezone
202          #:universal-time
203          #:wall-time
204          #:wall-timestring
205          #:week-containing
206
207          ;; recording.lisp -- SQL I/O Recording 
208          #:record-sql-comand
209          #:record-sql-result
210          #:add-sql-stream                 ; recording  xx
211          #:delete-sql-stream              ; recording  xx
212          #:list-sql-streams               ; recording  xx
213          #:sql-recording-p                ; recording  xx
214          #:sql-stream                     ; recording  xx
215          #:start-sql-recording            ; recording  xx
216          #:stop-sql-recording             ; recording  xx
217
218          ;; database.lisp -- Connection
219          #:*default-database-type*                ; clsql-base xx
220          #:*default-database*             ; classes    xx
221          #:connect                                ; database   xx
222          #:*connect-if-exists*            ; database   xx
223          #:connected-databases            ; database   xx
224          #:database                       ; database   xx
225          #:database-name                     ; database   xx
226          #:disconnect                     ; database   xx
227          #:reconnect                         ; database
228          #:find-database                     ; database   xx
229          #:status                            ; database   xx
230          #:with-database
231          #:with-default-database
232          #:disconnect-pooled
233          #:create-database
234          #:destroy-database
235          #:probe-database
236
237          ;; basic-sql.lisp
238          #:query
239          #:execute-command
240          #:write-large-object
241          #:read-large-object
242          #:delete-large-object
243          #:do-query
244          #:map-query
245
246          ;; Transactions
247          #:with-transaction
248          #:commit-transaction
249          #:rollback-transaction
250          #:add-transaction-commit-hook
251          #:add-transaction-rollback-hook
252          #:commit                            ; transact   xx
253          #:rollback                       ; transact   xx
254          #:with-transaction               ; transact   xx               .
255          #:start-transaction                 ; transact   xx
256          #:in-transaction-p                  ; transact   xx
257          #:database-start-transaction
258          #:database-abort-transaction
259          #:database-commit-transaction
260          #:transaction-level
261          #:transaction
262
263          ))
264     (:documentation "This is the INTERNAL SQL-Interface package of CLSQL-BASE."))
265
266 (defpackage #:clsql-base
267     (:import-from #:clsql-base-sys . #1#)
268     (:export . #1#)
269     (:documentation "This is the SQL-Interface package of CLSQL-BASE."))
270 );eval-when
271
272