/// <summary>
/// Simple helper method that creates a correct Rowset ready to be sent
/// to the EVE Online client based on the given MySqlDataReader
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static Rowset FromMySqlDataReader(MySqlDataReader reader)
{
PyList headers = new PyList(reader.FieldCount);
for (int i = 0; i < reader.FieldCount; i++)
{
headers[i] = reader.GetName(i);
}
Rowset result = new Rowset(headers);
while (reader.Read() == true)
{
PyList row = new PyList(reader.FieldCount);
for (int i = 0; i < reader.FieldCount; i++)
{
row[i] = Utils.ObjectFromColumn(reader, i);
}
result.Rows.Add(row);
}
return(result);
}
/// <summary>
/// Simple helper method that creates a correct Rowset ready to be sent
/// to the EVE Online client based on the given MySqlDataReader
/// </summary>
/// <param name="connection">The connection used</param>
/// <param name="reader"></param>
/// <returns></returns>
public static Rowset FromMySqlDataReader(IDatabaseConnection connection, MySqlDataReader reader)
{
connection.GetDatabaseHeaders(reader, out PyList <PyString> headers, out FieldType[] fieldTypes);
Rowset result = new Rowset(headers);
while (reader.Read() == true)
{
PyList row = new PyList(reader.FieldCount);
for (int i = 0; i < reader.FieldCount; i++)
{
row[i] = IDatabaseConnection.ObjectFromColumn(reader, fieldTypes[i], i);
}
result.Rows.Add(row);
}
return(result);
}