コード例 #1
0
        MyStructData ReadCurrentRowTextProtocol(MySqlFieldDefinition f)
        {
            BufferReader  r            = this.bufferReader;
            MyStructData  data         = new MyStructData();
            MySqlDataType type         = (MySqlDataType)f.FieldType;
            string        numberString = null;

            switch (type)
            {
            case MySqlDataType.TIMESTAMP:
            case MySqlDataType.DATE:
            case MySqlDataType.DATETIME:
            case MySqlDataType.NEWDATE:
            {
                QueryParsingConfig qparsingConfig = _queryParsingConf;
                tmpStringBuilder.Length = 0;        //clear
                data.myString           = r.ReadLengthCodedString(this.StringConverter);
                data.type = type;
                if (data.myString == null)
                {
                    data.type = MySqlDataType.NULL;
                    return(data);
                }
                if (qparsingConfig.DateStrings)
                {
                    return(data);
                }
                if (data.myString == "0000-00-00")
                {
                    data.myDateTime = DateTime.MinValue;        //?
                    data.type       = type;
                    return(data);
                }
                //-------------------------------------------------------------
                //    var originalString = dateString;
                //    if (field.type === Types.DATE) {
                //      dateString += ' 00:00:00';
                //    }
                tmpStringBuilder.Append(data.myString);
                //string originalString = dateString;
                if (type == MySqlDataType.DATE)
                {
                    tmpStringBuilder.Append(" 00:00:00");
                }
                //    if (timeZone !== 'local') {
                //      dateString += ' ' + timeZone;
                //    }

                if (!qparsingConfig.UseLocalTimeZone)
                {
                    tmpStringBuilder.Append(' ' + qparsingConfig.TimeZone);
                }
                //var dt;
                //    dt = new Date(dateString);
                //    if (isNaN(dt.getTime())) {
                //      return originalString;
                //    }

                data.myDateTime = DateTime.Parse(tmpStringBuilder.ToString(),
                                                 System.Globalization.CultureInfo.InvariantCulture);
                data.type = type;
                tmpStringBuilder.Length = 0;        //clear
            }
                return(data);

            case MySqlDataType.TINY:
            case MySqlDataType.SHORT:
            case MySqlDataType.LONG:
            case MySqlDataType.INT24:
            case MySqlDataType.YEAR:

                //TODO: review here,
                data.myString = numberString = r.ReadLengthCodedString(this.StringConverter);
                if (numberString == null ||
                    (f.IsZeroFill && numberString[0] == '0') ||
                    numberString.Length == 0)
                {
                    data.type = MySqlDataType.NULL;
                }
                else
                {
                    data.myInt32 = Convert.ToInt32(numberString);
                    data.type    = type;
                }
                return(data);

            case MySqlDataType.FLOAT:
            case MySqlDataType.DOUBLE:
                data.myString = numberString = r.ReadLengthCodedString(this.StringConverter);
                if (numberString == null || (f.IsZeroFill && numberString[0] == '0'))
                {
                    data.type = MySqlDataType.NULL;
                }
                else
                {
                    data.myDouble = Convert.ToDouble(numberString);
                    data.type     = type;
                }
                return(data);

            //    return (numberString === null || (field.zeroFill && numberString[0] == "0"))
            //      ? numberString : Number(numberString);
            case MySqlDataType.NEWDECIMAL:
            case MySqlDataType.LONGLONG:
                //    numberString = parser.parseLengthCodedString();
                //    return (numberString === null || (field.zeroFill && numberString[0] == "0"))
                //      ? numberString
                //      : ((supportBigNumbers && (bigNumberStrings || (Number(numberString) > IEEE_754_BINARY_64_PRECISION)))
                //        ? numberString
                //        : Number(numberString));

                QueryParsingConfig config = _queryParsingConf;
                data.myString = numberString = r.ReadLengthCodedString(this.StringConverter);
                if (numberString == null || (f.IsZeroFill && numberString[0] == '0'))
                {
                    data.type = MySqlDataType.NULL;
                }
                else if (config.SupportBigNumbers &&
                         (config.BigNumberStrings || (Convert.ToInt64(numberString) > Packet.IEEE_754_BINARY_64_PRECISION)))
                {
                    //store as string ?
                    //TODO: review here  again
                    data.myString = numberString;
                    data.type     = type;
                    throw new NotSupportedException();
                }
                else if (type == MySqlDataType.LONGLONG)
                {
                    data.myInt64 = Convert.ToInt64(numberString);
                    data.type    = type;
                }
                else    //decimal
                {
                    data.myDecimal = Convert.ToDecimal(numberString);
                    data.type      = type;
                }
                return(data);

            case MySqlDataType.BIT:

                data.myBuffer = r.ReadLengthCodedBuffer();
                data.type     = type;
                return(data);

            //    return parser.parseLengthCodedBuffer();
            case MySqlDataType.STRING:
            case MySqlDataType.VAR_STRING:

            case MySqlDataType.TINY_BLOB:
            case MySqlDataType.MEDIUM_BLOB:
            case MySqlDataType.LONG_BLOB:
            case MySqlDataType.BLOB:
                if (f.MarkedAsBinary)
                {
                    data.myBuffer = r.ReadLengthCodedBuffer();
                    data.type     = (data.myBuffer != null) ? type : MySqlDataType.NULL;
                }
                else
                {
                    data.myString = r.ReadLengthCodedString(this.StringConverter);
                    data.type     = (data.myString != null) ? type : MySqlDataType.NULL;
                }
                return(data);

            //    return (field.charsetNr === Charsets.BINARY)
            //      ? parser.parseLengthCodedBuffer()
            //      : parser.parseLengthCodedString();
            case MySqlDataType.GEOMETRY:
                //TODO: unfinished
                data.type = MySqlDataType.GEOMETRY;
                return(data);

            default:
                data.myString = r.ReadLengthCodedString(this.StringConverter);
                data.type     = type;
                return(data);
            }
        }
