On 11 Mar 2008, at 16:39, Matt Lawrence wrote:
I found some time last night to work on this. I put the tests in a
new file t/as_sql.t, they are pretty basic: just calling each new
method once and checking the output is as expected
There are now 2 cursor methods that are proxied from the resultset:
as_sql and as_static_sql.
as_sql leaves placeholders in the sql string and passes back the raw
values that go into it, as_static_sql replaces the placeholders
using the quote method from DBI, with optional data type mapping via
arguments (either name-based or positional). This seems to me to be
an acceptable compromise between fully-automatic data_type mapping
(which seems at first glance to be non-trivial and usually
unnecessary) and total disregard of data_type (which will bite Pg
bytea columns et al)
Comments?
Matt
Yes - where's the code?
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
