Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
package Alachisoft.NCache.Common.DataStructures;
import Alachisoft.NCache.Common.Enum.AggregateFunctionType;
import com.alachisoft.ncache.runtime.util.JvDateFormatter;
import com.alachisoft.ncache.serialization.core.io.ICompactSerializable;
import com.alachisoft.ncache.serialization.core.io.NCacheObjectInput;
import com.alachisoft.ncache.serialization.core.io.NCacheObjectOutput;
import java.io.IOException;
import java.util.Date;
public class RecordSet implements ICompactSerializable {
private int _rowCount;
private int _hiddenColumnCount;
private java.util.HashMap _dataIntIndex;
private java.util.HashMap _dataStringIndex;
/**
* Initializes new
*/
public RecordSet() {
_rowCount = 0;
_hiddenColumnCount = 0;
_dataIntIndex = new java.util.HashMap();
_dataStringIndex = new java.util.HashMap();
}
/**
* Gets of object
*
* @param obj Object whose is required
* @return of object
*/
public static ColumnDataType ToColumnDataType(Object obj) {
if (obj instanceof String) {
return ColumnDataType.String;
} else if (obj instanceof java.math.BigDecimal) {
return ColumnDataType.Decimal;
} else if (obj instanceof Short) {
return ColumnDataType.Int16;
} else if (obj instanceof Integer) {
return ColumnDataType.Int32;
} else if (obj instanceof Long) {
return ColumnDataType.Int64;
} else if (obj instanceof Short) {
return ColumnDataType.UInt16;
} else if (obj instanceof Integer) {
return ColumnDataType.UInt32;
} else if (obj instanceof Long) {
return ColumnDataType.UInt64;
} else if (obj instanceof Double) {
return ColumnDataType.Double;
} else if (obj instanceof Float) {
return ColumnDataType.Float;
} else if (obj instanceof Byte) {
return ColumnDataType.Byte;
} else if (obj instanceof Byte) {
return ColumnDataType.SByte;
} else if (obj instanceof Boolean) {
return ColumnDataType.Bool;
} else if (obj instanceof Character) {
return ColumnDataType.Char;
} else if (obj instanceof java.util.Date) {
return ColumnDataType.DateTime;
} else if (obj instanceof com.alachisoft.ncache.runtime.queries.AverageResult)//AVG BUG
{
return ColumnDataType.AverageResult;
} else {
return ColumnDataType.Object;
}
}
/**
* Converts String represenation to appropriate object of specified
*
* @param stringValue String representation of object
* @param dataType of object
* @return
*/
public static Object ToObject(String stringValue, ColumnDataType dataType) {
switch (dataType) {
case Bool:
return Boolean.parseBoolean(stringValue);
case Byte:
return Byte.parseByte(stringValue);
case Char:
return Character.valueOf(stringValue.charAt(0));
case DateTime:
try {
java.text.DateFormat formatter = new JvDateFormatter("dd/MM/yyyy/HH/mm/ss/SSSS/ZZZZ");
formatter.parse(stringValue);
return formatter.getCalendar().getTime();
} catch (Exception e) {
throw new RuntimeException(e.getMessage(), e);
}
case Decimal:
return new java.math.BigDecimal(stringValue);
case Double:
return Double.parseDouble(stringValue);
case Float:
return Float.parseFloat(stringValue);
case Int16:
return Short.parseShort(stringValue);
case Int32:
return Integer.parseInt(stringValue);
case Int64:
return Long.parseLong(stringValue);
case SByte:
return Byte.parseByte(stringValue);
case String:
return stringValue;
case UInt16:
return Short.valueOf(stringValue);
case UInt32:
return Integer.valueOf(stringValue);
case UInt64:
return Long.valueOf(stringValue);
default:
throw new java.lang.ClassCastException();
}
}
public static String GetString(Object obj, ColumnDataType dataType) {
if (dataType == Alachisoft.NCache.Common.DataStructures.ColumnDataType.DateTime) {
java.text.DateFormat formatter = new JvDateFormatter("dd/MM/yyyy/HH/mm/ss/SSSS/ZZZZ");
String str = formatter.format((Date) obj);
return str;
} else {
return obj.toString();
}
}
/**
* Gets Dictionary containg all column indexes and
*/
public final java.util.HashMap getData() {
return _dataIntIndex;
}
/**
* Adds specified value in speicified cell
*
* @param value value to be added
* @param rowID Zero base row index in
* @param columnID Zero base column index in
*/
public final void Add(Object value, int rowID, int columnID) {
if (_rowCount <= rowID) {
throw new IllegalArgumentException("Invalid rowID. No of rows in RecordSet are less than specified rowID.");
}
if (this.getColumnCount() <= columnID) {
throw new IllegalArgumentException("Invalid columnID. No of columns in RecordSet are less than specified columnID.");
}
_dataIntIndex.get(columnID).Add(value, rowID);
}
/**
* Adds specified value in speicified cell
*
* @param value value to be added
* @param rowID Zero base row index in
* @param columnName Column name in
*/
public final void Add(Object value, int rowID, String columnName) {
if (_rowCount <= rowID) {
throw new IllegalArgumentException("Invalid rowID. No of rows in RecordSet are less than specified rowID.");
}
if (!_dataStringIndex.containsKey(columnName)) {
throw new IllegalArgumentException("Invalid columnName. Specified column does not exist in RecordSet.");
}
_dataStringIndex.get(columnName).Add(value, rowID);
}
/**
* Adds a new row in
*/
public final void AddRow() {
_rowCount++;
}
/**
* Adds a new column in
*
* @param columnName Name of column
* @param isHidden IsHidden property of column
* @return fasle if column with same name already exists, true otherwise
*/
public final boolean AddColumn(String columnName, boolean isHidden) {
return this.AddColumn(columnName, isHidden, ColumnType.AttributeColumn, AggregateFunctionType.NOTAPPLICABLE);
}
/**
* Adds a new column in
*
* @param columnName Name of column
* @param isHidden IsHidden property of column
* @param aggregateFunctionType
* @return fasle if column with same name already exists, true otherwise
*/
public final boolean AddColumn(String columnName, boolean isHidden, AggregateFunctionType aggregateFunctionType) {
return this.AddColumn(columnName, isHidden, ColumnType.AttributeColumn, aggregateFunctionType);
}
/**
* Adds a new column in
*
* @param columnName Name of column
* @param isHidden IsHidden property of column
* @param columnType
* @param aggregateFunctionType
* @return fasle if column with same name already exists, true otherwise
*/
public final boolean AddColumn(String columnName, boolean isHidden, ColumnType columnType, AggregateFunctionType aggregateFunctionType) {
if (_dataStringIndex.containsKey(columnName)) {
return false;
}
RecordColumn column = new RecordColumn(columnName, isHidden);
column.setType(columnType);
column.setAggregateFunctionType(aggregateFunctionType);
_dataIntIndex.put(this.getColumnCount(), column);
_dataStringIndex.put(columnName, column);
if (isHidden)
_hiddenColumnCount++;
return true;
}
/**
* Gets object at specified cell
*
* @param rowID Zero based row ID
* @param columnID Zero based column ID
* @return Object at specified row and column
*/
public final Object GetObject(int rowID, int columnID) {
if (_rowCount <= rowID) {
throw new IllegalArgumentException("Invalid rowID. No of rows in RecordSet are less than specified rowID.");
}
if (this.getColumnCount() <= columnID) {
throw new IllegalArgumentException("Invalid columnID. No of columns in RecordSet are less than specified columnID.");
}
return _dataIntIndex.get(columnID).Get(rowID);
}
/**
* Gets object at specified cell
*
* @param rowID Zero based row ID
* @param columnName Name of column
* @return Object at specified row and column
*/
public final Object GetObject(int rowID, String columnName) {
if (_rowCount <= rowID) {
throw new IllegalArgumentException("Invalid rowID. No of rows in RecordSet are less than specified rowID.");
}
if (!_dataStringIndex.containsKey(columnName)) {
throw new IllegalArgumentException("Invalid columnName. Specified column does not exist in RecordSet.");
}
return _dataStringIndex.get(columnName).Get(rowID);
}
/**
* Gets column name of specified column ID
*
* @param columnID Zero based ID of column
* @return Name of column
*/
public final String GetColumnName(int columnID) {
if (this.getColumnCount() <= columnID) {
throw new IllegalArgumentException("Invalid columnID. No of columns in RecordSet are less than specified columnID.");
}
return _dataIntIndex.get(columnID).getName();
}
public final int GetColumnIndex(String columnName) {
if (!_dataStringIndex.containsKey(columnName)) {
throw new IllegalArgumentException("Invalid column name. Specified column does not exist in RecordSet.");
}
for (int i = 0; i < _dataIntIndex.size(); i++) {
if (_dataIntIndex.get(i).getName() == columnName)
return i;
}
throw new IllegalArgumentException("Invalid column name. Specified column does not exist in RecordSet.");
}
/**
* Sets IsHidden property of specified column name true
*
* @param columnName Name of column
*/
public final void HideColumn(String columnName) {
if (_dataStringIndex.containsKey(columnName)) {
if (_dataStringIndex.get(columnName).getIsHidden())
return;
else {
_dataStringIndex.get(columnName).setIsHidden(true);
_hiddenColumnCount++;
}
}
}
/**
* Sets IsHidden property of specified column false
*
* @param columnName Name of column
*/
public final void UnHideColumn(String columnName) {
if (_dataStringIndex.containsKey(columnName)) {
if (!_dataStringIndex.get(columnName).getIsHidden())
return;
else {
_dataStringIndex.get(columnName).setIsHidden(false);
_hiddenColumnCount--;
}
} else {
throw new IllegalArgumentException("Invalid columnName. Specified column does not exist in RecordSet.");
}
}
public final boolean GetIsHiddenColumn(int columnID) {
if (this.getColumnCount() <= columnID) {
throw new IllegalArgumentException("Invalid columnID. No of columns in RecordSet are less than specified columnID.");
} else {
return _dataIntIndex.get(columnID).getIsHidden();
}
}
public final boolean GetIsHiddenColumn(String columnName) {
if (_dataStringIndex.containsKey(columnName)) {
return _dataStringIndex.get(columnName).getIsHidden();
} else {
throw new IllegalArgumentException("Invalid columnName. Specified column does not exist in RecordSet.");
}
}
/**
* Sets of specified column
*
* @param columnName Name of column
* @param dataType to set
*/
public final void SetColumnDataType(String columnName, ColumnDataType dataType) {
if (_dataStringIndex.containsKey(columnName)) {
_dataStringIndex.get(columnName).setDataType(dataType);
} else {
throw new IllegalArgumentException("Invalid columnName. Specified column does not exist in RecordSet.");
}
}
/**
* Sets of specified column
*
* @param index Zero based index of column
* @param dataType to set
*/
public final void SetColumnDataType(int index, ColumnDataType dataType) {
if (_dataIntIndex.containsKey(index)) {
_dataIntIndex.get(index).setDataType(dataType);
} else {
throw new IllegalArgumentException("Invalid column index. Specified column does not exist in RecordSet.");
}
}
/**
* Gets of specified column
*
* @param columnName Name of column
* @return of column
*/
public final ColumnDataType GetColumnDataType(String columnName) {
if (_dataStringIndex.containsKey(columnName)) {
return _dataStringIndex.get(columnName).getDataType();
} else {
throw new IllegalArgumentException("Invalid columnName. Specified column does not exist in RecordSet.");
}
}
/**
* Gets of specified column
*
* @param index Zero based index of column
* @return of column
*/
public final ColumnDataType GetColumnDataType(int index) {
if (_dataIntIndex.containsKey(index)) {
return _dataIntIndex.get(index).getDataType();
} else {
throw new IllegalArgumentException("Invalid column index. Specified column does not exist in RecordSet.");
}
}
/**
* Sets of specifeid column
*
* @param columnName Name of column
* @param type to set
*/
public final void SetAggregateFunctionType(String columnName, AggregateFunctionType type) {
_dataStringIndex.get(columnName).setAggregateFunctionType(type);
}
/**
* Gets of specified column
*
* @param columnName Name of column
* @return of column
*/
public final AggregateFunctionType GetAggregateFunctionType(String columnName) {
return _dataStringIndex.get(columnName).getAggregateFunctionType();
}
/**
* Removes last column from
*/
public final void RemoveLastColumn() {
_dataStringIndex.remove(this.GetColumnName(this.getColumnCount() - 1));
if (_dataIntIndex.get(_dataIntIndex.size() - 1).getIsHidden())
_hiddenColumnCount--;
_dataIntIndex.remove(_dataIntIndex.size() - 1);
}
/**
* Gets number of rows in
*/
public final int getRowCount() {
return _rowCount;
}
/**
* Gets number of columns in
*/
public final int getColumnCount() {
return _dataStringIndex.size();
}
public final int getHiddenColumnCount() {
return _hiddenColumnCount;
}
public final int getColumnIndex(String columnName) {
if (!_dataStringIndex.containsKey(columnName))
throw new IllegalArgumentException("Invalid column name. Specified column does not exist in RecordSet.");
for (int i = 0; i < _dataIntIndex.size(); i++) {
if (_dataIntIndex.get(i).getName().equals(columnName))
return i;
}
throw new IllegalArgumentException("Invalid column name. Specified column does not exist in RecordSet.");
}
/**
* Merges
*
* @param recordSet to merge
*/
public final void Union(RecordSet recordSet) {
if (this.getColumnCount() != recordSet.getColumnCount()) {
throw new UnsupportedOperationException("Cannot compute union of two RecordSet with different number of columns.");
}
int thisRowCount = this._rowCount;
for (int i = 0; i < recordSet.getRowCount(); i++) {
boolean recordMatch = false;
for (int l = 0; l < thisRowCount; l++) {
boolean rowMatch = true;
java.util.ArrayList aggregateColumns = new java.util.ArrayList();
for (java.util.Map.Entry kvp : _dataStringIndex.entrySet()) {
if (kvp.getValue().getType() == ColumnType.AggregateResultColumn) {
aggregateColumns.add(kvp.getKey());
continue;
}
if (recordSet.GetObject(i, kvp.getKey()).equals(this.GetObject(l, kvp.getKey()))) {
continue;
}
rowMatch = false;
break;
}
if (rowMatch) {
//Rows matched, merging aggregate result columns
for (String column : aggregateColumns) {
switch (this.GetAggregateFunctionType(column)) {
case SUM:
java.math.BigDecimal a = new java.math.BigDecimal(0);
java.math.BigDecimal b = new java.math.BigDecimal(0);
Object thisVal = this.GetObject(i, column);
Object otherVal = recordSet.GetObject(i, column);
java.math.BigDecimal sum = null;
if (thisVal == null && otherVal != null) {
sum = (java.math.BigDecimal) otherVal;
} else if (thisVal != null && otherVal == null) {
sum = (java.math.BigDecimal) thisVal;
} else if (thisVal != null && otherVal != null) {
a = (java.math.BigDecimal) thisVal;
b = (java.math.BigDecimal) otherVal;
sum = a.add(b);
}
if (sum != null) {
this.Add(sum, i, column);
// this.AggregateFunctionResult = sum;
} else {
this.Add(null, i, column);
// this.AggregateFunctionResult = null;
}
break;
case COUNT:
a = (java.math.BigDecimal) this.GetObject(i, column);
b = (java.math.BigDecimal) recordSet.GetObject(i, column);
java.math.BigDecimal count = a.add(b);
this.Add(count, i, column);
//this.AggregateFunctionResult = count;
break;
case MIN:
java.lang.Comparable thisValue = (java.lang.Comparable) this.GetObject(i, column);
java.lang.Comparable otherValue = (java.lang.Comparable) recordSet.GetObject(i, column);
java.lang.Comparable min = thisValue;
if (thisValue == null && otherValue != null) {
min = otherValue;
} else if (thisValue != null && otherValue == null) {
min = thisValue;
} else if (thisValue == null && otherValue == null) {
min = null;
} else if (otherValue.compareTo(thisValue) < 0) {
min = otherValue;
}
//this.AggregateFunctionResult = min;
this.Add(min, i, column);
break;
case MAX:
thisValue = (java.lang.Comparable) this.GetObject(i, column);
otherValue = (java.lang.Comparable) recordSet.GetObject(i, column);
java.lang.Comparable max = thisValue;
if (thisValue == null && otherValue != null) {
max = otherValue;
} else if (thisValue != null && otherValue == null) {
max = thisValue;
} else if (thisValue == null && otherValue == null) {
max = null;
} else if (otherValue.compareTo(thisValue) > 0) {
max = otherValue;
}
//this.AggregateFunctionResult = max;
this.Add(max, i, column);
break;
case AVG:
thisVal = this.GetObject(i, column);
otherVal = recordSet.GetObject(i, column);
com.alachisoft.ncache.runtime.queries.AverageResult avg = null;//AVG BUG
if (thisVal == null && otherVal != null) {
avg = (com.alachisoft.ncache.runtime.queries.AverageResult) otherVal;//AVG BUG
} else if (thisVal != null && otherVal == null) {
avg = (com.alachisoft.ncache.runtime.queries.AverageResult) thisVal;//AVG BUG
} else if (thisVal != null && otherVal != null) {
com.alachisoft.ncache.runtime.queries.AverageResult thisResult = (com.alachisoft.ncache.runtime.queries.AverageResult) thisVal;//AVG BUG
com.alachisoft.ncache.runtime.queries.AverageResult otherResult = (com.alachisoft.ncache.runtime.queries.AverageResult) otherVal;//AVG BUG
avg = new com.alachisoft.ncache.runtime.queries.AverageResult();//AVG BUG
avg.setSum(thisResult.getSum().add(otherResult.getSum()));
avg.setCount(thisResult.getCount().add(otherResult.getCount()));
}
if (avg != null) {
//this.AggregateFunctionResult = avg;
this.Add(avg, i, column);
} else {
//this.AggregateFunctionResult = null;
this.Add(null, i, column);
}
break;
}
}
recordMatch = true;
break;
}
}
if (recordMatch == true) {
continue;
}
this.AddRow();
//Append data to current record set
for (int j = 0; j < this.getColumnCount(); j++) {
this.Add(recordSet.GetObject(i, j), _rowCount - 1, j);
}
}
}
@Override
public void serialize(NCacheObjectOutput out) throws IOException {
out.write(_rowCount);
for (java.util.Map.Entry kvp : _dataStringIndex.entrySet()) {
out.writeObject(kvp.getKey());
out.writeObject(kvp.getValue());
}
}
@Override
public void deserialize(NCacheObjectInput in) throws IOException, ClassNotFoundException {
_rowCount = in.readInt();
for (int i = 0; i < this.getColumnCount(); i++) {
Object tempVar = in.readObject();
String key = (String) ((tempVar instanceof String) ? tempVar : null);
Object tempVar2 = in.readObject();
RecordColumn col = (RecordColumn) ((tempVar2 instanceof RecordColumn) ? tempVar2 : null);
_dataStringIndex.put(key, col);
_dataIntIndex.put(i, col);
}
}
}
