[Caml-list] pg'ocaml and dumping sql statements

[Caml-list] pg'ocaml and dumping sql statements

[Joel Reymont]

Are there any provisions in PG'OCaml to dump SQL statements being executed?

	Thanks, Joel

--------------------------------------------------------------------------
- for hire: mac osx device driver ninja, kernel extensions and usb drivers
---------------------+------------+---------------------------------------
http://wagerlabs.com | @wagerlabs | http://www.linkedin.com/in/joelreymont
---------------------+------------+---------------------------------------

Re: [Caml-list] pg'ocaml and dumping sql statements

[Guillaume Yziquel]

Le Sunday 17 Apr 2011 à 15:08:10 (+0100), Joel Reymont a écrit :
> Are there any provisions in PG'OCaml to dump SQL statements being executed?

I'd suggest Printf.printf in the send_message function.

PG'OCaml talks the PostgreSQL protocol directly. So with the help of the
protocol description:

http://developer.postgresql.org/pgdocs/postgres/protocol-message-formats.html

you should be able to look at the query directly. See the Query message.
A 'Q' char, some 32 bit integers in network byte order for the length of
the message, followed by the textual query message.

> Query (F)
> 
>     Byte1('Q')
> 
>         Identifies the message as a simple query.
>     Int32
> 
>         Length of message contents in bytes, including self.
>     String
> 
>         The query string itself.

If you're dealing with prepared statements, you'll find all the
protocol information on the page mentionned above.

> 	Thanks, Joel

-- 
     Guillaume Yziquel