1 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
2 * Version 2.7.0: New backend: ODBC. Tests as
3 well as AODBC backend. Requires UFFI v1.4.10
4 * db-odbc/*.lisp: Add ODBC3 function SQLSetEnvAttr
5 to explicitly set ODBC2 support. Add BIGINT support.
6 Add result-types support. Added SQLTables.
7 Fix array type in fetch-all-rows. Make width
8 changable by database or query.
9 * base/utils.lisp: Add process functions
10 * base/package.lisp: Export utils to CLSQL-BASE-SYS
11 * db-aodbc: Implement sequence functions,
12 database-list-tables, database-list-attributes
13 * tests/utils.lisp: Add support for ODBC backend,
14 rework READ-SPECS to use +all-db-types+
15 * db-mysql/mysql-sql.lisp: Use WITHOUT-INTERRUPTS
18 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
19 * Version 2.6.13. Requires UFFI version 1.4.9
20 * db-odbc/*.lisp: Further porting.
21 Pre-alpha code! But, basic query is now working.
23 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
25 * base/transactions.lisp: Add quote for macro
26 expansion of WITH-TRANSACTIONS [Time Howe]
27 * db-sqlite/sqlite-sql.lisp: Support memory database
28 in database-probe [Ng Pheng Siong]
29 * db-odbc/*.lisp: Initial port to UFFI of SQL-ODBC.
30 The DBI layer is not finished.
32 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
34 * sql/objects.lisp: add :root-class functionality for
35 list-classes and add duration type support [Marcus Pearce]
36 * db-odbc: Add mid-level [DBI] layer
38 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
40 * db-aodbc: Add methods for generic functions, some are
42 * clsql-odbc.asd, db-odbc/*.lisp: Initial start of ODBC
45 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
47 * base/package.lisp: Add missing symbols [Marcus Pearce]
49 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
51 * test/test-fddl.lisp: Cleanup fix [Marcus Pearce]
52 * utils/time.lisp: Multiple fixes [Marcus Pearce]
53 * sql/sql.lisp: Fix for truncate-database [Marcus Pearce]
55 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
57 * sql/*.lisp: Remove schema versioning cruft
59 * Makefile: Add classic subdirectory
61 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
63 * sql/sql.lisp: Fix TRUNCATE command, bug reported
65 * sql/sql.lisp: Remove EXPLAIN function. Postgresql/Oracle
66 specific and easy for an application to directly support.
67 Idea from Marcus Pearce.
68 * base/basic-sql.lisp: Remove DESCRIBE-TABLE top-level
69 API as duplicates LIST-ATTRIBUTE-TYPES [Marcus Pearce].
70 Keep low-level interface for future optimization
71 supporting LIST-ATTRIBUTE-TYPES command.
72 * Makefile: Add to db-sqlite and test directories.
73 Include them in top-level Makefile
75 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
77 * sql/relations.lisp: Add missing file
78 * utils/time.lisp: Fixes/extensions [Marcus Pearce]
79 * test/test-time.lips: New file [Marcus Pearce]
81 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
83 * test/test-init.lisp: Properly handle object
84 creation. Close database after use.
85 * sql/sql.lisp: Make DESCRIBE-TABLE a generic
86 function so can have methods specialized on
87 table being a string or an sql-table object.
88 * base/pool.lisp: Really fix CMUCL locking
90 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
92 * test/test-init.lisp: Signal correctly
93 if any errors occurred in any test suite
94 * base/loop-extensions.lisp: Fix error
95 introduced for Lispworks
96 * base/pool.lisp: Fix locking for CMUCL
97 * base/objects.lisp: Remove schema-version cruft
99 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
100 * Version 2.6.2: New CLSQL API functions:
101 DESCRIBE-TABLE AND TRUNCATE-DATABASE
102 Currently, this are only supported on :postgresql
103 and :postgresql-socket
104 * base/database.lisp: automatically load ASDF system
105 in CONNECT if not already loaded
106 * base/tests.lisp: disconnect database after testing
107 * base/*.lisp: Remove CLOSED-DATABASE type in favor
108 of storing open/closed status in slot of database
109 * base/pool.lisp: Support locks for CMUCL, OpenMCL, SBCL
110 * db-postgresql/postgresql-sql.lisp: add DATABASE-RECONNECT,
111 DATABASE-DESCRIBE-TABLE
112 * db-sqlite/sqlite-sql.lisp: Add missing slots in database
113 * base/conditions: Remove duplicate condition
114 * db-*/*-sql.lisp: Fill new database slot DATABASE-TYPE
115 * base/recording.lisp: Add new :QUERY type for recording
117 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
118 * Version 2.6.1: documentation fixes, merged
119 classic-tests into tests
121 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
122 * Version 2.6.0 released: New API functions
123 CREATE-DATABASE, DESTORY-DATABASE, PROBE-DATABASE
124 * doc/ref_clsql.xml: Document new functions
125 * base/database.lisp: New API functions
126 * base/conditions.lisp: Added CLSQL-ACCESS-ERROR
127 * base/utils.lisp: Fix use of position-char.
128 Add COMMAND-OUTPUT used by backends for running
129 external programs. Fix parsing of SQL*NET-compatible
131 * base/loop-extension.lisp: Simplify package use
132 for Lispworks and Allegro
133 * db-*/*-sql.lisp: Added DATABASE-CREATE,
134 DATABASE-DESTORY, PROBE-DATABASE methods
135 * tests/test-init.lisp, clasic-tests/tests.lisp:
136 Use destroy-database and create-database to ensure
137 testing with empty database
138 * tests/test-connection.lisp: Add tests for
139 parsing of string connection-specs
140 * examples/run-tests.sh: New file for running
141 test suite on all installed CL implementations
142 * examples/clsql-tutorial.lisp: moved from
144 * examples/dot.clsql-tests.config: New file
145 giving an example test configuration
146 * test/README: Add notes about rtest/ptester
147 downloads and link to sample test configuration file.
149 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
150 * Version 2.5.1 released:
151 * tests/*.lisp: Rework so tests are run
152 on multiple backends automatically based
153 on the contents of ~/.clsql-tests.config.
154 Reuse helper functions from classic-tests.
155 * base/database.lisp: Support connection-spec
156 as string for CONNECT
157 * classic-tests/tests.lisp: Automatically
158 load database backends as needed.
160 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
161 * Version 2.5.0 released:
162 All tests for CLSQL and CLSQL-CLASSIC pass
164 * base/loop-extension.lisp: Add Lispworks
165 loop-extension. Improve type specifying on
168 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
169 * Version 2.4.2 released:
170 loop extension now supported on Allegro, all
171 CLSQL-TESTS pass on Allegro.
172 * sql/metaclasses.lisp: Some optimization
173 of compute-slots, be selective when
174 ordered-class-slots needs to be called
175 instead of class-slots
176 * TODO: add URL with documentation on
177 extending Lispworks LOOP form
179 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
180 * Version 2.4.1 released: CLSQL-TESt suite passes
181 all tests for postgresql and CMUCL, SBCL, OpenMCL.
182 Allegro and Lispworks pass all tests except for
183 FDML/LOOP/1 since the loop extension have not yet
184 been ported to those implementions.
185 * sql/metaclasses.lisp: Added new slot to standard-db-class
186 to hold user-specified type. OpenMCL adjustments to compensate
187 for its type-predicate function. Since AllegroCL, Lispworks,
188 and OpenMCL have different slot orders, added compute-slots
189 and ordered-class-slots functions so their slot order matches
192 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
193 * Version 2.4.0 released: All tests for clsql-classic now finish
194 correctly on Allegro, Lispworks, CMUCL, SBCL, OpenMCL for
195 mysql, postgresql, postgresql-sockets, and sqlite backends.
196 * db-mysql/mysql-sql.lisp: Fix array dereferencing
197 * classic-tests/tests.lisp: Fix package name of
198 number-to-sql-string.
199 * clsql.asd/clsql-tests.asd: Add support for asdf:test-op
200 * db-sqlite/sqlite-api-{uffi,sql}.lisp: Multiple UFFI fixes,
201 now passes tests on all support UFFI platforms.
202 * db-postgresql-socket/postgresql-socket-api.list: Ported to
204 * multiple: Finish renaming of :types keyword to :result-types for
205 greater CommonSQL compatibility, including documentation
206 * sql/basic-cmds.lisp: Remove obsolete file
208 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
209 * Version 2.3.3 released
210 * Fixes for sequences on mysql and sqlite [Marcus Pearce]
211 * Fixes for uffi sqlite backend [Aurelio Bignoli / Kevin Rosenberg]
212 * Fix for schema table [Marcus Pearce]
213 * Add loop extension support for SBCL and OpenMCL [Marcus Pearce]
214 * Fixes to test suite [Marcus Pearce]
216 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
217 * db-*/*-sql.lisp: Ensure that expr in
218 database-query-result-set is a string
219 * Documentation integration
221 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
222 * With for Marcus Pearce's excellent work, I've merged
223 his clsql-usql port into clsql. The original clsql
224 interface is available in the clsql-classic package.
226 02 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
227 * Integrate patch from Marcus Pearce <ek735@soi.city.ac.uk>
228 adding further support for providing backend for UncommonSQL
230 10 Mar 2004 Kevin Rosenberg (kevin@rosenberg.net)
231 * Integrate patch from Aurelio Bignoli for SQLite backend
233 11 Nov 2003 Kevin Rosenberg (kevin@rosenberg.net)
234 * Converted documentation to XML format
235 * Made package installable with asdf-install
237 23 Jul 2003 Kevin Rosenberg (kevin@rosenberg.net)
238 * Add for-each-row macro
240 12 Dec 2002 Kevin Rosenberg (kevin@rosenberg.net)
241 * uffi/clsql-uffi.lisp: return NIL for numeric fields that are NULL
243 16 Oct 2002 Kevin Rosenberg (kevin@rosenberg.net)
244 * Add support for SBCL, OpenMCL, and SCL
245 * Add *load-truename* to search path for clsql's
248 01 Sep 2002 Kevin Rosenberg (kevin@rosenberg.net)
249 * Rework use of file types in .asd files
251 17 Aug 2002 Kevin Rosenberg (kevin@rosenberg.net)
252 * Add .asd definition files for ASDF users
254 31 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
255 * Restructure directories for Common Lisp Controller v3 compatibility
257 25 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
258 * Also change case of logical host in loader files
259 * Rework handling of logical pathnames
261 05 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
262 * Change case of logical host
264 14 May 2002 Kevin Rosenberg (kevin@rosenberg.net)
265 * clsql-base.system: Added base package that can be used without
266 high-level SQL commands. Used for adding support for UncommonSQL.
267 * *.system: Reworked logical pathnames to be more consistent with
268 Common Lisp Controller.
269 * debian/*: Completed initial Debian support
271 10 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
273 * sql/transactions.cl:
274 Added transaction support. Functions/macros added:
275 with-transaction, commit-transaction, rollback-transaction,
276 add-transaction-commit-hook, add-transaction-rollback-hook
278 04 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
282 Added pool support in connect/disconnect and with-database.
283 Removed with-db-from-pool as with-database can now works with the connections pool
285 01 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
290 Completed connection pool.
291 Added with-db-from-pool macro.
293 27 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
295 Added initial support for connection pool
296 * sql/transactions.cl
297 Took transaction code from UncommonSQL and integrated
298 into CLSQL code. See file for disclaimer about why this
301 23 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
302 * interfaces/postgresql/postgresql-sql.cl:
303 Fix keyword typo in database-read-large-object
304 * interfaces/mysql/mysql-loader.cl
306 * test-suite/tester-clsql.cl
307 Fix type coercion of double-float
309 Added debian docbook catalog, made it the default
311 19 Apr 2002 Marc Battyani (marc.battyani@fractalconcept.com)
312 * interface/postgresql/postgresql-api.cl:
313 * interface/postgresql/postgresql-sql.cl:
315 * sql/db-interface.cl:
316 Added large objects support for postgresql.
318 07 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
319 * src/postgresql-socket/postgresql-socket-api.cl:
320 Fixed find-foreign-function call, eliminated crypt warning
322 Multiple improvements
324 Moved functionality from low-level interfaces to this file
325 via generic functions
326 * test-suite/tester.cl:
327 Added test with acl-compat-tester, moved others to old-tests
330 06 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
332 Reinstated commented out sections
333 * interfaces/postgresql/postgresql-loader.cl:
334 * interfaces/mysql/mysql-loader.cl:
335 Updated find-forieign-library support.
336 * interfaces/postgresql-socket/postgresql-socket-package.cl:
337 Fixed require form for Lispworks (Thanks Marc Battyani!)
338 * interfaces/postgresql-socket/postgresql-socket-api.cl:
339 Fixed eval of def-function for crypt library.
341 31 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
342 * Added interface to support USQL high-level rouines
344 29 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
345 * Separated db-interface and conditions from sql/sql.cl
346 * Improved foreign library loading testing
347 * interfaces/postgresql/postgresql-api.cl
348 Added PQisBusy function
349 * interfaces/clsql-uffi/clsql-uffi.cl
350 Fixed sign error for 64-bit processing
352 27 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
353 * interfaces/postgresql-socket/postgresql-socket-api.cl:
354 Fixes to read-double-from-socket. Added 64-bit integer support.
355 * test-suite/xptest-clsql.cl
356 Added testint for 64-bit integers
357 * Additons to installation docs
359 26 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
360 * interfaces/postgresql-socket/postgresql-socket-api.cl:
361 Implemented direct socket reading for field type :double
362 * Added usage information for :types to documentation
363 * interfaces/mysql/mysql-sql.cl: Fixed type specifiers in atoi,
365 * interfaces/clsql-uffi: Created new directory. Split common
366 interface routines that use UFFI into this package. Required
367 especially to support direct reading of 64-bit integers into
368 bignums and bypassing temporary strings.
369 * test-clsql.cl: Updated to test postgresql-socket's
370 read-double-from-socket function.
371 * test-suite/xptest-clsql.cl
372 Started work on test suite
374 25 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
375 * interfaces/mysql/mysql-api.cl: Added mysql-fetch-fields,
376 mysql-fetch-field-direct Got :auto types working
377 * interfaces/postgresql/postgresql-api.cl
378 * interfaces/postgresql-socket/postgresql-socket-api.cl
379 Added pgsql-field-types enum. Got :auto types working.
381 Renamed :field-types to :types.
383 24 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
384 * Added field-types parameter to query, database-query,
385 database-query-result-set, map-query. Haven't added code
386 to utilize field types, yet.
387 * Changed postgresql-socket result set from cons to a structure
388 * Updated test-clsql.cl to use automated testing with a config
390 * Changed return types of field accessors from cstring to
391 (* :unsigned-char). This prepares for being able to use specified
392 type conversions when taking field data into lisp.
393 * Added field-type processing for most interfaces. Not done yet.
395 23 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
396 * doc/ref.sgml: Updated MAP-QUERY example to use
397 *read-default-float-format* (John Foderaro)
398 * Extensive work to foreign library loaders and .system files to
399 check for successful loading of foreign libraries.
400 * Modified test-clsql.cl to allow more modularity and
401 automated testing in future release.
402 * mysql/mysql-sql.lisp: Added field types
404 01 Jan 2002 Kevin Rosenberg (kevin@rosenberg.net)
405 * mysql/mysql-sql.lisp:
406 - Added support for Allegro CL and Lispworks using UFFI layer
407 - Changed database-connect to use mysql-real-connect. This way,
408 can avoid using double (unwind-protect)
409 - Changed database-connect to have MySQL library allocate space
410 for MYSQL structure. This will make the code more robust in
411 the event that MySQL library changes the size of the mysql-mysql