public void TestCtor()
{
var testInputAllBoolStrings = new List<string>
{
bool.TrueString,
bool.TrueString,
bool.FalseString,
bool.TrueString,
bool.FalseString,
bool.FalseString
};
var testInputAllBoolMssqlBit = new List<string> {"1", "0", "0", "1", "0", "1"};
var testInputAllDecimal = new List<string> {"0.0", "1.0", "3.4", "6.90", "8.098"};
var testInputAllInt = new List<string> {"2", "138", "56", "85", "-5"};
var testInputAllDate = new List<string>
{
DateTime.Today.ToLongDateString(),
DateTime.Today.ToShortDateString(),
"2015-03-04 09:23:55.554121"
};
var testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllBoolStrings.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.BOOL, testResult.PsDbType);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllBoolMssqlBit.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.BOOL, testResult.PsDbType);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllDecimal.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.DEC, testResult.PsDbType);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllInt.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.INT, testResult.PsDbType);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllDate.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.DATE, testResult.PsDbType);
var testInputMixed = new List<string>();
testInputMixed.AddRange(testInputAllBoolMssqlBit);
testInputMixed.Add("do you wanna earn more money");
testInputMixed.Add("sure we all do.");
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputMixed.ToArray());
Assert.IsTrue(testResult.PsDbType.StartsWith(NoFuture.Sql.Mssql.Md.PsTypeInfo.DEFAULT_PS_DB_TYPE));
var testInputAllBoolMixed = new List<string>();
testInputAllBoolMixed.AddRange(testInputAllBoolStrings);
testInputAllBoolMixed.AddRange(testInputAllBoolMssqlBit);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllBoolMixed.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.BOOL, testResult.PsDbType);
var testInputAllIntWithDecPt = new List<string> {"2.0", "138.0", "56.0", "85.0", "-5.0"};
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllIntWithDecPt.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.DEC, testResult.PsDbType);
}
public void TestCtor()
{
var testInputAllBoolStrings = new List <string>
{
bool.TrueString,
bool.TrueString,
bool.FalseString,
bool.TrueString,
bool.FalseString,
bool.FalseString
};
var testInputAllBoolMssqlBit = new List <string> {
"1", "0", "0", "1", "0", "1"
};
var testInputAllDecimal = new List <string> {
"0.0", "1.0", "3.4", "6.90", "8.098"
};
var testInputAllInt = new List <string> {
"2", "138", "56", "85", "-5"
};
var testInputAllDate = new List <string>
{
DateTime.Today.ToLongDateString(),
DateTime.Today.ToShortDateString(),
"2015-03-04 09:23:55.554121"
};
var testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllBoolStrings.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.BOOL, testResult.PsDbType);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllBoolMssqlBit.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.BOOL, testResult.PsDbType);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllDecimal.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.DEC, testResult.PsDbType);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllInt.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.INT, testResult.PsDbType);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllDate.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.DATE, testResult.PsDbType);
var testInputMixed = new List <string>();
testInputMixed.AddRange(testInputAllBoolMssqlBit);
testInputMixed.Add("do you wanna earn more money");
testInputMixed.Add("sure we all do.");
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputMixed.ToArray());
Assert.IsTrue(testResult.PsDbType.StartsWith(NoFuture.Sql.Mssql.Md.PsTypeInfo.DEFAULT_PS_DB_TYPE));
var testInputAllBoolMixed = new List <string>();
testInputAllBoolMixed.AddRange(testInputAllBoolStrings);
testInputAllBoolMixed.AddRange(testInputAllBoolMssqlBit);
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllBoolMixed.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.BOOL, testResult.PsDbType);
var testInputAllIntWithDecPt = new List <string> {
"2.0", "138.0", "56.0", "85.0", "-5.0"
};
testResult = new NoFuture.Sql.Mssql.Md.PsTypeInfo("test", testInputAllIntWithDecPt.ToArray());
Assert.AreEqual(NoFuture.Sql.Mssql.Md.PsTypeInfo.DEC, testResult.PsDbType);
}
