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