Fernan Aguero wrote:
> +----[ 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').
If you fancy having a go at writing some more examples for the Manual
that would have made this clear to you first time round, we'd be happy
to have them :)
_______________________________________________
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/