コード例 #2
0
        MyStructData ReadCurrentRowTextProtocol(MySqlFieldDefinition f)
        {

            BufferReader r = this.bufferReader;
            MyStructData data = new MyStructData();
            MySqlDataType type = (MySqlDataType)f.FieldType;
            string numberString = null;
            switch (type)
            {

                case MySqlDataType.TIMESTAMP:
                case MySqlDataType.DATE:
                case MySqlDataType.DATETIME:
                case MySqlDataType.NEWDATE:
                    {

                        QueryParsingConfig qparsingConfig = _queryParsingConf;
                        tmpStringBuilder.Length = 0;//clear 
                        data.myString = r.ReadLengthCodedString(this.StringConverter);
                        data.type = type;
                        if (data.myString == null)
                        {
                            data.type = MySqlDataType.NULL;
                            return data;
                        }
                        if (qparsingConfig.DateStrings)
                        {
                            return data;
                        }

                        //-------------------------------------------------------------
                        //    var originalString = dateString;
                        //    if (field.type === Types.DATE) {
                        //      dateString += ' 00:00:00';
                        //    }
                        tmpStringBuilder.Append(data.myString);
                        //string originalString = dateString;
                        if (type == MySqlDataType.DATE)
                        {
                            tmpStringBuilder.Append(" 00:00:00");
                        }
                        //    if (timeZone !== 'local') {
                        //      dateString += ' ' + timeZone;
                        //    }

                        if (!qparsingConfig.UseLocalTimeZone)
                        {
                            tmpStringBuilder.Append(' ' + qparsingConfig.TimeZone);
                        }
                        //var dt;
                        //    dt = new Date(dateString);
                        //    if (isNaN(dt.getTime())) {
                        //      return originalString;
                        //    }

                        data.myDateTime = DateTime.Parse(tmpStringBuilder.ToString(),
                            System.Globalization.CultureInfo.InvariantCulture);
                        data.type = type;
                        tmpStringBuilder.Length = 0;//clear 
                    }
                    return data;
                case MySqlDataType.TINY:
                case MySqlDataType.SHORT:
                case MySqlDataType.LONG:
                case MySqlDataType.INT24:
                case MySqlDataType.YEAR:

                    //TODO: review here,                    
                    data.myString = numberString = r.ReadLengthCodedString(this.StringConverter);
                    if (numberString == null ||
                        (f.IsZeroFill && numberString[0] == '0') ||
                        numberString.Length == 0)
                    {
                        data.type = MySqlDataType.NULL;
                    }
                    else
                    {
                        data.myInt32 = Convert.ToInt32(numberString);
                        data.type = type;
                    }
                    return data;
                case MySqlDataType.FLOAT:
                case MySqlDataType.DOUBLE:
                    data.myString = numberString = r.ReadLengthCodedString(this.StringConverter);
                    if (numberString == null || (f.IsZeroFill && numberString[0] == '0'))
                    {
                        data.type = MySqlDataType.NULL;
                    }
                    else
                    {
                        data.myDouble = Convert.ToDouble(numberString);
                        data.type = type;
                    }
                    return data;
                //    return (numberString === null || (field.zeroFill && numberString[0] == "0"))
                //      ? numberString : Number(numberString);
                case MySqlDataType.NEWDECIMAL:
                case MySqlDataType.LONGLONG:
                    //    numberString = parser.parseLengthCodedString();
                    //    return (numberString === null || (field.zeroFill && numberString[0] == "0"))
                    //      ? numberString
                    //      : ((supportBigNumbers && (bigNumberStrings || (Number(numberString) > IEEE_754_BINARY_64_PRECISION)))
                    //        ? numberString
                    //        : Number(numberString));

                    QueryParsingConfig config = _queryParsingConf;
                    data.myString = numberString = r.ReadLengthCodedString(this.StringConverter);
                    if (numberString == null || (f.IsZeroFill && numberString[0] == '0'))
                    {
                        data.type = MySqlDataType.NULL;
                    }
                    else if (config.SupportBigNumbers &&
                        (config.BigNumberStrings || (Convert.ToInt64(numberString) > Packet.IEEE_754_BINARY_64_PRECISION)))
                    {
                        //store as string ?
                        //TODO: review here  again
                        data.myString = numberString;
                        data.type = type;
                        throw new NotSupportedException();
                    }
                    else if (type == MySqlDataType.LONGLONG)
                    {
                        data.myInt64 = Convert.ToInt64(numberString);
                        data.type = type;
                    }
                    else//decimal
                    {
                        data.myDecimal = Convert.ToDecimal(numberString);
                        data.type = type;
                    }
                    return data;
                case MySqlDataType.BIT:

                    data.myBuffer = r.ReadLengthCodedBuffer();
                    data.type = type;
                    return data;
                //    return parser.parseLengthCodedBuffer();
                case MySqlDataType.STRING:
                case MySqlDataType.VAR_STRING:

                case MySqlDataType.TINY_BLOB:
                case MySqlDataType.MEDIUM_BLOB:
                case MySqlDataType.LONG_BLOB:
                case MySqlDataType.BLOB:
                    if (f.MarkedAsBinary)
                    {
                        data.myBuffer = r.ReadLengthCodedBuffer();
                        data.type = (data.myBuffer != null) ? type : MySqlDataType.NULL;
                    }
                    else
                    {
                        data.myString = r.ReadLengthCodedString(this.StringConverter);
                        data.type = (data.myString != null) ? type : MySqlDataType.NULL;
                    }
                    return data;
                //    return (field.charsetNr === Charsets.BINARY)
                //      ? parser.parseLengthCodedBuffer()
                //      : parser.parseLengthCodedString();
                case MySqlDataType.GEOMETRY:
                    //TODO: unfinished
                    data.type = MySqlDataType.GEOMETRY;
                    return data;
                default:
                    data.myString = r.ReadLengthCodedString(this.StringConverter);
                    data.type = type;
                    return data;
            }
        }
