[Dbix-class] Re: many-to-many with attributes (again)

2007-10-12 Thread A. Pagaltzis
* Pedro Melo <[EMAIL PROTECTED]> [2007-10-12 18:35]: > Personally, when I have attributes in a link table, I don't > see that table as a link table anymore... Its a normal > 1-to-many-to-1 relation and I treat it as such. Even when the attribute is nothing more than a `rank` column to order the li

[Dbix-class] Re: Why is prefetch so slow?

2007-10-12 Thread A. Pagaltzis
* Ash Berlin <[EMAIL PROTECTED]> [2007-10-12 14:15]: > Zero time was last years (or further back.) This year was > negative time. Or does that make it last year's was negative > time. Or maybe the year before that.. Negative time would have had been being this year’s talk if it were last year.

[Dbix-class] (no subject)

2007-09-13 Thread A. Pagaltzis
Hi all, so this just rolled by in my feed reader: * Assaf Arkin : > The one thing I don’t like about ORM is they hide bad SQL > better than politicians hide money. In theory they could get it > righ

[Dbix-class] Re: Sweeping generalisations

2007-09-13 Thread A. Pagaltzis
Uhm, that was actually meant to have a subject. Sorry. Regards, -- Aristotle Pagaltzis // ___ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/re

[Dbix-class] Re: SQL Generation with SQL::DB

2007-09-07 Thread A. Pagaltzis
* Emanuele Zeppieri <[EMAIL PROTECTED]> [2007-09-07 14:20]: > 1. If you have both &'s and |'s in your (full) expression, how > can you find the correct order to evaluate the various > subexpressions? How do you choose between [] and {} and put them in the right order when you build data structures

[Dbix-class] Re: [OT][ANNOUNCE] SQL Generation with SQL::DB

2007-09-07 Thread A. Pagaltzis
Hi Emanuele, * Emanuele Zeppieri <[EMAIL PROTECTED]> [2007-09-07 13:25]: > A. Pagaltzis wrote: > > >* Emanuele Zeppieri <[EMAIL PROTECTED]> [2007-09-07 11:15]: > >>Mark Lawrence wrote: > >>>If that is so, then you are asking how the following is

[Dbix-class] Re: [OT][ANNOUNCE] SQL Generation with SQL::DB

2007-09-07 Thread A. Pagaltzis
* Emanuele Zeppieri <[EMAIL PROTECTED]> [2007-09-07 11:15]: > Mark Lawrence wrote: > >If that is so, then you are asking how the following is > >evaluated? > > > >($track->length > 248) & ! ($cd->year < 1997) > > No, I'm asking how it could be *built* by code without string > concatenations/in

[Dbix-class] Re: unsure about table setup - ideas needed

2007-09-05 Thread A. Pagaltzis
* Mario Minati <[EMAIL PROTECTED]> [2007-08-26 00:15]: > Do I have to create two address tables? No. Just make FKs from the person and company tables into the address table, instead of the other way around. Regards, -- Aristotle Pagaltzis // __

[Dbix-class] Re: Easy update for has_many?

2007-09-05 Thread A. Pagaltzis
* Jason Kohles <[EMAIL PROTECTED]> [2007-08-22 16:35]: > There is probably a cleaner way, but this is how I'm doing it > at the moment... There certainly is. sub update_profiles { my ( $self, @profiles ) = @_; my %new_profile = map { ( $_, $_ ) } @profiles; # first ki

[Dbix-class] Re: [OT][ANNOUNCE] SQL Generation with SQL::DB

2007-09-05 Thread A. Pagaltzis
* Matt S Trout <[EMAIL PROTECTED]> [2007-09-05 21:11]: > What justification is there for re-inventing SQL::Abstract and > SQL::Translator rather than sending patches? Is it forseeable that SQLA will ever be capable of expressing any arbitrary SQL query whatsoever? Including way unusual things like

[Dbix-class] Re: OT: do not reply to start a new thread (was: Recovering from a failed transaction ?)

2007-08-08 Thread A. Pagaltzis
* Richard Robinson <[EMAIL PROTECTED]> [2007-08-08 13:32]: > [ Matt points out offlist that I messed up with the headers & > sent this as a reply in a different thread. Sorry, reposted] * A. Pagaltzis <[EMAIL PROTECTED]> [2007-08-08 14:42]: > could you please avoid starti

[Dbix-class] OT: do not reply to start a new thread (was: Recovering from a failed transaction ?)

2007-08-08 Thread A. Pagaltzis
Hi Richard, could you please avoid starting threads by replying to a mail? I know it’s convenient not to have to type the `To:` address, but good mail clients which can actually thread messages will then show your mail as part of a thread it has nothing to do with. Some people may even completely