public void TestMySqlDbTypeNameToClientTypeResolverForFloat()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("FLOAT");
// Assert
Assert.AreEqual(typeof(float), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForMediumInt()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("MEDIUMINT");
// Assert
Assert.AreEqual(typeof(int), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForMultiLineString()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("MULTILINESTRING");
// Assert
Assert.AreEqual(typeof(byte[]), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForReal()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("REAL");
// Assert
Assert.AreEqual(typeof(double), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForBit()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("BIT");
// Assert
Assert.AreEqual(typeof(ulong), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForBinary()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("BINARY");
// Assert
Assert.AreEqual(typeof(byte[]), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForVarChar()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("VARCHAR");
// Assert
Assert.AreEqual(typeof(string), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForSmallInt()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("SMALLINT");
// Assert
Assert.AreEqual(typeof(short), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForLongText()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("LONGTEXT");
// Assert
Assert.AreEqual(typeof(string), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForInteger()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("INTEGER");
// Assert
Assert.AreEqual(typeof(long), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForBoolean()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("BOOLEAN");
// Assert
Assert.AreEqual(typeof(bool), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForPolygon()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("POLYGON");
// Assert
Assert.AreEqual(typeof(byte[]), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForMultiPoint()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("MULTIPOINT");
// Assert
Assert.AreEqual(typeof(byte[]), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForYear()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("YEAR");
// Assert
Assert.AreEqual(typeof(int), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForTimeStamp()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("TIMESTAMP");
// Assert
Assert.AreEqual(typeof(DateTime), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForBlobAsArray()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("BLOBASARRAY");
// Assert
Assert.AreEqual(typeof(byte[]), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForTime()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("TIME");
// Assert
Assert.AreEqual(typeof(TimeSpan), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForTinyInt()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("TINYINT");
// Assert
Assert.AreEqual(typeof(sbyte), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForDecimal2()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("DECIMAL2");
// Assert
Assert.AreEqual(typeof(decimal), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForNone()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("NONE");
// Assert
Assert.AreEqual(typeof(object), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForNumeric()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("NUMERIC");
// Assert
Assert.AreEqual(typeof(decimal), result);
}
public void TestMySqlDbTypeNameToClientTypeResolverForMediumBlob()
{
// Setup
var resolver = new MySqlDbTypeNameToClientTypeResolver();
// Act
var result = resolver.Resolve("MEDIUMBLOB");
// Assert
Assert.AreEqual(typeof(byte[]), result);
}
/// <summary>
/// Creates a new instance of <see cref="MySqlDbHelper"/> class.
/// </summary>
public MySqlDbHelper()
{
DbTypeResolver = new MySqlDbTypeNameToClientTypeResolver();
}
