public void BasicVarChar_Create()
{
const string s = "Test string";
var sObj = DataObject.VarChar(s);
Assert.IsNotNull(sObj);
Assert.IsInstanceOf <DataObject>(sObj);
Assert.AreEqual(SqlTypeCode.VarChar, sObj.Type.TypeCode);
Assert.IsInstanceOf <SqlString>(sObj.Value);
Assert.AreEqual(s, sObj.Value);
}
public void BasicVarChar_Compare()
{
const string s = "Test string";
var sObj1 = DataObject.VarChar(s);
var sObj2 = DataObject.VarChar(s);
Assert.IsNotNull(sObj1);
Assert.IsNotNull(sObj2);
Assert.IsTrue(sObj1.IsComparableTo(sObj2));
Assert.AreEqual(0, sObj1.CompareTo(sObj2));
}
public void BasicVarChar_Convert_ToInteger_Fail()
{
const string s = "fail";
var obj = DataObject.VarChar(s);
Assert.IsNotNull(obj);
Assert.IsInstanceOf <StringType>(obj.Type);
Assert.AreEqual(SqlTypeCode.VarChar, obj.Type.TypeCode);
DataObject result = null;
Assert.DoesNotThrow(() => result = obj.CastTo(PrimitiveTypes.Numeric(SqlTypeCode.Integer)));
Assert.IsNotNull(result);
Assert.IsInstanceOf <NumericType>(result.Type);
Assert.IsTrue(result.IsNull);
}
public void BasicVarChar_Convert_ToBoolean_Success()
{
const string s = "true";
var obj = DataObject.VarChar(s);
Assert.IsNotNull(obj);
Assert.IsInstanceOf <StringType>(obj.Type);
Assert.AreEqual(SqlTypeCode.VarChar, obj.Type.TypeCode);
DataObject result = null;
Assert.DoesNotThrow(() => result = obj.CastTo(PrimitiveTypes.Boolean()));
Assert.IsNotNull(result);
Assert.IsInstanceOf <BooleanType>(result.Type);
Assert.IsFalse(result.IsNull);
Assert.AreEqual(true, (bool)result);
}
public void BasicVarChar_Add()
{
const string s1 = "First test string that comes ";
const string s2 = "before the second test string";
var sObj1 = DataObject.VarChar(s1);
var sObj2 = DataObject.VarChar(s2);
Assert.IsNotNull(sObj1);
Assert.IsNotNull(sObj2);
Assert.IsTrue(sObj1.IsComparableTo(sObj2));
DataObject result = null;
Assert.DoesNotThrow(() => result = sObj1.Add(sObj2));
Assert.IsNotNull(result);
Assert.AreEqual("First test string that comes before the second test string", (string)result);
}
public override DataObject GetValue(long rowNumber, int columnOffset)
{
if (rowNumber < 0 || rowNumber >= privBits.Count)
{
throw new ArgumentOutOfRangeException("rowNumber");
}
var pair = privBits[(int)rowNumber];
switch (columnOffset)
{
case 0:
return(DataObject.Integer(pair.Value));
case 1:
return(DataObject.VarChar(pair.Key));
default:
throw new ArgumentOutOfRangeException("columnOffset");
}
}