[Dbix-class] DBIx::Class::ResultClass::HashRefInflator and JSON::XS expanding numbers as strings

2013-03-15 Thread Robert Rothenberg
I have a PostgreSQL database that I run queries on, then use $rs->result_class('DBIx::Class::ResultClass::HashRefInflator'); and send [ $rs->all ] to JSON::XS for serialization in a RESTful interface. It works well, except that numeric values are being translated into strings instead of number

Re: [Dbix-class] DBIx::Class::ResultClass::HashRefInflator and JSON::XS expanding numbers as strings

2013-03-15 Thread Peter Rabbitson
On Fri, Mar 15, 2013 at 09:48:13AM +, Robert Rothenberg wrote: > I have a PostgreSQL database that I run queries on, then use > > $rs->result_class('DBIx::Class::ResultClass::HashRefInflator'); > > and send [ $rs->all ] to JSON::XS for serialization in a RESTful interface. > > It works wel

Re: [Dbix-class] Re: Support for inline where (left join with extra condition)

2013-03-15 Thread Peter Rabbitson
On Thu, Mar 14, 2013 at 12:13:17AM +, brew wrote: > Yes that is a good improvement, thanks. > > For my case I would need the year to be a bind variable which > doesn't look like it is possible The "proper" way to do this will come at some point (frew: poke poke), it just isn't as easy as it