[Dbix-class] Strict sequence primary key

[Robert Stockdale]

*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#t=
xn_do
*
*
*
*-Bob
*
On Wed, Jan 20, 2010 at 4:59 PM, Wes Cravens <wcravens at cortex-it.com> 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 unle=
ss
> 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/dbix-class@lists.scsys.co.uk
>



-- =

Bob Stockdale
robert.stockdale at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100120/06f=
ef29b/attachment.htm