[Dbix-class] Searching - two criteria for the same field

2009-02-09 Thread Gerg Coates
I need to do a search on a resultset that is filtered by two values on the same field. I tried code like this, but it doesn't seem to be working: my $t = $schema->resultset('Table')->search( { 'glr_date' => { '>=', $beg_date }, 'glr_date' => { '<', $end_date } } ); Can anyone offer gui

[Dbix-class] 81transactions.t fixed

2009-02-09 Thread Peter Rabbitson
Will Hawes wrote: > t/81transactions.t 255 6528063 18 55-63 > (1 subtest UNEXPECTEDLY SUCCEEDED), 37 tests and 4 subtests skipped. > Failed 1/107 test scripts. 9/2071 subtests failed. > Files=107, Tests=2071, 76 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU) > Failed 1/107 test progr

[Dbix-class] Global Convertion ( win1251 <-> koi8r ) "on-the-fly"

2009-02-09 Thread ivan
In my DB - win1251 codepage. In my interface - koi8r codepage. Where I must add 2 string convertion ( win1251 <-> koi8r encoding ) for all SQL results and input params ? ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.pe

Re: [Dbix-class] loading data types from Oracle DB with DBIx::Class::Schema::Loader

2009-02-09 Thread Benjamin Hitz
Huh, I used this module and never noticed that it didn't write __PACKAGE__->data_type methods in the Classes. They work just fine, though. Maybe it slows stuff down? I had to hack the DBIx::Class::Schema::Loader::Oracle to handle oracle "schemas" (aka users) because we specify tables in qu

Re: [Dbix-class] Pagination Troubles

2009-02-09 Thread fREW Schmidt
Thanks Jason! Here is the complete function if anyone is curious: sub basic_data { > my $self = shift; > my $params = shift; > my $table = $params->{table}; > my $search = $params->{search}; > my $columns = $params->{columns}; > my $rows = $self->query->param('limit') || 2

Re: [Dbix-class] Call for testers

2009-02-09 Thread Michael Higgins
On Mon, 09 Feb 2009 11:08:15 +0100 Peter Rabbitson wrote: > Greetings, > > In order to resolve a cpan dependency deadlock, we prepared a > forward-compatible version of DBIC 0.08011. Keep in mind that this is > _not_ the long awaited 0.08100 release, so do not expect any new > features. In fact

Re: [Dbix-class] Call for testers

2009-02-09 Thread David Ihnen
Peter Rabbitson wrote: Greetings, In order to resolve a cpan dependency deadlock, we prepared a forward-compatible version of DBIC 0.08011. Keep in mind that this is _not_ the long awaited 0.08100 release, so do not expect any new features. In fact it strives to be bug-for-bug compatible with 0

[Dbix-class] loading data types from Oracle DB with DBIx::Class::Schema::Loader

2009-02-09 Thread Karl Forner
Re-sent from catalyst mailing-list... Hello, We are using catalyst with an Oracle database. We are using DBIx::Class::Schema::Loader to create the DBIx::Class interface, with the following command; ./myapp_create.pl model DB DBIC::Schema MyApp::Schema create=static 'dbi:Oracle:sid=BDBDEV;host=ch7

Re: [Dbix-class] Call for testers

2009-02-09 Thread Will Hawes
2009/2/9 Peter Rabbitson : > Both of these `prove` invocations are wrong, as they run the test against > the currently installed 0.08010 (I can tell by the presence of the > startup check warning). You either need to supply -Ilib to prove, > or use the -b option _after_ running `perl Makefile.PL;

Re: [Dbix-class] Call for testers

2009-02-09 Thread Ali M.
On Mon, Feb 9, 2009 at 12:08 PM, Peter Rabbitson wrote: > Greetings, > > Please download, test and report back at your convenience: > http://rabbit.us/diff/DBIx-Class-0.08011.tar.gz > Failed test here too Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>cd de

Re: [Dbix-class] Call for testers

2009-02-09 Thread Peter Rabbitson
Will Hawes wrote: > 2009/2/9 Peter Rabbitson : >> Greetings, >> Please download, test and report back at your convenience: >> http://rabbit.us/diff/DBIx-Class-0.08011.tar.gz >> > > D:\Setup\DBIx-Class-0.08011>prove t > > > > > D:\Setup\DBIx-Class-0.08011>prove -v t\81transactions.t > t\81trans

Re: [Dbix-class] Call for testers

2009-02-09 Thread Will Hawes
2009/2/9 Peter Rabbitson : > Greetings, > Please download, test and report back at your convenience: > http://rabbit.us/diff/DBIx-Class-0.08011.tar.gz > D:\Setup\DBIx-Class-0.08011>prove t Failed TestStat Wstat Total Fail List of Failed -

Re: [Dbix-class] Call for testers

2009-02-09 Thread Daisuke Maki
Test Summary Report --- t/81transactions (Wstat: 0 Tests: 63 Failed: 0) TODO passed: 55-61 t/95sql_maker_quote(Wstat: 0 Tests: 8 Failed: 0) TODO passed: 3 Files=107, Tests=2575, 78 wallclock secs ( 1.02 usr 0.57 sys + 53.92 cusr 1

[Dbix-class] Call for testers

2009-02-09 Thread Peter Rabbitson
Greetings, In order to resolve a cpan dependency deadlock, we prepared a forward-compatible version of DBIC 0.08011. Keep in mind that this is _not_ the long awaited 0.08100 release, so do not expect any new features. In fact it strives to be bug-for-bug compatible with 0.08010, so we can release