CDB_Object* CDBL_BlobResult::GetItem(CDB_Object* item_buff, I_Result::EGetItem policy)
{
if (m_CurrItem)
return 0;
EDB_Type b_type = item_buff ? item_buff->GetType() : eDB_UnsupportedType;
if (item_buff && b_type != eDB_Text && b_type != eDB_Image) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 230020 );
}
CDB_Stream* val = NULL;
if (item_buff) {
val = static_cast<CDB_Stream*>(item_buff);
if (policy == I_Result::eAssignLOB) {
// Explicitly truncate previous value ...
val->Truncate();
}
} else if (m_ColFmt.data_type == eDB_Text) {
val = new CDB_Text;
} else {
val = new CDB_Image;
}
_ASSERT(val);
// check if we do have something in buffer
if(m_ReadedBytes < m_BytesInBuffer) {
val->Append(m_Buff + m_ReadedBytes, m_BytesInBuffer - m_ReadedBytes);
m_ReadedBytes= m_BytesInBuffer;
}
if(m_BytesInBuffer == 0) {
return item_buff;
}
STATUS s;
while ((s = Check(dbreadtext(GetCmd(), m_Buff, (DBINT) sizeof(m_Buff)))) > 0) {
val->Append(m_Buff, (size_t(s) < sizeof(m_Buff))? size_t(s) : sizeof(m_Buff));
}
switch (s) {
case NO_MORE_ROWS:
m_EOR = true;
case 0:
m_CurrItem = 1;
break;
default:
DATABASE_DRIVER_ERROR( "dbreadtext failed." + GetDbgInfo(), 280003 );
}
return item_buff;
}
// Aux. for CTL_RowResult::GetItem()
CDB_Object* CTL_RowResult::GetItemInternal(
I_Result::EGetItem policy,
CS_COMMAND* cmd,
CS_INT item_no,
CS_DATAFMT& fmt,
CDB_Object* item_buf
)
{
CS_INT outlen = 0;
char buffer[2048];
EDB_Type b_type = item_buf ? item_buf->GetType() : eDB_UnsupportedType;
bool is_null = false;
switch ( fmt.datatype ) {
#ifdef FTDS_IN_USE
case CS_UNIQUE_TYPE:
#endif
case CS_VARBINARY_TYPE:
case CS_BINARY_TYPE: {
if (item_buf &&
b_type != eDB_VarBinary && b_type != eDB_Binary &&
b_type != eDB_VarChar && b_type != eDB_Char &&
b_type != eDB_LongChar && b_type != eDB_LongBinary) {
DATABASE_DRIVER_ERROR("Wrong type of CDB_Object." +
GetDbgInfo(), 130020 );
}
char* v = (fmt.maxlength < (CS_INT) sizeof(buffer))
? buffer : new char[fmt.maxlength + 1];
switch ( my_ct_get_data(cmd, item_no, v, fmt.maxlength, &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
switch ( b_type ) {
case eDB_VarBinary:
((CDB_VarBinary*) item_buf)->SetValue(v, outlen);
break;
case eDB_Binary:
((CDB_Binary*) item_buf)->SetValue(v, outlen);
break;
case eDB_VarChar:
v[outlen] = '\0';
*((CDB_VarChar*) item_buf) = v;
break;
case eDB_Char:
v[outlen] = '\0';
*((CDB_Char*) item_buf) = v;
break;
case eDB_LongChar:
v[outlen] = '\0';
*((CDB_LongChar*) item_buf) = v;
break;
case eDB_LongBinary:
((CDB_LongBinary*) item_buf)->SetValue(v, outlen);
break;
default:
break;
}
if (v != buffer) delete[] v;
return item_buf;
}
CDB_VarBinary* val = is_null
? new CDB_VarBinary() : new CDB_VarBinary(v, outlen);
if ( v != buffer) delete[] v;
return val;
}
case CS_CANCELED:
if (v != buffer) delete[] v;
DATABASE_DRIVER_ERROR("The command has been canceled." +
GetDbgInfo(), 130004 );
default:
if (v != buffer) delete[] v;
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_LONGBINARY_TYPE: {
if (item_buf &&
b_type != eDB_LongChar && b_type != eDB_LongBinary) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
char* v = (fmt.maxlength < (CS_INT) sizeof(buffer))
? buffer : new char[fmt.maxlength + 1];
switch ( my_ct_get_data(cmd, item_no, v, fmt.maxlength, &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
switch ( b_type ) {
case eDB_LongBinary:
((CDB_LongBinary*) item_buf)->SetValue(v, outlen);
break;
case eDB_LongChar:
v[outlen] = '\0';
*((CDB_LongChar*) item_buf) = v;
default:
break;
}
if (v != buffer) delete[] v;
return item_buf;
}
CDB_LongBinary* val = is_null
? new CDB_LongBinary(fmt.maxlength) :
new CDB_LongBinary(fmt.maxlength, v, outlen);
if ( v != buffer) delete[] v;
return val;
}
case CS_CANCELED:
if (v != buffer) {
delete[] v;
}
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
if (v != buffer) {
delete[] v;
}
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_BIT_TYPE: {
if (item_buf &&
b_type != eDB_Bit && b_type != eDB_TinyInt &&
b_type != eDB_SmallInt && b_type != eDB_Int) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_BIT v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
if (is_null) {
item_buf->AssignNULL();
}
else {
switch ( b_type ) {
case eDB_Bit:
*((CDB_Bit*) item_buf) = (int) v;
break;
case eDB_TinyInt:
*((CDB_TinyInt*) item_buf) = v ? 1 : 0;
break;
case eDB_SmallInt:
*((CDB_SmallInt*) item_buf) = v ? 1 : 0;
break;
case eDB_Int:
*((CDB_Int*) item_buf) = v ? 1 : 0;
break;
default:
break;
}
}
return item_buf;
}
return is_null ? new CDB_Bit() : new CDB_Bit((int) v);
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_VARCHAR_TYPE:
case CS_CHAR_TYPE: {
if (item_buf &&
b_type != eDB_VarBinary && b_type != eDB_Binary &&
b_type != eDB_VarChar && b_type != eDB_Char &&
b_type != eDB_LongChar && b_type != eDB_LongBinary) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
char* v = static_cast<unsigned int>(fmt.maxlength) < sizeof(buffer)
? buffer : new char[fmt.maxlength + 1];
switch ( my_ct_get_data(cmd, item_no, v, fmt.maxlength, &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
v[outlen] = '\0';
if ( item_buf) {
if (is_null) {
item_buf->AssignNULL();
}
else {
switch ( b_type ) {
case eDB_VarChar:
*((CDB_VarChar*) item_buf) = v;
break;
case eDB_Char:
*((CDB_Char*) item_buf) = v;
break;
case eDB_LongChar:
*((CDB_LongChar*) item_buf) = v;
break;
case eDB_VarBinary:
((CDB_VarBinary*) item_buf)->SetValue(v, outlen);
break;
case eDB_Binary:
((CDB_Binary*) item_buf)->SetValue(v, outlen);
break;
case eDB_LongBinary:
((CDB_LongBinary*) item_buf)->SetValue(v, outlen);
break;
default:
break;
}
}
if ( v != buffer) delete[] v;
return item_buf;
}
CDB_VarChar* val = is_null
? new CDB_VarChar() : new CDB_VarChar(v, (size_t) outlen);
if (v != buffer) delete[] v;
return val;
}
case CS_CANCELED:
if (v != buffer) {
delete[] v;
}
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
if (v != buffer) {
delete[] v;
}
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_LONGCHAR_TYPE: {
char* v = static_cast<unsigned int>(fmt.maxlength) < sizeof(buffer)
? buffer : new char[fmt.maxlength + 1];
switch ( my_ct_get_data(cmd, item_no, v, fmt.maxlength, &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
v[outlen] = '\0';
if ( item_buf) {
if (is_null) {
item_buf->AssignNULL();
}
else {
switch ( b_type ) {
case eDB_LongChar:
*((CDB_LongChar*) item_buf) = v;
break;
case eDB_LongBinary:
((CDB_LongBinary*) item_buf)->SetValue(v, outlen);
break;
case eDB_VarChar:
if (outlen <= MAX_VARCHAR_SIZE) {
((CDB_VarChar*) item_buf)->SetValue(v, outlen, eEncoding_Unknown);
} else {
DATABASE_DRIVER_ERROR( "Invalid conversion to CDB_VarChar type", 230021 );
}
break;
default:
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
break;
}
}
if ( v != buffer) delete[] v;
return item_buf;
}
CDB_LongChar* val = is_null
? new CDB_LongChar(fmt.maxlength) : new CDB_LongChar((size_t) outlen, v);
if (v != buffer) delete[] v;
return val;
}
case CS_CANCELED:
if (v != buffer) {
delete[] v;
}
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
if (v != buffer) {
delete[] v;
}
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_DATETIME_TYPE: {
if (item_buf && b_type != eDB_DateTime) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_DATETIME v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf) {
if (!is_null) {
((CDB_DateTime*)item_buf)->Assign(v.dtdays, v.dttime);
}
else {
item_buf->AssignNULL();
}
return item_buf;
}
CDB_DateTime* val;
if (!is_null) {
val = new CDB_DateTime(v.dtdays, v.dttime);
} else {
val = new CDB_DateTime;
}
return val;
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_DATETIME4_TYPE: {
if (item_buf &&
b_type != eDB_SmallDateTime && b_type != eDB_DateTime) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_DATETIME4 v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf) {
if (!is_null) {
switch ( b_type ) {
case eDB_SmallDateTime:
((CDB_SmallDateTime*) item_buf)->Assign
(v.days, v.minutes);
break;
case eDB_DateTime:
((CDB_DateTime*) item_buf)->Assign
(v.days, v.minutes * 60 * 300);
break;
default:
break;
}
}
else {
item_buf->AssignNULL();
}
return item_buf;
}
return is_null
? new CDB_SmallDateTime
: new CDB_SmallDateTime(v.days, v.minutes);
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_TINYINT_TYPE: {
if (item_buf &&
b_type != eDB_TinyInt && b_type != eDB_SmallInt &&
b_type != eDB_Int) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_TINYINT v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
if (is_null) {
item_buf->AssignNULL();
}
else {
switch ( b_type ) {
case eDB_TinyInt:
*((CDB_TinyInt*) item_buf) = (Uint1) v;
break;
case eDB_SmallInt:
*((CDB_SmallInt*) item_buf) = (Int2) v;
break;
case eDB_Int:
*((CDB_Int*) item_buf) = (Int4) v;
break;
default:
break;
}
}
return item_buf;
}
return is_null
? new CDB_TinyInt() : new CDB_TinyInt((Uint1) v);
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_SMALLINT_TYPE: {
if (item_buf &&
b_type != eDB_SmallInt && b_type != eDB_Int) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_SMALLINT v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
if (is_null) {
item_buf->AssignNULL();
}
else {
switch ( b_type ) {
case eDB_SmallInt:
*((CDB_SmallInt*) item_buf) = (Int2) v;
break;
case eDB_Int:
*((CDB_Int*) item_buf) = (Int4) v;
break;
default:
break;
}
}
return item_buf;
}
return is_null
? new CDB_SmallInt() : new CDB_SmallInt((Int2) v);
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_INT_TYPE: {
if (item_buf && b_type != eDB_Int) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_INT v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
if (is_null) {
item_buf->AssignNULL();
}
else {
*((CDB_Int*) item_buf) = (Int4) v;
}
return item_buf;
}
return is_null ? new CDB_Int() : new CDB_Int((Int4) v);
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_LONG_TYPE: {
if (item_buf && b_type != eDB_BigInt) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
Int8 v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
if (is_null) {
item_buf->AssignNULL();
}
else {
*((CDB_BigInt*) item_buf) = (Int8) v;
}
return item_buf;
}
return is_null ? new CDB_BigInt() : new CDB_BigInt(v);
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_DECIMAL_TYPE:
case CS_NUMERIC_TYPE: {
if (item_buf && b_type != eDB_BigInt && b_type != eDB_Numeric) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_NUMERIC v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
if (outlen < 3) { /* it used to be == 0 but ctlib on windows
returns 2 even for NULL numeric */
item_buf->AssignNULL();
} else if (is_null) {
item_buf->AssignNULL();
} else {
if (b_type == eDB_Numeric) {
((CDB_Numeric*) item_buf)->Assign
((unsigned int) v.precision,
(unsigned int) v.scale,
(const unsigned char*) v.array);
}
else {
*((CDB_BigInt*) item_buf) =
numeric_to_longlong((unsigned int)
v.precision, v.array);
}
}
return item_buf;
}
if (fmt.scale == 0 && fmt.precision < 20) {
return (outlen == 0)
? new CDB_BigInt
: new CDB_BigInt(numeric_to_longlong((unsigned int)
v.precision,v.array));
} else {
return is_null
? new CDB_Numeric
: new CDB_Numeric((unsigned int) v.precision,
(unsigned int) v.scale,
(const unsigned char*) v.array);
}
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_FLOAT_TYPE: {
if (item_buf && b_type != eDB_Double) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_FLOAT v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
if (is_null) {
item_buf->AssignNULL();
}
else {
*((CDB_Double*) item_buf) = (double) v;
}
return item_buf;
}
return is_null
? new CDB_Double() : new CDB_Double((double) v);
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_REAL_TYPE: {
if (item_buf && b_type != eDB_Float) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CS_REAL v;
switch ( my_ct_get_data(cmd, item_no, &v, (CS_INT) sizeof(v), &outlen, is_null) ) {
case CS_SUCCEED:
case CS_END_ITEM:
case CS_END_DATA: {
if ( item_buf ) {
if (is_null) {
item_buf->AssignNULL();
}
else {
*((CDB_Float*) item_buf) = (float) v;
}
return item_buf;
}
return is_null ? new CDB_Float() : new CDB_Float((float) v);
}
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
case CS_TEXT_TYPE:
case CS_IMAGE_TYPE: {
if (item_buf && b_type != eDB_Text && b_type != eDB_Image) {
DATABASE_DRIVER_ERROR( "Wrong type of CDB_Object." + GetDbgInfo(), 130020 );
}
CDB_Stream* val = NULL;
if (item_buf) {
val = static_cast<CDB_Stream*>(item_buf);
if (policy == I_Result::eAssignLOB) {
// Explicitly truncate previous value ...
val->Truncate();
}
} else if (fmt.datatype == CS_TEXT_TYPE) {
val = new CDB_Text;
} else {
val = new CDB_Image;
}
_ASSERT(val);
if (m_NullValue[GetCurrentItemNum()] == eIsNull)
return val;
for (;;) {
switch ( my_ct_get_data(cmd, item_no, buffer, sizeof(buffer), &outlen, is_null) ) {
case CS_SUCCEED:
if (outlen != 0)
val->Append(buffer, outlen);
continue;
case CS_END_ITEM:
case CS_END_DATA:
if (outlen != 0)
val->Append(buffer, outlen);
return val;
case CS_CANCELED:
DATABASE_DRIVER_ERROR( "The command has been canceled." + GetDbgInfo(), 130004 );
default:
DATABASE_DRIVER_ERROR( "ct_get_data failed." + GetDbgInfo(), 130000 );
}
}
}
default: {
// Not handled data types ...
// CS_MONEY_TYPE
// CS_MONEY4_TYPE
// CS_SENSITIVITY_TYPE
// CS_BOUNDARY_TYPE
// CS_VOID_TYPE
// CS_USHORT_TYPE
// CS_UNICHAR_TYPE
DATABASE_DRIVER_ERROR( "Unexpected result type." + GetDbgInfo(), 130004 );
}
}
}
string CVariant::GetString(void) const
{
string s("");
if( IsNull() )
{
switch( GetType() ) {
case eDB_TinyInt:
case eDB_SmallInt:
case eDB_Int:
case eDB_BigInt:
case eDB_Numeric:
s = "0";
break;
case eDB_Float:
case eDB_Double:
s = "0.0";
break;
default:
break;
}
}
else
{
switch( GetType() ) {
case eDB_Char:
case eDB_VarChar:
case eDB_LongChar:
s = ((CDB_String*)GetData())->Value();
break;
case eDB_Binary:
{
CDB_Binary *b = (CDB_Binary*)GetData();
s = string((char*)b->Value(), b->Size());
break;
}
case eDB_LongBinary:
{
CDB_LongBinary *vb = (CDB_LongBinary*)GetData();
s = string((char*)vb->Value(), vb->DataSize());
break;
}
case eDB_VarBinary:
{
CDB_VarBinary *vb = (CDB_VarBinary*)GetData();
s = string((char*)vb->Value(), vb->Size());
break;
}
case eDB_TinyInt:
s = NStr::IntToString(GetByte());
break;
case eDB_SmallInt:
s = NStr::IntToString(GetInt2());
break;
case eDB_Int:
s = NStr::IntToString(GetInt4());
break;
case eDB_BigInt:
s = NStr::Int8ToString(GetInt8());
break;
case eDB_Float:
s = NStr::DoubleToString(GetFloat());
break;
case eDB_Double:
s = NStr::DoubleToString(GetDouble());
break;
case eDB_Bit:
s = NStr::BoolToString(GetBit());
break;
case eDB_Numeric:
s = ((CDB_Numeric*)GetData())->Value();
break;
case eDB_DateTime:
case eDB_SmallDateTime:
s = GetCTime().AsString();
break;
case eDB_Text:
case eDB_Image:
{
CDB_Stream* stream = (CDB_Stream*)GetData();
char* buff[4096];
size_t read_bytes = 0;
s.reserve(stream->Size());
while ((read_bytes = stream->Read(buff, sizeof(buff))) != 0) {
s.append((const char*) buff, read_bytes);
if (read_bytes < sizeof(buff)) {
break;
}
}
}
break;
default:
x_Verify_AssignType(eDB_UnsupportedType, "string");
break;
}
}
return s;
}
bool CDBL_Connection::x_SendData(I_BlobDescriptor& descr_in,
CDB_Stream& stream, bool log_it)
{
size_t size = stream.Size();
if (size < 1)
return false;
x_SetExtraMsg(descr_in, size);
I_BlobDescriptor* p_desc= 0;
// check what type of descriptor we've got
if(descr_in.DescriptorType() != CDBL_BLOB_DESCRIPTOR_TYPE_MAGNUM){
// this is not a native descriptor
p_desc = x_GetNativeBlobDescriptor
(dynamic_cast<CDB_BlobDescriptor&>(descr_in));
if(p_desc == 0) return false;
x_SetExtraMsg(*p_desc, size);
}
unique_ptr<I_BlobDescriptor> d_guard(p_desc);
CDBL_BlobDescriptor& desc
= p_desc ? dynamic_cast<CDBL_BlobDescriptor&>(*p_desc) :
dynamic_cast<CDBL_BlobDescriptor&>(descr_in);
char buff[1800]; // maximal page size
if (size <= sizeof(buff)) { // we could write a blob in one chunk
size_t s = stream.Read(buff, sizeof(buff));
if (Check(dbwritetext(GetDBLibConnection(), (char*) desc.m_ObjName.c_str(),
desc.m_TxtPtr_is_NULL ? 0 : desc.m_TxtPtr,
DBTXPLEN,
desc.m_TimeStamp_is_NULL ? 0 : desc.m_TimeStamp,
log_it ? TRUE : FALSE, (DBINT) s, (BYTE*) buff))
!= SUCCEED) {
DATABASE_DRIVER_ERROR( "dbwritetext failed." + GetDbgInfo(), 210030 );
}
return true;
}
// write it in chunks
if (Check(dbwritetext(GetDBLibConnection(), (char*) desc.m_ObjName.c_str(),
desc.m_TxtPtr_is_NULL ? 0 : desc.m_TxtPtr,
DBTXPLEN,
desc.m_TimeStamp_is_NULL ? 0 : desc.m_TimeStamp,
log_it ? TRUE : FALSE, (DBINT) size, 0)) != SUCCEED ||
Check(dbsqlok(GetDBLibConnection())) != SUCCEED ||
// dbresults(GetDBLibConnection()) == FAIL) {
x_Results(GetDBLibConnection()) == FAIL) {
DATABASE_DRIVER_ERROR( "dbwritetext/dbsqlok/dbresults failed." + GetDbgInfo(), 210031 );
}
while (size > 0) {
size_t s = stream.Read(buff, sizeof(buff));
if (s < 1) {
Check(dbcancel(GetDBLibConnection()));
DATABASE_DRIVER_ERROR("BLOB data corrupted." + GetDbgInfo(),
210032);
}
if (Check(dbmoretext(GetDBLibConnection(), (DBINT) s, (BYTE*) buff)) != SUCCEED) {
Check(dbcancel(GetDBLibConnection()));
DATABASE_DRIVER_ERROR( "dbmoretext failed." + GetDbgInfo(), 210033 );
}
size -= s;
}
// if (dbsqlok(GetDBLibConnection()) != SUCCEED || dbresults(GetDBLibConnection()) == FAIL) {
if (Check(dbsqlok(GetDBLibConnection())) != SUCCEED || x_Results(GetDBLibConnection()) == FAIL) {
DATABASE_DRIVER_ERROR( "dbsqlok/dbresults failed." + GetDbgInfo(), 210034 );
}
return true;
}
