WG: [Dbix-class] Oracle Prefetch / Join

2007-05-07 Thread SHAD0WRUNNER
Hello again, I tried this example with Oracle: Tables CDS - Tracks #1. Package: # package Schema::CD; use base qw/DBIx::Class/; __PACKAGE__-load_components(qw/ PK::Auto Core /); __PACKAGE__-table('cds'); __PACKAGE__-add_columns( id = {

[Dbix-class] automatically applying db-functions on specific fields

2007-05-07 Thread quarky
Hi, hope this is not too much a newby question, but it really bugs me. I have a table with encrypted information in one field. Actually it is encrypted with the aes_encrypt function of mysql. I would like to use this function to automatically encrypt and decrypt the values in this field using

Re: [Dbix-class] automatically applying db-functions on specific fields

2007-05-07 Thread Dieter Späth
Original-Nachricht Datum: Mon, 07 May 2007 09:44:28 +0200 Von: [EMAIL PROTECTED] An: dbix-class@lists.rawmode.org Betreff: [Dbix-class] automatically applying db-functions on specific fields Hi, hope this is not too much a newby question, but it really bugs me. I have a

Re: [Dbix-class] automatically applying db-functions on specific fields

2007-05-07 Thread Oleg Pronin
Perl-side solution is very simple - use InflateColumn plugin (DBIx::Class::InflateColumn). 2007/5/7, [EMAIL PROTECTED] [EMAIL PROTECTED]: Any suggestions? (In the unlikely event, that someone might know how to emulate aes_encrypt by using perl on the client side, I would appreciate this

Re: [Dbix-class] RFC: Inflating user-supplied values

2007-05-07 Thread Matt S Trout
On Sun, May 06, 2007 at 09:16:41AM -0400, Jason Kohles wrote: So everybody probably saw my confusion with inflation from yesterday, and while it is all working now (thanks Claco!) I have to admit I still find the behavior counter-intuitive at best. I guess when I was just inflating

Re: [Dbix-class] admin functions for the storage object?

2007-05-07 Thread Matt S Trout
On Fri, May 04, 2007 at 08:48:22PM +0100, Jess Robinson wrote: On Fri, 4 May 2007, John Napiorkowski wrote: Hi, Not sure if this is something other people care about but I end up have to write some driver specific code for stuff like dis/enabling FK constraints and so forth to make

Re: [Dbix-class] Use of sub-select in joins

2007-05-07 Thread Matt S Trout
On Fri, May 04, 2007 at 11:03:10PM +0930, Jon Schutz wrote: I think that would work, yes. In which case using search_literal() would get around the need for the table sub-select. A good suggestion, thankyou. Though I am still interested in the other half of the problem - if I _have_ to do

[Dbix-class] Re: New Class::C3 dev releases

2007-05-07 Thread Adam Sjøgren
On Tue, 1 May 2007 13:44:37 -0500, Brandon wrote: I've pushed new dev releases of Class::C3 and Class::C3::XS out to CPAN again. The big changes are that they've both moved to Module::Install (which I'm a little bit nervous about, having never put together a Module::Install-based module

Re: [Dbix-class] Karl Moens ([EMAIL PROTECTED]) is out of the office.

2007-05-07 Thread Matt S Trout
On Tue, May 01, 2007 at 01:09:30PM +0100, [EMAIL PROTECTED] wrote: I will be out of the office starting 01/05/2007 and will not return until 02/05/2007. I've asked you four times now privately to fix your autoresponder. I even mailed your postmaster offering to help. I have now had enough.

Re: [Dbix-class] admin functions for the storage object?

2007-05-07 Thread Ash Berlin
Matt S Trout wrote: On Fri, May 04, 2007 at 08:48:22PM +0100, Jess Robinson wrote: On Fri, 4 May 2007, John Napiorkowski wrote: Hi, Not sure if this is something other people care about but I end up have to write some driver specific code for stuff like dis/enabling FK constraints and so

Re: [Dbix-class] Re: New Class::C3 dev releases

2007-05-07 Thread Brandon Black
On 5/7/07, Adam Sjøgren [EMAIL PROTECTED] wrote: http://www.dtmf.com/Class-C3-XS-0.01_07.tar.gz Just some building feedback: Actually I've already release Class::C3 0.16 + Class::C3::XS 0.02 to CPAN, they're virtually identical to the previous dev releases. dh-make-perl in Ubuntu 7.04

[Dbix-class] Field triggers

2007-05-07 Thread Pedro Melo
Hi, This is what I want to do: when someone inserts or updates a password field, I want to sha1_hex'digest it. I was able to do this overriding both set_column() (for updates) and insert() (for inserts). Is this the best way? Should I use the inflate_column instead? Best regards, --

Re: [Dbix-class] Field triggers

2007-05-07 Thread Jonas Alves
On 07/05/07, Pedro Melo [EMAIL PROTECTED] wrote: Hi, This is what I want to do: when someone inserts or updates a password field, I want to sha1_hex'digest it. I was able to do this overriding both set_column() (for updates) and insert() (for inserts). Is this the best way? Should I use the

Re: [Dbix-class] RFC: Inflating user-supplied values

2007-05-07 Thread Jason Kohles
On May 7, 2007, at 9:02 AM, Matt S Trout wrote: On Sun, May 06, 2007 at 09:16:41AM -0400, Jason Kohles wrote: So everybody probably saw my confusion with inflation from yesterday, and while it is all working now (thanks Claco!) I have to admit I still find the behavior counter-intuitive at

Re: [Dbix-class] RFC: Inflating user-supplied values

2007-05-07 Thread Christopher H. Laco
and while it is all working now (thanks Claco!) I have to admit I still find the behavior counter-intuitive at best. I guess when I was just inflating DateTime objects it made more sense, since the inflated values were so much more complex than the representation that was stored in the

Re: [Dbix-class] Field triggers

2007-05-07 Thread Pedro Melo
Hi, On May 7, 2007, at 5:17 PM, Jonas Alves wrote: On 07/05/07, Pedro Melo [EMAIL PROTECTED] wrote: This is what I want to do: when someone inserts or updates a password field, I want to sha1_hex'digest it. I was able to do this overriding both set_column() (for updates) and insert() (for

[Dbix-class] Group by query in Perl

2007-05-07 Thread Dmitri Pissarenko
Hello! I have a table with activities and each of them has a certain duration. Each activitiy is assigned to one category. I want to create a table, in which a) each category is shown and b) for each category the sum of durations of its activities is shown. In other words, I want to display

