1 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2 * db-odbc/odbc-api.lisp: Fix changing nil to "NIL"
3 for odbc/postgresql backend.
4 * db-odbc/odbc-sql.lisp: Fix ATTRIBUTE-TYPE so that
5 it can handle NIL values from the ODBC driver
7 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
9 * base/conditions.lisp: Add *backend-warning-behavior*
11 * db-postgresql-socket/postgresql-socket-sql.lisp:
12 Honor value of *backend-warning-behavior*
13 * tests/test-fdml.lisp: Remove test of raw boolean value
14 since different backends handle this differently. Add
15 test for :column attribute.
16 * tests/test-oodml.lisp: Add tests for boolean slot value
17 and for :void-value attribute
18 * tests/test-init.lisp: Use *backend-warning-behavior*
19 to suppress warnings from postgresql about implicitly
20 creating primary key in tables. Add new address table.
22 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
24 * db-odbc/odbc-dbi.lisp: Convert TINYINT to integers when
26 * sql/objects.lisp: Properly handled writing/reading Boolean
27 values from SQL database when retrieving objects.
28 * test/test-fdml.lisp: Add another test for boolean results
29 * test/utils.lisp: Fix incorrect declaration
31 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
33 * sql/generics.lisp: add generic function for SELECT.
34 * sql/objects.lisp: make SELECT a method specialisation.
35 * sql/classes.lisp: MAKE-QUERY now calls SELECT if the selections
36 referred to are View Classes.
37 * base/basic-sql.lisp: in DO-QUERY and MAP-QUERY, if the
38 query-expression arg evaluates to a list, then we have an object
40 * tests/test-oodml.lisp: add tests for DO-QUERY and MAP-QUERY with
42 * TODO: remove items done and add a todo for SELECT.
43 * sql/objects.lisp: SELECT takes a :field-names arg to pass on to
45 * sql/sql.lisp: add :field-names arg to QUERY.
46 * tests/test-fdml.lisp: minor rework to use :field-names arg to
49 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
50 * sql/objects.lisp: fix bug in FIND-ALL when SELECT called with 2
52 * sql/objects.lisp: make the :flatp argument to SELECT work with
54 * sql/objects.lisp: make SELECT accept a :result-types argument
55 (defaults to :auto) which is passed on to QUERY.
56 * sql/objects.lisp: SELECT returns field-names as a second value.
57 * tests/test-ooddl.lisp: add flatp arg to SELECT calls as appropriate.
58 * tests/test-fdml.lisp: add flatp/result-types arguments to calls
59 to SELECT and take only first value as appropriate.
60 * tests/test-fdml.lisp: add two new tests for query result coercion
61 and the field-names returned as a second value from SELECT.
62 * tests/test-oodml.lisp: add flatp arg to SELECT calls as appropriate.
64 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
66 * sql/metaclasses.lisp: Add void-value slot
67 * doc/csql.xml: Update def-view-class documentation
68 * test/test-init.lisp: Change old :db-type to :db-kind.
69 Remove old :nulls-ok attributes.
70 * sql/objects.lisp: Add new universal-time and bigint
71 types. Optimize reading of integers using parse-integer
72 rather than read-from-string.
73 * */*.lisp: Merge clsql-base-sys and clsql-base packages
74 into clsql-base package
75 * classic/sql.lisp: Move large object support into base, leaving
76 classic without any functionality that is provided in the clsql
78 * classic/package.lisp: Rename clsql-classic-sys package to
79 its former nickname of clsql-classic
81 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
82 * Version 2.10.5: SQLite backend now passes all result-types tests
83 * clsql-sqlite.asd: Depend on clsql-uffi system
84 * db-sqlite/sqlite-sql.lisp: Use clsql-uffi:convert-raw-field
85 for efficiency and code reuse.
86 * db-sqlite/sqlite-api-uffi.lisp: Change (* :char) to (* :unsigned-char)
87 for better cross-implementation compatibility.
89 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
91 * sql/tables.lisp: Fix typo in CACHE-TABLE-QUERIES
93 * db-postgresql/postgresql-sql.lisp: Fix foreign-string vs. cstring
94 bug on SBCL in result-field-names function as reported by Marcus Pearce
95 * db-sqlite/sqlite-sql.lisp: Fix in database-store-next-row
96 manifest in SBCL testing
98 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
100 * sql/database.lisp: Conform more to CommonSQL output
101 for STATUS command [Marcus Pearce]
102 * sql/sqlite-sql.lisp: Rework to use result-types
103 * sql/sqlite-api-clisp.lisp: Add compatibility layer
104 with sqlite-api-uffi.lisp so that sqlite-sql.lisp can
105 be cleaned up of most clisp reader conditionals
106 * sql/test-init.lisp: Now run field type tests on sqlite
109 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
111 * base/basic-sql.lisp: Set default value of :result-types
112 to :auto for more CommonSQL conformance.
113 * test/test-fdml.lisp: Add tests for numeric value of fields
116 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
117 * Version 2.10.1: New API function: CACHE-TABLE-QUERIES.
118 * base/basic-sql.lisp, db-*/*-sql.lisp: More CommonSQL conformance.
119 Return field names as second value for QUERY. This can be overridden
120 for efficiency with the new keyword :FIELD-NAMES set to NIL
121 in the QUERY invocation.
122 * test/test-fdml.lisp: Add tests for new field-name feature
123 * sql/metaclass.lisp: Remove old Lispworks cruft
124 and replace it with invocation of new code in kmr-mop.lisp
125 which actually works with Lispworks 4.2
126 * doc/ref_clsql.xml: Document new :FIELD-NAMES keyword to
128 * base/db-interface.lisp: Document the multiple values
129 returned by DATABASE-ATTRIBUTE-TYPE so matches the
130 undocumented CommonSQL behavior.
131 * sql/table.lisp: Add *CACHE-TABLE-QUERIES-DEFAULT* and
132 *DEFAULT-UPDATE-OBJECTS-MAX-LEN* variables and export them.
133 LIST-ATTRIBUTE-TYPES now conforms to CommonSQL spec.
134 Implement CACHE-TABLE-QUERIES.
135 * db-odbc/odbc-sql.lisp: Fix attribute-type function
136 * test/test-fddl.lisp: Add tests for attribute type
137 * db-mysql/mysql-sql.lisp: Mild optimization in accessing
139 * base/classes.lisp: Add attribute-cache slot to database clas
140 * base/initialize.lisp: initialize-database-type now automatically
141 loads database-type backend as needed.
142 * base/test-init.lisp: Utilize new initialize-database-type functionality.
143 * TODO: remove items done
145 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
147 * sql/objects.lisp: remove create/drop-sequence-from-class.
148 * sql/objects.lisp: add INSTANCE-REFRESHED generic function.
149 * sql/objects.lisp: improved CommonSQL compatibility for
150 UPDATE-RECORD-FROM-SLOT, UPDATE-RECORD-FROM-SLOTS,
151 UPDATE-RECORDS-FROM-INSTANCE and DELETE-INSTANCE-RECORDS.
152 * sql/generics.lisp: move generics from objects.lisp to here.
154 29 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
156 * db-mysql/mysql-client-info.lisp: Add client version 4.1
158 * sql/sql.lisp: Make *default-database* the default for
161 28 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
163 * db-mysql/mysql-sql.lisp: Fix bug in transaction capability
165 * sql/objects.lisp: Commit patch from Slawek Zak to allow specifying
166 :metaclass in DEF-VIEW-CLASS invocation. This allows defining classes
167 on a metaclass specialized from standard-db-class.
170 24 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
171 * Version 2.9.4: Multiple changes to support Allegro's "modern"
172 lisp which uses a lowercase reader and has case-sensitive symbols
173 * sql/classes.lisp: Fix make-load-form bug for sql-ident-table
174 exposed by case-sensitive mlisp.
176 22 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
177 * Version 2.9.3: All tests now pass on all platforms!
178 * LATEST-TEST-RESULTS: New file with summary of test results
179 * sql/generics.lisp: New file for generic function definitions.
180 * test/test-init.lisp: Display names of skipped tests.
181 Use unwind-protect to ensure disconnect
182 * sql/objects.lisp: Change database-type to database-underlying-type
183 so that actual database engine is properly identified
184 * db-odbc/odbc-api.lisp: Have default *time-conversion-function*
185 return an ISO timestring for compatibility with other drivers.
186 Workaround bug in MyODBC for LIST-TABLE-INDEXES
187 * test/test-fdml.lisp: Accomodate that odbc-postgresql driver
188 returns floating-point values for floor and truncate operations
189 * db-aodbc/aodbc-sql.lisp: Implement DATABASE-LIST-VIEWS
190 * tests/test-basic.lisp: Port to regression tester
191 * test/test-init.lisp: Output to *report-stream*
192 * docs/appendix.xml: Document ODBC and SQLite backends.
193 * sql/classes.lisp: Make output-sql require a database parameter.
194 This allows SQL generation to have the proper case to support
195 the differences in case handling between CommonSQL API,
196 Postgresql, MySQL, Oracle.
198 21 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
199 * Version 2.9.2: Improvments in database capability introspection
200 and querying. Support transactions in MySQL where available.
201 All tests now pass on MySQL and SQLite in addition to postgresql
202 and postgresql-socket. ODBC fails only with OODDL/TIME/1 and OODDL/TIME/2.
203 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST-VIEWS. Better support
204 DATABASE-LIST-SEQUENCES.
205 * clsql-uffi.asd, clsql-mysql.asd: Improve shared library loading
206 * Database_capabilies: add HAS-VIEWS, HAS-CREATE/DESTROY-DB,
207 HAS-BOOLEAN-WHERE, TRANSACTION-CAPABLE
208 * tests/*.lisp: Check database capabilities and remove tests which
209 the database backend does not support
210 * sql/table.lisp: Add :TRANSACTIONS keyword to create table which
211 controls whether InnoDB tables will be created when supported on
212 the underlying MySQL server.
214 20 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
215 * Version 2.9.0: New API function: LIST-TABLE-INDEXES,
216 supported by all database backends (except AODBC since
217 AODBC doesn't support index querying)
218 * db-obdc/odbc-sql.lisp: Support DATABASE-LIST-INDEXES
219 * db-odbc/odbc-api.lisp: Add %TABLE-STATISTICS function
220 to support index queries
221 * db-aodbc/aodbc-sql.lisp: Filter driver manager
222 "information_schema" tables from LIST-TABLES
223 * tests/test-basic.lisp: Remove table after testing
224 * tests/test-fddl.lisp: Test LIST-TABLE-INDEXES
225 * base/db-interface.lisp: Add DATABASE-UNDERLYING-TYPE
226 which gets the underlying type of database -- required
227 when dealing with ODBC databases and want to query
228 database capabilities. Added DB-USE-COLUMN-ON-DROP-TABLES?
229 as first database-backend specific feature. Is T on
230 :mysql, NIL on other backends. Change DROP-TABLE to
233 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
234 * Version 2.8.2: Build changes for FreeBSD [Slawek Zak]
236 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
238 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST function
239 * db-odbc/odbc-dbi.lisp: Add LIST-ALL-DATA-SOURCES function
241 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
242 * Version 2.8.0: New API function: LIST-DATABASES
243 * base/utils.lisp: Fix command-output on CMUCL/SBCL
244 * db-*/*-sql.lisp: Add new database-list function
245 * base/database.lisp: Add new LIST-DATABASES command
247 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
249 * db-sqlite/sqlite-sql.lisp: Fix sequence functions.
250 * db-sqlite/sqlite-api-uffi.lisp: Print error string
253 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
255 * doc/csql.xml, examples/clsql-tutorial.lisp: Patch for db-kind
258 17 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
260 * base/objects.lisp, base/classes.lisp: Patch
261 for db-kind from Eduardo Munoz
263 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
265 * base/basic-sql.lisp: Fix FLATP in QUERY
267 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
268 * Version 2.7.3: Implement RECONNECT
270 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
271 * Version 2.7.2: Fix ODBC on Lispworks Windows
273 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
274 * Version 2.7.1: Fix for new ODBC backend.
275 clsql-odbc now works on SBCL, CMUCL, OpenMCL
276 in addition to AllegroCL and Lispworks.
278 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
279 * Version 2.7.0: New backend: ODBC. Tests as
280 well as AODBC backend on Allegro,Lispworks.
281 SBCL and CMUCL don't work quite yet. Requires UFFI v1.4.11+
282 * db-odbc/*.lisp: Add ODBC3 function SQLSetEnvAttr
283 to explicitly set ODBC2 support. Add BIGINT support.
284 Add result-types support. Added SQLTables.
285 Fix array type in fetch-all-rows. Make width
286 changable by database or query.
287 * base/utils.lisp: Add process functions
288 * base/package.lisp: Export utils to CLSQL-BASE-SYS
289 * db-aodbc: Implement sequence functions,
290 database-list-tables, database-list-attributes
291 * tests/utils.lisp: Add support for ODBC backend,
292 rework READ-SPECS to use +all-db-types+
293 * db-mysql/mysql-sql.lisp: Use WITHOUT-INTERRUPTS
296 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
297 * Version 2.6.13. Requires UFFI version 1.4.9
298 * db-odbc/*.lisp: Further porting.
299 Pre-alpha code! But, basic query is now working.
301 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
303 * base/transactions.lisp: Add quote for macro
304 expansion of WITH-TRANSACTIONS [Time Howe]
305 * db-sqlite/sqlite-sql.lisp: Support memory database
306 in database-probe [Ng Pheng Siong]
307 * db-odbc/*.lisp: Initial port to UFFI of SQL-ODBC.
308 The DBI layer is not finished.
310 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
312 * sql/objects.lisp: add :root-class functionality for
313 list-classes and add duration type support [Marcus Pearce]
314 * db-odbc: Add mid-level [DBI] layer
316 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
318 * db-aodbc: Add methods for generic functions, some are
320 * clsql-odbc.asd, db-odbc/*.lisp: Initial start of ODBC
323 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
325 * base/package.lisp: Add missing symbols [Marcus Pearce]
327 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
329 * test/test-fddl.lisp: Cleanup fix [Marcus Pearce]
330 * utils/time.lisp: Multiple fixes [Marcus Pearce]
331 * sql/sql.lisp: Fix for truncate-database [Marcus Pearce]
333 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
335 * sql/*.lisp: Remove schema versioning cruft
337 * Makefile: Add classic subdirectory
339 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
341 * sql/sql.lisp: Fix TRUNCATE command, bug reported
343 * sql/sql.lisp: Remove EXPLAIN function. Postgresql/Oracle
344 specific and easy for an application to directly support.
345 Idea from Marcus Pearce.
346 * base/basic-sql.lisp: Remove DESCRIBE-TABLE top-level
347 API as duplicates LIST-ATTRIBUTE-TYPES [Marcus Pearce].
348 Keep low-level interface for future optimization
349 supporting LIST-ATTRIBUTE-TYPES command.
350 * Makefile: Add to db-sqlite and test directories.
351 Include them in top-level Makefile
353 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
355 * sql/relations.lisp: Add missing file
356 * utils/time.lisp: Fixes/extensions [Marcus Pearce]
357 * test/test-time.lips: New file [Marcus Pearce]
359 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
361 * test/test-init.lisp: Properly handle object
362 creation. Close database after use.
363 * sql/sql.lisp: Make DESCRIBE-TABLE a generic
364 function so can have methods specialized on
365 table being a string or an sql-table object.
366 * base/pool.lisp: Really fix CMUCL locking
368 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
370 * test/test-init.lisp: Signal correctly
371 if any errors occurred in any test suite
372 * base/loop-extensions.lisp: Fix error
373 introduced for Lispworks
374 * base/pool.lisp: Fix locking for CMUCL
375 * base/objects.lisp: Remove schema-version cruft
377 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
378 * Version 2.6.2: New CLSQL API functions:
379 DESCRIBE-TABLE AND TRUNCATE-DATABASE
380 Currently, this are only supported on :postgresql
381 and :postgresql-socket
382 * base/database.lisp: automatically load ASDF system
383 in CONNECT if not already loaded
384 * base/tests.lisp: disconnect database after testing
385 * base/*.lisp: Remove CLOSED-DATABASE type in favor
386 of storing open/closed status in slot of database
387 * base/pool.lisp: Support locks for CMUCL, OpenMCL, SBCL
388 * db-postgresql/postgresql-sql.lisp: add DATABASE-RECONNECT,
389 DATABASE-DESCRIBE-TABLE
390 * db-sqlite/sqlite-sql.lisp: Add missing slots in database
391 * base/conditions: Remove duplicate condition
392 * db-*/*-sql.lisp: Fill new database slot DATABASE-TYPE
393 * base/recording.lisp: Add new :QUERY type for recording
395 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
396 * Version 2.6.1: documentation fixes, merged
397 classic-tests into tests
399 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
400 * Version 2.6.0 released: New API functions
401 CREATE-DATABASE, DESTORY-DATABASE, PROBE-DATABASE
402 * doc/ref_clsql.xml: Document new functions
403 * base/database.lisp: New API functions
404 * base/conditions.lisp: Added CLSQL-ACCESS-ERROR
405 * base/utils.lisp: Fix use of position-char.
406 Add COMMAND-OUTPUT used by backends for running
407 external programs. Fix parsing of SQL*NET-compatible
409 * base/loop-extension.lisp: Simplify package use
410 for Lispworks and Allegro
411 * db-*/*-sql.lisp: Added DATABASE-CREATE,
412 DATABASE-DESTORY, PROBE-DATABASE methods
413 * tests/test-init.lisp, clasic-tests/tests.lisp:
414 Use destroy-database and create-database to ensure
415 testing with empty database
416 * tests/test-connection.lisp: Add tests for
417 parsing of string connection-specs
418 * examples/run-tests.sh: New file for running
419 test suite on all installed CL implementations
420 * examples/clsql-tutorial.lisp: moved from
422 * examples/dot.clsql-tests.config: New file
423 giving an example test configuration
424 * test/README: Add notes about rtest/ptester
425 downloads and link to sample test configuration file.
427 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
428 * Version 2.5.1 released:
429 * tests/*.lisp: Rework so tests are run
430 on multiple backends automatically based
431 on the contents of ~/.clsql-tests.config.
432 Reuse helper functions from classic-tests.
433 * base/database.lisp: Support connection-spec
434 as string for CONNECT
435 * classic-tests/tests.lisp: Automatically
436 load database backends as needed.
438 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
439 * Version 2.5.0 released:
440 All tests for CLSQL and CLSQL-CLASSIC pass
442 * base/loop-extension.lisp: Add Lispworks
443 loop-extension. Improve type specifying on
446 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
447 * Version 2.4.2 released:
448 loop extension now supported on Allegro, all
449 CLSQL-TESTS pass on Allegro.
450 * sql/metaclasses.lisp: Some optimization
451 of compute-slots, be selective when
452 ordered-class-slots needs to be called
453 instead of class-slots
454 * TODO: add URL with documentation on
455 extending Lispworks LOOP form
457 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
458 * Version 2.4.1 released: CLSQL-TESt suite passes
459 all tests for postgresql and CMUCL, SBCL, OpenMCL.
460 Allegro and Lispworks pass all tests except for
461 FDML/LOOP/1 since the loop extension have not yet
462 been ported to those implementions.
463 * sql/metaclasses.lisp: Added new slot to standard-db-class
464 to hold user-specified type. OpenMCL adjustments to compensate
465 for its type-predicate function. Since AllegroCL, Lispworks,
466 and OpenMCL have different slot orders, added compute-slots
467 and ordered-class-slots functions so their slot order matches
470 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
471 * Version 2.4.0 released: All tests for clsql-classic now finish
472 correctly on Allegro, Lispworks, CMUCL, SBCL, OpenMCL for
473 mysql, postgresql, postgresql-sockets, and sqlite backends.
474 * db-mysql/mysql-sql.lisp: Fix array dereferencing
475 * classic-tests/tests.lisp: Fix package name of
476 number-to-sql-string.
477 * clsql.asd/clsql-tests.asd: Add support for asdf:test-op
478 * db-sqlite/sqlite-api-{uffi,sql}.lisp: Multiple UFFI fixes,
479 now passes tests on all support UFFI platforms.
480 * db-postgresql-socket/postgresql-socket-api.list: Ported to
482 * multiple: Finish renaming of :types keyword to :result-types for
483 greater CommonSQL compatibility, including documentation
484 * sql/basic-cmds.lisp: Remove obsolete file
486 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
487 * Version 2.3.3 released
488 * Fixes for sequences on mysql and sqlite [Marcus Pearce]
489 * Fixes for uffi sqlite backend [Aurelio Bignoli / Kevin Rosenberg]
490 * Fix for schema table [Marcus Pearce]
491 * Add loop extension support for SBCL and OpenMCL [Marcus Pearce]
492 * Fixes to test suite [Marcus Pearce]
494 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
495 * db-*/*-sql.lisp: Ensure that expr in
496 database-query-result-set is a string
497 * Documentation integration
499 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
500 * With for Marcus Pearce's excellent work, I've merged
501 his clsql-usql port into clsql. The original clsql
502 interface is available in the clsql-classic package.
504 02 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
505 * Integrate patch from Marcus Pearce <ek735@soi.city.ac.uk>
506 adding further support for providing backend for UncommonSQL
508 10 Mar 2004 Kevin Rosenberg (kevin@rosenberg.net)
509 * Integrate patch from Aurelio Bignoli for SQLite backend
511 11 Nov 2003 Kevin Rosenberg (kevin@rosenberg.net)
512 * Converted documentation to XML format
513 * Made package installable with asdf-install
515 23 Jul 2003 Kevin Rosenberg (kevin@rosenberg.net)
516 * Add for-each-row macro
518 12 Dec 2002 Kevin Rosenberg (kevin@rosenberg.net)
519 * uffi/clsql-uffi.lisp: return NIL for numeric fields that are NULL
521 16 Oct 2002 Kevin Rosenberg (kevin@rosenberg.net)
522 * Add support for SBCL, OpenMCL, and SCL
523 * Add *load-truename* to search path for clsql's
526 01 Sep 2002 Kevin Rosenberg (kevin@rosenberg.net)
527 * Rework use of file types in .asd files
529 17 Aug 2002 Kevin Rosenberg (kevin@rosenberg.net)
530 * Add .asd definition files for ASDF users
532 31 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
533 * Restructure directories for Common Lisp Controller v3 compatibility
535 25 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
536 * Also change case of logical host in loader files
537 * Rework handling of logical pathnames
539 05 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
540 * Change case of logical host
542 14 May 2002 Kevin Rosenberg (kevin@rosenberg.net)
543 * clsql-base.system: Added base package that can be used without
544 high-level SQL commands. Used for adding support for UncommonSQL.
545 * *.system: Reworked logical pathnames to be more consistent with
546 Common Lisp Controller.
547 * debian/*: Completed initial Debian support
549 10 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
551 * sql/transactions.cl:
552 Added transaction support. Functions/macros added:
553 with-transaction, commit-transaction, rollback-transaction,
554 add-transaction-commit-hook, add-transaction-rollback-hook
556 04 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
560 Added pool support in connect/disconnect and with-database.
561 Removed with-db-from-pool as with-database can now works with the connections pool
563 01 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
568 Completed connection pool.
569 Added with-db-from-pool macro.
571 27 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
573 Added initial support for connection pool
574 * sql/transactions.cl
575 Took transaction code from UncommonSQL and integrated
576 into CLSQL code. See file for disclaimer about why this
579 23 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
580 * interfaces/postgresql/postgresql-sql.cl:
581 Fix keyword typo in database-read-large-object
582 * interfaces/mysql/mysql-loader.cl
584 * test-suite/tester-clsql.cl
585 Fix type coercion of double-float
587 Added debian docbook catalog, made it the default
589 19 Apr 2002 Marc Battyani (marc.battyani@fractalconcept.com)
590 * interface/postgresql/postgresql-api.cl:
591 * interface/postgresql/postgresql-sql.cl:
593 * sql/db-interface.cl:
594 Added large objects support for postgresql.
596 07 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
597 * src/postgresql-socket/postgresql-socket-api.cl:
598 Fixed find-foreign-function call, eliminated crypt warning
600 Multiple improvements
602 Moved functionality from low-level interfaces to this file
603 via generic functions
604 * test-suite/tester.cl:
605 Added test with acl-compat-tester, moved others to old-tests
608 06 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
610 Reinstated commented out sections
611 * interfaces/postgresql/postgresql-loader.cl:
612 * interfaces/mysql/mysql-loader.cl:
613 Updated find-forieign-library support.
614 * interfaces/postgresql-socket/postgresql-socket-package.cl:
615 Fixed require form for Lispworks (Thanks Marc Battyani!)
616 * interfaces/postgresql-socket/postgresql-socket-api.cl:
617 Fixed eval of def-function for crypt library.
619 31 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
620 * Added interface to support USQL high-level rouines
622 29 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
623 * Separated db-interface and conditions from sql/sql.cl
624 * Improved foreign library loading testing
625 * interfaces/postgresql/postgresql-api.cl
626 Added PQisBusy function
627 * interfaces/clsql-uffi/clsql-uffi.cl
628 Fixed sign error for 64-bit processing
630 27 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
631 * interfaces/postgresql-socket/postgresql-socket-api.cl:
632 Fixes to read-double-from-socket. Added 64-bit integer support.
633 * test-suite/xptest-clsql.cl
634 Added testint for 64-bit integers
635 * Additons to installation docs
637 26 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
638 * interfaces/postgresql-socket/postgresql-socket-api.cl:
639 Implemented direct socket reading for field type :double
640 * Added usage information for :types to documentation
641 * interfaces/mysql/mysql-sql.cl: Fixed type specifiers in atoi,
643 * interfaces/clsql-uffi: Created new directory. Split common
644 interface routines that use UFFI into this package. Required
645 especially to support direct reading of 64-bit integers into
646 bignums and bypassing temporary strings.
647 * test-clsql.cl: Updated to test postgresql-socket's
648 read-double-from-socket function.
649 * test-suite/xptest-clsql.cl
650 Started work on test suite
652 25 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
653 * interfaces/mysql/mysql-api.cl: Added mysql-fetch-fields,
654 mysql-fetch-field-direct Got :auto types working
655 * interfaces/postgresql/postgresql-api.cl
656 * interfaces/postgresql-socket/postgresql-socket-api.cl
657 Added pgsql-field-types enum. Got :auto types working.
659 Renamed :field-types to :types.
661 24 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
662 * Added field-types parameter to query, database-query,
663 database-query-result-set, map-query. Haven't added code
664 to utilize field types, yet.
665 * Changed postgresql-socket result set from cons to a structure
666 * Updated test-clsql.cl to use automated testing with a config
668 * Changed return types of field accessors from cstring to
669 (* :unsigned-char). This prepares for being able to use specified
670 type conversions when taking field data into lisp.
671 * Added field-type processing for most interfaces. Not done yet.
673 23 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
674 * doc/ref.sgml: Updated MAP-QUERY example to use
675 *read-default-float-format* (John Foderaro)
676 * Extensive work to foreign library loaders and .system files to
677 check for successful loading of foreign libraries.
678 * Modified test-clsql.cl to allow more modularity and
679 automated testing in future release.
680 * mysql/mysql-sql.lisp: Added field types
682 01 Jan 2002 Kevin Rosenberg (kevin@rosenberg.net)
683 * mysql/mysql-sql.lisp:
684 - Added support for Allegro CL and Lispworks using UFFI layer
685 - Changed database-connect to use mysql-real-connect. This way,
686 can avoid using double (unwind-protect)
687 - Changed database-connect to have MySQL library allocate space
688 for MYSQL structure. This will make the code more robust in
689 the event that MySQL library changes the size of the mysql-mysql