X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=ChangeLog;h=982bb0d7065656a7552b1f6def0f34f92a222470;hb=1f4aee256a7a46f6501f9db7798874307c88e5f7;hp=223de7d3fd0f47a8a4f20f59955f229427b4bfe1;hpb=5990bfce392a05c10237d4f97b008c4f828028e5;p=clsql.git diff --git a/ChangeLog b/ChangeLog index 223de7d..982bb0d 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,12 +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. + as Lisp strings. Add new *update-records-on-make-instance* special + 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