Mon Mar 19 11:30:27 2012

Asterisk developer's documentation


func_realtime.c

Go to the documentation of this file.
00001 /*
00002  * Asterisk -- An open source telephony toolkit.
00003  *
00004  * Copyright (C) 2005-2006, BJ Weschke. All rights reserved.
00005  * 
00006  * BJ Weschke <bweschke@btwtech.com>
00007  * 
00008  * This code is released by the author with no restrictions on usage. 
00009  *
00010  * See http://www.asterisk.org for more information about
00011  * the Asterisk project. Please do not directly contact
00012  * any of the maintainers of this project for assistance;
00013  * the project provides a web site, mailing lists and IRC
00014  * channels for your use.
00015  *
00016  */
00017 
00018 /*** MODULEINFO
00019    <support_level>core</support_level>
00020  ***/
00021 
00022 /*! \file
00023  *
00024  * \brief REALTIME dialplan function
00025  * 
00026  * \author BJ Weschke <bweschke@btwtech.com>
00027  * 
00028  * \ingroup functions
00029  */
00030 
00031 #include "asterisk.h"
00032 
00033 ASTERISK_FILE_VERSION(__FILE__, "$Revision: 340863 $")
00034 
00035 #include "asterisk/file.h"
00036 #include "asterisk/channel.h"
00037 #include "asterisk/pbx.h"
00038 #include "asterisk/config.h"
00039 #include "asterisk/module.h"
00040 #include "asterisk/lock.h"
00041 #include "asterisk/utils.h"
00042 #include "asterisk/app.h"
00043 
00044 /*** DOCUMENTATION
00045    <function name="REALTIME" language="en_US">
00046       <synopsis>
00047          RealTime Read/Write Functions.
00048       </synopsis>
00049       <syntax>
00050          <parameter name="family" required="true" />
00051          <parameter name="fieldmatch" required="true" />
00052          <parameter name="value" />
00053          <parameter name="delim1|field">
00054             <para>Use <replaceable>delim1</replaceable> with <replaceable>delim2</replaceable> on
00055             read and <replaceable>field</replaceable> without <replaceable>delim2</replaceable> on
00056             write</para>
00057             <para>If we are reading and <replaceable>delim1</replaceable> is not specified, defaults
00058             to <literal>,</literal></para>
00059          </parameter>
00060          <parameter name="delim2">
00061             <para>Parameter only used when reading, if not specified defaults to <literal>=</literal></para>
00062          </parameter>
00063       </syntax>
00064       <description>
00065          <para>This function will read or write values from/to a RealTime repository.
00066          REALTIME(....) will read names/values from the repository, and 
00067          REALTIME(....)= will write a new value/field to the repository. On a
00068          read, this function returns a delimited text string. The name/value
00069          pairs are delimited by <replaceable>delim1</replaceable>, and the name and value are delimited
00070          between each other with delim2. 
00071          If there is no match, NULL will be returned by the function.
00072          On a write, this function will always return NULL.</para>
00073       </description>
00074       <see-also>
00075          <ref type="function">REALTIME_STORE</ref>
00076          <ref type="function">REALTIME_DESTROY</ref>
00077          <ref type="function">REALTIME_FIELD</ref>
00078          <ref type="function">REALTIME_HASH</ref>
00079       </see-also>
00080    </function>
00081    <function name="REALTIME_STORE" language="en_US">
00082       <synopsis>
00083          RealTime Store Function.
00084       </synopsis>
00085       <syntax>
00086          <parameter name="family" required="true" />
00087          <parameter name="field1" required="true" />
00088          <parameter name="fieldN" required="true" multiple="true" />
00089          <parameter name="field30" required="true" />
00090       </syntax>
00091       <description>
00092          <para>This function will insert a new set of values into the RealTime repository.
00093          If RT engine provides an unique ID of the stored record, REALTIME_STORE(...)=..
00094          creates channel variable named RTSTOREID, which contains value of unique ID.
00095          Currently, a maximum of 30 field/value pairs is supported.</para>
00096       </description>
00097       <see-also>
00098          <ref type="function">REALTIME</ref>
00099          <ref type="function">REALTIME_DESTROY</ref>
00100          <ref type="function">REALTIME_FIELD</ref>
00101          <ref type="function">REALTIME_HASH</ref>
00102       </see-also>
00103    </function>
00104    <function name="REALTIME_DESTROY" language="en_US">
00105       <synopsis>
00106          RealTime Destroy Function.
00107       </synopsis>
00108       <syntax>
00109          <parameter name="family" required="true" />
00110          <parameter name="fieldmatch" required="true" />
00111          <parameter name="value" />
00112          <parameter name="delim1" />
00113          <parameter name="delim2" />
00114       </syntax>
00115       <description>
00116          <para>This function acts in the same way as REALTIME(....) does, except that
00117          it destroys the matched record in the RT engine.</para>
00118       </description>
00119       <see-also>
00120          <ref type="function">REALTIME</ref>
00121          <ref type="function">REALTIME_STORE</ref>
00122          <ref type="function">REALTIME_FIELD</ref>
00123          <ref type="function">REALTIME_HASH</ref>
00124       </see-also>
00125    </function>
00126    <function name="REALTIME_FIELD" language="en_US">
00127       <synopsis>
00128          RealTime query function.
00129       </synopsis>
00130       <syntax>
00131          <parameter name="family" required="true" />
00132          <parameter name="fieldmatch" required="true" />
00133          <parameter name="value" required="true" />
00134          <parameter name="fieldname" required="true" />
00135       </syntax>
00136       <description>
00137          <para>This function retrieves a single item, <replaceable>fieldname</replaceable>
00138          from the RT engine, where <replaceable>fieldmatch</replaceable> contains the value
00139          <replaceable>value</replaceable>.  When written to, the REALTIME_FIELD() function
00140          performs identically to the REALTIME() function.</para>
00141       </description>
00142       <see-also>
00143          <ref type="function">REALTIME</ref>
00144          <ref type="function">REALTIME_STORE</ref>
00145          <ref type="function">REALTIME_DESTROY</ref>
00146          <ref type="function">REALTIME_HASH</ref>
00147       </see-also>
00148    </function>
00149    <function name="REALTIME_HASH" language="en_US">
00150       <synopsis>
00151          RealTime query function.
00152       </synopsis>
00153       <syntax>
00154          <parameter name="family" required="true" />
00155          <parameter name="fieldmatch" required="true" />
00156          <parameter name="value" required="true" />
00157       </syntax>
00158       <description>
00159          <para>This function retrieves a single record from the RT engine, where
00160          <replaceable>fieldmatch</replaceable> contains the value
00161          <replaceable>value</replaceable> and formats the output suitably, such that
00162          it can be assigned to the HASH() function.  The HASH() function then provides
00163          a suitable method for retrieving each field value of the record.</para>
00164       </description>
00165       <see-also>
00166          <ref type="function">REALTIME</ref>
00167          <ref type="function">REALTIME_STORE</ref>
00168          <ref type="function">REALTIME_DESTROY</ref>
00169          <ref type="function">REALTIME_FIELD</ref>
00170       </see-also>
00171    </function>
00172  ***/
00173 
00174 AST_THREADSTORAGE(buf1);
00175 AST_THREADSTORAGE(buf2);
00176 AST_THREADSTORAGE(buf3);
00177 
00178 static int function_realtime_read(struct ast_channel *chan, const char *cmd, char *data, char *buf, size_t len) 
00179 {
00180    struct ast_variable *var, *head;
00181    struct ast_str *out;
00182    size_t resultslen;
00183    int n;
00184    AST_DECLARE_APP_ARGS(args,
00185       AST_APP_ARG(family);
00186       AST_APP_ARG(fieldmatch);
00187       AST_APP_ARG(value);
00188       AST_APP_ARG(delim1);
00189       AST_APP_ARG(delim2);
00190    );
00191 
00192    if (ast_strlen_zero(data)) {
00193       ast_log(LOG_WARNING, "Syntax: REALTIME(family,fieldmatch[,value[,delim1[,delim2]]]) - missing argument!\n");
00194       return -1;
00195    }
00196 
00197    AST_STANDARD_APP_ARGS(args, data);
00198 
00199    if (!args.delim1)
00200       args.delim1 = ",";
00201    if (!args.delim2)
00202       args.delim2 = "=";
00203 
00204    if (chan)
00205       ast_autoservice_start(chan);
00206 
00207    head = ast_load_realtime_all(args.family, args.fieldmatch, args.value, SENTINEL);
00208 
00209    if (!head) {
00210       if (chan)
00211          ast_autoservice_stop(chan);
00212       return -1;
00213    }
00214 
00215    resultslen = 0;
00216    n = 0;
00217    for (var = head; var; n++, var = var->next)
00218       resultslen += strlen(var->name) + strlen(var->value);
00219    /* add space for delimiters and final '\0' */
00220    resultslen += n * (strlen(args.delim1) + strlen(args.delim2)) + 1;
00221 
00222    out = ast_str_alloca(resultslen);
00223    for (var = head; var; var = var->next)
00224       ast_str_append(&out, 0, "%s%s%s%s", var->name, args.delim2, var->value, args.delim1);
00225    ast_copy_string(buf, ast_str_buffer(out), len);
00226 
00227    ast_variables_destroy(head);
00228 
00229    if (chan)
00230       ast_autoservice_stop(chan);
00231 
00232    return 0;
00233 }
00234 
00235 static int function_realtime_write(struct ast_channel *chan, const char *cmd, char *data, const char *value)
00236 {
00237    int res = 0;
00238    AST_DECLARE_APP_ARGS(args,
00239       AST_APP_ARG(family);
00240       AST_APP_ARG(fieldmatch);
00241       AST_APP_ARG(value);
00242       AST_APP_ARG(field);
00243    );
00244 
00245    if (ast_strlen_zero(data)) {
00246       ast_log(LOG_WARNING, "Syntax: %s(family,fieldmatch,value,newcol) - missing argument!\n", cmd);
00247       return -1;
00248    }
00249 
00250    if (chan)
00251       ast_autoservice_start(chan);
00252 
00253    AST_STANDARD_APP_ARGS(args, data);
00254 
00255    res = ast_update_realtime(args.family, args.fieldmatch, args.value, args.field, (char *)value, SENTINEL);
00256 
00257    if (res < 0) {
00258       ast_log(LOG_WARNING, "Failed to update. Check the debug log for possible data repository related entries.\n");
00259    }
00260 
00261    if (chan)
00262       ast_autoservice_stop(chan);
00263 
00264    return 0;
00265 }
00266 
00267 static int realtimefield_read(struct ast_channel *chan, const char *cmd, char *data, char *buf, size_t len) 
00268 {
00269    struct ast_variable *var, *head;
00270    struct ast_str *escapebuf = ast_str_thread_get(&buf1, 16);
00271    struct ast_str *fields = ast_str_thread_get(&buf2, 16);
00272    struct ast_str *values = ast_str_thread_get(&buf3, 16);
00273    int first = 0;
00274    enum { rtfield, rthash } which;
00275    AST_DECLARE_APP_ARGS(args,
00276       AST_APP_ARG(family);
00277       AST_APP_ARG(fieldmatch);
00278       AST_APP_ARG(value);
00279       AST_APP_ARG(fieldname);
00280    );
00281 
00282    if (!strcmp(cmd, "REALTIME_FIELD")) {
00283       which = rtfield;
00284    } else {
00285       which = rthash;
00286    }
00287 
00288    if (ast_strlen_zero(data)) {
00289       ast_log(LOG_WARNING, "Syntax: %s(family,fieldmatch,value%s) - missing argument!\n", cmd, which == rtfield ? ",fieldname" : "");
00290       return -1;
00291    }
00292 
00293    AST_STANDARD_APP_ARGS(args, data);
00294 
00295    if ((which == rtfield && args.argc != 4) || (which == rthash && args.argc != 3)) {
00296       ast_log(LOG_WARNING, "Syntax: %s(family,fieldmatch,value%s) - missing argument!\n", cmd, which == rtfield ? ",fieldname" : "");
00297       return -1;
00298    }
00299 
00300    if (chan) {
00301       ast_autoservice_start(chan);
00302    }
00303 
00304    if (!(head = ast_load_realtime_all(args.family, args.fieldmatch, args.value, SENTINEL))) {
00305       if (chan) {
00306          ast_autoservice_stop(chan);
00307       }
00308       return -1;
00309    }
00310 
00311    ast_str_reset(fields);
00312    ast_str_reset(values);
00313 
00314    for (var = head; var; var = var->next) {
00315       if (which == rtfield) {
00316          ast_debug(1, "Comparing %s to %s\n", var->name, args.fieldname);
00317          if (!strcasecmp(var->name, args.fieldname)) {
00318             ast_debug(1, "Match! Value is %s\n", var->value);
00319             ast_copy_string(buf, var->value, len);
00320             break;
00321          }
00322       } else if (which == rthash) {
00323          ast_debug(1, "Setting hash key %s to value %s\n", var->name, var->value);
00324          ast_str_append(&fields, 0, "%s%s", first ? "" : ",", ast_str_set_escapecommas(&escapebuf, 0, var->name, INT_MAX));
00325          ast_str_append(&values, 0, "%s%s", first ? "" : ",", ast_str_set_escapecommas(&escapebuf, 0, var->value, INT_MAX));
00326          first = 0;
00327       }
00328    }
00329    ast_variables_destroy(head);
00330 
00331    if (which == rthash) {
00332       pbx_builtin_setvar_helper(chan, "~ODBCFIELDS~", ast_str_buffer(fields));
00333       ast_copy_string(buf, ast_str_buffer(values), len);
00334    }
00335 
00336    if (chan) {
00337       ast_autoservice_stop(chan);
00338    }
00339 
00340    return 0;
00341 }
00342 
00343 static int function_realtime_store(struct ast_channel *chan, const char *cmd, char *data, const char *value)
00344 {
00345    int res = 0;
00346    char storeid[32];
00347    char *valcopy;
00348    AST_DECLARE_APP_ARGS(a,
00349       AST_APP_ARG(family);
00350       AST_APP_ARG(f)[30]; /* fields */
00351    );
00352 
00353    AST_DECLARE_APP_ARGS(v,
00354       AST_APP_ARG(v)[30]; /* values */
00355    );
00356 
00357    if (ast_strlen_zero(data)) {
00358       ast_log(LOG_WARNING, "Syntax: REALTIME_STORE(family,field1,field2,...,field30) - missing argument!\n");
00359       return -1;
00360    }
00361 
00362    if (chan)
00363       ast_autoservice_start(chan);
00364 
00365    valcopy = ast_strdupa(value);
00366    AST_STANDARD_APP_ARGS(a, data);
00367    AST_STANDARD_APP_ARGS(v, valcopy);
00368 
00369    res = ast_store_realtime(a.family, 
00370       a.f[0], v.v[0], a.f[1], v.v[1], a.f[2], v.v[2], a.f[3], v.v[3], a.f[4], v.v[4],
00371       a.f[5], v.v[5], a.f[6], v.v[6], a.f[7], v.v[7], a.f[8], v.v[8], a.f[9], v.v[9],
00372       a.f[10], v.v[10], a.f[11], v.v[11], a.f[12], v.v[12], a.f[13], v.v[13], a.f[14], v.v[14],
00373       a.f[15], v.v[15], a.f[16], v.v[16], a.f[17], v.v[17], a.f[18], v.v[18], a.f[19], v.v[19],
00374       a.f[20], v.v[20], a.f[21], v.v[21], a.f[22], v.v[22], a.f[23], v.v[23], a.f[24], v.v[24],
00375       a.f[25], v.v[25], a.f[26], v.v[26], a.f[27], v.v[27], a.f[28], v.v[28], a.f[29], v.v[29], SENTINEL
00376    );
00377 
00378    if (res < 0) {
00379       ast_log(LOG_WARNING, "Failed to store. Check the debug log for possible data repository related entries.\n");
00380    } else {
00381       snprintf(storeid, sizeof(storeid), "%d", res);
00382       pbx_builtin_setvar_helper(chan, "RTSTOREID", storeid);
00383    }
00384 
00385    if (chan)
00386       ast_autoservice_stop(chan);
00387 
00388    return 0;
00389 }
00390 
00391 static int function_realtime_readdestroy(struct ast_channel *chan, const char *cmd, char *data, char *buf, size_t len) 
00392 {
00393    struct ast_variable *var, *head;
00394    struct ast_str *out;
00395    size_t resultslen;
00396    int n;
00397    AST_DECLARE_APP_ARGS(args,
00398       AST_APP_ARG(family);
00399       AST_APP_ARG(fieldmatch);
00400       AST_APP_ARG(value);
00401       AST_APP_ARG(delim1);
00402       AST_APP_ARG(delim2);
00403    );
00404 
00405    if (ast_strlen_zero(data)) {
00406       ast_log(LOG_WARNING, "Syntax: REALTIME_DESTROY(family,fieldmatch[,value[,delim1[,delim2]]]) - missing argument!\n");
00407       return -1;
00408    }
00409 
00410    AST_STANDARD_APP_ARGS(args, data);
00411 
00412    if (!args.delim1)
00413       args.delim1 = ",";
00414    if (!args.delim2)
00415       args.delim2 = "=";
00416 
00417    if (chan)
00418       ast_autoservice_start(chan);
00419 
00420    head = ast_load_realtime_all(args.family, args.fieldmatch, args.value, SENTINEL);
00421 
00422    if (!head) {
00423       if (chan)
00424          ast_autoservice_stop(chan);
00425       return -1;
00426    }
00427 
00428    resultslen = 0;
00429    n = 0;
00430    for (var = head; var; n++, var = var->next)
00431       resultslen += strlen(var->name) + strlen(var->value);
00432    /* add space for delimiters and final '\0' */
00433    resultslen += n * (strlen(args.delim1) + strlen(args.delim2)) + 1;
00434 
00435    out = ast_str_alloca(resultslen);
00436    for (var = head; var; var = var->next) {
00437       ast_str_append(&out, 0, "%s%s%s%s", var->name, args.delim2, var->value, args.delim1);
00438    }
00439    ast_copy_string(buf, ast_str_buffer(out), len);
00440 
00441    ast_destroy_realtime(args.family, args.fieldmatch, args.value, SENTINEL);
00442    ast_variables_destroy(head);
00443 
00444    if (chan)
00445       ast_autoservice_stop(chan);
00446 
00447    return 0;
00448 }
00449 
00450 static struct ast_custom_function realtime_function = {
00451    .name = "REALTIME",
00452    .read = function_realtime_read,
00453    .write = function_realtime_write,
00454 };
00455 
00456 static struct ast_custom_function realtimefield_function = {
00457    .name = "REALTIME_FIELD",
00458    .read = realtimefield_read,
00459    .write = function_realtime_write,
00460 };
00461 
00462 static struct ast_custom_function realtimehash_function = {
00463    .name = "REALTIME_HASH",
00464    .read = realtimefield_read,
00465 };
00466 
00467 static struct ast_custom_function realtime_store_function = {
00468    .name = "REALTIME_STORE",
00469    .write = function_realtime_store,
00470 };
00471 
00472 static struct ast_custom_function realtime_destroy_function = {
00473    .name = "REALTIME_DESTROY",
00474    .read = function_realtime_readdestroy,
00475 };
00476 
00477 static int unload_module(void)
00478 {
00479    int res = 0;
00480    res |= ast_custom_function_unregister(&realtime_function);
00481    res |= ast_custom_function_unregister(&realtime_store_function);
00482    res |= ast_custom_function_unregister(&realtime_destroy_function);
00483    res |= ast_custom_function_unregister(&realtimefield_function);
00484    res |= ast_custom_function_unregister(&realtimehash_function);
00485    return res;
00486 }
00487 
00488 static int load_module(void)
00489 {
00490    int res = 0;
00491    res |= ast_custom_function_register(&realtime_function);
00492    res |= ast_custom_function_register(&realtime_store_function);
00493    res |= ast_custom_function_register(&realtime_destroy_function);
00494    res |= ast_custom_function_register(&realtimefield_function);
00495    res |= ast_custom_function_register(&realtimehash_function);
00496    return res;
00497 }
00498 
00499 AST_MODULE_INFO_STANDARD(ASTERISK_GPL_KEY, "Read/Write/Store/Destroy values from a RealTime repository");

Generated on Mon Mar 19 11:30:27 2012 for Asterisk - The Open Source Telephony Project by  doxygen 1.4.7