Exemple #1
0
 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();
     }
 }
Exemple #2
0
 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();
     }
 }
Exemple #3
0
 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);
 }
Exemple #4
0
 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;
 }
Exemple #5
0
 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;
 }
Exemple #6
0
 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;
 }
Exemple #7
0
 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;
 }
        public override DataTable GetSchemaTable()
        {
            if ((this.fields == null) || (this.fields.Length == 0))
            {
                return(null);
            }
            DataTable table = new DataTable("SchemaTable");

            table.Columns.Add("ColumnName", typeof(string));
            table.Columns.Add("ColumnOrdinal", typeof(int));
            table.Columns.Add("ColumnSize", typeof(int));
            table.Columns.Add("NumericPrecision", typeof(int));
            table.Columns.Add("NumericScale", typeof(int));
            table.Columns.Add("IsUnique", typeof(bool));
            table.Columns.Add("IsKey", typeof(bool));
            DataColumn column = table.Columns["IsKey"];

            column.AllowDBNull = true;
            table.Columns.Add("BaseCatalogName", typeof(string));
            table.Columns.Add("BaseColumnName", typeof(string));
            table.Columns.Add("BaseSchemaName", typeof(string));
            table.Columns.Add("BaseTableName", typeof(string));
            table.Columns.Add("DataType", typeof(Type));
            table.Columns.Add("AllowDBNull", typeof(bool));
            table.Columns.Add("ProviderType", typeof(int));
            table.Columns.Add("IsAliased", typeof(bool));
            table.Columns.Add("IsExpression", typeof(bool));
            table.Columns.Add("IsIdentity", typeof(bool));
            table.Columns.Add("IsAutoIncrement", typeof(bool));
            table.Columns.Add("IsRowVersion", typeof(bool));
            table.Columns.Add("IsHidden", typeof(bool));
            table.Columns.Add("IsLong", typeof(bool));
            table.Columns.Add("IsReadOnly", typeof(bool));
            int num = 1;

            for (int i = 0; i < this.fields.Length; i++)
            {
                MySqlField field = this.fields[i];
                DataRow    row   = table.NewRow();
                row["ColumnName"]    = field.ColumnName;
                row["ColumnOrdinal"] = num++;
                row["ColumnSize"]    = field.IsTextField ? (field.ColumnLength / field.MaxLength) : field.ColumnLength;
                int precision = field.Precision;
                int scale     = field.Scale;
                if (precision != -1)
                {
                    row["NumericPrecision"] = (short)precision;
                }
                if (scale != -1)
                {
                    row["NumericScale"] = (short)scale;
                }
                row["DataType"]        = this.GetFieldType(i);
                row["ProviderType"]    = (int)field.Type;
                row["IsLong"]          = field.IsBlob && (field.ColumnLength > 0xff);
                row["AllowDBNull"]     = field.AllowsNull;
                row["IsReadOnly"]      = false;
                row["IsRowVersion"]    = false;
                row["IsUnique"]        = field.IsUnique;
                row["IsKey"]           = field.IsPrimaryKey;
                row["IsAutoIncrement"] = field.IsAutoIncrement;
                row["BaseSchemaName"]  = field.DatabaseName;
                row["BaseCatalogName"] = null;
                row["BaseTableName"]   = field.RealTableName;
                row["BaseColumnName"]  = field.OriginalColumnName;
                table.Rows.Add(row);
            }
            return(table);
        }
Exemple #9
0
 public abstract IMySqlValue ReadColumnValue(int index, MySqlField field, IMySqlValue value);
Exemple #10
0
 public abstract int PrepareStatement(string sql, ref MySqlField[] parameters);