[Dbix-class] looking for some postgres bytea/lob pointers

Hey, I'm looking for some suggestions about the best way to access bytea or lob objects in Postgres using DBIx. I know there was a discussion about this last month, but there wasn't any code examples and to be honest I am a bit of a newb to this. The only example I could find was over at the cat

Re: [Dbix-class] Is this the canonical way to do this?

I probably shouldn't name name variable "$video_rs" since it could cause confusion. I know it took me a while to figure out the whole resultset versus row deal. Now I don't think about it so much it's easy to get sloppy. -john --- Matt S Trout <[EMAIL PROTECTED]> wrote: > John Napiorkowski wro

Re: [Dbix-class] searchable archive of the list?

* Matt S Trout <[EMAIL PROTECTED]> [2006-06-08 17:15]: > Cheers. Note the list footer :) Hahaha, I did quite the double-take! It took a moment before I noticed you only just added it, and we hadn’t all just overlooked it before. Regards, -- Aristotle Pagaltzis // _

Re: [Dbix-class] InflateColumn::DateTime

> My problem is in deflate: > >> $column => >> { >> inflate => sub { >> my ($value, $obj) = @_; >> $obj->_datetime_parser->parse_datetime($value); >> }, >> deflate => sub { >> my ($value, $obj) = @_; > $o

Re: [Dbix-class] InflateColumn::DateTime

Mark Hedges wrote: > On Thu, 8 Jun 2006, Christopher H. Laco wrote: >> I agree. The second version/error seems kind of obvious, and I'm sure >> isn't the normal way of doing things. >> >> It's the first version/error that's really throwing me here. >> >> Time to start digging... > > Hmm yes you're

Re: [Dbix-class] InflateColumn::DateTime

On Thu, 8 Jun 2006, Christopher H. Laco wrote: > > I agree. The second version/error seems kind of obvious, and I'm sure > isn't the normal way of doing things. > > It's the first version/error that's really throwing me here. > > Time to start digging... Hmm yes you're right, you were already

Re: [Dbix-class] InflateColumn::DateTime

At the very least, here's a patch to quench the "undefined value...regex match operation' warnings on columns that don't have a data_type defined. -=Chris --- DateTime.pm.orig Thu Jun 08 14:10:10 2006 +++ DateTime.pm Thu Jun 08 14:25:26 2006 @@ -48,7 +48,7 @@ sub register_column { my ($self, $

Re: [Dbix-class] InflateColumn::DateTime

Christopher H. Laco wrote: > Mark Hedges wrote: >> On Thu, 8 Jun 2006, Christopher H. Laco wrote: >>> If the order item and cart item instead load InflateColumn::DateTime, >>> all hell breaks loose. If I try copying the raw value, which is a >>> DateTime object, I get this what trying to add to a r

Re: [Dbix-class] InflateColumn::DateTime

Mark Hedges wrote: > On Thu, 8 Jun 2006, Christopher H. Laco wrote: >> If the order item and cart item instead load InflateColumn::DateTime, >> all hell breaks loose. If I try copying the raw value, which is a >> DateTime object, I get this what trying to add to a relation: >> >>> Can't use string

Re: [Dbix-class] InflateColumn::DateTime

On Thu, 8 Jun 2006, Christopher H. Laco wrote: > > If the order item and cart item instead load InflateColumn::DateTime, > all hell breaks loose. If I try copying the raw value, which is a > DateTime object, I get this what trying to add to a relation: > > > Can't use string ("Handel::Subclassin

Re: [Dbix-class] searchable archive of the list?

John Napiorkowski wrote: > Hey, > > Does anyone know of a place where this list has a > searchable archive? I found it on google once, but I > can't find it again and I am sure some of the > questions I want to ask have been discussed before. > > --john > >

Re: [Dbix-class] searchable archive of the list?

On 08/06/06, A. Pagaltzis <[EMAIL PROTECTED]> wrote: > * Carl Franks <[EMAIL PROTECTED]> [2006-06-08 16:15]: > > You can also restrict google searches to directories within > > sites with: > > > > site:http://lists.rawmode.org/pipermail/dbix-class/ > > No, `site:` doesn't work like that. It only re

Re: [Dbix-class] searchable archive of the list?

A. Pagaltzis wrote: > * Carl Franks <[EMAIL PROTECTED]> [2006-06-08 16:15]: >> You can also restrict google searches to directories within >> sites with: >> >> site:http://lists.rawmode.org/pipermail/dbix-class/ > > No, `site:` doesn’t work like that. It only restricts to a > domain. If you give i

Re: [Dbix-class] Is this the canonical way to do this?

John Napiorkowski wrote: > Looks like I was having some sort of mental block the > other night. I got the following to work properly: > > my $video_rs = $self->find({video_id=>$video_id}); > return ( defined($video_rs) ? 1 : 0 ); > > and it did what I wanted. > > I have to specify the key name

Re: [Dbix-class] searchable archive of the list?

* Carl Franks <[EMAIL PROTECTED]> [2006-06-08 16:15]: > You can also restrict google searches to directories within > sites with: > > site:http://lists.rawmode.org/pipermail/dbix-class/ No, `site:` doesn’t work like that. It only restricts to a domain. If you give it a full URI, it doesn’t find a

Re: [Dbix-class] InflateColumn::DateTime

I have a related issue, which actually started this question. I'm trying to copy column data from one row to another, or in Handel speak: from the Cart Item to the Order Item. If both the order item and cart item use the traditionl inflate_column/inflate/deflate, everything works just fine. If t

Re: [Dbix-class] searchable archive of the list?

Christopher H. Laco wrote: > A. Pagaltzis wrote: >> * John Napiorkowski <[EMAIL PROTECTED]> [2006-06-08 14:50]: >>> Does anyone know of a place where this list has a searchable >>> archive? I found it on google once, but I can't find it again >> You are joking, right? :-) >> >> Every single mail f

Re: [Dbix-class] searchable archive of the list?

On 08/06/06, A. Pagaltzis <[EMAIL PROTECTED]> wrote: > * Christopher H. Laco <[EMAIL PROTECTED]> [2006-06-08 15:45]: > > A. Pagaltzis wrote: > > > List-Archive: > > > > See term: "searchable". :-) > > mkdir dbix-class && cd dbix-class > li

Re: [Dbix-class] searchable archive of the list?

* Christopher H. Laco <[EMAIL PROTECTED]> [2006-06-08 15:45]: > A. Pagaltzis wrote: > > List-Archive: > > See term: "searchable". :-) mkdir dbix-class && cd dbix-class linkextor -f a::'\.gz$' http://lists.rawmode.org/pipermail/dbix-class

