[Freeswitch-users] dbh:query - insert id

[John M]

Hi Nathan,

Yes, generally the current connection can make a select query and get the last inserted id and return that.

It's possible, as suggested by Daniel earlier that doing a subsequent query for 'select last_insert_id()' may be the best way but that will be assuming the db connection doesn't refresh as that could potentially return the last inserted id of a concurrent channel.

For me, I have implemented a solution where I have an extra column where I insert the channel uuid along with the data I insert as well. Then I make a select query to the db collecting the id where the uuid matches the current channel uuid and order by uuid desc.

My expectation/hope is that I won't get 2 uuid's generated by freeswitch within a few seconds and should be able to rely on the id coming back as being the last inserted id for the insert query I had just made.

Cheers,
-Jm

 

 

 

-----Original Message-----
From: Nathan Neulinger <nneul at mst.edu>
To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
Sent: Sun, May 26, 2013 1:35 am
Subject: Re: [Freeswitch-users] dbh:query - insert id


Looking at the code, I'm not seeing anything that would do this. Affected rows 
is directly implemented as part of ODBC, 
that's why it's easily available.


You could probably do a subsequent select on last_insert_id(), but there is a 
high risk of race condition - some other 
thread could use the dbh driver in the intervening time.

I don't believe that the last insert id is returned automatically on any of the 
mysql api (underlying calls not FS) 
calls, and then you have the odbc layer on top of that.

The way I've seen some other packages do it is to implement a mysql specific sql 
execute call that runs the statement, 
and then immediately runs a select last_insert_id() and returns it.

-- Nathan

On 05/25/2013 10:01 AM, Lloyd Aloysius wrote:
> William,
>
> Thank you for the reply. Question was related to freeswitch dbh driver. Not 
related to sql specific.
>
> Most of the SQL Driver have a method to get the id after the insert record. My 
questions was does freeswitch dbh have
> any method to get the id?
>
> For Example dbh have a method dbh:affected_rows() for insert , update.
>
> Like this do we have a method for ID?
>
> Thanks
> Lloyd
> *
-- 
------------------------------------------------------------
Nathan Neulinger                       nneul at mst.edu
Missouri S&T Information Technology    (573) 612-1412
System Administrator - Architect

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org
http://www.freeswitchsolutions.com




Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130525/39e9f054/attachment.html