void mssql_save_msg(Msg *msg, Octstr *momt /*, Octstr smsbox_id */) { Octstr *sql; Octstr *stuffer[30]; int stuffcount = 0; DBPoolConn *pc; pc = dbpool_conn_consume(pool); if (pc == NULL) { error(0, "MSSql: DBPool Error!"); return; } sql = octstr_format(SQLBOX_MSSQL_INSERT_QUERY, sqlbox_logtable, st_str(momt), st_str(msg->sms.sender), st_str(msg->sms.receiver), st_str(msg->sms.udhdata), st_str(msg->sms.msgdata), st_num(msg->sms.time), st_str(msg->sms.smsc_id), st_str(msg->sms.service), st_str(msg->sms.account), st_num(msg->sms.sms_type), st_num(msg->sms.mclass), st_num(msg->sms.mwi), st_num(msg->sms.coding), st_num(msg->sms.compress), st_num(msg->sms.validity), st_num(msg->sms.deferred), st_num(msg->sms.dlr_mask), st_str(msg->sms.dlr_url), st_num(msg->sms.pid), st_num(msg->sms.alt_dcs), st_num(msg->sms.rpi), st_str(msg->sms.charset), st_str(msg->sms.boxc_id), st_str(msg->sms.binfo), st_str(msg->sms.meta_data)); #if defined(SQLBOX_TRACE) debug("SQLBOX", 0, "sql: %s", octstr_get_cstr(sql)); #endif sql_update(pc, sql, NULL); while (stuffcount > 0) { octstr_destroy(stuffer[--stuffcount]); } dbpool_conn_produce(pc); octstr_destroy(sql); }
void mysql_save_msg(Msg *msg, Octstr *momt /*, Octstr smsbox_id */) { Octstr *sql; Octstr *stuffer[30]; int stuffcount = 0; sql = octstr_format(SQLBOX_MYSQL_INSERT_QUERY, sqlbox_logtable, st_str(momt), st_str(msg->sms.sender), st_str(msg->sms.receiver), st_str(msg->sms.udhdata), st_str(msg->sms.msgdata), st_num(msg->sms.time), st_str(msg->sms.smsc_id), st_str(msg->sms.service), st_str(msg->sms.account), st_num(msg->sms.sms_type), st_num(msg->sms.mclass), st_num(msg->sms.mwi), st_num(msg->sms.coding), st_num(msg->sms.compress), st_num(msg->sms.validity), st_num(msg->sms.deferred), st_num(msg->sms.dlr_mask), st_str(msg->sms.dlr_url), st_num(msg->sms.pid), st_num(msg->sms.alt_dcs), st_num(msg->sms.rpi), st_str(msg->sms.charset), st_str(msg->sms.boxc_id), st_str(msg->sms.binfo), st_str(msg->sms.meta_data)); sql_update(sql); while (stuffcount > 0) { octstr_destroy(stuffer[--stuffcount]); } octstr_destroy(sql); }
static int count_modules() { extern st_table_t module_table; return st_num(module_table); }
void redis_save_msg(Msg *msg, Octstr *momt /*, Octstr smsbox_id */) { Octstr *sql, *jsonstr, *subst; Octstr *stuffer[30]; json_t *msgjson, *root; char *json; int stuffcount = 0; msgjson = json_object(); json_object_set_new(msgjson, "momt", json_string(octstr_get_cstr(st_str(momt)))); json_object_set_new(msgjson, "sender", json_string(octstr_get_cstr(st_str(msg->sms.sender)))); json_object_set_new(msgjson, "receiver", json_string(octstr_get_cstr(st_str(msg->sms.receiver)))); json_object_set_new(msgjson, "foreign_id", json_string(octstr_get_cstr(st_str(msg->sms.foreign_id)))); json_object_set_new(msgjson, "udhdata", json_string(octstr_get_cstr(st_str(msg->sms.udhdata)))); json_object_set_new(msgjson, "msgdata", json_string(octstr_get_cstr(st_str(msg->sms.msgdata)))); json_object_set_new(msgjson, "time", json_string(octstr_get_cstr(st_num(msg->sms.time)))); json_object_set_new(msgjson, "smsc_id", json_string(octstr_get_cstr(st_str(msg->sms.smsc_id)))); json_object_set_new(msgjson, "service", json_string(octstr_get_cstr(st_str(msg->sms.service)))); json_object_set_new(msgjson, "account", json_string(octstr_get_cstr(st_str(msg->sms.account)))); json_object_set_new(msgjson, "sms_type", json_string(octstr_get_cstr(st_num(msg->sms.sms_type)))); json_object_set_new(msgjson, "mclass", json_string(octstr_get_cstr(st_num(msg->sms.mclass)))); json_object_set_new(msgjson, "mwi", json_string(octstr_get_cstr(st_num(msg->sms.mwi)))); json_object_set_new(msgjson, "coding", json_string(octstr_get_cstr(st_num(msg->sms.coding)))); json_object_set_new(msgjson, "compress", json_string(octstr_get_cstr(st_num(msg->sms.compress)))); json_object_set_new(msgjson, "validity", json_string(octstr_get_cstr(st_num(msg->sms.validity)))); json_object_set_new(msgjson, "deferred", json_string(octstr_get_cstr(st_num(msg->sms.deferred)))); json_object_set_new(msgjson, "dlr_mask", json_string(octstr_get_cstr(st_num(msg->sms.dlr_mask)))); json_object_set_new(msgjson, "dlr_url", json_string(octstr_get_cstr(st_str(msg->sms.dlr_url)))); json_object_set_new(msgjson, "pid", json_string(octstr_get_cstr(st_num(msg->sms.pid)))); json_object_set_new(msgjson, "alt_dcs", json_string(octstr_get_cstr(st_num(msg->sms.alt_dcs)))); json_object_set_new(msgjson, "rpi", json_string(octstr_get_cstr(st_num(msg->sms.rpi)))); json_object_set_new(msgjson, "charset", json_string(octstr_get_cstr(st_str(msg->sms.charset)))); json_object_set_new(msgjson, "boxc_id", json_string(octstr_get_cstr(st_str(msg->sms.boxc_id)))); json_object_set_new(msgjson, "binfo", json_string(octstr_get_cstr(st_str(msg->sms.binfo)))); json_object_set_new(msgjson, "priority", json_string(octstr_get_cstr(st_num(msg->sms.priority)))); json_object_set_new(msgjson, "meta_data", json_string(octstr_get_cstr(st_str(msg->sms.meta_data)))); root = json_object(); json_object_set(root, "msg", msgjson); json = json_dumps(root, JSON_COMPACT); jsonstr = octstr_create(json); subst = octstr_create("%s"); sql = octstr_format(SQLBOX_REDIS_QUEUE_PUSH, sqlbox_logtable, subst); sql_update(sql, jsonstr); octstr_destroy(sql); octstr_destroy(subst); octstr_destroy(jsonstr); while (stuffcount > 0) { octstr_destroy(stuffer[--stuffcount]); } json_decref(msgjson); json_decref(root); gw_free(json); }