Re: [Dbix-class] searchable archive of the list?

A. Pagaltzis wrote: > * John Napiorkowski <[EMAIL PROTECTED]> [2006-06-08 14:50]: >> Does anyone know of a place where this list has a searchable >> archive? I found it on google once, but I can't find it again > > You are joking, right? :-) > > Every single mail from this list has the following

Re: [Dbix-class] searchable archive of the list?

* John Napiorkowski <[EMAIL PROTECTED]> [2006-06-08 14:50]: > Does anyone know of a place where this list has a searchable > archive? I found it on google once, but I can't find it again You are joking, right? :-) Every single mail from this list has the following header, along with all the othe

Re: [Dbix-class] searchable archive of the list?

http://www.gossamer-threads.com/ has searchable archives for Catalyst (which has been a total lifesaver for me) but didn't see one for DBIx. I know it's out there, but I can't recall the steps I took from google to find it. Oh well, I am sure it will turn up eventually. --jn --- Jess Robinson <

Re: [Dbix-class] searchable archive of the list?

for example: http://dir.gmane.org/gmane.comp.lang.perl.modules.dbix-class Jess Robinson wrote: > Try gossamer-threads (too lazy to actually find link ;) > > Jess > > On Thu, 8 Jun 2006, John Napiorkowski wrote: > >> Hey, >> >> Does anyone know of a place where this list has a >> searchable arch

Re: [Dbix-class] searchable archive of the list?

Try gossamer-threads (too lazy to actually find link ;) Jess On Thu, 8 Jun 2006, John Napiorkowski wrote: > Hey, > > Does anyone know of a place where this list has a > searchable archive? I found it on google once, but I > can't find it again and I am sure some of the > questions I want to as

[Dbix-class] searchable archive of the list?

Hey, Does anyone know of a place where this list has a searchable archive? I found it on google once, but I can't find it again and I am sure some of the questions I want to ask have been discussed before. --john __ Do You Yahoo!? Tired of spam?

Re: [Dbix-class] InflateColumn::DateTime

Mark Hedges wrote: > On Wed, 7 Jun 2006 [EMAIL PROTECTED] wrote: > >> From: [EMAIL PROTECTED] >> To: dbix-class@lists.rawmode.org >> Date: Wed, 07 Jun 2006 21:30:25 -0300 >> Subject: Re: [Dbix-class] InflateColumn::DateTime >> >> Hey Matt, >> >>> No it isn't, because it stops you being able to do

Re: [Dbix-class] InflateColumn::DateTime

[EMAIL PROTECTED] wrote: > Hey Matt, > >> No it isn't, because it stops you being able to do date math on your DB. >> >> One of the intentions of this feature is that once it's fully supported >> across all the databases we handle it'll make Epoch unnecessary. If the >> ::Epoch author's about on

Re: [Dbix-class] Is this the canonical way to do this?

Looks like I was having some sort of mental block the other night. I got the following to work properly: my $video_rs = $self->find({video_id=>$video_id}); return ( defined($video_rs) ? 1 : 0 ); and it did what I wanted. I have to specify the key name in find since my table has multiple primary

Re: [Dbix-class] Patch for Storage::DBI::deployment_statements / deploy

Thanks Daniel, I already fixed this in my branch, and I thought we did in trunk too.. ;) Jess On Wed, 7 Jun 2006, Daniel Koch wrote: > The attached patch fixes deployment_statements() when the sqlt_type is > different than the DBI driver (e.g. 'MySQL' vs 'mysql'). > > Thanks, > > Dan Koch > >

Re: [Dbix-class] possible bug in DBIC:ResultSet?

On Wed, 7 Jun 2006, Mark Hedges wrote: > >> On Tue, 6 Jun 2006, Mark Hedges wrote: >>> I didn't look closely. This is another entity that has a >>> timestamp DEFAULT CURRENT_TIMESTAMP() as a column of an MCPK. >>> >>> I tried adding >>> >>> __PACKAGE__->load_components(qw( PK::Auto Core )); >>