in test-outofproc/AddProductColumnTypes.cs [23:48]
public static ProductColumnTypes Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "addproduct-columntypes")] HttpRequestData req)
{
NameValueCollection queryStrings = HttpUtility.ParseQueryString(req.Url.Query);
var product = new ProductColumnTypes()
{
ProductId = int.Parse(queryStrings["productId"], null),
// Integer Types in MySql. reference: https://dev.mysql.com/doc/refman/8.0/en/numeric-types.html
BigIntType = int.MaxValue,
BitType = 1,
DecimalType = 1.2345M,
NumericType = 1.2345M,
SmallIntType = 0,
TinyIntType = 1,
FloatType = 1.2,
RealType = 1.2f,
DateType = DateTime.UtcNow.ToString("yyyy-MM-dd", CultureInfo.CreateSpecificCulture("en-US")),
DatetimeType = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.CreateSpecificCulture("en-US")),
TimeType = DateTime.UtcNow.TimeOfDay,
CharType = "test",
VarcharType = "test",
NcharType = "test",
NvarcharType = "test"
};
return product;
}