<div dir="ltr">Since realm+key are a unique pair storing a single value you can't do it with mod_db. Anything build around fetching,editing,storing the value will be subject to race conditions if there are 2 concurrent calls accessing it.<div><br></div><div>You could implement this yourself using a custom transactional database and accessing it in Lua via freeswitch.Dbh. Begin a transaction, select the first UUID ordered by perhaps insertion uepoch, delete that uuid, commit, then use that uuid. Using SELECT FOR UPDATE will prevent another concurrent call getting the same uuid - the other will block until the commit at which point it's no longer in the table. That blocking should be fine because it's a very short transaction. Just insert another row to push a new uuid onto the stack.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 23 June 2016 at 15:35, David Ponzone <span dir="ltr"><<a href="mailto:david.ponzone@gmail.com" target="_blank">david.ponzone@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Guys,<div><br></div><div>I am searching for a way to stack UUID into a FIFO.</div><div>What I need is something like db insert/realm/key/${uuid} or hash insert/realm/key/${uuid} but that I need to keep several uuids with the same realm/key tuple.</div><div><br></div><div>The ideal would be:</div><div>I first insert realm/key/${uuid1}</div><div>then insert real/ley/{uuid2}</div><div><br></div><div>then if I do select/realm/key, it pops out ${uuid1)</div><div>I can then manually remove it, and the next select will pop out ${uuid2}</div><div><br></div><div>I don’t think it’s possible with hash/db, so does anyone a way/trick to achieve that ? </div><div><br></div><div>(the goal is to intercept several simultaneous incoming calls in the RINGING state)</div><div><br></div><div>Thank you</div><div><br><div>
<span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><div style="word-wrap:break-word"><div style="color:rgb(0,0,0)"><span style="color:rgb(0,34,243);font-family:'Helvetica Neue'"><font color="#1C00FF">David Ponzone<font face="Arial" size="2"><span> </span> </font></font></span><span style="color:rgb(0,34,243);font-family:'Helvetica Neue'"><font color="#000000">Direction Technique</font></span></div><div><div style="font-family:Arial;font-size:10px"><font face="'Helvetica Neue'"><font size="3"><span style="font-size:13px">email: <a href="mailto:david.ponzone@ipeva.fr" target="_blank">david.ponzone@ipeva.fr</a></span></font></font></div><div style="font-family:Arial;font-size:10px"><font face="'Helvetica Neue'"><font size="3"><span style="font-size:13px">tel: 01 74 03 18 97</span></font></font></div><div style="font-family:Arial;font-size:10px"><font face="'Helvetica Neue'"><font size="3"><span style="font-size:13px">gsm: 06 66 98 76 34</span></font></font></div><div style="color:rgb(0,34,243);font-family:Arial;font-size:10px"><font face="'Helvetica Neue'"><br></font></div><div style="color:rgb(0,34,243)"><font color="#1C00FF" face="'Helvetica Neue'">Service Client </font><font face="'Helvetica Neue'"><font color="#FF0000">IP</font></font><font color="#1C00FF" face="'Helvetica Neue'">eva</font></div><div style="color:rgb(0,34,243);font-family:Arial;font-size:10px"><font color="#1C00FF" face="'Helvetica Neue'"><span style="color:rgb(0,0,0);font-family:Helvetica"><div><font face="'Helvetica Neue'"><font size="3"><span style="font-size:13px">tel: 0811 46 26 26</span></font></font></div><div><font face="'Helvetica Neue'" size="3"><span style="font-size:13px"><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 10px/normal Arial;color:rgb(0,34,243)"><span style="text-decoration:underline"><a>www.ipeva.fr</a></span><span style="color:rgb(101,104,149)"> - <span style="color:rgb(0,34,243);text-decoration:underline"><a>www.ipeva-studio.com</a></span></span></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 10px/normal Arial;color:rgb(0,34,243)"><span style="text-decoration:underline"><br></span></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 10px/normal Arial;color:rgb(0,34,243)"><span><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;text-align:justify;font:normal normal normal 10px/normal Arial;color:rgb(192,192,192)"><i>Ce message et toutes les pièces jointes sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisée est interdite. Tout message électronique est susceptible d'altération. </i><b><i>IPeva</i></b><i> décline toute responsabilité au titre de ce message s'il a été altéré, déformé ou falsifié. Si vous n'êtes pas destinataire de ce message, merci de le détruire immédiatement et d'avertir l'expéditeur.</i></div><div><i><br></i></div></span></div></span></font></div></span></font></div></div></div></span><br></span><br>
</div>
<br></div></div><br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div>