*I'm not sure about how to lock the table, but you should be able to accomplish the rest of the transaction using the txn_do method:* * * * http://search.cpan.org/~frew/DBIx-Class-0.08115/lib/DBIx/Class/Storage.pm#txn_do * * * *-Bob * On Wed, Jan 20, 2010 at 4:59 PM, Wes Cravens <[email protected]> wrote:
> In an effort to create strictly sequential (Incrementing Integer no gaps) > primary keys my method has traditionally been: > > BEGIN; > LOCK table; > SELECT MAX(id) FROM table; > INSERT INTO table...; > COMMIT; > > I'm relatively new to DBIC and have not really seen a way to do this unless > I create a wrapper to handle it. > > Is there something I am missing? > > Thanks, > > Wes > > _______________________________________________ > 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] > -- Bob Stockdale [email protected]
_______________________________________________ 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]
