Re: [Dbix-class] select specific columns on resultset

2013-04-11 Thread Jess Robinson
Can you show us the complete piece of code for the search/output, and the class definitions? That trace looks like you first asked for Id only, and then later did another query, or called a relation method on the result . This code: my

[Dbix-class] transaction in a resultset class

2013-04-11 Thread shawn wilson
Since txn_* is a part of the schema, how do I have a resultset method always run within one transaction without passing $schema (which just seems kludgy)? Since I can't find anything on google about doing this, I'm guessing it's a bad idea or there's some obviousness I'm missing?

Re: [Dbix-class] transaction in a resultset class

2013-04-11 Thread Peter Rabbitson
On Thu, Apr 11, 2013 at 10:58:50AM -0400, shawn wilson wrote: Since txn_* is a part of the schema, how do I have a resultset method always run within one transaction without passing $schema (which just seems kludgy)? Since I can't find anything on google about doing this, I'm guessing it's a

Re: [Dbix-class] transaction in a resultset class

2013-04-11 Thread shawn wilson
On Thu, Apr 11, 2013 at 11:28 AM, Peter Rabbitson rabbit+d...@rabbit.us wrote: On Thu, Apr 11, 2013 at 10:58:50AM -0400, shawn wilson wrote: Since txn_* is a part of the schema, how do I have a resultset method always run within one transaction without passing $schema (which just seems

Re: [Dbix-class] transaction in a resultset class

2013-04-11 Thread shawn wilson
On Thu, Apr 11, 2013 at 12:03 PM, shawn wilson ag4ve...@gmail.com wrote: On Thu, Apr 11, 2013 at 11:28 AM, Peter Rabbitson rabbit+d...@rabbit.us wrote: On Thu, Apr 11, 2013 at 10:58:50AM -0400, shawn wilson wrote: Since txn_* is a part of the schema, how do I have a resultset method always

[Dbix-class] Test suites fail on sqlite upgrade

2013-04-11 Thread Shea Levy
Hi, After updating sqlite from 3.7.14.1 to 3.7.16.1 (my package manager uses a system sqlite for DBD::SQLite), the DBIx-Class testsuites fail: http://hydra.nixos.org/build/4720176/nixlog/1/raw. Any ideas about how serious this is or how to fix it? That log is a build of DBIx-Class 0.08204,

Re: [Dbix-class] Test suites fail on sqlite upgrade

2013-04-11 Thread Peter Rabbitson
On Thu, Apr 11, 2013 at 01:47:23PM -0400, Shea Levy wrote: Hi, After updating sqlite from 3.7.14.1 to 3.7.16.1 (my package manager uses a system sqlite for DBD::SQLite) Could you provide a basic instruction on how to build such a DBD::SQLite? the DBIx-Class testsuites fail:

Re: [Dbix-class] transaction in a resultset class

2013-04-11 Thread Charlie Garrison
Good morning, On 11/04/13 at 12:06 PM -0400, shawn wilson ag4ve...@gmail.com wrote: Err, not sure if that was stated that well - how would I write something like: $schema-txn_do(sub{ $self-create({ url = $page, stamp = time, }); }); Did you read the docco Peter sent links for? It explains