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

[postmodern-devel] Table extra options in DAO definition
by Rafał Strzaliński 14 Jul '08

14 Jul '08

Hi, I'm attaching a patch that allows to add table extra options ( :check :unique ..) to a DAO definition. Sample: (defclass account () ((id :col-type serial ) (login :col-type (varchar 255) :accessor login :initarg :login) (password :col-type (varchar 255) :accessor password :initarg :password) (created_at :col-type timestamp :accessor created-at :initform (now-timestamp))) (:unique name) (:metaclass dao-class) (:keys id) (:extra-options (:unique login)) (:table-name account.account)) -- Best regards, Rafal Strzalinski (nabla) http://nablaone.net

2 4

[postmodern-devel] prepare macro syntax
by Roman Budzianowski 19 Jun '08

19 Jun '08

Hi Marijn, (prepare q) where q is bound to a query works fine, however (prepare (get 'foo 'query)) doesn't complain, but generates incorrect closure. Easy workaround, but is this a bug? Thanks, Roman

2 3

[postmodern-devel] the reason why i'd like an iolib network backend instead of usocket
by Attila Lendvai 19 Jun '08

19 Jun '08

dear list, after some uptime, all of a sudden i was getting these errors on our server. this is probably something going awry inside sb-bsd-sockets. as time permits, i'll experiment with an iolib based network backend for cl-postgres. - attila *** At: 2008-06-14T03:47:32.266936+02:00 *** In thread: http worker 34 / serving request / CALL-WITH-SERVER-ERROR-HANDLER / HANDLE-TOPLEVEL-CONDITION *** Error: Socket error in \"socket\": EPROTONOSUPPORT (Protocol not supported) *** Backtrace is: 000: ((LAMBDA (SB-PCL::.PV. SB-PCL::.NEXT-METHOD-CALL. SB-PCL::.ARG0. SB-PCL::.ARG1.)) #<unavailable argument> #<unavailable argument> #<ESEHO-PRESENTATION::ESEHO-APPLICATION \" /\" {911C645}> #<SB-BSD-SOCKETS:PROTOCOL-NOT-SUPPORTED-ERROR {EBE8041}>) 001: ((HU.DWIM.WUI:HANDLE-TOPLEVEL-CONDITION :AROUND (T T)) #<ESEHO-PRESENTATION::ESEHO-APPLICATION \"/\" {911C645}> #<SB-BSD-SOCKETS:PROTOCOL-NOT-SUPPORTED-ERROR {EBE8041}>) 002: ((FLET HU.DWIM.WUI::HANDLE-REQUEST-ERROR) #<SB-BSD-SOCKETS:PROTOCOL-NOT-SUPPORTED-ERROR {EBE8041}>) 003: ((LAMBDA (ERROR)) #<SB-BSD-SOCKETS:PROTOCOL-NOT-SUPPORTED-ERROR {EBE8041}>) 004: (SIGNAL #<SB-BSD-SOCKETS:PROTOCOL-NOT-SUPPORTED-ERROR {EBE8041}>) [:EXTERNAL] 005: (ERROR SB-BSD-SOCKETS:PROTOCOL-NOT-SUPPORTED-ERROR) [:EXTERNAL] 006: (SB-BSD-SOCKETS:SOCKET-ERROR \"socket\") 007: (SB-BSD-SOCKETS:SOCKET-ERROR \"socket\") [:EXTERNAL] 008: ((SHARED-INITIALIZE :AFTER (SB-BSD-SOCKETS:SOCKET T)) #<error printing object: NIL>) [:EXTERNAL] 009: ((LAMBDA ())) 010: (USOCKET:SOCKET-CONNECT \"database\" 5432) [:EXTERNAL] 011: (CL-POSTGRES::INITIATE-CONNECTION #<CL-POSTGRES:DATABASE-CONNECTION {107C3F11}>) 012: (CL-POSTGRES:OPEN-DATABASE \"eseho\" \"eseho\" \"szupertitok\" \"database\" 5432 :NO) 013: ((CL-RDBMS.POSTGRESQL::CONNECTION-OF :AROUND (CL-RDBMS.POSTGRESQL::POSTGRESQL-POSTMODERN-TRANSACTION)) #<DWIM-META-MODEL::TRANSACTION :begin-executed-p #t {107AB379}>) 0

2 1

[postmodern-devel] db-null problem
by Roman Budzianowski 13 Jun '08

13 Jun '08

There seems to be a problem with exporting of 'db-null type: CL-USER> (pomo:sql (:create-table foo ((age :type (or db-null integer) :default :null)))) "CREATE TABLE foo (age OR NOT NULL DEFAULT NULL)" =========> error! CL-USER> (in-package :pomo) #<The POSTMODERN package> POMO> (pomo:sql (:create-table foo ((age :type (or db-null integer) :default :null)))) "CREATE TABLE foo (age INTEGER DEFAULT NULL)" POMO> Roman

2 1

[postmodern-devel] sql-op :raw
by Roman Budzianowski 06 Jun '08

06 Jun '08

Hi Marijn, The following fails: (sql (:DROP-TABLE 'MANUFACTURERS (:RAW "cascade"))) with Passed 1 too many arguments for arglist (S-SQL::NAME) Is :raw applicable only in certain contexts? Obviously this is just example - I am trying to build it in run time. Thanks, Roman

2 1

[postmodern-devel] dao functionality
by Roman Budzianowski 05 Jun '08

05 Jun '08

Hi everybody, I have decided to use the postmodern library to basically dump and then keep updating a large in memory object database into Postgres. I am coming from the lisp side (my knowledge of rdb is limited). I am wondering if the dao metaclass would allow me to define a table like the 'enemy' example. In particular is it possible to specify :foreign-key? I don't intend to keep my objects in memory using dao class. I just want to use it to create tables and then to do inserts and updates. Should I use S-SQL and sql-compile instead? Thanks, Roman

2 1