November 2008 - postmodern-devel - mailman3.common-lisp.net

[postmodern-devel] [patch] export postmodern:dao-keys
by Maciej Pasternacki 25 Nov '08

25 Nov '08

Hello, I just written a simple DAO cache for my app (for curious: http://paste.lisp.org/display/70998 - I wrap Hunchentoot request handler body with WITH-DAO-CACHE and it caches DAO of given class and primary key to avoid repeated SELECTs when serving a single request). For the caching to work well, I need to figure out keys of a DAO, and this functionality is unexported. Attached patch exports (and documents) DAO-KEYS, adds method for a symbol (invoking DAO-KEYS on class named by a symbol), and for a DAO instance (returning list of values that are instance's primary key). Regards, Maciej -- Maciej Pasternacki -><- http://www.pasternacki.net/ -><- http://www.3ofcoins.net/

2 1

[postmodern-devel] Clozure CL Unicode support
by Daniel Lyons 24 Nov '08

24 Nov '08

Hi, I have a trivial change request, which I am currently hacking around. Currently, cl-postgres.asd contains: (defparameter *unicode* #+(or sb-unicode unicode ics) t #-(or sb-unicode unicode ics) nil) It would make life slightly easier and less confusing for Clozure users if this could be extended just slightly: (defparameter *unicode* #+(or sb-unicode unicode ics ccl) t #-(or sb-unicode unicode ics ccl) nil) Clozure supposedly only uses Unicode for characters, so it ought to be a fine assumption. I've gotten around this on a current project by placing these lines in my .asd file: #+ccl (push :unicode *features*) The *features* variable seems to also include some other options if you'd rather (I don't know if any of these are deprecated or preferable, I'm a bit new to all this): :clozure, :clozure-common- lisp, :openmcl-unicode-strings. Oh, and incidentally, thanks for this library! I haven't been so pleased with a database library for as long as I can remember. It's really a joy to use. — Daniel Lyons http://www.storytotell.org -- Tell It!

2 1

[postmodern-devel] Multirow inserts and transactions in postmodern
by Harry Bock 12 Nov '08

12 Nov '08

Hi, I'm wonder what the proper :insert-into syntax would be to insert multiple rows simultaneously, like so: "INSERT INTO my_table (col1, col2, col3) VALUES ('1', '2', '3'), ('4', '5', '6'), ...;" As this tends to be much faster when inserting large data sets. Also, the transaction functionality of postmodern doesn't seem to be well-documented. Is the only method of working with them to wrap calls in the with-transaction macro? Thanks, Harry -- Harry Bock Software Developer, Package Maintainer OSHEAN, Inc. Email: harry(a)oshean.org PGP Key ID: 546CC353

2 3

[postmodern-devel] select distinct
by Jens Teich 02 Nov '08

02 Nov '08

How do I express a SELECT statement in s-sql using DISTINCT to receive only unique values? Jens

2 2