X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=ChangeLog;h=982bb0d7065656a7552b1f6def0f34f92a222470;hb=1f4aee256a7a46f6501f9db7798874307c88e5f7;hp=fe6e0f957eb1a6e9576ac97acb71ce3d832a27b3;hpb=79cdb16ebd29e11e9762ec81c32314433d85eaad;p=clsql.git diff --git a/ChangeLog b/ChangeLog index fe6e0f9..982bb0d 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,14 +1,32 @@ 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net) + * TODO: New section on optimizations, especially optimizing JOINs. + * sql/objects.lisp: Have :target-slot return of list of lists rather + than a list of cons pairs to be conformant with CommonSQL. + Make :target-slot much more efficient by using a SQL inner join + statement and just requiring one SQL query. Add :retrieval :deferrred + to target-slot joins. Add placeholder for update-objects-join. + * sql/classes.lisp: Add :inner-join and :on slots to sql-query class + and process them for query output-sql. + +4 May 2004 Kevin Rosenberg (kevin@rosenberg.net) + * Version 2.10.11 * base/basic-sql.lisp: Avoid multiple evaluation of query-expression in DO-QUERY * sql/objects.lisp: Make SELECT a normal function. SELECT now accepts type-modified database identifiers, such as [foo :string] which means that the values in column foo are returned as Lisp strings. Add new *update-records-on-make-instance* special - variable controlling automatic creation of new instances. + variable controlling automatic creation of new instances. Add missing + RESULT-TYPES keyword to FIND-ALL. Add :target-slot support. * sql/packages.lisp: Export *update-records-on-make-instance* + * test/test-oodml.lisp: Add tests for :target-slot and many-to-many + selections. * test/test-fdml.lisp: Add tests for type-modified database identifiers. + * test/test-init.lisp: Stop using add-relation since implementing + many-to-many joins. Use *update-records-on-make-instance* + to automatically store records on instance creation. Add many-to-many + employee-address view-class. 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net) * Version 2.10.10