Hello,
I have am working on one real time auction application where user used to
enter new bid based on previous minimum bid value. There is possibility
that two user will get same minimum value for their next bid. So I would
like to restrict second user on select statement if already first user has
fired select statement and waiting for insert statement to complete.
So could any one can guide me how to deal with such condition in
DBIx::Class. I have tried
eg.
$schema->storage->txn_begin();
my $res = $schema->resultset('Test')->search($filter,
{for=>'update'})->first();
$schema->resultset('Test')->create($params);
$schema->storage->txn_commit();
Thanks,
Hardik Joshi
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
