public void TestMdsSqLiteConvertFieldResolverForByte()
{
// Setup
var setting = DbSettingMapper.Get <SqliteConnection>();
var resolver = new SqLiteConvertFieldResolver();
var field = new Field("Field", typeof(byte));
// Act
var result = resolver.Resolve(field, setting);
// Assert
Assert.AreEqual("CAST([Field] AS [BLOB])", result);
}
public void TestSqLiteConvertFieldResolverForDateTime()
{
// Setup
var setting = DbSettingMapper.Get <SQLiteConnection>();
var resolver = new SqLiteConvertFieldResolver();
var field = new Field("Field", typeof(DateTime));
// Act
var result = resolver.Resolve(field, setting);
// Assert
Assert.AreEqual("CAST([Field] AS [DATETIME])", result);
}
public void TestSdsSqLiteConvertFieldResolverForString()
{
// Setup
var setting = DbSettingMapper.Get <SQLiteConnection>();
var resolver = new SqLiteConvertFieldResolver();
var field = new Field("Field", typeof(string));
// Act
var result = resolver.Resolve(field, setting);
// Assert
Assert.AreEqual("CAST([Field] AS [TEXT])", result);
}
public void TestSqLiteConvertFieldResolverForDecimal()
{
// Setup
var setting = DbSettingMapper.Get <SqliteConnection>();
var resolver = new SqLiteConvertFieldResolver();
var field = new Field("Field", typeof(decimal));
// Act
var result = resolver.Resolve(field, setting);
// Assert
Assert.AreEqual("CAST([Field] AS [DECIMAL])", result);
}
