Re: [Dbix-class] I found a bug under UTF8Column

2008-03-08 Thread Matt S Trout
You can't fix UTF8Columns by patching Row. Please try and supply a patch that fixes the problem at source rather than polluting the rest of the code base. UTF8Columns is only really required (AFAIK) by sites stuck with old DBD::mysql installs without proper utf8 support, so I don't want the magic

Re: [Dbix-class] Bug with find_or_new and insert_or_update with postgresql: any success?

2008-03-08 Thread Matt S Trout
On Mon, Feb 25, 2008 at 11:53:19PM +0300, Alex Povolotsky wrote: Hello! I've found in archives nearly my case, that passing NULL to Pg is not 'not passing column at all', so adding a new row with a simple code like this my $loc = $c-model($self-model_name)-find_or_new({lid = $id});

Re: [Dbix-class] Prefetch Problem: Related data can't be fetched

2008-03-08 Thread Matt S Trout
On Wed, Feb 27, 2008 at 07:55:32PM +0900, [EMAIL PROTECTED] wrote: Hi, My friend solved the problem. It's weird though and I am still a little bit confused. The way I am trying to access/display the rows is like this: [% FOREACH railway = railways -%] [%

Re: [Dbix-class] count behaviour

2008-03-08 Thread Matt S Trout
On Tue, Feb 26, 2008 at 04:21:00PM +0300, Alex Povolotsky wrote: Ash Berlin wrote: As for where its documened... somewhere in the Template Toolkit manual. the _rs methods are mentioned in Relationship docs of DBIC. Tho it could be more obvious, since currently there is just this

Re: [Dbix-class] ON DELETE statement in Pg not avaiable in schema::loader?

2008-03-08 Thread Matt S Trout
On Tue, Feb 26, 2008 at 01:17:37PM +0100, Moritz Onken wrote: Hi, I use the ON DELETE statements in my Pg database to set the foreign key to null if a column is deleted. But this information doesn't make it's way to the schema if I use Schema::Loader. And therefore the files created

Re: [Dbix-class] ON DELETE statement in Pg not avaiable in schema::loader?

2008-03-08 Thread Moritz Onken
Wouldn't it be great (tm) if we could add an on_delete and on_update config to all the relationships? Like the cascade_delete config option. If the DMBS supports that type of actions DBIC does not have to take care of it, otherwise it does. There might be a good reason why this has not

Re: [Dbix-class] DBIx::Class column list

2008-03-08 Thread Ryan D Johnson
xyon [EMAIL PROTECTED] writes: I just want to fetch the column names. Below is essentially what I want to do (but it obviously doesn't work;)): my @columns = $schema-resultset('data')-columns; Is this what you're looking for: $ $schema-resultset('User')-result_source-columns; $ARRAY1 = [

Re: [Dbix-class] DBIx::Class column list

2008-03-08 Thread xyon
Precisely it, thank you! Is there documentation somewhere addressing this that I could have looked at before posting to the list? Thanks so much. On Sat, 2008-03-08 at 11:05 -0800, Ryan D Johnson wrote: xyon [EMAIL PROTECTED] writes: I just want to fetch the column names. Below is

Re: [Dbix-class] I found a bug under UTF8Column

2008-03-08 Thread Jonathan Rockway
* On Fri, Mar 07 2008, Tomohiro Hosaka wrote: Index: t/85utf8.t A quick reading of this patch doesn't tell me what you're trying to do. Could you please describe that? If so, I can probably fix it without touching Row. Feel free to reply in Japanese if that's easier for you. Regards, Jonathan