float Sql_GetFloatData(Sql_t *self, size_t col)
{
if( self && self->row )
{
if( col < Sql_NumColumns(self) )
{
return (self->row[col] ? (float)atof(self->row[col]) : 0.f);
}
}
ShowFatalError("Sql_GetFloatData: SQL_ERROR\n");
return 0;
}
uint32 Sql_GetUIntData(Sql_t *self, size_t col)
{
if( self && self->row )
{
if( col < Sql_NumColumns(self) )
{
return (self->row[col] ? (uint32)strtoul(self->row[col],NULL,10) : 0);
}
}
ShowFatalError("Sql_GetUIntData: SQL_ERROR\n");
return 0;
}
int32 Sql_GetIntData(Sql_t *self, size_t col)
{
if( self && self->row )
{
if( col < Sql_NumColumns(self) )
{
return (self->row[col] ? (int32)atoi(self->row[col]) : 0);
}
}
ShowFatalError("Sql_GetIntData: SQL_ERROR\n");
return 0;
}
int8* Sql_GetData(Sql_t* self, size_t col)
{
if( self && self->row )
{
if( col < Sql_NumColumns(self) )
{
return self->row[col];
}
}
ShowFatalError("Sql_GetData: SQL_ERROR\n");
return NULL;
}
/// Gets the data of a column.
int Sql_GetData(Sql* self, size_t col, char** out_buf, size_t* out_len)
{
if( self && self->row )
{
if( col < Sql_NumColumns(self) )
{
if( out_buf ) *out_buf = self->row[col];
if( out_len ) *out_len = (size_t)self->lengths[col];
}
else
{// out of range - ignore
if( out_buf ) *out_buf = NULL;
if( out_len ) *out_len = 0;
}
return SQL_SUCCESS;
}
return SQL_ERROR;
}
int32 Sql_GetData(Sql_t* self, size_t col, char** out_buf, size_t* out_len)
{
if( self && self->row )
{
if( col < Sql_NumColumns(self) )
{
if( out_buf ) *out_buf = self->row[col];
if( out_len ) *out_len = (size_t)self->lengths[col];
}
else // out of range - ignore
{
if( out_buf ) *out_buf = NULL;
if( out_len ) *out_len = 0;
}
return SQL_SUCCESS;
}
ShowFatalError("Sql_GetData: SQL_ERROR\n");
return SQL_ERROR;
}
