1 9 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
2 * sql/test-fdml.lisp: Renumber SELECT tests to avoid overwriting
4 * sql/test-init.lisp: Check test-database-underlying-type for
6 * sql/objects.lisp: Fix (setf slot-value-using-class) for Lispworks
8 8 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
9 * sql/operations.lisp: complete remaining operations for the sql
10 syntax: SUBSTR, SOME, ORDER-BY, GROUP-BY, NULL, DISTINCT, EXCEPT,
11 UNION, INTERSECT, BETWEEN.
12 * sql/classes.lisp: add new classes: SQL-BETWEEN-EXPRESSION,
13 SQL-QUERY-MODIFIER-EXPRESSION and SQL-SET-EXPRESSION.
14 * tests/test-syntax.lisp: add tests for new operations.
15 * tests/test-fdml.lisp: add tests for queries based on new operations.
16 * tests/test-init.lisp: add select/20 to tests skipped for sqlite and
17 select/20, query/5, query/7 and query/8 to tests skipped by mysql.
18 * TODO: removed entries done.
20 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
21 * tests/benchmarks.lisp: Add immediate vs. deferred
24 8 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
25 * Version 2.10.13: Now works on openmcl 0.14.2
26 * sql/objects.lisp: Add :retrieval :immediate for
28 * tests/test-init.lisp: Add non-index fields for testing
29 join class employee-addresss
30 * test/test-oodml.lisp: Add tests for retrieval immediate
31 * sql/metaclasses.lisp: Handle differences in direct-slot-definition
32 values which are now listifed by openmcl 14.2.
33 * sql/objects.lisp: more framework for supporing immediate retrieval
35 7 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
36 * docs/intro.xml: Upload location of a README file
37 * sql/metaclass.lisp: Work-around openmcl's CHANGE-CLASS
38 changing the type-specifier. Use a lisp type of (OR NULL FOO)
39 for a specified-type of FOO unless :db-constraints :not-null.
40 No need to specialize finalize-inheritance for openmcl.
41 * tests/test-*.lisp: Rename fields so that joins occur on
42 fields with different names. This ensures that join code is
43 selecting the proper name.
44 * test/test-init.lisp: Add :base-table for employee-address
45 view class for testing.
46 * sql/objects.lisp: Use view-table rather than name of table
47 in a number of places to fix errors noted with using :base-table.
49 6 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
50 * sql/objects.lisp: replace *update-records-on-make-instance* with
51 *db-auto-sync* which also controls both automatic creation of
52 new records on creation of new instance and updating of record
53 fields on setting of instance slots (as suggested by Edi Weitz).
54 * tests/test-init.lisp: replace *update-records-on-make-instance*
56 * sql/package.lisp: replace *update-records-on-make-instance*
58 * TODO: replace *update-records-on-make-instance* with *db-auto-sync*.
59 * sql/objects.lisp: remove redundant rebindings of *db-initializing*
60 and *default-database* in FIND-ALL.
61 * sql/package.lisp: import time functions from CLSQL-BASE.
62 * tests/test-time.lisp: replace CLSQl-BASE package qualifier with CLSQL.
63 * tests/test-fdml.lisp: replace CLSQl-BASE package qualifier with CLSQL.
64 * tests/test-init.lisp: replace CLSQl-BASE package qualifier with CLSQL.
65 * tests/test-ooddl.lisp: replace CLSQl-BASE package qualifier with
68 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
69 * sql/classes.lisp: Add SQL-OBJECT-QUERY type. Have [select 'class]
70 now return a sql-object-query type rather than directly performing a query.
71 This improves CommonSQL conformance.
72 * sql/sql.lisp: Add new QUERY method for SQL-OBJECT-QUERY. Move
73 from basic/basic-sql.lisp the DO-QUERY and MAP-QUERY since they now
74 depend on sql-object-query-type.
75 * sql/loop-extensions.lisp: Move from base package
76 * classic/package.lisp: remove references to map-query and do-query
78 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
79 * TODO: New section on optimizations, especially optimizing JOINs.
80 * sql/objects.lisp: Have :target-slot return of list of lists rather
81 than a list of cons pairs to be conformant with CommonSQL.
82 Make :target-slot much more efficient by using a SQL inner join
83 statement and just requiring one SQL query. Add :retrieval :deferrred
84 to target-slot joins. Add placeholder for update-objects-join.
85 * sql/classes.lisp: Add :inner-join and :on slots to sql-query class
86 and process them for query output-sql.
88 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
90 * base/basic-sql.lisp: Avoid multiple evaluation
91 of query-expression in DO-QUERY
92 * sql/objects.lisp: Make SELECT a normal function.
93 SELECT now accepts type-modified database identifiers, such as
94 [foo :string] which means that the values in column foo are returned
95 as Lisp strings. Add new *update-records-on-make-instance* special
96 variable controlling automatic creation of new instances. Add missing
97 RESULT-TYPES keyword to FIND-ALL. Add :target-slot support.
98 * sql/packages.lisp: Export *update-records-on-make-instance*
99 * test/test-oodml.lisp: Add tests for :target-slot and many-to-many
101 * test/test-fdml.lisp: Add tests for type-modified
102 database identifiers.
103 * test/test-init.lisp: Stop using add-relation since implementing
104 many-to-many joins. Use *update-records-on-make-instance*
105 to automatically store records on instance creation. Add many-to-many
106 employee-address view-class.
108 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
110 * base/loop.lisp: Add object iteration. Use :result-type
111 :auto for result-set. Remove
112 duplicate (and non-correct) code for non-list variables by
113 simply making an atom variable into a list.
114 * sql/package.lisp: Remove unnecessary clsql-sys package
115 and replace it with clsql.
116 * sql/metaclasses.lisp: Properly store specified-type from
117 direct-slot-definition and then store translated type in
118 effective-slot-definition
119 * sql/classes.lisp: Don't output type in sql-output
120 for SQL-IDENT-ATTRIBUTE. This is in preparation for supporting
121 [foo :integer] as fields in SELECT.
122 * sql/query.lisp: Set default for :result-types to :auto in
124 * sql/objects.lisp: Use specified-type when invocating
125 database-get-type-specifier. def-view-class macro now returns
127 * base/basic-sql.lisp: Make :AUTO the default value for
128 :RESULT-TYPES for MAP-QUERY and DO-QUERY.
129 * sql/objects.lisp: Add bigint type
130 * test/tests-basic.lisp: Add tests for :result-types for
131 MAP-QUERY and DO-QUERY
132 * test/test-fdml.lisp: Add test for result-types in LOOP
133 and also using single symbol rather than a list for variables.
134 Add test that default :result-types is auto for FDML QUERY.
135 * test/test-syntax.lisp: Don't expect TYPE in the SQL-OUTPUT
136 of SQL-IDENT-ATTRIBUTE.
137 * test/test-oodml.lisp: Enable OO loop iteration test,
138 modify it so it doesn't depend on boolean where.
140 4 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
142 * sql/objects.lisp: added derived type specifier for universal time.
143 * sql/package.lisp: added #:universal-time to clsql-sys exports.
144 * tests/test-oodml.lisp: added test for translation of boolean slots
145 in SELECT with object queries.
147 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
148 * db-odbc/odbc-api.lisp: Fix changing nil to "NIL"
149 for odbc/postgresql backend.
150 * db-odbc/odbc-sql.lisp: Fix ATTRIBUTE-TYPE so that
151 it can handle NIL values from the ODBC driver
152 * tests/benchmarks.lisp: New file with initial
154 * sql/relations.lisp: fix to add subclassing support,
155 minor optimizations [Edi Weitz]
157 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
159 * base/conditions.lisp: Add *backend-warning-behavior*
161 * db-postgresql-socket/postgresql-socket-sql.lisp:
162 Honor value of *backend-warning-behavior*
163 * tests/test-fdml.lisp: Remove test of raw boolean value
164 since different backends handle this differently. Add
165 test for :column attribute.
166 * tests/test-oodml.lisp: Add tests for boolean slot value
167 and for :void-value attribute
168 * tests/test-init.lisp: Use *backend-warning-behavior*
169 to suppress warnings from postgresql about implicitly
170 creating primary key in tables. Add new address table.
172 3 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
174 * db-odbc/odbc-dbi.lisp: Convert TINYINT to integers when
175 result-types is :auto
176 * sql/objects.lisp: Properly handled writing/reading Boolean
177 values from SQL database when retrieving objects.
178 * test/test-fdml.lisp: Add another test for boolean results
179 * test/utils.lisp: Fix incorrect declaration
181 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
183 * sql/generics.lisp: add generic function for SELECT.
184 * sql/objects.lisp: make SELECT a method specialisation.
185 * sql/classes.lisp: MAKE-QUERY now calls SELECT if the selections
186 referred to are View Classes.
187 * base/basic-sql.lisp: in DO-QUERY and MAP-QUERY, if the
188 query-expression arg evaluates to a list, then we have an object
190 * tests/test-oodml.lisp: add tests for DO-QUERY and MAP-QUERY with
192 * TODO: remove items done and add a todo for SELECT.
193 * sql/objects.lisp: SELECT takes a :field-names arg to pass on to
195 * sql/sql.lisp: add :field-names arg to QUERY.
196 * tests/test-fdml.lisp: minor rework to use :field-names arg to
199 2 May 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
200 * sql/objects.lisp: fix bug in FIND-ALL when SELECT called with 2
201 or more View Classes.
202 * sql/objects.lisp: make the :flatp argument to SELECT work with
204 * sql/objects.lisp: make SELECT accept a :result-types argument
205 (defaults to :auto) which is passed on to QUERY.
206 * sql/objects.lisp: SELECT returns field-names as a second value.
207 * tests/test-ooddl.lisp: add flatp arg to SELECT calls as appropriate.
208 * tests/test-fdml.lisp: add flatp/result-types arguments to calls
209 to SELECT and take only first value as appropriate.
210 * tests/test-fdml.lisp: add two new tests for query result coercion
211 and the field-names returned as a second value from SELECT.
212 * tests/test-oodml.lisp: add flatp arg to SELECT calls as appropriate.
214 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
215 * Version 2.10.6-pre1
216 * sql/metaclasses.lisp: Add void-value slot
217 * doc/csql.xml: Update def-view-class documentation
218 * test/test-init.lisp: Change old :db-type to :db-kind.
219 Remove old :nulls-ok attributes.
220 * sql/objects.lisp: Add new universal-time and bigint
221 types. Optimize reading of integers using parse-integer
222 rather than read-from-string.
223 * */*.lisp: Merge clsql-base-sys and clsql-base packages
224 into clsql-base package
225 * classic/sql.lisp: Move large object support into base, leaving
226 classic without any functionality that is provided in the clsql
228 * classic/package.lisp: Rename clsql-classic-sys package to
229 its former nickname of clsql-classic
231 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
232 * Version 2.10.5: SQLite backend now passes all result-types tests
233 * clsql-sqlite.asd: Depend on clsql-uffi system
234 * db-sqlite/sqlite-sql.lisp: Use clsql-uffi:convert-raw-field
235 for efficiency and code reuse.
236 * db-sqlite/sqlite-api-uffi.lisp: Change (* :char) to (* :unsigned-char)
237 for better cross-implementation compatibility.
239 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
241 * sql/tables.lisp: Fix typo in CACHE-TABLE-QUERIES
243 * db-postgresql/postgresql-sql.lisp: Fix foreign-string vs. cstring
244 bug on SBCL in result-field-names function as reported by Marcus Pearce
245 * db-sqlite/sqlite-sql.lisp: Fix in database-store-next-row
246 manifest in SBCL testing
248 1 May 2004 Kevin Rosenberg (kevin@rosenberg.net)
250 * sql/database.lisp: Conform more to CommonSQL output
251 for STATUS command [Marcus Pearce]
252 * sql/sqlite-sql.lisp: Rework to use result-types
253 * sql/sqlite-api-clisp.lisp: Add compatibility layer
254 with sqlite-api-uffi.lisp so that sqlite-sql.lisp can
255 be cleaned up of most clisp reader conditionals
256 * sql/test-init.lisp: Now run field type tests on sqlite
259 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
261 * base/basic-sql.lisp: Set default value of :result-types
262 to :auto for more CommonSQL conformance.
263 * test/test-fdml.lisp: Add tests for numeric value of fields
266 30 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
267 * Version 2.10.1: New API function: CACHE-TABLE-QUERIES.
268 * base/basic-sql.lisp, db-*/*-sql.lisp: More CommonSQL conformance.
269 Return field names as second value for QUERY. This can be overridden
270 for efficiency with the new keyword :FIELD-NAMES set to NIL
271 in the QUERY invocation.
272 * test/test-fdml.lisp: Add tests for new field-name feature
273 * sql/metaclass.lisp: Remove old Lispworks cruft
274 and replace it with invocation of new code in kmr-mop.lisp
275 which actually works with Lispworks 4.2
276 * doc/ref_clsql.xml: Document new :FIELD-NAMES keyword to
278 * base/db-interface.lisp: Document the multiple values
279 returned by DATABASE-ATTRIBUTE-TYPE so matches the
280 undocumented CommonSQL behavior.
281 * sql/table.lisp: Add *CACHE-TABLE-QUERIES-DEFAULT* and
282 *DEFAULT-UPDATE-OBJECTS-MAX-LEN* variables and export them.
283 LIST-ATTRIBUTE-TYPES now conforms to CommonSQL spec.
284 Implement CACHE-TABLE-QUERIES.
285 * db-odbc/odbc-sql.lisp: Fix attribute-type function
286 * test/test-fddl.lisp: Add tests for attribute type
287 * db-mysql/mysql-sql.lisp: Mild optimization in accessing
289 * base/classes.lisp: Add attribute-cache slot to database clas
290 * base/initialize.lisp: initialize-database-type now automatically
291 loads database-type backend as needed.
292 * base/test-init.lisp: Utilize new initialize-database-type functionality.
293 * TODO: remove items done
295 30 Apr 2004 Marcus Pearce (m.t.pearce@city.ac.uk)
297 * sql/objects.lisp: remove create/drop-sequence-from-class.
298 * sql/objects.lisp: add INSTANCE-REFRESHED generic function.
299 * sql/objects.lisp: improved CommonSQL compatibility for
300 UPDATE-RECORD-FROM-SLOT, UPDATE-RECORD-FROM-SLOTS,
301 UPDATE-RECORDS-FROM-INSTANCE and DELETE-INSTANCE-RECORDS.
302 * sql/generics.lisp: move generics from objects.lisp to here.
304 29 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
306 * db-mysql/mysql-client-info.lisp: Add client version 4.1
308 * sql/sql.lisp: Make *default-database* the default for
311 28 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
313 * db-mysql/mysql-sql.lisp: Fix bug in transaction capability
315 * sql/objects.lisp: Commit patch from Slawek Zak to allow specifying
316 :metaclass in DEF-VIEW-CLASS invocation. This allows defining classes
317 on a metaclass specialized from standard-db-class.
320 24 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
321 * Version 2.9.4: Multiple changes to support Allegro's "modern"
322 lisp which uses a lowercase reader and has case-sensitive symbols
323 * sql/classes.lisp: Fix make-load-form bug for sql-ident-table
324 exposed by case-sensitive mlisp.
326 22 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
327 * Version 2.9.3: All tests now pass on all platforms!
328 * LATEST-TEST-RESULTS: New file with summary of test results
329 * sql/generics.lisp: New file for generic function definitions.
330 * test/test-init.lisp: Display names of skipped tests.
331 Use unwind-protect to ensure disconnect
332 * sql/objects.lisp: Change database-type to database-underlying-type
333 so that actual database engine is properly identified
334 * db-odbc/odbc-api.lisp: Have default *time-conversion-function*
335 return an ISO timestring for compatibility with other drivers.
336 Workaround bug in MyODBC for LIST-TABLE-INDEXES
337 * test/test-fdml.lisp: Accomodate that odbc-postgresql driver
338 returns floating-point values for floor and truncate operations
339 * db-aodbc/aodbc-sql.lisp: Implement DATABASE-LIST-VIEWS
340 * tests/test-basic.lisp: Port to regression tester
341 * test/test-init.lisp: Output to *report-stream*
342 * docs/appendix.xml: Document ODBC and SQLite backends.
343 * sql/classes.lisp: Make output-sql require a database parameter.
344 This allows SQL generation to have the proper case to support
345 the differences in case handling between CommonSQL API,
346 Postgresql, MySQL, Oracle.
348 21 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
349 * Version 2.9.2: Improvments in database capability introspection
350 and querying. Support transactions in MySQL where available.
351 All tests now pass on MySQL and SQLite in addition to postgresql
352 and postgresql-socket. ODBC fails only with OODDL/TIME/1 and OODDL/TIME/2.
353 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST-VIEWS. Better support
354 DATABASE-LIST-SEQUENCES.
355 * clsql-uffi.asd, clsql-mysql.asd: Improve shared library loading
356 * Database_capabilies: add HAS-VIEWS, HAS-CREATE/DESTROY-DB,
357 HAS-BOOLEAN-WHERE, TRANSACTION-CAPABLE
358 * tests/*.lisp: Check database capabilities and remove tests which
359 the database backend does not support
360 * sql/table.lisp: Add :TRANSACTIONS keyword to create table which
361 controls whether InnoDB tables will be created when supported on
362 the underlying MySQL server.
364 20 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
365 * Version 2.9.0: New API function: LIST-TABLE-INDEXES,
366 supported by all database backends (except AODBC since
367 AODBC doesn't support index querying)
368 * db-obdc/odbc-sql.lisp: Support DATABASE-LIST-INDEXES
369 * db-odbc/odbc-api.lisp: Add %TABLE-STATISTICS function
370 to support index queries
371 * db-aodbc/aodbc-sql.lisp: Filter driver manager
372 "information_schema" tables from LIST-TABLES
373 * tests/test-basic.lisp: Remove table after testing
374 * tests/test-fddl.lisp: Test LIST-TABLE-INDEXES
375 * base/db-interface.lisp: Add DATABASE-UNDERLYING-TYPE
376 which gets the underlying type of database -- required
377 when dealing with ODBC databases and want to query
378 database capabilities. Added DB-USE-COLUMN-ON-DROP-TABLES?
379 as first database-backend specific feature. Is T on
380 :mysql, NIL on other backends. Change DROP-TABLE to
383 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
384 * Version 2.8.2: Build changes for FreeBSD [Slawek Zak]
386 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
388 * db-odbc/odbc-sql.lisp: Add DATABASE-LIST function
389 * db-odbc/odbc-dbi.lisp: Add LIST-ALL-DATA-SOURCES function
391 19 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
392 * Version 2.8.0: New API function: LIST-DATABASES
393 * base/utils.lisp: Fix command-output on CMUCL/SBCL
394 * db-*/*-sql.lisp: Add new database-list function
395 * base/database.lisp: Add new LIST-DATABASES command
397 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
399 * db-sqlite/sqlite-sql.lisp: Fix sequence functions.
400 * db-sqlite/sqlite-api-uffi.lisp: Print error string
403 18 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
405 * doc/csql.xml, examples/clsql-tutorial.lisp: Patch for db-kind
408 17 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
410 * base/objects.lisp, base/classes.lisp: Patch
411 for db-kind from Eduardo Munoz
413 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
415 * base/basic-sql.lisp: Fix FLATP in QUERY
417 16 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
418 * Version 2.7.3: Implement RECONNECT
420 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
421 * Version 2.7.2: Fix ODBC on Lispworks Windows
423 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
424 * Version 2.7.1: Fix for new ODBC backend.
425 clsql-odbc now works on SBCL, CMUCL, OpenMCL
426 in addition to AllegroCL and Lispworks.
428 15 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
429 * Version 2.7.0: New backend: ODBC. Tests as
430 well as AODBC backend on Allegro,Lispworks.
431 SBCL and CMUCL don't work quite yet. Requires UFFI v1.4.11+
432 * db-odbc/*.lisp: Add ODBC3 function SQLSetEnvAttr
433 to explicitly set ODBC2 support. Add BIGINT support.
434 Add result-types support. Added SQLTables.
435 Fix array type in fetch-all-rows. Make width
436 changable by database or query.
437 * base/utils.lisp: Add process functions
438 * base/package.lisp: Export utils to CLSQL-BASE-SYS
439 * db-aodbc: Implement sequence functions,
440 database-list-tables, database-list-attributes
441 * tests/utils.lisp: Add support for ODBC backend,
442 rework READ-SPECS to use +all-db-types+
443 * db-mysql/mysql-sql.lisp: Use WITHOUT-INTERRUPTS
446 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
447 * Version 2.6.13. Requires UFFI version 1.4.9
448 * db-odbc/*.lisp: Further porting.
449 Pre-alpha code! But, basic query is now working.
451 13 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
453 * base/transactions.lisp: Add quote for macro
454 expansion of WITH-TRANSACTIONS [Time Howe]
455 * db-sqlite/sqlite-sql.lisp: Support memory database
456 in database-probe [Ng Pheng Siong]
457 * db-odbc/*.lisp: Initial port to UFFI of SQL-ODBC.
458 The DBI layer is not finished.
460 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
462 * sql/objects.lisp: add :root-class functionality for
463 list-classes and add duration type support [Marcus Pearce]
464 * db-odbc: Add mid-level [DBI] layer
466 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
468 * db-aodbc: Add methods for generic functions, some are
470 * clsql-odbc.asd, db-odbc/*.lisp: Initial start of ODBC
473 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
475 * base/package.lisp: Add missing symbols [Marcus Pearce]
477 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
479 * test/test-fddl.lisp: Cleanup fix [Marcus Pearce]
480 * utils/time.lisp: Multiple fixes [Marcus Pearce]
481 * sql/sql.lisp: Fix for truncate-database [Marcus Pearce]
483 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
485 * sql/*.lisp: Remove schema versioning cruft
487 * Makefile: Add classic subdirectory
489 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
491 * sql/sql.lisp: Fix TRUNCATE command, bug reported
493 * sql/sql.lisp: Remove EXPLAIN function. Postgresql/Oracle
494 specific and easy for an application to directly support.
495 Idea from Marcus Pearce.
496 * base/basic-sql.lisp: Remove DESCRIBE-TABLE top-level
497 API as duplicates LIST-ATTRIBUTE-TYPES [Marcus Pearce].
498 Keep low-level interface for future optimization
499 supporting LIST-ATTRIBUTE-TYPES command.
500 * Makefile: Add to db-sqlite and test directories.
501 Include them in top-level Makefile
503 12 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
505 * sql/relations.lisp: Add missing file
506 * utils/time.lisp: Fixes/extensions [Marcus Pearce]
507 * test/test-time.lips: New file [Marcus Pearce]
509 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
511 * test/test-init.lisp: Properly handle object
512 creation. Close database after use.
513 * sql/sql.lisp: Make DESCRIBE-TABLE a generic
514 function so can have methods specialized on
515 table being a string or an sql-table object.
516 * base/pool.lisp: Really fix CMUCL locking
518 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
520 * test/test-init.lisp: Signal correctly
521 if any errors occurred in any test suite
522 * base/loop-extensions.lisp: Fix error
523 introduced for Lispworks
524 * base/pool.lisp: Fix locking for CMUCL
525 * base/objects.lisp: Remove schema-version cruft
527 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
528 * Version 2.6.2: New CLSQL API functions:
529 DESCRIBE-TABLE AND TRUNCATE-DATABASE
530 Currently, this are only supported on :postgresql
531 and :postgresql-socket
532 * base/database.lisp: automatically load ASDF system
533 in CONNECT if not already loaded
534 * base/tests.lisp: disconnect database after testing
535 * base/*.lisp: Remove CLOSED-DATABASE type in favor
536 of storing open/closed status in slot of database
537 * base/pool.lisp: Support locks for CMUCL, OpenMCL, SBCL
538 * db-postgresql/postgresql-sql.lisp: add DATABASE-RECONNECT,
539 DATABASE-DESCRIBE-TABLE
540 * db-sqlite/sqlite-sql.lisp: Add missing slots in database
541 * base/conditions: Remove duplicate condition
542 * db-*/*-sql.lisp: Fill new database slot DATABASE-TYPE
543 * base/recording.lisp: Add new :QUERY type for recording
545 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
546 * Version 2.6.1: documentation fixes, merged
547 classic-tests into tests
549 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
550 * Version 2.6.0 released: New API functions
551 CREATE-DATABASE, DESTORY-DATABASE, PROBE-DATABASE
552 * doc/ref_clsql.xml: Document new functions
553 * base/database.lisp: New API functions
554 * base/conditions.lisp: Added CLSQL-ACCESS-ERROR
555 * base/utils.lisp: Fix use of position-char.
556 Add COMMAND-OUTPUT used by backends for running
557 external programs. Fix parsing of SQL*NET-compatible
559 * base/loop-extension.lisp: Simplify package use
560 for Lispworks and Allegro
561 * db-*/*-sql.lisp: Added DATABASE-CREATE,
562 DATABASE-DESTORY, PROBE-DATABASE methods
563 * tests/test-init.lisp, clasic-tests/tests.lisp:
564 Use destroy-database and create-database to ensure
565 testing with empty database
566 * tests/test-connection.lisp: Add tests for
567 parsing of string connection-specs
568 * examples/run-tests.sh: New file for running
569 test suite on all installed CL implementations
570 * examples/clsql-tutorial.lisp: moved from
572 * examples/dot.clsql-tests.config: New file
573 giving an example test configuration
574 * test/README: Add notes about rtest/ptester
575 downloads and link to sample test configuration file.
577 10 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
578 * Version 2.5.1 released:
579 * tests/*.lisp: Rework so tests are run
580 on multiple backends automatically based
581 on the contents of ~/.clsql-tests.config.
582 Reuse helper functions from classic-tests.
583 * base/database.lisp: Support connection-spec
584 as string for CONNECT
585 * classic-tests/tests.lisp: Automatically
586 load database backends as needed.
588 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
589 * Version 2.5.0 released:
590 All tests for CLSQL and CLSQL-CLASSIC pass
592 * base/loop-extension.lisp: Add Lispworks
593 loop-extension. Improve type specifying on
596 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
597 * Version 2.4.2 released:
598 loop extension now supported on Allegro, all
599 CLSQL-TESTS pass on Allegro.
600 * sql/metaclasses.lisp: Some optimization
601 of compute-slots, be selective when
602 ordered-class-slots needs to be called
603 instead of class-slots
604 * TODO: add URL with documentation on
605 extending Lispworks LOOP form
607 09 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
608 * Version 2.4.1 released: CLSQL-TESt suite passes
609 all tests for postgresql and CMUCL, SBCL, OpenMCL.
610 Allegro and Lispworks pass all tests except for
611 FDML/LOOP/1 since the loop extension have not yet
612 been ported to those implementions.
613 * sql/metaclasses.lisp: Added new slot to standard-db-class
614 to hold user-specified type. OpenMCL adjustments to compensate
615 for its type-predicate function. Since AllegroCL, Lispworks,
616 and OpenMCL have different slot orders, added compute-slots
617 and ordered-class-slots functions so their slot order matches
620 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
621 * Version 2.4.0 released: All tests for clsql-classic now finish
622 correctly on Allegro, Lispworks, CMUCL, SBCL, OpenMCL for
623 mysql, postgresql, postgresql-sockets, and sqlite backends.
624 * db-mysql/mysql-sql.lisp: Fix array dereferencing
625 * classic-tests/tests.lisp: Fix package name of
626 number-to-sql-string.
627 * clsql.asd/clsql-tests.asd: Add support for asdf:test-op
628 * db-sqlite/sqlite-api-{uffi,sql}.lisp: Multiple UFFI fixes,
629 now passes tests on all support UFFI platforms.
630 * db-postgresql-socket/postgresql-socket-api.list: Ported to
632 * multiple: Finish renaming of :types keyword to :result-types for
633 greater CommonSQL compatibility, including documentation
634 * sql/basic-cmds.lisp: Remove obsolete file
636 08 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
637 * Version 2.3.3 released
638 * Fixes for sequences on mysql and sqlite [Marcus Pearce]
639 * Fixes for uffi sqlite backend [Aurelio Bignoli / Kevin Rosenberg]
640 * Fix for schema table [Marcus Pearce]
641 * Add loop extension support for SBCL and OpenMCL [Marcus Pearce]
642 * Fixes to test suite [Marcus Pearce]
644 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
645 * db-*/*-sql.lisp: Ensure that expr in
646 database-query-result-set is a string
647 * Documentation integration
649 06 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
650 * With for Marcus Pearce's excellent work, I've merged
651 his clsql-usql port into clsql. The original clsql
652 interface is available in the clsql-classic package.
654 02 Apr 2004 Kevin Rosenberg (kevin@rosenberg.net)
655 * Integrate patch from Marcus Pearce <ek735@soi.city.ac.uk>
656 adding further support for providing backend for UncommonSQL
658 10 Mar 2004 Kevin Rosenberg (kevin@rosenberg.net)
659 * Integrate patch from Aurelio Bignoli for SQLite backend
661 11 Nov 2003 Kevin Rosenberg (kevin@rosenberg.net)
662 * Converted documentation to XML format
663 * Made package installable with asdf-install
665 23 Jul 2003 Kevin Rosenberg (kevin@rosenberg.net)
666 * Add for-each-row macro
668 12 Dec 2002 Kevin Rosenberg (kevin@rosenberg.net)
669 * uffi/clsql-uffi.lisp: return NIL for numeric fields that are NULL
671 16 Oct 2002 Kevin Rosenberg (kevin@rosenberg.net)
672 * Add support for SBCL, OpenMCL, and SCL
673 * Add *load-truename* to search path for clsql's
676 01 Sep 2002 Kevin Rosenberg (kevin@rosenberg.net)
677 * Rework use of file types in .asd files
679 17 Aug 2002 Kevin Rosenberg (kevin@rosenberg.net)
680 * Add .asd definition files for ASDF users
682 31 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
683 * Restructure directories for Common Lisp Controller v3 compatibility
685 25 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
686 * Also change case of logical host in loader files
687 * Rework handling of logical pathnames
689 05 Jul 2002 Kevin Rosenberg (kevin@rosenberg.net)
690 * Change case of logical host
692 14 May 2002 Kevin Rosenberg (kevin@rosenberg.net)
693 * clsql-base.system: Added base package that can be used without
694 high-level SQL commands. Used for adding support for UncommonSQL.
695 * *.system: Reworked logical pathnames to be more consistent with
696 Common Lisp Controller.
697 * debian/*: Completed initial Debian support
699 10 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
701 * sql/transactions.cl:
702 Added transaction support. Functions/macros added:
703 with-transaction, commit-transaction, rollback-transaction,
704 add-transaction-commit-hook, add-transaction-rollback-hook
706 04 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
710 Added pool support in connect/disconnect and with-database.
711 Removed with-db-from-pool as with-database can now works with the connections pool
713 01 May 2002 Marc Battyani (marc.battyani@fractalconcept.com)
718 Completed connection pool.
719 Added with-db-from-pool macro.
721 27 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
723 Added initial support for connection pool
724 * sql/transactions.cl
725 Took transaction code from UncommonSQL and integrated
726 into CLSQL code. See file for disclaimer about why this
729 23 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
730 * interfaces/postgresql/postgresql-sql.cl:
731 Fix keyword typo in database-read-large-object
732 * interfaces/mysql/mysql-loader.cl
734 * test-suite/tester-clsql.cl
735 Fix type coercion of double-float
737 Added debian docbook catalog, made it the default
739 19 Apr 2002 Marc Battyani (marc.battyani@fractalconcept.com)
740 * interface/postgresql/postgresql-api.cl:
741 * interface/postgresql/postgresql-sql.cl:
743 * sql/db-interface.cl:
744 Added large objects support for postgresql.
746 07 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
747 * src/postgresql-socket/postgresql-socket-api.cl:
748 Fixed find-foreign-function call, eliminated crypt warning
750 Multiple improvements
752 Moved functionality from low-level interfaces to this file
753 via generic functions
754 * test-suite/tester.cl:
755 Added test with acl-compat-tester, moved others to old-tests
758 06 Apr 2002 Kevin Rosenberg (kevin@rosenberg.net)
760 Reinstated commented out sections
761 * interfaces/postgresql/postgresql-loader.cl:
762 * interfaces/mysql/mysql-loader.cl:
763 Updated find-forieign-library support.
764 * interfaces/postgresql-socket/postgresql-socket-package.cl:
765 Fixed require form for Lispworks (Thanks Marc Battyani!)
766 * interfaces/postgresql-socket/postgresql-socket-api.cl:
767 Fixed eval of def-function for crypt library.
769 31 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
770 * Added interface to support USQL high-level rouines
772 29 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
773 * Separated db-interface and conditions from sql/sql.cl
774 * Improved foreign library loading testing
775 * interfaces/postgresql/postgresql-api.cl
776 Added PQisBusy function
777 * interfaces/clsql-uffi/clsql-uffi.cl
778 Fixed sign error for 64-bit processing
780 27 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
781 * interfaces/postgresql-socket/postgresql-socket-api.cl:
782 Fixes to read-double-from-socket. Added 64-bit integer support.
783 * test-suite/xptest-clsql.cl
784 Added testint for 64-bit integers
785 * Additons to installation docs
787 26 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
788 * interfaces/postgresql-socket/postgresql-socket-api.cl:
789 Implemented direct socket reading for field type :double
790 * Added usage information for :types to documentation
791 * interfaces/mysql/mysql-sql.cl: Fixed type specifiers in atoi,
793 * interfaces/clsql-uffi: Created new directory. Split common
794 interface routines that use UFFI into this package. Required
795 especially to support direct reading of 64-bit integers into
796 bignums and bypassing temporary strings.
797 * test-clsql.cl: Updated to test postgresql-socket's
798 read-double-from-socket function.
799 * test-suite/xptest-clsql.cl
800 Started work on test suite
802 25 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
803 * interfaces/mysql/mysql-api.cl: Added mysql-fetch-fields,
804 mysql-fetch-field-direct Got :auto types working
805 * interfaces/postgresql/postgresql-api.cl
806 * interfaces/postgresql-socket/postgresql-socket-api.cl
807 Added pgsql-field-types enum. Got :auto types working.
809 Renamed :field-types to :types.
811 24 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
812 * Added field-types parameter to query, database-query,
813 database-query-result-set, map-query. Haven't added code
814 to utilize field types, yet.
815 * Changed postgresql-socket result set from cons to a structure
816 * Updated test-clsql.cl to use automated testing with a config
818 * Changed return types of field accessors from cstring to
819 (* :unsigned-char). This prepares for being able to use specified
820 type conversions when taking field data into lisp.
821 * Added field-type processing for most interfaces. Not done yet.
823 23 Mar 2002 Kevin Rosenberg (kevin@rosenberg.net)
824 * doc/ref.sgml: Updated MAP-QUERY example to use
825 *read-default-float-format* (John Foderaro)
826 * Extensive work to foreign library loaders and .system files to
827 check for successful loading of foreign libraries.
828 * Modified test-clsql.cl to allow more modularity and
829 automated testing in future release.
830 * mysql/mysql-sql.lisp: Added field types
832 01 Jan 2002 Kevin Rosenberg (kevin@rosenberg.net)
833 * mysql/mysql-sql.lisp:
834 - Added support for Allegro CL and Lispworks using UFFI layer
835 - Changed database-connect to use mysql-real-connect. This way,
836 can avoid using double (unwind-protect)
837 - Changed database-connect to have MySQL library allocate space
838 for MYSQL structure. This will make the code more robust in
839 the event that MySQL library changes the size of the mysql-mysql