> > (require db)
> > (define db (postgresql-connect ...args...))
> > (simple-result-info (query db "insert into collaborations (name) values
> ('foojalskdsfls')"))
> '((insert-id . #f) (affected-rows . 1))
>
With postgresql instead of doing a plain insert you can use returning to
return your id:
(assuming your collaborations table has a id field that is automatically
initialized)
> (query-row db "insert into collaborations (name) values ('foojalskdsfls')
returning id")
'#(3) ;; the id of your inserted row
see returning in the postgres-documentation:
https://www.postgresql.org/docs/9.5/sql-insert.html
--
You received this message because you are subscribed to the Google Groups
"Racket Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to racket-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
