/// <summary> /// Instantiate a Table by directly deserializing byte data from the given Deserializer. /// </summary> /// <param name="input">The Deserializer providing the data for the table.</param> internal SingleRowTable(Deserializer input) : base(input) { // Validate row count. if (this.RowCount > 1) { throw new VoltInvalidDataException(Resources.InvalidRowCount, this.RowCount); } else if (this.RowCount == 0) { return; } // Total byte length of the row (ignored). int rowLength = input.ReadInt32(); // Read data and push in storage. for (short c = 0; c < this.ColumnCount; c++) { switch (ColumnType[c]) { case DBType.TINYINT: Column.SetValue(input.ReadSByteN(), c); break; case DBType.SMALLINT: Column.SetValue(input.ReadInt16N(), c); break; case DBType.INTEGER: Column.SetValue(input.ReadInt32N(), c); break; case DBType.BIGINT: Column.SetValue(input.ReadInt64N(), c); break; case DBType.FLOAT: Column.SetValue(input.ReadDoubleN(), c); break; case DBType.DECIMAL: Column.SetValue(input.ReadVoltDecimalN(), c); break; case DBType.TIMESTAMP: Column.SetValue(input.ReadDateTimeN(), c); break; case DBType.VARBINARY: Column.SetValue(input.ReadByteArray(), c); break; default: Column.SetValue(input.ReadString(), c); break; } } }
/// <summary> /// Instantiate a Table by directly deserializing byte data from the given Deserializer. /// </summary> /// <param name="input">The Deserializer providing the data for the table.</param> internal SingleRowTable(Deserializer input) : base(input) { // Validate row count. if (this.RowCount > 1) throw new VoltInvalidDataException(Resources.InvalidRowCount, this.RowCount); else if (this.RowCount == 0) return; // Total byte length of the row (ignored). int rowLength = input.ReadInt32(); // Read data and push in storage. for (short c = 0; c < this.ColumnCount; c++) { switch (ColumnType[c]) { case DBType.TINYINT: Column.SetValue(input.ReadSByteN(), c); break; case DBType.SMALLINT: Column.SetValue(input.ReadInt16N(), c); break; case DBType.INTEGER: Column.SetValue(input.ReadInt32N(), c); break; case DBType.BIGINT: Column.SetValue(input.ReadInt64N(), c); break; case DBType.FLOAT: Column.SetValue(input.ReadDoubleN(), c); break; case DBType.DECIMAL: Column.SetValue(input.ReadVoltDecimalN(), c); break; case DBType.TIMESTAMP: Column.SetValue(input.ReadDateTimeN(), c); break; case DBType.VARBINARY: Column.SetValue(input.ReadByteArray(), c); break; default: Column.SetValue(input.ReadString(), c); break; } } }
/// <summary> /// Instantiate a Table by directly deserializing byte data from the given Deserializer. /// </summary> /// <param name="input">The Deserializer providing the data for the table.</param> internal Table(Deserializer input) : base(input) { // Allocate column-based data storage. for (short c = 0; c < this.ColumnCount; c++) { switch (ColumnType[c]) { case DBType.TINYINT: Column[c] = new sbyte?[this.RowCount]; break; case DBType.SMALLINT: Column[c] = new short?[this.RowCount]; break; case DBType.INTEGER: Column[c] = new int?[this.RowCount]; break; case DBType.BIGINT: Column[c] = new long?[this.RowCount]; break; case DBType.FLOAT: Column[c] = new double?[this.RowCount]; break; case DBType.DECIMAL: Column[c] = new VoltDecimal?[this.RowCount]; break; case DBType.TIMESTAMP: Column[c] = new DateTime?[this.RowCount]; break; case DBType.STRING: Column[c] = new string[this.RowCount]; break; case DBType.VARBINARY: Column[c] = new byte[this.RowCount][]; break; default: throw new VoltUnsupportedTypeException(Resources.UnsupportedDBType, ColumnType[c]); } } // Get data and push to storage. for (int r = 0; r < this.RowCount; r++) { // Total byte length of the row (ignored). input.Skip(4); // Read data and push in storage. for (short c = 0; c < this.ColumnCount; c++) { switch (ColumnType[c]) { case DBType.TINYINT: (Column[c] as sbyte?[])[r] = input.ReadSByteN(); break; case DBType.SMALLINT: (Column[c] as short?[])[r] = input.ReadInt16N(); break; case DBType.INTEGER: (Column[c] as int?[])[r] = input.ReadInt32N(); break; case DBType.BIGINT: (Column[c] as long?[])[r] = input.ReadInt64N(); break; case DBType.FLOAT: (Column[c] as double?[])[r] = input.ReadDoubleN(); break; case DBType.DECIMAL: (Column[c] as VoltDecimal?[])[r] = input.ReadVoltDecimalN(); break; case DBType.TIMESTAMP: (Column[c] as DateTime?[])[r] = input.ReadDateTimeN(); break; case DBType.VARBINARY: (Column[c] as byte[][])[r] = input.ReadByteArray(); break; default: (Column[c] as string[])[r] = input.ReadString(); break; } } } // Attach the enumerable row collection. this._Rows = new RowCollection(this); }
/// <summary> /// Returns a straight data array (boxed) of the requested data type from a single-column Table. /// </summary> /// <param name="input">The deserializer hoding the response data.</param> /// <param name="TResult">The desired output data type of the array elements.</param> /// <returns>A boxed array of elements of the requested data type.</returns> internal static object FromSingleColumn(Deserializer input, Type TResult) { // Skip table length, metadata length, status, get column count. short columnCount = input.Skip(9).ReadInt16(); // Validate there is indeed only one column. if (columnCount != 1) { throw new VoltInvalidDataException(Resources.InvalidColumnCount, columnCount); } // Read column data type. DBType columnType = (DBType)input.ReadSByte(); // Validate the data type matches the .NET casting request. if (VoltType.ToDBType(TResult) != columnType) { throw new VoltInvalidCastException( Resources.InvalidCastException , columnType.ToString() , TResult.ToString() ); } // Skip column name, get Row count. int rowCount = input.SkipString().ReadInt32(); // Load data. switch (VoltType.ToNetType(TResult)) { case VoltType.NetType.Byte: byte[] dataByte = new byte[rowCount]; for (int r = 0; r < rowCount; r++) { dataByte[r] = input.Skip(4).ReadByte(); } return(dataByte); case VoltType.NetType.ByteN: byte?[] dataByteN = new byte?[rowCount]; for (int r = 0; r < rowCount; r++) { dataByteN[r] = input.Skip(4).ReadByteN(); } return(dataByteN); case VoltType.NetType.SByte: sbyte[] dataSByte = new sbyte[rowCount]; for (int r = 0; r < rowCount; r++) { dataSByte[r] = input.Skip(4).ReadSByte(); } return(dataSByte); case VoltType.NetType.SByteN: sbyte?[] dataSByteN = new sbyte?[rowCount]; for (int r = 0; r < rowCount; r++) { dataSByteN[r] = input.Skip(4).ReadSByteN(); } return(dataSByteN); case VoltType.NetType.Int16: short[] dataInt16 = new short[rowCount]; for (int r = 0; r < rowCount; r++) { dataInt16[r] = input.Skip(4).ReadInt16(); } return(dataInt16); case VoltType.NetType.Int16N: short?[] dataInt16N = new short?[rowCount]; for (int r = 0; r < rowCount; r++) { dataInt16N[r] = input.Skip(4).ReadInt16N(); } return(dataInt16N); case VoltType.NetType.Int32: int[] dataInt32 = new int[rowCount]; for (int r = 0; r < rowCount; r++) { dataInt32[r] = input.Skip(4).ReadInt32(); } return(dataInt32); case VoltType.NetType.Int32N: int?[] dataInt32N = new int?[rowCount]; for (int r = 0; r < rowCount; r++) { dataInt32N[r] = input.Skip(4).ReadInt32N(); } return(dataInt32N); case VoltType.NetType.Int64: long[] dataInt64 = new long[rowCount]; for (int r = 0; r < rowCount; r++) { dataInt64[r] = input.Skip(4).ReadInt64(); } return(dataInt64); case VoltType.NetType.Int64N: long?[] dataInt64N = new long?[rowCount]; for (int r = 0; r < rowCount; r++) { dataInt64N[r] = input.Skip(4).ReadInt64N(); } return(dataInt64N); case VoltType.NetType.Double: double[] dataDouble = new double[rowCount]; for (int r = 0; r < rowCount; r++) { dataDouble[r] = input.Skip(4).ReadDouble(); } return(dataDouble); case VoltType.NetType.DoubleN: double?[] dataDoubleN = new double?[rowCount]; for (int r = 0; r < rowCount; r++) { dataDoubleN[r] = input.Skip(4).ReadDoubleN(); } return(dataDoubleN); case VoltType.NetType.DateTime: DateTime[] dataDateTime = new DateTime[rowCount]; for (int r = 0; r < rowCount; r++) { dataDateTime[r] = input.Skip(4).ReadDateTime(); } return(dataDateTime); case VoltType.NetType.DateTimeN: DateTime?[] dataDateTimeN = new DateTime?[rowCount]; for (int r = 0; r < rowCount; r++) { dataDateTimeN[r] = input.Skip(4).ReadDateTimeN(); } return(dataDateTimeN); case VoltType.NetType.String: string[] dataString = new string[rowCount]; for (int r = 0; r < rowCount; r++) { dataString[r] = input.Skip(4).ReadString(); } return(dataString); case VoltType.NetType.VoltDecimal: VoltDecimal[] dataVoltDecimal = new VoltDecimal[rowCount]; for (int r = 0; r < rowCount; r++) { dataVoltDecimal[r] = input.Skip(4).ReadVoltDecimal(); } return(dataVoltDecimal); case VoltType.NetType.VoltDecimalN: VoltDecimal?[] dataVoltDecimalN = new VoltDecimal?[rowCount]; for (int r = 0; r < rowCount; r++) { dataVoltDecimalN[r] = input.Skip(4).ReadVoltDecimalN(); } return(dataVoltDecimalN); case VoltType.NetType.Decimal: Decimal[] dataDecimal = new Decimal[rowCount]; for (int r = 0; r < rowCount; r++) { dataDecimal[r] = input.Skip(4).ReadDecimal(); } return(dataDecimal); case VoltType.NetType.DecimalN: Decimal?[] dataDecimalN = new Decimal?[rowCount]; for (int r = 0; r < rowCount; r++) { dataDecimalN[r] = input.Skip(4).ReadDecimalN(); } return(dataDecimalN); case VoltType.NetType.ByteArray: input.Skip(4); return(input.ReadByteArray()); default: throw new VoltUnsupportedTypeException(Resources.UnsupportedParameterNETType, TResult.ToString()); } }