[Dbix-class] Re: Group by query in Perl

2007-05-07 Thread Dmitri Pissarenko
Hello! Please ignore my question, I found the solution. My query statement was wrong. Here is the correct one: my @durationSums = $c-model('TimeTrackingAppDB::Activity')-search( undef, { join = [qw/ goal /], select = [ 'goal.name', { sum = 'me.duration' } ], as

Re: [Dbix-class] Karl Moens ([EMAIL PROTECTED]) is out of the office.

2007-05-07 Thread Zbigniew Lukasiak
The other day I had the idea to make a list of shame where all the mailing lists could publish the names of people with bad autoresponders. This might be quite effective to get people attention to the problem. -- Zbyszek On 5/7/07, Matt S Trout [EMAIL PROTECTED] wrote: On Tue, May 01, 2007 at

DBIx::Class::InflateColumn bug (was Re: [Dbix-class] RFC: Inflating user-supplied values)

2007-05-07 Thread Jason Kohles
On May 7, 2007, at 1:16 PM, Christopher H. Laco wrote: and while it is all working now (thanks Claco!) I have to admit I still find the behavior counter-intuitive at best. I guess when I was just inflating DateTime objects it made more sense, since the inflated values were so much more complex

Re: DBIx::Class::InflateColumn bug (was Re: [Dbix-class] RFC: Inflating user-supplied values)

2007-05-07 Thread Christopher H. Laco
Jason Kohles wrote: On May 7, 2007, at 1:16 PM, Christopher H. Laco wrote: and while it is all working now (thanks Claco!) I have to admit I still find the behavior counter-intuitive at best. I guess when I was just inflating DateTime objects it made more sense, since the inflated values

Re: [Dbix-class] Default values

2007-05-07 Thread Matt S Trout
On Mon, Apr 30, 2007 at 05:05:00PM -0400, Dan Boger wrote: sub new { my ($self, $attrs) = @_; WRONG! my ($class, $attrs) = @_; It's not an object yet, it's a class. always say $class in constructor, because ... $attrs-{unixtime} = time if not $attrs-{unixtime} or

Re: [Dbix-class] Re: New Class::C3 dev releases

2007-05-07 Thread Matt S Trout
On Mon, May 07, 2007 at 10:25:26AM -0500, Brandon Black wrote: Ok, I don't think there's really anything out there that knows about Build.PL but not Makefile.PL, so I'll just remove these from the packages and release new versions. I find Module::Build's author-side tools excellent but it's a