Mailing List Archive: Zope: Users

Getting Auto Increment value

Index | Next | Previous | View Threaded

Merav.B at puresight

Jun 11, 2009, 5:36 AM

Post #1 of 4 (1407 views)
Permalink

Getting Auto Increment value

I am working with zope & mysql.

I have a table with SERIAL column type, I create "z-sql method" for insert operation, how can I get the value for the auto increment column?

I know that in mysql I can call last_insert_id(), šhow do I call it, should I create another "z sql method" and if I do,š how can I be sure the the value return is for my insert command and not for another. Is there a way to call 2 query from the same "z sql method"?

I am really lost on this, any help will be wellcom.

Thank in advanced.

lists at zopyx

Jun 11, 2009, 5:50 AM

Post #2 of 4 (1323 views)
Permalink

Re: Getting Auto Increment value [In reply to]

On 11.06.09 14:36, Merav Ben-David wrote:
>
>
>
> I am working with zope & mysql.
>
> I have a table with SERIAL column type, I create â€śz-sql methodâ€ť for
> insert operation, how can I get the value for the auto increment column?
>
> I know that in mysql I can call last_insert_id(), how do I call it,
> should I create another â€śz sql methodâ€ť and if I do, how can I be sure
> the the value return is for my insert command and not for another. Is
> there a way to call 2 query from the same â€śz sql methodâ€ť?
>
>
>
> I am really lost on this, any help will be wellcom.
>
> Thank in advanced.
>

You should be able to write two ZSQL methods and wrap them into a
PythonScript. So you call the PythonScript
instead of the ZSQL method(s) directly. In addition there is a
sql-delimiter tag in DTML afaik - possibly
undocumented. I would go for the PythonScript + 2 ZSQL methods approach.

-aj

Attachments:

lists.vcf (0.32 KB)

robert at redcor

Jun 11, 2009, 6:18 AM

Post #3 of 4 (1324 views)
Permalink

Re: Getting Auto Increment value [In reply to]

to my knowledge SELECT LAST_INSERT_ID();
is per connection.
so if you do the call in the same request in which you did the the creation of
the record, you should be fine
robert
Merav Ben-David schrieb:
>
>
>
>
> I am working with zope & mysql.
>
> I have a table with SERIAL column type, I create "z-sql method" for
> insert operation, how can I get the value for the auto increment column?
>
> I know that in mysql I can call last_insert_id(), how do I call it,
> should I create another "z sql method" and if I do, how can I be sure
> the the value return is for my insert command and not for another. Is
> there a way to call 2 query from the same "z sql method"?
>
>
>
> I am really lost on this, any help will be wellcom.
>
> Thank in advanced.
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Zope maillist - Zope [at] zope
> http://mail.zope.org/mailman/listinfo/zope
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://mail.zope.org/mailman/listinfo/zope-announce
> http://mail.zope.org/mailman/listinfo/zope-dev )

_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

bennetttm at appstate

Jun 11, 2009, 6:25 AM

Post #4 of 4 (1323 views)
Permalink

Re: Getting Auto Increment value [In reply to]

I am suspecting that serial in MySQL works like serial in PostgreSQL in which
a sequence is automatically created. If so, you should be able to query the
last_value field in the sequence without having to call the function. The field
name might be different in MySQL, I don't know. This will give you the last
value inserted and if you need the next just add 1.

Also, if it is an auto increment column and again if it is like PostgreSQL
then all you have to do is use the word 'default' without quotes and it "auto
increments" the value for the new insert. See if there is a default for your
serial field.

Thomas

On Thursday 11 June 2009 08:36:21 Merav Ben-David wrote:
> I am working with zope & mysql.
>
> I have a table with SERIAL column type, I create "z-sql method" for insert
> operation, how can I get the value for the auto increment column?
>
> I know that in mysql I can call last_insert_id(), how do I call it, should
> I create another "z sql method" and if I do, how can I be sure the the
> value return is for my insert command and not for another. Is there a way
> to call 2 query from the same "z sql method"?
>
>
>
> I am really lost on this, any help will be wellcom.
>
> Thank in advanced.

--
Normally I'm against big things,
I think the world is going to be saved by millions of small things.
Too many things can go wrong when they get big.
- Pete Seeger at his 90th birthday party Sunday May 3, 2009

==========================================
Thomas McMillan Grant Bennett Appalachian State University
Operations & Systems Analyst P O Box 32026
University Library Boone, North Carolina 28608
(828) 262 6587

Library Systems Help Desk: https://www.library.appstate.edu/help/
==========================================
_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads