modules/db_mysql/km_val.c
4f778298
 /* 
  * Copyright (C) 2001-2003 FhG Fokus
  * Copyright (C) 2008 1&1 Internet AG
  *
31f52f1d
  * This file is part of Kamailio, a free SIP server.
4f778298
  *
31f52f1d
  * Kamailio is free software; you can redistribute it and/or modify
4f778298
  * it under the terms of the GNU General Public License as published by
  * the Free Software Foundation; either version 2 of the License, or
  * (at your option) any later version
  *
31f52f1d
  * Kamailio is distributed in the hope that it will be useful,
4f778298
  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  * GNU General Public License for more details.
  *
  * You should have received a copy of the GNU General Public License 
  * along with this program; if not, write to the Free Software 
9e1ff448
  * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
4f778298
  */
 
083502f8
 /*! \file
c56b4491
  *  \brief DB_MYSQL :: Data conversions
083502f8
  *  \ingroup db_mysql
  *  Module: \ref db_mysql
  */
4f778298
 
 #include "../../dprint.h"
96121273
 #include "../../lib/srdb1/db_ut.h"
 #include "km_val.h"
 #include "km_my_con.h"
4f778298
 
 
c56b4491
 /*!
  * \brief Converting a value to a string
  *
  * Converting a value to a string, used when converting result from a query
  * \param _c database connection
  * \param _v source value
  * \param _s target string
  * \param _len target string length
  * \return 0 on success, negative on error
4f778298
  */
956802dc
 int db_mysql_val2str(const db1_con_t* _c, const db_val_t* _v, char* _s, int* _len)
4f778298
 {
b32ac21f
 	int l, tmp;
4f778298
 	char* old_s;
 
b32ac21f
 	tmp = db_val2str(_c, _v, _s, _len);
 	if (tmp < 1)
 		return tmp;
4f778298
 
 	switch(VAL_TYPE(_v)) {
b81f22ee
 	case DB1_STRING:
4f778298
 		l = strlen(VAL_STRING(_v));
 		if (*_len < (l * 2 + 3)) {
 			LM_ERR("destination buffer too short\n");
2d98f9c4
 			return -6;
4f778298
 		} else {
 			old_s = _s;
 			*_s++ = '\'';
 			_s += mysql_real_escape_string(CON_CONNECTION(_c), _s, VAL_STRING(_v), l);
 			*_s++ = '\'';
 			*_s = '\0'; /* FIXME */
 			*_len = _s - old_s;
 			return 0;
 		}
 		break;
 
b81f22ee
 	case DB1_STR:
c4944cf6
 		if (*_len < (VAL_STR(_v).len * 2 + 3)) {
4f778298
 			LM_ERR("destination buffer too short\n");
2d98f9c4
 			return -7;
4f778298
 		} else {
 			old_s = _s;
 			*_s++ = '\'';
c4944cf6
 			_s += mysql_real_escape_string(CON_CONNECTION(_c), _s, VAL_STR(_v).s, VAL_STR(_v).len);
4f778298
 			*_s++ = '\'';
 			*_s = '\0';
 			*_len = _s - old_s;
 			return 0;
 		}
 		break;
 
b81f22ee
 	case DB1_BLOB:
4f778298
 		l = VAL_BLOB(_v).len;
 		if (*_len < (l * 2 + 3)) {
 			LM_ERR("destination buffer too short\n");
2d98f9c4
 			return -9;
4f778298
 		} else {
 			old_s = _s;
 			*_s++ = '\'';
 			_s += mysql_real_escape_string(CON_CONNECTION(_c), _s, VAL_STR(_v).s, l);
 			*_s++ = '\'';
 			*_s = '\0';
 			*_len = _s - old_s;
 			return 0;
 		}			
 		break;
 
 	default:
 		LM_DBG("unknown data type\n");
2d98f9c4
 		return -10;
4f778298
 	}
 }