<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><tt>Hi Carlos,</tt></p>
<p><tt>Unfortunately, this is not currently possible - the only
NoSQL backend that supports this is MongoDB, with its "find()"
raw query. Redis is close, but it can only fetch multiple values
of the same key, which is not what we want.</tt></p>
<p><tt>We should definitely add this feature to the 2.4 roadmap,
especially since the implementation seems straightforward.
cachedb_local could be extended with a minimalistic raw query
syntax to allow this. We could even add an optional regexp key
matching, for example:<br>
</tt></p>
<p><tt> cache_raw_query("local", "GET foo-.*-[0-9]{2}-bar",
"$avp(values)");<br>
cache_raw_query("local", "GET foo-.*-[0-9]{2}-bar",
"$avp(values)", "$avp(keys)");</tt><br>
<tt><tt> cache_raw_query("local", "GETALL", "$avp(values)");</tt></tt><br>
<tt><tt><tt> cache_raw_query("local", "GETALL", "$avp(values)",
"$avp(keys)");</tt></tt><br>
cache_raw_query("local", "GETALL foo-.*-[0-9]{2}-bar",
"$avp(values)");<br>
cache_raw_query("local", "GETALL foo-.*-[0-9]{2}-bar",
"$avp(values)", "$avp(keys)");<br>
</tt></p>
<p><tt>Would this suffice for your use case? Any feedback is good
feedback.<br>
</tt></p>
<p><tt>Cheers,</tt><br>
</p>
<pre class="moz-signature" cols="72">Liviu Chircu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 22.08.2017 00:09, Carlos Eduardo
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAB=EceaH9LfTWeuzvA__SRU-Mk0hav3JSb+oc46tQEhGvvybWw@mail.gmail.com">
<div dir="ltr">Hello everyone,
<div><br>
</div>
<div>Hoe can list all local cache on my script script, like is
done on redis using KEYS *? is that possible?</div>
<div><br>
</div>
<div>I'm using Opensips 1.11.</div>
<div><br>
</div>
<div>Best regards<br clear="all">
<div><br>
</div>
-- <br>
<div class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>
<div style="font-size:small"><b>Carlos E. Wagner</b></div>
<div style="font-size:small;font-family:arial"><font
style="font-family:arial,sans-serif;font-size:13px"><font
style="font-size:x-small;color:rgb(0,0,0)"><i>Tecnólogo
em Telecomunicações, OCP, dCAA</i></font><br>
<b style="font-family:arial;font-size:small"><font
color="#000000" face="arial, sans-serif"><br>
</font></b></font></div>
<div style="font-size:small;font-family:arial"><font
style="font-family:arial,sans-serif;font-size:13px"><b
style="font-family:arial;font-size:small"><font
color="#000000" face="arial, sans-serif">Gnotel
Telecom</font></b></font></div>
<div style="font-size:small;font-family:arial"><font
style="font-family:arial,sans-serif;font-size:13px"><b
style="font-family:arial;font-size:small"><font
face="arial, sans-serif">E-mail:</font></b><font
style="font-size:small" face="arial,
sans-serif"> <u><a
href="mailto:kaduww@gmail.com"
target="_blank" moz-do-not-send="true">kaduww@gmail.com</a></u></font></font></div>
<div style="font-size:small;font-family:arial"><font
style="font-family:arial,sans-serif;font-size:13px"><font
style="font-size:small" face="arial,
sans-serif"> <u><a
href="mailto:carlos@gnotel.com.br"
target="_blank" moz-do-not-send="true">carlos@gnotel.com.br</a></u></font></font></div>
<div style="font-size:small;font-family:arial"><font
style="font-family:arial,sans-serif;font-size:13px" color="#000000"><b>Fone:</b></font><font
face="arial, sans-serif"> +55 48 9981-0894</font><br>
<font
style="font-family:arial,sans-serif;font-size:13px"
color="#000000"><b>Skype:</b></font><font
face="arial, sans-serif"> </font><font
face="arial, sans-serif">carlos.e.wagner</font></div>
<div style="font-size:small;font-family:arial"><font
face="arial, sans-serif"><a
href="http://www.gnotel.com.br"
target="_blank" moz-do-not-send="true">www.gnotel.com.br</a></font></div>
<div style="font-size:small;font-family:arial"><font
face="arial, sans-serif"><a
href="http://www.blogdovoip.com"
target="_blank" moz-do-not-send="true">www.blogdovoip.com</a></font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>