[Dbix-class] Multiple self-selects against a table

[Zbigniew Lukasiak]

Hi,

Have a look at:
http://search.cpan.org/~jrobinson/DBIx-Class-0.07005/lib/DBIx/Class/ResultSet.pm#join

Particularily look at "If the same join is supplied twice, it will be
aliased to <rel>_2 (and similarly for a third time)." - this explains
how to join the same table multiple times.

--
Zbyszek

On 2/26/07, Michael Henson <mhenson at silverthorneinc.com> wrote:
> Hello,
>
> I am working with code that dynamically generates a query like:
>
> SELECT DISTINCT aa.product_id AS id
> FROM product_variant_options aa,
>      product_variant_option ab,
>      product_variant_options ac
> WHERE
>  (aa.option_set_id = ? AND aa.option_id = ? AND aa.variant_of = ?)
>  AND (ab.option_set_id = ? AND ab.option_id = ? AND ab.variant_of = ?)
>  AND (ac.option_set_id = ? AND ac.option_id = ? AND ac.variant_of = ?)
>  AND aa.product_id = ab.product_id
>  AND aa.product_id = ac.product_id
>
> The dynamic part is that the number of (option_set_id, option_id) pairs
> we need to use as select criteria is unknown - at least one pair, but
> limited only by the highest number of options actually associated with a
> product in the db.
>
> Is there a clean DBIx-ish way of doing this, or is building the query
> string manually the only way at the moment?
>
> Thanks,
> Michael Henson
> mhenson at silverthorneinc.com
>
>
>
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>


-- 
Zbigniew Lukasiak
http://brudnopis.blogspot.com/