Re^3: RFC: DBIx::Declare - generate code to call stored procs/SQL statements


laziness, impatience, and hubris
	PerlMonks

Re^3: RFC: DBIx::Declare - generate code to call stored procs/SQL statements

by wazoox (Prior)

on May 22, 2009 at 15:28 UTC ( [id://765708]=note: print w/replies, xml )

Need Help??

in reply to Re^2: RFC: DBIx::Declare - generate code to call stored procs/SQL statements
in thread RFC: DBIx::Declare - generate code to call stored procs/SQL statements

Well, I don't actually care about Oracle, but postgres is a must-have for me :) I'll have a look at your code, but right now I'm upgrading my machine and still haven't reinstalled postgresql :)

Comment on Re^3: RFC: DBIx::Declare - generate code to call stored procs/SQL statements

Replies are listed 'Best First'.

Re^4: RFC: DBIx::Declare - generate code to call stored procs/SQL statements
by Jenda (Abbot) on May 22, 2009 at 22:49 UTC

Hopefully you'll just need to implement a PostgreSQL specific _InferSQL. It's supposed to find the parameters of the stored procedure and set the SQL statement, the args array and the out_args hash (each key should point to an array containing the max size, the SQL type (DBI::SQL_INTEGER, ...) and the string containing the type ('varchar(100)',...). Contact me on jenda@krynicky.cz please once you have the necessary spare time :-)

Jenda
Enoch was right!
Enjoy the last years of Rome.

[reply]

In Section Meditations