public override string GetScalarFunctionSql(MandatoryScalarFunctions function)
{
switch (function)
{
case MandatoryScalarFunctions.GetTodaysDate:
return("now()");
case MandatoryScalarFunctions.GetGuid:
return("gen_random_uuid()"); //requires pgcrypto e.g. CREATE EXTENSION pgcrypto;
default:
throw new ArgumentOutOfRangeException("function");
}
}
public override string GetScalarFunctionSql(MandatoryScalarFunctions function)
{
switch (function)
{
case MandatoryScalarFunctions.GetTodaysDate:
return("CURRENT_TIMESTAMP");
case MandatoryScalarFunctions.GetGuid:
return("SYS_GUID()");
default:
throw new ArgumentOutOfRangeException("function");
}
}
public override string GetScalarFunctionSql(MandatoryScalarFunctions function)
{
switch (function)
{
case MandatoryScalarFunctions.GetTodaysDate: //this works at least as of 5.7.19
return("now()");
case MandatoryScalarFunctions.GetGuid: //using this as defaults in columns requires MySql 8 (2018)
return("(uuid())");
default:
throw new ArgumentOutOfRangeException("function");
}
}
public override string GetScalarFunctionSql(MandatoryScalarFunctions function)
{
switch (function)
{
case MandatoryScalarFunctions.GetTodaysDate:
return("GETDATE()");
case MandatoryScalarFunctions.GetGuid:
return("newid()");
default:
throw new ArgumentOutOfRangeException("function");
}
}
public abstract string GetScalarFunctionSql(MandatoryScalarFunctions function);
