public void Test_Can_Convert_String()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(string), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("VARCHAR(200)", type);
}
public void Test_Can_Convert_Text()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(string), new Core.Data.DataFieldInfo()
{
DataFieldType = Core.Attributes.FieldType.Text
});
Assert.Equals("LONGTEXT", type);
}
public void Test_Can_Convert_Unicode_String()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(string), new Core.Data.DataFieldInfo()
{
DataFieldType = Core.Attributes.FieldType.UnicodeString
});
Assert.Equals("VARCHAR(200) CHARSET utf8", type);
}
public void Test_Can_Convert_timespan()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(TimeSpan), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("TIME", type);
}
public void Test_Can_Get_Default()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(this.GetType(), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("VARCHAR(200)", type);
}
public void Test_Can_Convert_Bool()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(bool), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("TINYINT(1)", type);
}
public void Test_Can_Convert_dates()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(DateTime), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("DATETIME", type);
}
public void Test_Can_Convert_Int64()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(long), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("BIGINT(20)", type);
}
public void Test_Can_Convert_ByteArray()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(byte[]), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("LONGBLOB", type);
}
public void Test_Can_Convert_Unicode_Text()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(string), new Core.Data.DataFieldInfo()
{
DataFieldType = Core.Attributes.FieldType.UnicodeText
});
Assert.AreEqual("LONGTEXT CHARSET utf8", type);
}
public void Test_Can_Convert_char()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(char), new Core.Data.DataFieldInfo()
{
});
Assert.AreEqual("VARCHAR(1)", type);
}
public void Test_Can_Convert_Unicode_Char()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(char), new Core.Data.DataFieldInfo()
{
DataFieldType = Core.Attributes.FieldType.UnicodeChar
});
Assert.AreEqual("VARCHAR(1) CHARSET utf8", type);
}
public void Test_Can_Convert_Int32()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(int), new Core.Data.DataFieldInfo()
{
});
Assert.AreEqual("INT(11)", type);
}
public void Test_Can_Override_String_Length_With_Max()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(string), new Core.Data.DataFieldInfo()
{
FieldLength = Int32.MaxValue
});
Assert.Equals("LONGTEXT", type);
}
public void Test_Can_Override_String_Length()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(string), new Core.Data.DataFieldInfo()
{
FieldLength = 400
});
Assert.Equals("VARCHAR(400)", type);
}
public void Test_Can_Convert_Float()
{
IConvertToDatastore mapper = new MySqlServerDBConverter();
string type = mapper.MapType(typeof(double), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("DOUBLE", type);
type = mapper.MapType(typeof(float), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("DOUBLE", type);
type = mapper.MapType(typeof(decimal), new Core.Data.DataFieldInfo()
{
});
Assert.Equals("NUMERIC", type);
}
