bool
variant_as_string( DEBUGHELPER *pH, const VARIANT &var, std::string *ret )
{
if (var.vt & VT_VECTOR) return false;
if (var.vt & VT_RESERVED) return false;
if (var.vt & VT_ARRAY)
return safearray_as_string( pH, reinterpret_cast<DWORDLONG>(var.parray), ret);
if (var.vt & VT_BYREF)
{
// Construct a fake variant with the byref-value in it.
VARTYPE vt = var.vt & ~VT_BYREF;
long size = vartype_len(vt);
VARIANT var2;
var2.vt = vt;
long source=reinterpret_cast<long>(var.byref);
void *dest;
if( vt == VT_VARIANT)
dest = &var2;
else
{
var2.vt=vt;
dest = &(var2.bVal);
}
if(!ReadMem(pH,source, size, dest)) return false;
std::string retval;
if( ! variant_as_string( pH, var2, &retval)) return false;
retval += "]";
*ret = "[" + retval;
return true;
}
std::ostringstream os;
switch (var.vt & VT_TYPEMASK )
{
case VT_I2: os << V_I2(&var); break;
case VT_I4: os << V_I4(&var); break;
//case VT_I8: os << V_I8(&var); break;
case VT_R4: os << V_R4(&var); break;
case VT_R8: os << V_R8(&var); break;
case VT_UNKNOWN:
case VT_DISPATCH: os << "0x" << std::hex << (long )V_DISPATCH(&var); break;
case VT_BOOL: os << (V_BOOL(&var)==VARIANT_FALSE?"False":"True"); break;
case VT_I1: os << "'" << V_I1(&var) << "'" ; break;
case VT_UI1: os << "'" << V_UI1(&var) << "'" ; break;
case VT_UI2: os << V_UI2(&var); break;
case VT_UI4: os << V_UI4(&var); break;
case VT_INT: os << V_INT(&var); break;
case VT_UINT: os << V_UINT(&var); break;
case VT_ERROR: os << "error"; break;
case VT_CY: os << (((double)(V_CY(&var).int64))/10000.); break;
case VT_DATE: return date_as_string(V_DATE(&var), ret); break;
case VT_BSTR:
{
long pBSTR = reinterpret_cast<long>( V_BSTR(&var) );
// if (!ReadMem(pH, reinterpret_cast<DWORDLONG>( V_BSTR(&var) ), &pBSTR)) return false;
std::string ret;
if (!bstr_as_string( pH, pBSTR , &ret )) return false;
os << ret;
}break;
case VT_EMPTY: os << '@'; break;
case VT_NULL: os << "null"; break;
break;
default:
return false;
}
*ret = os.str();
return true;
}
/*
* csql_db_value_as_string() - convert DB_VALUE to string
* return: formatted string
* value(in): value to convert
* length(out): length of output string
* plain_output(in): refine string for plain output
*/
char *
csql_db_value_as_string (DB_VALUE * value, int *length, bool plain_string)
{
char *result = NULL;
int len = 0;
if (value == NULL)
{
return (NULL);
}
switch (DB_VALUE_TYPE (value))
{
case DB_TYPE_BIGINT:
result =
bigint_to_string (DB_GET_BIGINT (value), default_bigint_profile.fieldwidth, default_bigint_profile.leadingzeros,
default_bigint_profile.leadingsymbol, default_bigint_profile.commas,
default_bigint_profile.format);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_INTEGER:
result =
bigint_to_string (DB_GET_INTEGER (value), default_int_profile.fieldwidth, default_int_profile.leadingzeros,
default_int_profile.leadingsymbol, default_int_profile.commas, default_int_profile.format);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_SHORT:
result =
bigint_to_string (SHORT_TO_INT (DB_GET_SHORT (value)), default_short_profile.fieldwidth,
default_short_profile.leadingzeros, default_short_profile.leadingsymbol,
default_short_profile.commas, default_short_profile.format);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_FLOAT:
result =
double_to_string ((double) DB_GET_FLOAT (value), default_float_profile.fieldwidth,
default_float_profile.precision, default_float_profile.leadingsign, NULL, NULL,
default_float_profile.leadingzeros, default_float_profile.trailingzeros,
default_float_profile.commas, default_float_profile.format);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_DOUBLE:
result =
double_to_string (DB_GET_DOUBLE (value), default_double_profile.fieldwidth, default_double_profile.precision,
default_double_profile.leadingsign, NULL, NULL, default_double_profile.leadingzeros,
default_double_profile.trailingzeros, default_double_profile.commas,
default_double_profile.format);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_NUMERIC:
result = numeric_to_string (value, default_numeric_profile.commas);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_VARCHAR:
case DB_TYPE_CHAR:
{
int dummy, bytes_size, decomp_size;
bool need_decomp = false;
char *str;
char *decomposed = NULL;
str = db_get_char (value, &dummy);
bytes_size = db_get_string_size (value);
if (bytes_size > 0 && DB_GET_STRING_CODESET (value) == INTL_CODESET_UTF8)
{
need_decomp =
unicode_string_need_decompose (str, bytes_size, &decomp_size, lang_get_generic_unicode_norm ());
}
if (need_decomp)
{
decomposed = (char *) malloc (decomp_size * sizeof (char));
if (decomposed != NULL)
{
unicode_decompose_string (str, bytes_size, decomposed, &decomp_size, lang_get_generic_unicode_norm ());
str = decomposed;
bytes_size = decomp_size;
}
else
{
return NULL;
}
}
result = string_to_string (str, default_string_profile.string_delimiter, '\0', bytes_size, &len, plain_string);
if (decomposed != NULL)
{
free_and_init (decomposed);
}
}
break;
case DB_TYPE_VARNCHAR:
case DB_TYPE_NCHAR:
{
int dummy, bytes_size, decomp_size;
bool need_decomp = false;
char *str;
char *decomposed = NULL;
str = db_get_char (value, &dummy);
bytes_size = db_get_string_size (value);
if (bytes_size > 0 && DB_GET_STRING_CODESET (value) == INTL_CODESET_UTF8)
{
need_decomp =
unicode_string_need_decompose (str, bytes_size, &decomp_size, lang_get_generic_unicode_norm ());
}
if (need_decomp)
{
decomposed = (char *) malloc (decomp_size * sizeof (char));
if (decomposed != NULL)
{
unicode_decompose_string (str, bytes_size, decomposed, &decomp_size, lang_get_generic_unicode_norm ());
str = decomposed;
bytes_size = decomp_size;
}
else
{
return NULL;
}
}
result = string_to_string (str, default_string_profile.string_delimiter, 'N', bytes_size, &len, plain_string);
if (decomposed != NULL)
{
free_and_init (decomposed);
}
}
break;
case DB_TYPE_VARBIT:
case DB_TYPE_BIT:
result = bit_to_string (value, default_string_profile.string_delimiter, plain_string);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_OBJECT:
result = object_to_string (DB_GET_OBJECT (value), get_object_print_format ());
if (result == NULL)
{
result = duplicate_string ("NULL");
}
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_VOBJ:
result = object_to_string (DB_GET_OBJECT (value), get_object_print_format ());
if (result == NULL)
{
result = duplicate_string ("NULL");
}
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_SET:
case DB_TYPE_MULTISET:
case DB_TYPE_SEQUENCE:
result =
set_to_string (value, default_set_profile.begin_notation, default_set_profile.end_notation,
default_set_profile.max_entries, plain_string);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_TIME:
{
char buf[TIME_BUF_SIZE];
if (db_time_to_string (buf, sizeof (buf), DB_GET_TIME (value)))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
break;
}
case DB_TYPE_TIMETZ:
{
char buf[TIMETZ_BUF_SIZE];
DB_TIMETZ *time_tz = DB_GET_TIMETZ (value);
if (db_timetz_to_string (buf, sizeof (buf), &(time_tz->time), &time_tz->tz_id))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_TIMELTZ:
{
char buf[TIMETZ_BUF_SIZE];
if (db_timeltz_to_string (buf, sizeof (buf), DB_GET_TIME (value)))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_MONETARY:
{
char *leading_str = NULL;
char *trailing_str = NULL;
DB_CURRENCY currency = ((DB_GET_MONETARY (value))->type);
if (default_monetary_profile.currency_symbol)
{
if (intl_get_currency_symbol_position (currency) == 1)
{
trailing_str = intl_get_money_symbol_console (currency);
}
else
{
leading_str = intl_get_money_symbol_console (currency);
}
}
result =
(DB_GET_MONETARY (value) == NULL) ? NULL : double_to_string ((DB_GET_MONETARY (value))->amount,
default_monetary_profile.fieldwidth,
default_monetary_profile.decimalplaces,
default_monetary_profile.leadingsign,
leading_str, trailing_str,
default_monetary_profile.leadingzeros,
default_monetary_profile.trailingzeros,
default_monetary_profile.commas,
DOUBLE_FORMAT_DECIMAL);
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_DATE:
/* default format for all locales */
result = date_as_string (DB_GET_DATE (value), default_date_profile.format);
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_UTIME:
{
char buf[TIMESTAMP_BUF_SIZE];
if (db_utime_to_string (buf, sizeof (buf), DB_GET_UTIME (value)))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_TIMESTAMPTZ:
{
char buf[TIMESTAMPTZ_BUF_SIZE];
DB_TIMESTAMPTZ *ts_tz = DB_GET_TIMESTAMPTZ (value);
if (db_timestamptz_to_string (buf, sizeof (buf), &(ts_tz->timestamp), &(ts_tz->tz_id)))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_TIMESTAMPLTZ:
{
char buf[TIMESTAMPTZ_BUF_SIZE];
if (db_timestampltz_to_string (buf, sizeof (buf), DB_GET_UTIME (value)))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_DATETIME:
{
char buf[DATETIME_BUF_SIZE];
if (db_datetime_to_string (buf, sizeof (buf), DB_GET_DATETIME (value)))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_DATETIMETZ:
{
char buf[DATETIMETZ_BUF_SIZE];
DB_DATETIMETZ *dt_tz = DB_GET_DATETIMETZ (value);
if (db_datetimetz_to_string (buf, sizeof (buf), &(dt_tz->datetime), &(dt_tz->tz_id)))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_DATETIMELTZ:
{
char buf[DATETIMETZ_BUF_SIZE];
if (db_datetimeltz_to_string (buf, sizeof (buf), DB_GET_DATETIME (value)))
{
result = duplicate_string (buf);
}
if (result)
{
len = strlen (result);
}
}
break;
case DB_TYPE_NULL:
result = duplicate_string ("NULL");
if (result)
{
len = strlen (result);
}
break;
case DB_TYPE_BLOB:
case DB_TYPE_CLOB:
{
DB_ELO *elo = DB_GET_ELO (value);
if (elo != NULL)
{
result = duplicate_string (elo->locator);
}
if (result != NULL)
{
len = strlen (result);
}
}
break;
case DB_TYPE_ENUMERATION:
{
int bytes_size, decomp_size;
bool need_decomp = false;
const char *str;
char *decomposed = NULL;
if (db_get_enum_short (value) == 0 && db_get_enum_string (value) == NULL)
{
/* ENUM special error value */
str = "";
bytes_size = 0;
}
else
{
str = db_get_enum_string (value);
bytes_size = db_get_enum_string_size (value);
}
if (bytes_size > 0 && db_get_enum_codeset (value) == INTL_CODESET_UTF8)
{
need_decomp =
unicode_string_need_decompose (str, bytes_size, &decomp_size, lang_get_generic_unicode_norm ());
}
if (need_decomp)
{
decomposed = (char *) malloc (decomp_size * sizeof (char));
if (decomposed != NULL)
{
unicode_decompose_string (str, bytes_size, decomposed, &decomp_size, lang_get_generic_unicode_norm ());
str = decomposed;
bytes_size = decomp_size;
}
else
{
return NULL;
}
}
result = string_to_string (str, default_string_profile.string_delimiter, '\0', bytes_size, &len, plain_string);
if (decomposed != NULL)
{
free_and_init (decomposed);
}
}
break;
default:
{
char temp_buffer[256];
(void) sprintf (temp_buffer, "<%s>", db_get_type_name (DB_VALUE_TYPE (value)));
result = duplicate_string (temp_buffer);
if (result)
{
len = strlen (result);
}
}
}
if (length)
{
*length = len;
}
return result;
}
