On Thu, 23 Mar 2006, Jess Robinson wrote: > > I just spent several minutes writing a DBIx::Class schema to handle this, > and now it's occured to me that we haven't seen what you've tried.. > > It certainly doesn't look hard at all, so I have a suspicion that you just > got your relationships mixed up, can you show the code you tried? > > Also, whats a product_id? It seems to just exist in vendor_product's > imagination.. and sale_item has one as well, but I have no idea where they > are pointing. > > .. Anyway, to get a vendor_name from a sale_item, you need to do something > like: > > DB::Schema::SaleItem->belongs_to(sale_id => 'DB::Schema::Sale'); > DB::Schema::Sale->belongs_to(vendor_name => 'DB::Schema::Vendor'); > > then from a $saleitem: > > $saleitem->sale_id->vendor_name > > will get you a vendor object > > (You can name the relationships however you like)
A vendor_product's product_id is the product_id at the remote vendor for one of our products that we might be selling there. We might sell the same product in multiple ways/prices with one vendor. product_id is arbitrary, it comes from the vendor, but for every vendor_product, the MCPK of (vendor_name, product_id) will be unique and defines what it is. Your example is obvious, but not what I am trying to do. I want to go from a sale_item to the vendor_product that was sold. I can't without writing a subroutine for a sale_item to get the vendor_name from the parent sale, then look up the vendor_product from that vendor_name and its product_id. Mark _______________________________________________ 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/
