/// <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); }