コード例 #3
0
        MyStructData ReadCurrentRowBinaryProtocol(MySqlFieldDefinition f)
        {
            MySqlDataType fieldType = (MySqlDataType)f.FieldType;
            MyStructData  myData    = new MyStructData();
            BufferReader  r         = this.bufferReader;

            switch (fieldType)
            {
            case MySqlDataType.TIMESTAMP: //
            case MySqlDataType.DATE:      //
            case MySqlDataType.DATETIME:  //
            case MySqlDataType.NEWDATE:   //
                r.ReadLengthCodedDateTime(out myData.myDateTime);
                myData.type = fieldType;
                return(myData);

            case MySqlDataType.TINY:    //length = 1;
                myData.myInt32 = r.U1();
                myData.type    = fieldType;
                return(myData);

            case MySqlDataType.SHORT:   //length = 2;
            case MySqlDataType.YEAR:    //length = 2;
                myData.myInt32 = (int)r.U2();
                myData.type    = fieldType;
                return(myData);

            case MySqlDataType.INT24:
            case MySqlDataType.LONG:    //length = 4;
                myData.myInt32 = (int)r.U4();
                myData.type    = fieldType;
                return(myData);

            case MySqlDataType.FLOAT:
                myData.myDouble = r.ReadFloat();
                myData.type     = fieldType;
                return(myData);

            case MySqlDataType.DOUBLE:
                myData.myDouble = r.ReadDouble();
                myData.type     = fieldType;
                return(myData);

            case MySqlDataType.NEWDECIMAL:
                myData.myDecimal = r.ReadDecimal();
                myData.type      = fieldType;
                return(myData);

            case MySqlDataType.LONGLONG:
                myData.myInt64 = r.ReadInt64();
                myData.type    = fieldType;
                return(myData);

            case MySqlDataType.VARCHAR:
                myData.myString = r.ReadLengthCodedString(this.StringConverter);
                myData.type     = fieldType;
                return(myData);

            case MySqlDataType.BIT:
                myData.myBuffer = r.ReadLengthCodedBuffer();
                myData.type     = fieldType;
                return(myData);

            case MySqlDataType.STRING:
            case MySqlDataType.VAR_STRING:
            case MySqlDataType.TINY_BLOB:
            case MySqlDataType.MEDIUM_BLOB:
            case MySqlDataType.LONG_BLOB:
            case MySqlDataType.BLOB:
                if (f.MarkedAsBinary)
                {
                    myData.myBuffer = r.ReadLengthCodedBuffer();
                }
                else
                {
                    myData.myString = r.ReadLengthCodedString(this.StringConverter);
                }
                myData.type = fieldType;
                return(myData);

            case MySqlDataType.GEOMETRY:
                throw new NotSupportedException();

            default:
                myData.myBuffer = r.ReadLengthCodedBuffer();
                myData.type     = MySqlDataType.NULL;
                return(myData);
            }
        }
