1 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2 * Version 2.10.5: SQLite backend now passes all result-types tests
3 * clsql-sqlite.asd: Depend on clsql-uffi system
4 * db-sqlite/sqlite-sql.lisp: Use clsql-uffi:convert-raw-field
5 for efficiency and code reuse.
6 * db-sqlite/sqlite-api-uffi.lisp: Change (* :char) to (* :unsigned-char)
7 for better cross-implementation compatibility.
9 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
11 * sql/tables.lisp: Fix typo in CACHE-TABLE-QUERIES
13 * db-postgresql/postgresql-sql.lisp: Fix foreign-string vs. cstring
14 bug on SBCL in result-field-names function as reported by Marcus Pearce
15 * db-sqlite/sqlite-sql.lisp: Fix in database-store-next-row
16 manifest in SBCL testing
18 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
20 * sql/database.lisp: Conform more to CommonSQL output
21 for STATUS command [Marcus Pearce]
22 * sql/sqlite-sql.lisp: Rework to use result-types
23 * sql/sqlite-api-clisp.lisp: Add compatibility layer
24 with sqlite-api-uffi.lisp so that sqlite-sql.lisp can
25 be cleaned up of most clisp reader conditionals
26 * sql/test-init.lisp: Now run field type tests on sqlite
29 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
31 * base/basic-sql.lisp: Set default value of :result-types
32 to :auto for more CommonSQL conformance.
33 * test/test-fdml.lisp: Add tests for numeric value of fields
36 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
37 * Version 2.10.1: New API function: CACHE-TABLE-QUERIES.
38 * base/basic-sql.lisp, db-*/*-sql.lisp: More CommonSQL conformance.
39 Return field names as second value for QUERY. This can be overridden
40 for efficiency with the new keyword :FIELD-NAMES set to NIL
41 in the QUERY invocation.
42 * test/test-fdml.lisp: Add tests for new field-name feature
43 * sql/metaclass.lisp: Remove old Lispworks cruft
44 and replace it with invocation of new code in kmr-mop.lisp
45 which actually works with Lispworks 4.2
46 * doc/ref_clsql.xml: Document new :FIELD-NAMES keyword to
48 * base/db-interface.lisp: Document the multiple values
49 returned by DATABASE-ATTRIBUTE-TYPE so matches the
50 undocumented CommonSQL behavior.
51 * sql/table.lisp: Add *CACHE-TABLE-QUERIES-DEFAULT* and
52 *DEFAULT-UPDATE-OBJECTS-MAX-LEN* variables and export them.
53 LIST-ATTRIBUTE-TYPES now conforms to CommonSQL spec.
54 Implement CACHE-TABLE-QUERIES.
55 * db-odbc/odbc-sql.lisp: Fix attribute-type function
56 * test/test-fddl.lisp: Add tests for attribute type
57 * db-mysql/mysql-sql.lisp: Mild optimization in accessing
59 * base/classes.lisp: Add attribute-cache slot to database clas
60 * base/initialize.lisp: initialize-database-type now automatically
61 loads database-type backend as needed.
62 * base/test-init.lisp: Utilize new initialize-database-type functionality.
63 * TODO: remove items done
65 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
67 * sql/objects.lisp: remove create/drop-sequence-from-class.
68 * sql/objects.lisp: add INSTANCE-REFRESHED generic function.
69 * sql/objects.lisp: improved CommonSQL compatibility for
70 UPDATE-RECORD-FROM-SLOT, UPDATE-RECORD-FROM-SLOTS,
71 UPDATE-RECORDS-FROM-INSTANCE and DELETE-INSTANCE-RECORDS.
72 * sql/generics.lisp: move generics from objects.lisp to here.
74 29 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
76 * db-mysql/mysql-client-info.lisp: Add client version 4.1
78 * sql/sql.lisp: Make *default-database* the default for
81 28 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
83 * db-mysql/mysql-sql.lisp: Fix bug in transaction capability
85 * sql/objects.lisp: Commit patch from Slawek Zak to allow specifying
86 :metaclass in DEF-VIEW-CLASS invocation. This allows defining classes
87 on a metaclass specialized from standard-db-class.
90 24 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
91 * Version 2.9.4: Multiple changes to support Allegro's "modern"
92 lisp which uses a lowercase reader and has case-sensitive symbols
93 * sql/classes.lisp: Fix make-load-form bug for sql-ident-table
94 exposed by case-sensitive mlisp.
96 22 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
97 * Version 2.9.3: All tests now pass on all platforms!
98 * LATEST-TEST-RESULTS: New file with summary of test results
99 * sql/generics.lisp: New file for generic function definitions.
100 * test/test-init.lisp: Display names of skipped tests.
101 Use unwind-protect to ensure disconnect
102 * sql/objects.lisp: Change database-type to database-underlying-type
103 so that actual database engine is properly identified
104 * db-odbc/odbc-api.lisp: Have default *time-conversion-function*
105 return an ISO timestring for compatibility with other drivers.
106 Workaround bug in MyODBC for LIST-TABLE-INDEXES
107 * test/test-fdml.lisp: Accomodate that odbc-postgresql driver
108 returns floating-point values for floor and truncate operations
109 * db-aodbc/aodbc-sql.lisp: Implement DATABASE-LIST-VIEWS
110 * tests/test-basic.lisp: Port to regression tester
111 * test/test-init.lisp: Output to *report-stream*
112 * docs/appendix.xml: Document ODBC and SQLite backends.
113 * sql/classes.lisp: Make output-sql require a database parameter.
114 This allows SQL generation to have the proper case to support
115 the differences in case handling between CommonSQL API,
116 Postgresql, MySQL, Oracle.
118 21 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
119 * Version 2.9.2: Improvments in database capability introspection
120 and querying. Support transactions in MySQL where available.
121 All tests now pass on MySQL and SQLite in addition to postgresql
122 and postgresql-socket. ODBC fails only with OODDL/TIME/1 and OODDL/TIME/2.
123 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST-VIEWS. Better support
124 DATABASE-LIST-SEQUENCES.
125 * clsql-uffi.asd, clsql-mysql.asd: Improve shared library loading
126 * Database_capabilies: add HAS-VIEWS, HAS-CREATE/DESTROY-DB,
127 HAS-BOOLEAN-WHERE, TRANSACTION-CAPABLE
128 * tests/*.lisp: Check database capabilities and remove tests which
129 the database backend does not support
130 * sql/table.lisp: Add :TRANSACTIONS keyword to create table which
131 controls whether InnoDB tables will be created when supported on
132 the underlying MySQL server.
134 20 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
135 * Version 2.9.0: New API function: LIST-TABLE-INDEXES,
136 supported by all database backends (except AODBC since
137 AODBC doesn't support index querying)
138 * db-obdc/odbc-sql.lisp: Support DATABASE-LIST-INDEXES
139 * db-odbc/odbc-api.lisp: Add %TABLE-STATISTICS function
140 to support index queries
141 * db-aodbc/aodbc-sql.lisp: Filter driver manager
142 "information_schema" tables from LIST-TABLES
143 * tests/test-basic.lisp: Remove table after testing
144 * tests/test-fddl.lisp: Test LIST-TABLE-INDEXES
145 * base/db-interface.lisp: Add DATABASE-UNDERLYING-TYPE
146 which gets the underlying type of database -- required
147 when dealing with ODBC databases and want to query
148 database capabilities. Added DB-USE-COLUMN-ON-DROP-TABLES?
149 as first database-backend specific feature. Is T on
150 :mysql, NIL on other backends. Change DROP-TABLE to
153 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
154 * Version 2.8.2: Build changes for FreeBSD [Slawek Zak]
156 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
158 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST function
159 * db-odbc/odbc-dbi.lisp: Add LIST-ALL-DATA-SOURCES function
161 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
162 * Version 2.8.0: New API function: LIST-DATABASES
163 * base/utils.lisp: Fix command-output on CMUCL/SBCL
164 * db-*/*-sql.lisp: Add new database-list function
165 * base/database.lisp: Add new LIST-DATABASES command
167 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
169 * db-sqlite/sqlite-sql.lisp: Fix sequence functions.
170 * db-sqlite/sqlite-api-uffi.lisp: Print error string
173 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
175 * doc/csql.xml, examples/clsql-tutorial.lisp: Patch for db-kind
178 17 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
180 * base/objects.lisp, base/classes.lisp: Patch
181 for db-kind from Eduardo Munoz
183 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
185 * base/basic-sql.lisp: Fix FLATP in QUERY
187 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
188 * Version 2.7.3: Implement RECONNECT
190 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
191 * Version 2.7.2: Fix ODBC on Lispworks Windows
193 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
194 * Version 2.7.1: Fix for new ODBC backend.
195 clsql-odbc now works on SBCL, CMUCL, OpenMCL
196 in addition to AllegroCL and Lispworks.
198 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
199 * Version 2.7.0: New backend: ODBC. Tests as
200 well as AODBC backend on Allegro,Lispworks.
201 SBCL and CMUCL don't work quite yet. Requires UFFI v1.4.11+
202 * db-odbc/*.lisp: Add ODBC3 function SQLSetEnvAttr
203 to explicitly set ODBC2 support. Add BIGINT support.
204 Add result-types support. Added SQLTables.
205 Fix array type in fetch-all-rows. Make width
206 changable by database or query.
207 * base/utils.lisp: Add process functions
208 * base/package.lisp: Export utils to CLSQL-BASE-SYS
209 * db-aodbc: Implement sequence functions,
210 database-list-tables, database-list-attributes
211 * tests/utils.lisp: Add support for ODBC backend,
212 rework READ-SPECS to use +all-db-types+
213 * db-mysql/mysql-sql.lisp: Use WITHOUT-INTERRUPTS
216 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
217 * Version 2.6.13. Requires UFFI version 1.4.9
218 * db-odbc/*.lisp: Further porting.
219 Pre-alpha code! But, basic query is now working.
221 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
223 * base/transactions.lisp: Add quote for macro
224 expansion of WITH-TRANSACTIONS [Time Howe]
225 * db-sqlite/sqlite-sql.lisp: Support memory database
226 in database-probe [Ng Pheng Siong]
227 * db-odbc/*.lisp: Initial port to UFFI of SQL-ODBC.
228 The DBI layer is not finished.
230 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
232 * sql/objects.lisp: add :root-class functionality for
233 list-classes and add duration type support [Marcus Pearce]
234 * db-odbc: Add mid-level [DBI] layer
236 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
238 * db-aodbc: Add methods for generic functions, some are
240 * clsql-odbc.asd, db-odbc/*.lisp: Initial start of ODBC
243 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
245 * base/package.lisp: Add missing symbols [Marcus Pearce]
247 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
249 * test/test-fddl.lisp: Cleanup fix [Marcus Pearce]
250 * utils/time.lisp: Multiple fixes [Marcus Pearce]
251 * sql/sql.lisp: Fix for truncate-database [Marcus Pearce]
253 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
255 * sql/*.lisp: Remove schema versioning cruft
257 * Makefile: Add classic subdirectory
259 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
261 * sql/sql.lisp: Fix TRUNCATE command, bug reported
263 * sql/sql.lisp: Remove EXPLAIN function. Postgresql/Oracle
264 specific and easy for an application to directly support.
265 Idea from Marcus Pearce.
266 * base/basic-sql.lisp: Remove DESCRIBE-TABLE top-level
267 API as duplicates LIST-ATTRIBUTE-TYPES [Marcus Pearce].
268 Keep low-level interface for future optimization
269 supporting LIST-ATTRIBUTE-TYPES command.
270 * Makefile: Add to db-sqlite and test directories.
271 Include them in top-level Makefile
273 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
275 * sql/relations.lisp: Add missing file
276 * utils/time.lisp: Fixes/extensions [Marcus Pearce]
277 * test/test-time.lips: New file [Marcus Pearce]
279 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
281 * test/test-init.lisp: Properly handle object
282 creation. Close database after use.
283 * sql/sql.lisp: Make DESCRIBE-TABLE a generic
284 function so can have methods specialized on
285 table being a string or an sql-table object.
286 * base/pool.lisp: Really fix CMUCL locking
288 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
290 * test/test-init.lisp: Signal correctly
291 if any errors occurred in any test suite
292 * base/loop-extensions.lisp: Fix error
293 introduced for Lispworks
294 * base/pool.lisp: Fix locking for CMUCL
295 * base/objects.lisp: Remove schema-version cruft
297 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
298 * Version 2.6.2: New CLSQL API functions:
299 DESCRIBE-TABLE AND TRUNCATE-DATABASE
300 Currently, this are only supported on :postgresql
301 and :postgresql-socket
302 * base/database.lisp: automatically load ASDF system
303 in CONNECT if not already loaded
304 * base/tests.lisp: disconnect database after testing
305 * base/*.lisp: Remove CLOSED-DATABASE type in favor
306 of storing open/closed status in slot of database
307 * base/pool.lisp: Support locks for CMUCL, OpenMCL, SBCL
308 * db-postgresql/postgresql-sql.lisp: add DATABASE-RECONNECT,
309 DATABASE-DESCRIBE-TABLE
310 * db-sqlite/sqlite-sql.lisp: Add missing slots in database
311 * base/conditions: Remove duplicate condition
312 * db-*/*-sql.lisp: Fill new database slot DATABASE-TYPE
313 * base/recording.lisp: Add new :QUERY type for recording
315 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
316 * Version 2.6.1: documentation fixes, merged
317 classic-tests into tests
319 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
320 * Version 2.6.0 released: New API functions
321 CREATE-DATABASE, DESTORY-DATABASE, PROBE-DATABASE
322 * doc/ref_clsql.xml: Document new functions
323 * base/database.lisp: New API functions
324 * base/conditions.lisp: Added CLSQL-ACCESS-ERROR
325 * base/utils.lisp: Fix use of position-char.
326 Add COMMAND-OUTPUT used by backends for running
327 external programs. Fix parsing of SQL*NET-compatible
329 * base/loop-extension.lisp: Simplify package use
330 for Lispworks and Allegro
331 * db-*/*-sql.lisp: Added DATABASE-CREATE,
332 DATABASE-DESTORY, PROBE-DATABASE methods
333 * tests/test-init.lisp, clasic-tests/tests.lisp:
334 Use destroy-database and create-database to ensure
335 testing with empty database
336 * tests/test-connection.lisp: Add tests for
337 parsing of string connection-specs
338 * examples/run-tests.sh: New file for running
339 test suite on all installed CL implementations
340 * examples/clsql-tutorial.lisp: moved from
342 * examples/dot.clsql-tests.config: New file
343 giving an example test configuration
344 * test/README: Add notes about rtest/ptester
345 downloads and link to sample test configuration file.
347 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
348 * Version 2.5.1 released:
349 * tests/*.lisp: Rework so tests are run
350 on multiple backends automatically based
351 on the contents of ~/.clsql-tests.config.
352 Reuse helper functions from classic-tests.
353 * base/database.lisp: Support connection-spec
354 as string for CONNECT
355 * classic-tests/tests.lisp: Automatically
356 load database backends as needed.
358 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
359 * Version 2.5.0 released:
360 All tests for CLSQL and CLSQL-CLASSIC pass
362 * base/loop-extension.lisp: Add Lispworks
363 loop-extension. Improve type specifying on
366 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
367 * Version 2.4.2 released:
368 loop extension now supported on Allegro, all
369 CLSQL-TESTS pass on Allegro.
370 * sql/metaclasses.lisp: Some optimization
371 of compute-slots, be selective when
372 ordered-class-slots needs to be called
373 instead of class-slots
374 * TODO: add URL with documentation on
375 extending Lispworks LOOP form
377 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
378 * Version 2.4.1 released: CLSQL-TESt suite passes
379 all tests for postgresql and CMUCL, SBCL, OpenMCL.
380 Allegro and Lispworks pass all tests except for
381 FDML/LOOP/1 since the loop extension have not yet
382 been ported to those implementions.
383 * sql/metaclasses.lisp: Added new slot to standard-db-class
384 to hold user-specified type. OpenMCL adjustments to compensate
385 for its type-predicate function. Since AllegroCL, Lispworks,
386 and OpenMCL have different slot orders, added compute-slots
387 and ordered-class-slots functions so their slot order matches
390 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
391 * Version 2.4.0 released: All tests for clsql-classic now finish
392 correctly on Allegro, Lispworks, CMUCL, SBCL, OpenMCL for
393 mysql, postgresql, postgresql-sockets, and sqlite backends.
394 * db-mysql/mysql-sql.lisp: Fix array dereferencing
395 * classic-tests/tests.lisp: Fix package name of
396 number-to-sql-string.
397 * clsql.asd/clsql-tests.asd: Add support for asdf:test-op
398 * db-sqlite/sqlite-api-{uffi,sql}.lisp: Multiple UFFI fixes,
399 now passes tests on all support UFFI platforms.
400 * db-postgresql-socket/postgresql-socket-api.list: Ported to
402 * multiple: Finish renaming of :types keyword to :result-types for
403 greater CommonSQL compatibility, including documentation
404 * sql/basic-cmds.lisp: Remove obsolete file
406 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
407 * Version 2.3.3 released
408 * Fixes for sequences on mysql and sqlite [Marcus Pearce]
409 * Fixes for uffi sqlite backend [Aurelio Bignoli / Kevin Rosenberg]
410 * Fix for schema table [Marcus Pearce]
411 * Add loop extension support for SBCL and OpenMCL [Marcus Pearce]
412 * Fixes to test suite [Marcus Pearce]
414 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
415 * db-*/*-sql.lisp: Ensure that expr in
416 database-query-result-set is a string
417 * Documentation integration
419 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
420 * With for Marcus Pearce's excellent work, I've merged
421 his clsql-usql port into clsql. The original clsql
422 interface is available in the clsql-classic package.
424 02 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
425 * Integrate patch from Marcus Pearce <ek735@soi.city.ac.uk>
426 adding further support for providing backend for UncommonSQL
428 10 Mar 2004 Kevin Rosenberg (kevin@rosenberg.net)
429 * Integrate patch from Aurelio Bignoli for SQLite backend
431 11 Nov 2003 Kevin Rosenberg (kevin@rosenberg.net)
432 * Converted documentation to XML format
433 * Made package installable with asdf-install
435 23 Jul 2003 Kevin Rosenberg (kevin@rosenberg.net)
436 * Add for-each-row macro
438 12 Dec 2002 Kevin Rosenberg (kevin@rosenberg.net)
439 * uffi/clsql-uffi.lisp: return NIL for numeric fields that are NULL
441 16 Oct 2002 Kevin Rosenberg (kevin@rosenberg.net)
442 * Add support for SBCL, OpenMCL, and SCL
443 * Add *load-truename* to search path for clsql's
446 01 Sep 2002 Kevin Rosenberg (kevin@rosenberg.net)
447 * Rework use of file types in .asd files
449 17 Aug 2002 Kevin Rosenberg (kevin@rosenberg.net)
450 * Add .asd definition files for ASDF users
452 31 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
453 * Restructure directories for Common Lisp Controller v3 compatibility
455 25 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
456 * Also change case of logical host in loader files
457 * Rework handling of logical pathnames
459 05 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
460 * Change case of logical host
462 14 May 2002 Kevin Rosenberg (kevin@rosenberg.net)
463 * clsql-base.system: Added base package that can be used without
464 high-level SQL commands. Used for adding support for UncommonSQL.
465 * *.system: Reworked logical pathnames to be more consistent with
466 Common Lisp Controller.
467 * debian/*: Completed initial Debian support
469 10 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
471 * sql/transactions.cl:
472 Added transaction support. Functions/macros added:
473 with-transaction, commit-transaction, rollback-transaction,
474 add-transaction-commit-hook, add-transaction-rollback-hook
476 04 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
480 Added pool support in connect/disconnect and with-database.
481 Removed with-db-from-pool as with-database can now works with the connections pool
483 01 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
488 Completed connection pool.
489 Added with-db-from-pool macro.
491 27 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
493 Added initial support for connection pool
494 * sql/transactions.cl
495 Took transaction code from UncommonSQL and integrated
496 into CLSQL code. See file for disclaimer about why this
499 23 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
500 * interfaces/postgresql/postgresql-sql.cl:
501 Fix keyword typo in database-read-large-object
502 * interfaces/mysql/mysql-loader.cl
504 * test-suite/tester-clsql.cl
505 Fix type coercion of double-float
507 Added debian docbook catalog, made it the default
509 19 Apr 2002 Marc Battyani (marc.battyani@fractalconcept.com)
510 * interface/postgresql/postgresql-api.cl:
511 * interface/postgresql/postgresql-sql.cl:
513 * sql/db-interface.cl:
514 Added large objects support for postgresql.
516 07 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
517 * src/postgresql-socket/postgresql-socket-api.cl:
518 Fixed find-foreign-function call, eliminated crypt warning
520 Multiple improvements
522 Moved functionality from low-level interfaces to this file
523 via generic functions
524 * test-suite/tester.cl:
525 Added test with acl-compat-tester, moved others to old-tests
528 06 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
530 Reinstated commented out sections
531 * interfaces/postgresql/postgresql-loader.cl:
532 * interfaces/mysql/mysql-loader.cl:
533 Updated find-forieign-library support.
534 * interfaces/postgresql-socket/postgresql-socket-package.cl:
535 Fixed require form for Lispworks (Thanks Marc Battyani!)
536 * interfaces/postgresql-socket/postgresql-socket-api.cl:
537 Fixed eval of def-function for crypt library.
539 31 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
540 * Added interface to support USQL high-level rouines
542 29 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
543 * Separated db-interface and conditions from sql/sql.cl
544 * Improved foreign library loading testing
545 * interfaces/postgresql/postgresql-api.cl
546 Added PQisBusy function
547 * interfaces/clsql-uffi/clsql-uffi.cl
548 Fixed sign error for 64-bit processing
550 27 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
551 * interfaces/postgresql-socket/postgresql-socket-api.cl:
552 Fixes to read-double-from-socket. Added 64-bit integer support.
553 * test-suite/xptest-clsql.cl
554 Added testint for 64-bit integers
555 * Additons to installation docs
557 26 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
558 * interfaces/postgresql-socket/postgresql-socket-api.cl:
559 Implemented direct socket reading for field type :double
560 * Added usage information for :types to documentation
561 * interfaces/mysql/mysql-sql.cl: Fixed type specifiers in atoi,
563 * interfaces/clsql-uffi: Created new directory. Split common
564 interface routines that use UFFI into this package. Required
565 especially to support direct reading of 64-bit integers into
566 bignums and bypassing temporary strings.
567 * test-clsql.cl: Updated to test postgresql-socket's
568 read-double-from-socket function.
569 * test-suite/xptest-clsql.cl
570 Started work on test suite
572 25 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
573 * interfaces/mysql/mysql-api.cl: Added mysql-fetch-fields,
574 mysql-fetch-field-direct Got :auto types working
575 * interfaces/postgresql/postgresql-api.cl
576 * interfaces/postgresql-socket/postgresql-socket-api.cl
577 Added pgsql-field-types enum. Got :auto types working.
579 Renamed :field-types to :types.
581 24 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
582 * Added field-types parameter to query, database-query,
583 database-query-result-set, map-query. Haven't added code
584 to utilize field types, yet.
585 * Changed postgresql-socket result set from cons to a structure
586 * Updated test-clsql.cl to use automated testing with a config
588 * Changed return types of field accessors from cstring to
589 (* :unsigned-char). This prepares for being able to use specified
590 type conversions when taking field data into lisp.
591 * Added field-type processing for most interfaces. Not done yet.
593 23 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
594 * doc/ref.sgml: Updated MAP-QUERY example to use
595 *read-default-float-format* (John Foderaro)
596 * Extensive work to foreign library loaders and .system files to
597 check for successful loading of foreign libraries.
598 * Modified test-clsql.cl to allow more modularity and
599 automated testing in future release.
600 * mysql/mysql-sql.lisp: Added field types
602 01 Jan 2002 Kevin Rosenberg (kevin@rosenberg.net)
603 * mysql/mysql-sql.lisp:
604 - Added support for Allegro CL and Lispworks using UFFI layer
605 - Changed database-connect to use mysql-real-connect. This way,
606 can avoid using double (unwind-protect)
607 - Changed database-connect to have MySQL library allocate space
608 for MYSQL structure. This will make the code more robust in
609 the event that MySQL library changes the size of the mysql-mysql