Function db_insert_ucontact

modules/usrloc/ucontact.c:519–705

! \brief * Insert contact into the database */

 * Insert contact into the database
 */
int db_insert_ucontact(ucontact_t* _c,query_list_t **ins_list, int update)
{
	int nr_vals = UL_COLS - 1;
	int start = 0;

	static db_ps_t myI_ps = NULL;
	static db_ps_t myR_ps = NULL;
	char* dom;
	db_key_t keys[UL_COLS];
	db_val_t vals[UL_COLS];

	if (_c->flags & FL_MEM) {
		return 0;
	}

	/* in CM_SQL_ONLY, we let the SQL engine auto-generate the ucontact_id */
	if (cluster_mode == CM_SQL_ONLY) {
		start++;
		nr_vals--;
	}

	keys[0] = &contactid_col;
	keys[1] = &user_col;
	keys[2] = &contact_col;
	keys[3] = &expires_col;
	keys[4] = &q_col;
	keys[5] = &callid_col;
	keys[6] = &cseq_col;
	keys[7] = &flags_col;
	keys[8] = &cflags_col;
	keys[9] = &user_agent_col;
	keys[10] = &received_col;
	keys[11] = &path_col;
	keys[12] = &sock_col;
	keys[13] = &methods_col;
	keys[14] = &last_mod_col;
	keys[15] = &sip_instance_col;
	keys[16] = &kv_store_col;
	keys[17] = &attr_col;
	keys[UL_COLS - 1] = &domain_col; /* "domain" always stays last */

	memset(vals, 0, sizeof vals);

	vals[0].type = DB_BIGINT;
	vals[0].val.bigint_val = _c->contact_id;

	vals[1].type = DB_STR;
	vals[1].val.str_val.s = _c->aor->s;
	vals[1].val.str_val.len = _c->aor->len;

	vals[2].type = DB_STR;
	vals[2].val.str_val.s = _c->c.s;
	vals[2].val.str_val.len = _c->c.len;

	vals[3].type = DB_INT;
	vals[3].val.int_val = _c->expires;

	vals[4].type = DB_DOUBLE;