Re: [Dbix-class] User error? SQLite problem? with DBIx::Class::Fixtures and populate

2008-10-07 Thread luke saunders
On Tue, Oct 7, 2008 at 6:22 PM, Ashley <[EMAIL PROTECTED]> wrote: > I'm messing around with writing some tests with DBIx::Class::Fixtures and > getting stuck. Trying to see if it's something obvious I'm doing wrong or > there is currently an sqlite problem. The code below runs fine except the > fi

Re: [Dbix-class] Probleme with nextval() and postgresql 7.4.17

2008-10-07 Thread Matt S Trout
On Tue, Oct 07, 2008 at 10:54:30AM +0200, Ludovic Legrand wrote: > hi, > I want to select the nextval of the sequence 'seq_id_comparison' of the > table 'Comparison' with this line: > > $dbh->resultset('Comparison')->search(undef, { > select => "nextval('seq_id_comparison')", > as => '

[Dbix-class] User error? SQLite problem? with DBIx::Class::Fixtures and populate

2008-10-07 Thread Ashley
I'm messing around with writing some tests with DBIx::Class::Fixtures and getting stuck. Trying to see if it's something obvious I'm doing wrong or there is currently an sqlite problem. The code below runs fine except the final step: $fixtures->populate. This is the error it gives- SQL wa

Re: [Dbix-class] install test failures

2008-10-07 Thread Peter Rabbitson
Dave Howorth wrote: > Dave Howorth wrote: >> The test uses this regex: qr/No such column made_up_column .*? at >> .*?81transactions.t line \d+/, >> >> I'm not clear why it needs to use such a complicated regex instead of >> just qr/No such column made_up_column/ ? >> >> I also don't understand why

Re: [Dbix-class] install test failures

2008-10-07 Thread Dave Howorth
Dave Howorth wrote: > The test uses this regex: qr/No such column made_up_column .*? at > .*?81transactions.t line \d+/, > > I'm not clear why it needs to use such a complicated regex instead of > just qr/No such column made_up_column/ ? > > I also don't understand why it doesn't need a /s modifi

Re: [Dbix-class] Patch roundup time, again.

2008-10-07 Thread Dave Howorth
Matt S Trout wrote: > Any outstanding patches, please send to this thread. Can somebody also > go through rt.cpan.org and work out if there's anything on there we need > to apply as well? Fix problem with t/61findnot.t: --- Makefile.PL 2008-08-14 17:39:12.0 +0100 +++ Makefile.PL.new

Re: [Dbix-class] install test failures

2008-10-07 Thread Peter Rabbitson
Can you update to the latest trunk, and see if the same stuff comes back? There were many changes to the test suite today. ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.o

Re: [Dbix-class] install test failures

2008-10-07 Thread Matt S Trout
On Tue, Oct 07, 2008 at 11:57:56AM +0100, Dave Howorth wrote: > Dave Howorth wrote: > > Can anybody help me track down my test failures, please? > > > > Hopefully it's me being silly but if not, I'd like to make an RT report > > before release. > > OK, I've tracked down the problem with t/61findn

Re: [Dbix-class] install test failures

2008-10-07 Thread Dave Howorth
Peter Rabbitson wrote: > Dave Howorth wrote: >> Peter Rabbitson wrote: >>> Dave Howorth wrote: This doesn't solve my issue with t/81transactions.t. I'll look at that now. >>> About t/81transactions - does this happen on trunk with no >>> midifications? What is your `env | grep DBICTEST` if any

Re: [Dbix-class] install test failures

2008-10-07 Thread Peter Rabbitson
Dave Howorth wrote: > Peter Rabbitson wrote: >> Dave Howorth wrote: >>> This doesn't solve my issue with t/81transactions.t. I'll look at that now. >> About t/81transactions - does this happen on trunk with no >> midifications? What is your `env | grep DBICTEST` if any? > > Yes, it happens on trun

Re: [Dbix-class] install test failures

2008-10-07 Thread Dave Howorth
Peter Rabbitson wrote: > Dave Howorth wrote: >> This doesn't solve my issue with t/81transactions.t. I'll look at that now. > > About t/81transactions - does this happen on trunk with no > midifications? What is your `env | grep DBICTEST` if any? Yes, it happens on trunk with no modifications. No

Re: [Dbix-class] install test failures

2008-10-07 Thread Peter Rabbitson
Dave Howorth wrote: > Dave Howorth wrote: >> Can anybody help me track down my test failures, please? >> >> Hopefully it's me being silly but if not, I'd like to make an RT report >> before release. > > OK, I've tracked down the problem with t/61findnot.t and raised an RT > report for it. The issu

RE: [Dbix-class] Prefetch problem

2008-10-07 Thread peter
mst wrote: On Thu, Oct 02, 2008 at 04:50:23PM +0100, [EMAIL PROTECTED] wrote: In theory you can set quoting on table and field names: http://search.cpan.org/~ash/DBIx-Class-0.08010/lib/DBIx/Class/Manual/Cookboo k.pod#Setting_quoting_for_the_generated_SQL. In practice, though, that doesn't wo

Re: [Dbix-class] install test failures

2008-10-07 Thread Dave Howorth
Dave Howorth wrote: > Can anybody help me track down my test failures, please? > > Hopefully it's me being silly but if not, I'd like to make an RT report > before release. OK, I've tracked down the problem with t/61findnot.t and raised an RT report for it. The issue is that it has an undeclared

[Dbix-class] Probleme with nextval() and postgresql 7.4.17

2008-10-07 Thread Ludovic Legrand
hi, I want to select the nextval of the sequence 'seq_id_comparison' of the table 'Comparison' with this line: $dbh->resultset('Comparison')->search(undef, { select => "nextval('seq_id_comparison')", as => 'id_comp', })->single->get_column('id_comp'); SQL equivalent: SELECT NEXTV