Re: [Dbix-class] Memory usage, something hanging on?

2007-01-08 Thread Toby Corkindale
On Mon, Jan 08, 2007 at 04:59:20PM +, Matt S Trout wrote: > On 8 Jan 2007, at 15:51, Adam Sjøgren wrote: > > > Hi. > > > > > >In a Catalyst application I am working on, in which we use > >DBIx::Class, server.pl just grew to use over 300MB ram, staying that > >size from then on. > > [snip] > >

Re: [Dbix-class] Documentation bug: catalyst::request

2006-10-18 Thread Toby Corkindale
On Wed, Oct 18, 2006 at 12:37:24PM +0100, Toby Corkindale wrote: > Bug in Catalyst::Request. > It says: > $req->action >Returns the requested action as a Catalyst::Action object. > > However, it just returns the "action", (ie. foo/bar). > > To get a

[Dbix-class] Documentation bug: catalyst::request

2006-10-18 Thread Toby Corkindale
Bug in Catalyst::Request. It says: $req->action Returns the requested action as a Catalyst::Action object. However, it just returns the "action", (ie. foo/bar). To get a genuine Catalyst::Action object, you need to call $c->action. -Toby -- Turning and turning in the widening gyre/T

[Dbix-class] Error in DBIx::Class::Manual::Cookbook

2006-10-13 Thread Toby Corkindale
Seems to be an error in the Manual::Cookbook. Under "Stringification" it says: Employ the standard stringification technique by using the "overload" module. Replace "foo" with the column/method of your choice. use overload ’""’ => ’foo’, fallback => 1; However, this resu

Re: [Dbix-class] select * from function('param')

2006-08-16 Thread Toby Corkindale
On Fri, Jul 28, 2006 at 12:38:59AM -0400, Daniel Westermann-Clark wrote: > On 2006-07-27 22:38:02 +, mock wrote: > > So I've got a function in my Pg database which takes a single > > parameter and returns a set of rows. > > > > "select * from function('param')" works just fine from psql and >

Re: [Dbix-class] select from dual

2006-08-16 Thread Toby Corkindale
On Wed, Jul 19, 2006 at 09:33:35AM +0100, Jess Robinson wrote: > On Mon, 17 Jul 2006, A. Pagaltzis wrote: > > >* Jess Robinson <[EMAIL PROTECTED]> [2006-07-17 00:30]: > >What did you need it for? > > Basically, in Oracle, you canÿÿt say things like > > SELECT NOW(); > > because a SELECT wit

Re: [Dbix-class] D::C generates unneccessary duplicate joins..

2006-07-06 Thread Toby Corkindale
On Thu, Jul 06, 2006 at 01:49:12PM +0100, Jess Robinson wrote: > On Wed, 5 Jul 2006, Toby Corkindale wrote: > > Hi, > > I'm trying to work out how to optimise a query. D::C is generating twice as > > many joins as neccessary, which adds up to hurt performance in extended

Re: [Dbix-class] D::C generates unneccessary duplicate joins..

2006-07-06 Thread Toby Corkindale
On Wed, Jul 05, 2006 at 04:44:29PM +0100, Matt S Trout wrote: > Toby Corkindale wrote: > > Hi, > > I'm trying to work out how to optimise a query. D::C is generating twice as > > many joins as neccessary, which adds up to hurt performance in extended > > c

[Dbix-class] D::C generates unneccessary duplicate joins..

