X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FManual%2FIntro.pod;h=8e4b7fdb3b88df561ab41066a8ca0409262536db;hb=d6988be8c653765a1a5dcf988a2e539029584450;hp=2728c5aeb20bced650a02fd5d6a62982f4717af1;hpb=89597fedbda8d4ec01748f4fddc27ccfae6f3a30;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Manual/Intro.pod b/lib/DBIx/Class/Manual/Intro.pod index 2728c5a..8e4b7fd 100644 --- a/lib/DBIx/Class/Manual/Intro.pod +++ b/lib/DBIx/Class/Manual/Intro.pod @@ -403,24 +403,23 @@ The concept of a L in DBIx::Class warrants special discussion. The formal definition (which somewhat resembles that of a classic RDBMS) is I. However this is where the -similarity ends. While in a RDBMS you can safely change any column within a -row, you can not do the same in DBIC because B object and a specific row in your -database>. Any time you call a CRUD operation on a row (e.g. +similarity ends. Any time you call a CRUD operation on a row (e.g. L, L, L, -etc.) DBIx::Class will use the B of the +etc.) DBIx::Class will use the values of of the L columns to populate -the C clause necessary to accomplish the operation. - -This is why it is important to declare a -L on all your result -sources B. In a pinch one can -always declare each row identifiable by all its columns: +the C clause necessary to accomplish the operation. This is why it is +important to declare a L +on all your result sources B. +In a pinch one can always declare each row identifiable by all its columns: __PACKAGE__->set_primary_keys (__PACKAGE__->columns); +Note that DBIx::Class is smart enough to store a copy of the PK values before +any row-object changes take place, so even if you change the values of PK +columns the C clause will remain correct. + If you elect not to declare a C, DBIx::Class will behave correctly by throwing exceptions on any row operation that relies on unique identifiable rows. If you inherited datasets with multiple identical rows in them, you can @@ -430,18 +429,20 @@ L, L, L -For example, the following would not work: +For example, the following would not work (assuming C does not have +a declared PK): my $row = $schema->resultset('People') - ->search({ last_name => 'Dantes' }) - ->next; + ->search({ last_name => 'Dantes' }) + ->next; $row->update({ children => 2 }); # <-- exception thrown because $row isn't # necessarily unique So instead the following should be done: - $schema->resultset('People')->search({ last_name => 'Dantes' }) - ->update({ children => 2 }); # <-- update's ALL Dantes to have children of 2 + $schema->resultset('People') + ->search({ last_name => 'Dantes' }) + ->update({ children => 2 }); # <-- update's ALL Dantes to have children of 2 =head2 Problems on RHEL5/CentOS5