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

[postmodern-devel] Add :between-symmetric operator
by Daniel White 23 Jan '10

23 Jan '10

For example: (:select '* :from 'table :where (:between-symmetric 'column 10 1)) -- Daniel White

2 1

[postmodern-devel] creating a function based index
by Richard KLINDA 04 Jan '10

04 Jan '10

Hello, is there syntax available for creating function based indexes? How can I write this in s-sql? ,---- | CREATE INDEX my_index ON my_table (LOWER(my_column)) `---- I tried ,---- | (sql (:create-index :my-index :on :my-table :fields (:lower :my-column))) | | => (:LOWER :TERM) cannot be coerced to a string. | [Condition of type SIMPLE-TYPE-ERROR] `---- Thanks in advance, Richard

2 1

[postmodern-devel] Converting a SQL statement with subquery into S-SQL
by Sam Alves 26 Dec '09

26 Dec '09

Hi All, I'm trying to make the following SQL statement lispy by converting it to s-sql: SELECT * FROM filter WHERE title IN ( SELECT filter_title FROM user_filter WHERE user_id = 4); Here's my best attempt: :SELECT '* :FROM 'filter :WHERE 'title :IN (:SELECT 'filter_title :FROM user_filter :WHERE (:= 'user-id 3)) However, I get the following error: Keyword WHERE takes exactly one argument I've tried the SQL query in psql so I know it works, but I can't seem to come up with an equivalent s-sql statement. Thanks for any assistance, Sam -- Sam Alves Package Maintainer OSHEAN, Inc. Email: sam(a)oshean.org

2 2

[postmodern-devel] Exlcuding slots dao-save
by Phil Marneweck 10 Nov '09

10 Nov '09

Hi I am trying to figure out how to exclude certain slots when persisting the dao instance to the db short of making a new object with the limited range of slots. Any ideas or advise? Thanx

2 27

[postmodern-devel] Date Problem
by Phil Marneweck 04 Nov '09

04 Nov '09

I get different date formats back from a postmodern query at different times. I am using SBCL 1.0.31.32 and the latest (as of the weekend) from clbuild. The steps. 1. I delete all my .fasl files for a project 2. I do a require for the project to load and compile 3. I run a query/function and I get the correct "date" data back => #<DATE 01-01-2009> 4. I close emacs and re-open it 5. I do a require of the project to load 6. I run a query/function and I get incorrect "date" data back => 3439756800 Any ideas?

2 2

Re: [postmodern-devel] Patch for with-column-writers?
by Curtis Schlak 28 Oct '09

28 Oct '09

Marijn, Brilliant! Thank you for the fix. I enjoy your libraries and, if I find something else that can help, I'll be sure to send the email. Skaal! Curtis.

1 0

[postmodern-devel] Patch for with-column-writers?
by Curtis Schlak 27 Oct '09

27 Oct '09

I tried multiple ways to get the with-column-writers macro in the repository to work and could not. I believe that the loop should read :in rather than :on as follows: (defmacro with-column-writers ((&rest defs) &body body) `(let ((*custom-column-writers* (append (list ,@(loop :for (field writer) :in defs :collect `(cons (to-sql-name ,field) ,writer))) *custom-column-writers*))) ,@body)) With that in place, the following code works correctly: (defclass foo () ((id :col-type int :initform :id :accessor foo-id) (stuff :initform :stuff :accessor foo-stuff)) (:metaclass postmodern:dao-class) (:keys id)) (setf foo (postmodern:with-column-writers ((:id #'(lambda (inst val) (setf (foo-id inst) val) (setf (foo-stuff inst) (format nil "My Value: ~A" val))))) (postmodern:get-dao 'foo 1)))

2 1

[postmodern-devel] Error when using :col-type serial
by Mitch Berkson 19 Oct '09

19 Oct '09

I defined a dao class which I would like to get a sequential id from the database. For the id slot I have: (id :col-type serial :accessor seat-id) When I try to do an update-dao with an instance of that class, I get: Error: The slot ID is unbound in the object #<CPA-SEAT 2665E40F> (an instance of class #<DAO-CLASS CPA-SEAT 25EE423B>). I'd appreciate any suggestions about what I'm doing wrong. Thank you. Mitch

2 2

[postmodern-devel] simple-date:date and "can not be converted to an SQL literal." error
by Mikhail Shevchuk 18 Oct '09

18 Oct '09

Hello, forum! I have a dao class that uses 'date' col-type: (reg_date :col-type date :initarg :date :accessor user-reg-date :initform (get-current-simple-date))) here is a (get-current-simple-date) result: #<SIMPLE-DATE:DATE 17-10-2009> but the following error is generated when I'm trying to instantiate the object: Value #<SIMPLE-DATE:DATE 17-10-2009> can not be converted to an SQL literal. [Condition of type SIMPLE-ERROR] Thanks in advance! -- http://blog.shevchuk.org

2 7

[postmodern-devel] Multiple values from row-readers
by Russ Tyndall 07 Oct '09

07 Oct '09

I was wondering if it was a bug or intended behavior that row reader functions do not properly return multiple values? I am working on a cl-postgres backend to clsql, so I am not very familiar with much of the workings of this project, but noticed this somewhat odd (from my perspective) behavior. I have worked around this in the obvious way (list instead of multiple values). It seems to be a problem with the returning-effected-rows macro (which expands to a let, effectively discarding any multiple values returned from the row reader). Is there a reason not to change the definition to the following? http://paste.lisp.org/display/88358 Cheers, Russ Tyndall

2 1