public void AbortingSequentialAccess(MySqlField[] fields, int startIndex) {
if (this.conn.Settings.UseUsageAdvisor) {
this.LogUAHeader(null);
Logger.WriteLine("");
Logger.WriteLine("A rowset that was being accessed using SequentialAccess had to load all of its remaining columns. This can cause performance problems. This is most likely due to calling Prepare() on a command before reading all the columns of a rowset that is being accessed with SequentialAccess");
LogUAFooter();
}
}
public void ReadPartialRowSet(string cmdText, bool[] uaFieldsUsed, MySqlField[] fields) {
if (this.conn.Settings.UseUsageAdvisor) {
this.LogUAHeader(cmdText);
Logger.WriteLine("Reason: Every column was not accessed. Consider a more focused query.");
Logger.Write("Fields not accessed: ");
for (int i = 0; i < uaFieldsUsed.Length; i++) {
if (!uaFieldsUsed[i]) {
Logger.Write(" " + fields[i].ColumnName);
}
}
Logger.WriteLine(" ");
LogUAFooter();
}
}
public abstract IMySqlValue ReadColumnValue(int index, MySqlField field, IMySqlValue value);
public abstract int PrepareStatement(string sql, ref MySqlField[] parameters);
public abstract IMySqlValue ReadColumnValue(int index, MySqlField field, IMySqlValue value);
public override IMySqlValue ReadColumnValue(int index, MySqlField field, IMySqlValue valObject) {
bool flag;
long length = -1L;
if (this.nullMap != null) {
flag = this.nullMap[index + 2];
} else {
length = this.stream.ReadFieldLength();
flag = length == -1L;
}
this.stream.Encoding = field.Encoding;
return valObject.ReadValue(this.stream, length, flag);
}
public override MySqlField[] ReadColumnMetadata(int count) {
MySqlField[] fieldArray = new MySqlField[count];
for (int i = 0; i < count; i++) {
fieldArray[i] = this.GetFieldMetaData();
}
this.ReadEOF();
return fieldArray;
}
public override int PrepareStatement(string sql, ref MySqlField[] parameters) {
byte[] bytes = base.encoding.GetBytes(sql);
this.ExecuteCommand(DBCmd.PREPARE, bytes, bytes.Length);
this.stream.OpenPacket();
if (this.stream.ReadByte() != 0) {
throw new MySqlException("Expected prepared statement marker");
}
int num2 = this.stream.ReadInteger(4);
int num3 = this.stream.ReadInteger(2);
int count = this.stream.ReadInteger(2);
this.stream.ReadInteger(3);
if (count > 0) {
parameters = this.ReadColumnMetadata(count);
for (int i = 0; i < parameters.Length; i++) {
parameters[i].Encoding = base.encoding;
}
}
if (num3 > 0) {
while (num3-- > 0) {
this.stream.OpenPacket();
this.stream.SkipPacket();
}
this.ReadEOF();
}
return num2;
}
private MySqlField GetFieldMetaData41() {
ColumnFlags flags;
MySqlField field = new MySqlField(base.connection);
this.stream.OpenPacket();
field.Encoding = base.encoding;
field.CatalogName = this.stream.ReadLenString();
field.DatabaseName = this.stream.ReadLenString();
field.TableName = this.stream.ReadLenString();
field.RealTableName = this.stream.ReadLenString();
field.ColumnName = this.stream.ReadLenString();
field.OriginalColumnName = this.stream.ReadLenString();
this.stream.ReadByte();
field.CharacterSetIndex = this.stream.ReadInteger(2);
field.ColumnLength = this.stream.ReadInteger(4);
MySqlDbType type = (MySqlDbType)this.stream.ReadByte();
if ((this.Flags & ClientFlags.LONG_FLAG) != 0) {
flags = (ColumnFlags)this.stream.ReadInteger(2);
} else {
flags = (ColumnFlags)this.stream.ReadByte();
}
field.SetTypeAndFlags(type, flags);
field.Scale = (byte)this.stream.ReadByte();
if (this.stream.HasMoreData) {
this.stream.ReadInteger(2);
}
if ((base.charSets != null) && (field.CharacterSetIndex != -1)) {
CharacterSet chararcterSet = CharSetMap.GetChararcterSet(base.Version, (string)base.charSets[field.CharacterSetIndex]);
field.MaxLength = chararcterSet.byteCount;
field.Encoding = CharSetMap.GetEncoding(base.version, (string)base.charSets[field.CharacterSetIndex]);
}
return field;
}
private MySqlField GetFieldMetaData() {
ColumnFlags flags;
this.stream.Encoding = base.encoding;
if (this.version.isAtLeast(4, 1, 0)) {
return this.GetFieldMetaData41();
}
this.stream.OpenPacket();
MySqlField field = new MySqlField(base.connection);
field.Encoding = base.encoding;
field.TableName = this.stream.ReadLenString();
field.ColumnName = this.stream.ReadLenString();
field.ColumnLength = this.stream.ReadNBytes();
MySqlDbType type = (MySqlDbType)this.stream.ReadNBytes();
this.stream.ReadByte();
if ((this.Flags & ClientFlags.LONG_FLAG) != 0) {
flags = (ColumnFlags)this.stream.ReadInteger(2);
} else {
flags = (ColumnFlags)this.stream.ReadByte();
}
field.SetTypeAndFlags(type, flags);
field.Scale = (byte)this.stream.ReadByte();
if (!this.version.isAtLeast(3, 0x17, 15) && this.version.isAtLeast(3, 0x17, 0)) {
field.Scale = (byte)(field.Scale + 1);
}
return field;
}
