/// <summary>
/// Creates a row by fetching it from a result set.
/// </summary>
/// <param name="result">The result.</param>
/// <returns></returns>
internal static MySqlRow FetchFromResult(MySqlResult result)
{
// fetch data
IntPtr valueArr = MySqlNative.mysql_fetch_row(result.Handle);
if (valueArr == IntPtr.Zero)
{
return(null);
}
IntPtr lengthArr = MySqlNative.mysql_fetch_lengths(result.Handle);
int numFields = (int)MySqlNative.mysql_num_fields(result.Handle);
// create row
MySqlRow row = new MySqlRow();
row.result = result;
row.values = new object[numFields];
// lengths
long[] length = new long[numFields];
Marshal.Copy(lengthArr, length, 0, numFields);
// values
IntPtr[] valuePtrs = new IntPtr[numFields];
Marshal.Copy(valueArr, valuePtrs, 0, numFields);
for (int i = 0; i < numFields; i++)
{
row.values[i] = result.Fields[i].CastFrom(Marshal.PtrToStringAnsi(valuePtrs[i]));
}
return(row);
}
/// <summary>
/// Fetches the fields for the result set.
/// </summary>
private void FetchFields()
{
// fetch fields
IntPtr fieldsArr = MySqlNative.mysql_fetch_fields(handle);
int numFields = (int)MySqlNative.mysql_num_fields(handle);
// create
fields = new MySqlField[numFields];
// fields
for (int i = 0; i < numFields; i++)
{
// get field
MySqlField.Field field = (MySqlField.Field)Marshal.PtrToStructure(fieldsArr + (i * Marshal.SizeOf(typeof(MySqlField.Field))), typeof(MySqlField.Field));
// add
fields[i] = new MySqlField(field);
}
}