Hi,
I'm trying to find any documentation about selecting database schema with dao-class, for example something like this:
(defclass my-class () ((some-column :column t :accessor some-column :initarg some-column) ..... itd)) (:metaclass postmodern:dao-class) (:table-name (:dot 'scheme-name 'table-name)) (:keys some-column))
But it seems (:dot 'scheme-name 'table-name) format is supported only in queries? How can I select an schema in database?
But it seems (:dot 'scheme-name 'table-name) format is supported only in queries? How can I select an schema in database?
The table-name has to be a string, and is not evaluated. You could just do (:table-name "schema_name.table_name"). Or use #.(sql (:dot 'foo 'bar)).
On Sat, Dec 11, 2010 at 12:17, Marijn Haverbeke marijnh@gmail.com wrote:
But it seems (:dot 'scheme-name 'table-name) format is supported only in queries? How can I select an schema in database?
The table-name has to be a string, and is not evaluated. You could just do (:table-name "schema_name.table_name"). Or use #.(sql (:dot 'foo 'bar)).
Great, thank you!
postmodern-devel@common-lisp.net
-
Marijn Haverbeke -
Slobodan Milnović