2006-07-05 Thread Toby Corkindale
Hi, I'm trying to work out how to optimise a query. D::C is generating twice as many joins as neccessary, which adds up to hurt performance in extended cases of the example I give below. I've played around with from=> somewhat, but there's probably a simpler way, right? For the simplified case, w

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Toby Corkindale
On Thu, May 18, 2006 at 04:48:53PM +0100, Toby Corkindale wrote: > I just ask, because it wasn't working on my little test - the update() was > dieing with "Column foo not found". (It wasn't joining anything) Whoops, i mean, column "Bar" not fou

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Toby Corkindale
On Thu, May 18, 2006 at 02:56:00PM +0100, Matt S Trout wrote: > my $rs = $schema->resultset('Example')->search({ id => { '<', 1000 }); > # remember this doesn't actually run a query > > $schema->txn_do( >sub { $rs->update({ foo => \"foo + 1" }); } > ); OK, I'm just playing with mo

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Toby Corkindale
On Thu, May 18, 2006 at 02:56:00PM +0100, Matt S Trout wrote: > Toby Corkindale wrote: > >> ... but if you can't persuade it to run something that's at least *almost* > >> equivalent to the pure hand-crafted SQL you would have done anyway, I want > >> t

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Toby Corkindale
On Thu, May 18, 2006 at 01:31:26PM +0100, Matt S Trout wrote: > Toby Corkindale wrote: > > On Thu, May 18, 2006 at 01:11:46AM -0700, John Napiorkowski wrote: > >> To be honest I am sure part of my problem is ignorance > >> about the best way to use DBIx. So your sugge

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-18 Thread Toby Corkindale
On Thu, May 18, 2006 at 01:11:46AM -0700, John Napiorkowski wrote: > To be honest I am sure part of my problem is ignorance > about the best way to use DBIx. So your suggestions > of any type are useful. I've been using SQL for quite > a long time and writing a statement like the one I > show bel

Re: [Dbix-class] trouble with using 'select' in a search clause

2006-05-17 Thread Toby Corkindale
On Wed, May 17, 2006 at 01:47:36AM -0700, John Napiorkowski wrote: > Hi, > > I'm trying to create a query to perform something like > this: > > SELECT me.*, invitees.* > FROM members_invitees me > JOIN invitees invitees > ON ( invitees.invitee_id = me.invitee_id ) > WHERE ( member_id =

Re: [Dbix-class] ping 'from' attribute doc author: you need to fix them

2006-05-10 Thread Toby Corkindale
On Wed, May 10, 2006 at 10:00:07AM -0700, Aran Deltac wrote: > > > Can whoever originally wrote this step up and correct it please? > > > > And perhaps add another couple of tests to your test suite? > > Toby - would you be willing to create these? If someone can provide documentation that explai

Re: [Dbix-class] ping 'from' attribute doc author: you need to fix them

2006-05-10 Thread Toby Corkindale
On Wed, May 10, 2006 at 04:55:12PM +0100, Matt S Trout wrote: > Toby Corkindale wrote: > > Hi, > > just following on from a discussion on IRC yesterday.. > > I was asking about why a 'from' clause in a search method of mine was > > causing D::C to die with an

[Dbix-class] 'from' attribute docs suggestion (or is it a bug?)

2006-05-10 Thread Toby Corkindale
Hi, just following on from a discussion on IRC yesterday.. I was asking about why a 'from' clause in a search method of mine was causing D::C to die with an error.* The answer given was that I shouldn't be using 'from' at all, as I wasn't a developer, and only people who were willing to read and gr

Re: [Dbix-class] Accessing $dbh for blobs/large-objects

2006-05-09 Thread Toby Corkindale
ering myself to write a D::C::...::BLOB::FH interface at some point, unless there's a better way to do this.. ;) tjc On Tue, May 09, 2006 at 12:40:51PM +0100, Toby Corkindale wrote: > On Mon, May 08, 2006 at 08:23:10PM +0100, Matt S Trout wrote: > > Toby Corkindale wrote: > > &

Re: [Dbix-class] Accessing $dbh for blobs/large-objects

2006-05-09 Thread Toby Corkindale
On Mon, May 08, 2006 at 08:23:10PM +0100, Matt S Trout wrote: > Toby Corkindale wrote: > > Hi, > > I'm trying to do some work with large objects (blobs) in PostgreSQL, via a > > DBIx::Class::Schema-based database. > > Is this the correct way to get at the $dbh to

[Dbix-class] Accessing $dbh for blobs/large-objects

2006-05-08 Thread Toby Corkindale
Hi, I'm trying to do some work with large objects (blobs) in PostgreSQL, via a DBIx::Class::Schema-based database. Is this the correct way to get at the $dbh to use? my $dbh = $c->model('DB')->schema->storage->_dbh; ta, Toby -- Turning and turning in the widening gyre/The falcon cannot hear the

Re: [Dbix-class] has_many relationship docs

2006-04-28 Thread Toby Corkindale
On Thu, Apr 27, 2006 at 08:10:16PM +0100, Matt S Trout wrote: > Toby Corkindale wrote: > > Did anyone come back (perhaps offlist) with an answer to this? > > > > Reason I ask is that I'm just trying to get my head around adding objects > > via > > many_to_m

Re: [Dbix-class] has_many relationship docs

2006-04-27 Thread Toby Corkindale
Did anyone come back (perhaps offlist) with an answer to this? Reason I ask is that I'm just trying to get my head around adding objects via many_to_many relationships. Is there a shortcut method, a-la has_many's *_add_to() method? ie. Actor has a many_to_many relationship to Roles, eg: Schema::A

[Dbix-class] Re: [Catalyst] Testcase for DBIx::Class::Loader - demonstrates failure under load

2006-02-13 Thread Toby Corkindale
On Mon, Feb 13, 2006 at 11:09:49AM -0600, Brandon Black wrote: > On 2/13/06, Brandon Black <[EMAIL PROTECTED]> wrote: > > On 2/13/06, Toby Corkindale <[EMAIL PROTECTED]> wrote: > > > On Mon, Feb 13, 2006 at 09:55:31AM -0600, Brandon Black wrote: > > >