+----[ Matt S Trout <[EMAIL PROTECTED]> (23.May.2006 15:55):
|
[ snipped ]
| >my $userHashRef = {
| > user_id => $user_id,
| > username => $username,
| > firstname => $firstname,
| > ... };
| >
| >my $dbix = MyApp::DB->connect( 'dbi:mysql:dbname=... );
| >
| >my $resultSetObj = $dbix->resultset('Users')->search( $userHashRef );
| >
| >$resultSetObj->update_or_create;
[snipped]
| >When running the script I stepped into this:
| >DBIx::Class::ResultSet::update_or_create(): Error executing
| >'INSERT INTO users (firstname, ..., user_id, username)
| >VALUES (?, ?, ...) ('Fernan', ..., '1', 'fernan'):
| >DBD::mysql::st execute failed: Duplicate entry '1' for key 1
| >at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/Class/Storage/DBI.pm
| >line 525.
| >
| >Why is it trying to INSERT when it should have UPDATED the
| >row?
[ snipped ]
| my $user = $dbix->resultset('Users')->update_or_create($hashref);
|
| :)
|
+----]
Thanks Matt. That did it.
Now that I read the docs again, the description of
update_or_create in ResultSet clearly says that it will
'search first ...' (I even quoted it in my previous
message!) but on first read this implicit search was not
obvious to me.
For some reason, my head insisted on trying to impose the
logic of the process (which in my head was 'search' first
and then 'update_or_create').
Thanks again,
Fernan
_______________________________________________
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/
