Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Update all dbix related rows?

by uG (Scribe)
on Mar 29, 2010 at 23:24 UTC ( #831733=perlquestion: print w/replies, xml ) Need Help??
uG has asked for the wisdom of the Perl Monks concerning the following question:

I have two dbix::class schemas who have a has_many and belongs_to relationship. Lets sat A has_many B and B belongs_to A. How do I update B, as well as the A row that it belongs to with just one update statement?

Replies are listed 'Best First'.
Re: Update all dbix related rows?
by snopal (Pilgrim) on Mar 30, 2010 at 13:39 UTC

    You should use a transaction, not a single insert.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://831733]
Approved by planetscape
help
Chatterbox?
[Eily]: and since his name is a modified version of astérisque (asterisk), which is a typographical symbol, I think it's even funnier that he would lose a diacritic
[Eily]: the pun doesn't work so well with "he lost a diacritic" though :P
[LanX]: Obelix might offer to find it again ...
[LanX]: not much to translate anyway since Goscinny died
[Eily]: https://en. wikipedia.org/ wiki/List_of_Aster ix_characters some of the names were changed to include a new pun
[LanX]: sure some are even funnier now
[LanX]: some lost because they were not translated like Epidemais
[LanX]: some of the english names are funny too

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (13)
As of 2017-05-24 15:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?