public DataTypeList GetDataType(string FldKey)
{
DataTypeView dtv = _dataTypesService.GetDataTypeView(int.Parse(FldKey));
DataTypeList dataTypeList = new DataTypeList();
AddViewToList(dtv, ref dataTypeList);
return dataTypeList;
}
/// <summary>
/// Initializes a new instance of the <see cref="CubeDB.Data.Env"/> class.
/// </summary>
public Env(String name)
{
this.Name = name;
this._datatypes = new DataTypeList();
this._reservedWords = new List<string>();
}
private void AddViewToList(DataTypeView dtv, ref DataTypeList list)
{
// Map DataTypeView to DataType and add to DataTypeList
list.Add(new DataType()
{
FldKey = dtv.FldKey,
FldBigInt = dtv.FldBigInt.Trim(),
FldBit = dtv.FldBit.Trim(),
FldChar = dtv.FldChar.Trim(),
FldDateTime = dtv.FldDateTime.Trim(),
FldDecimal = dtv.FldDecimal.Trim(),
FldInt = dtv.FldInt.Trim(),
FldMoney = dtv.FldMoney.Trim(),
FldNChar = dtv.FldNChar.Trim(),
FldNText = dtv.FldNText.Trim(),
FldNumeric = dtv.FldNumeric.Trim(),
FldNVarChar = dtv.FldNVarChar.Trim(),
FldNVarCharMax = dtv.FldNVarCharMax.Trim(),
FldSmallDateTime = dtv.FldSmallDateTime.Trim(),
FldSmallInt = dtv.FldSmallInt.Trim(),
FldSmallMoney = dtv.FldSmallMoney.Trim(),
FldText = dtv.FldText.Trim(),
FldTinyInt = dtv.FldTinyInt.Trim(),
FldVarChar = dtv.FldVarChar.Trim(),
FldVarCharMax = dtv.FldVarCharMax.Trim()
});
}
public DataTypeList GetDataType(string FldKey)
{
DataTypeView dtv = _dataTypesService.GetDataTypeView(int.Parse(FldKey));
DataTypeList dataTypeList = new DataTypeList();
AddViewToList(dtv, ref dataTypeList);
return(dataTypeList);
}
public DataTypeList GetDataTypeList()
{
List<DataTypeView> dtvList = _dataTypesService.GetDataTypeViewList();
DataTypeList dataTypeList = new DataTypeList();
foreach (DataTypeView dtv in dtvList)
{
AddViewToList(dtv, ref dataTypeList);
}
return dataTypeList;
}
public DataTypeList GetDataTypeList()
{
List <DataTypeView> dtvList = _dataTypesService.GetDataTypeViewList();
DataTypeList dataTypeList = new DataTypeList();
foreach (DataTypeView dtv in dtvList)
{
AddViewToList(dtv, ref dataTypeList);
}
return(dataTypeList);
}
public void TestSqlServerTimeStampWithTimeZone()
{
//arrange
_column.DbDataType = "TIMESTAMP(6) WITH TIME ZONE";
_column.Precision = 6;
//automatically assign oracle datatypes
var types = new DataTypeList().Execute();
DatabaseSchemaFixer.UpdateDataTypes(types, new List <DatabaseColumn>(new [] { _column }));
//act
var result = _typeWriter.WriteDataType(_column);
//assert
Assert.AreEqual("TIMESTAMP (6) WITH TIME ZONE", result);
}
private void AddViewToList(DataTypeView dtv, ref DataTypeList list)
{
// Map DataTypeView to DataType and add to DataTypeList
list.Add(new DataType()
{
FldKey = dtv.FldKey,
FldBigInt = dtv.FldBigInt.Trim(),
FldBit = dtv.FldBit.Trim(),
FldChar = dtv.FldChar.Trim(),
FldDateTime = dtv.FldDateTime.Trim(),
FldDecimal = dtv.FldDecimal.Trim(),
FldInt = dtv.FldInt.Trim(),
FldMoney = dtv.FldMoney.Trim(),
FldNChar = dtv.FldNChar.Trim(),
FldNText = dtv.FldNText.Trim(),
FldNumeric = dtv.FldNumeric.Trim(),
FldNVarChar = dtv.FldNVarChar.Trim(),
FldNVarCharMax = dtv.FldNVarCharMax.Trim(),
FldSmallDateTime = dtv.FldSmallDateTime.Trim(),
FldSmallInt = dtv.FldSmallInt.Trim(),
FldSmallMoney = dtv.FldSmallMoney.Trim(),
FldText = dtv.FldText.Trim(),
FldTinyInt = dtv.FldTinyInt.Trim(),
FldVarChar = dtv.FldVarChar.Trim(),
FldVarCharMax = dtv.FldVarCharMax.Trim()
});
}