コード例 #4
0
 MyStructData ReadCurrentRowBinaryProtocol(MySqlFieldDefinition f)
 {
     MySqlDataType fieldType = (MySqlDataType)f.FieldType;
     MyStructData myData = new MyStructData();
     BufferReader r = this.bufferReader;
     switch (fieldType)
     {
         case MySqlDataType.TIMESTAMP://
         case MySqlDataType.DATE://
         case MySqlDataType.DATETIME://
         case MySqlDataType.NEWDATE://
             r.ReadLengthCodedDateTime(out myData.myDateTime);
             myData.type = fieldType;
             return myData;
         case MySqlDataType.TINY://length = 1;
             myData.myInt32 = r.U1();
             myData.type = fieldType;
             return myData;
         case MySqlDataType.SHORT://length = 2;
         case MySqlDataType.YEAR://length = 2;
             myData.myInt32 = (int)r.U2();
             myData.type = fieldType;
             return myData;
         case MySqlDataType.INT24:
         case MySqlDataType.LONG://length = 4;
             myData.myInt32 = (int)r.U4();
             myData.type = fieldType;
             return myData;
         case MySqlDataType.FLOAT:
             myData.myDouble = r.ReadFloat();
             myData.type = fieldType;
             return myData;
         case MySqlDataType.DOUBLE:
             myData.myDouble = r.ReadDouble();
             myData.type = fieldType;
             return myData;
         case MySqlDataType.NEWDECIMAL:
             myData.myDecimal = r.ReadDecimal();
             myData.type = fieldType;
             return myData;
         case MySqlDataType.LONGLONG:
             myData.myInt64 = r.ReadInt64();
             myData.type = fieldType;
             return myData;
         case MySqlDataType.STRING:
         case MySqlDataType.VARCHAR:
         case MySqlDataType.VAR_STRING:
             myData.myString = r.ReadLengthCodedString(this.StringConverter);
             myData.type = fieldType;
             return myData;
         case MySqlDataType.TINY_BLOB:
         case MySqlDataType.MEDIUM_BLOB:
         case MySqlDataType.LONG_BLOB:
         case MySqlDataType.BLOB:
         case MySqlDataType.BIT:
             myData.myBuffer = r.ReadLengthCodedBuffer();
             myData.type = fieldType;
             return myData;
         case MySqlDataType.GEOMETRY:
             throw new NotSupportedException();
         default:
             myData.myBuffer = r.ReadLengthCodedBuffer();
             myData.type = MySqlDataType.NULL;
             return myData;
     }
 }