public static DbValue INSTR(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "INSTR"; args.EnsureMinCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); } int startIndex = 0; if (args.Length > 2) { DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (arg2type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg2type.Name.ToUpper()); } if (!Types.IsNullValue(arg2)) { startIndex = tools.GetInt(arg2); } } mstring sentence = tools.GetString(arg0); mstring word = tools.GetString(arg1); int index = -1; if (startIndex < sentence.Length) { if (startIndex > 0) { sentence = sentence.SubstringM(startIndex); } index = sentence.IndexOf(word); if (index > -1) { index += startIndex; } } return tools.AllocValue(index); }
public static DbValue NVL2(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "NVL2"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (arg0type.ID != arg1type.ID) { args.Expected(FunctionName, 0, "input " + arg0type.Name.ToString() + ", got " + arg1type.Name.ToUpper()); } if (arg0type.ID != arg2type.ID) { args.Expected(FunctionName, 0, "input " + arg0type.Name.ToString() + ", got " + arg2type.Name.ToUpper()); } if (Types.IsNullValue(arg0)) { return args[2]; } else { return args[1]; } }
public static DbValue CONCAT(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "CONCAT"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); } mstring s0 = tools.GetString(arg0); mstring s1 = tools.GetString(arg1); s0 = s0.AppendM(s1); return(tools.AllocValue(s0)); }
public static DbValue NVL2(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "NVL2"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (arg0type.ID != arg1type.ID) { args.Expected(FunctionName, 0, "input " + arg0type.Name.ToString() + ", got " + arg1type.Name.ToUpper()); } if (arg0type.ID != arg2type.ID) { args.Expected(FunctionName, 0, "input " + arg0type.Name.ToString() + ", got " + arg2type.Name.ToUpper()); } if (Types.IsNullValue(arg0)) { return(args[2]); } else { return(args[1]); } }
public static DbValue ADD_MONTHS(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "ADD_MONTHS"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg1type.Name.ToUpper()); } DateTime dt = tools.GetDateTime(arg0); int months = tools.GetInt(arg1); dt = dt.AddMonths(months); return(tools.AllocValue(dt)); }
public static DbValue ROUND(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "ROUND"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DOUBLE) { args.Expected(FunctionName, 0, "input DOUBLE, got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 1, "digits INT, got " + arg1type.Name.ToUpper()); } int digits = tools.GetInt(arg1); double x = tools.GetDouble(arg0); x = Math.Round(x, digits); return tools.AllocValue(x); }
public static DbValue ROUND(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "ROUND"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DOUBLE) { args.Expected(FunctionName, 0, "input DOUBLE, got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 1, "digits INT, got " + arg1type.Name.ToUpper()); } int digits = tools.GetInt(arg1); double x = tools.GetDouble(arg0); x = Math.Round(x, digits); return(tools.AllocValue(x)); }
public static DbValue ADD_MONTHS(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "ADD_MONTHS"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg1type.Name.ToUpper()); } DateTime dt = tools.GetDateTime(arg0); int months = tools.GetInt(arg1); dt = dt.AddMonths(months); return tools.AllocValue(dt); }
public static DbValue SUBSTRING(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "SUBSTRING"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); return null; } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 1, "count INT, got " + arg1type.Name.ToUpper()); return null; } DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (arg2type.ID != DbTypeID.INT) { args.Expected(FunctionName, 1, "count INT, got " + arg2type.Name.ToUpper()); return null; } mstring x = tools.GetString(arg0); int startIndex = tools.GetInt(arg1); if (startIndex < 0) { startIndex = 0; } int len = tools.GetInt(arg2); if (len < 0) { throw new ArgumentException(FunctionName + " length cannot be negative"); } if (startIndex + len > x.Length) { return tools.AllocValue(mstring.Prepare()); } else { mstring sub = x.SubstringM(startIndex, len); return tools.AllocValue(sub); } }
public static DbValue MONTHS_BETWEEN(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "MONTHS_BETWEEN"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg1type.Name.ToUpper()); } DateTime dt0 = tools.GetDateTime(arg0); DateTime dt1 = tools.GetDateTime(arg1); int daysInMonth0 = DateTime.DaysInMonth(dt0.Year, dt0.Month); int daysInMonth1 = DateTime.DaysInMonth(dt1.Year, dt1.Month); double btw = 0; if (dt0.Year == dt1.Year && dt0.Month == dt1.Month) //same month and same year { btw = (double)(dt0.Day - dt1.Day) / (double)daysInMonth0; } else if (dt0.Day == daysInMonth0 && dt1.Day == daysInMonth1) //both fall on the last day of their months { btw = 12 * (dt0.Year - dt1.Year) + dt0.Month - dt1.Month; } else { TimeSpan sp = dt0 - dt1; btw = sp.TotalDays / 31d; } return(tools.AllocValue(btw)); }
public static DbValue MONTHS_BETWEEN(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "MONTHS_BETWEEN"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg1type.Name.ToUpper()); } DateTime dt0 = tools.GetDateTime(arg0); DateTime dt1 = tools.GetDateTime(arg1); int daysInMonth0 = DateTime.DaysInMonth(dt0.Year, dt0.Month); int daysInMonth1 = DateTime.DaysInMonth(dt1.Year, dt1.Month); double btw = 0; if (dt0.Year == dt1.Year && dt0.Month == dt1.Month) //same month and same year { btw = (double)(dt0.Day - dt1.Day) / (double)daysInMonth0; } else if (dt0.Day == daysInMonth0 && dt1.Day == daysInMonth1) //both fall on the last day of their months { btw = 12 * (dt0.Year - dt1.Year) + dt0.Month - dt1.Month; } else { TimeSpan sp = dt0 - dt1; btw = sp.TotalDays / 31d; } return tools.AllocValue(btw); }
public static DbValue REVERSE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "REVERSE"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } mstring x = tools.GetString(arg0); mstring r = mstring.Prepare(); for (int i = x.Length-1; i >= 0; i--) { r = r.AppendM(x.SubstringM(i, 1)); } return tools.AllocValue(r); }
public static DbValue REVERSE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "REVERSE"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } mstring x = tools.GetString(arg0); mstring r = mstring.Prepare(); for (int i = x.Length - 1; i >= 0; i--) { r = r.AppendM(x.SubstringM(i, 1)); } return(tools.AllocValue(r)); }
public static DbValue SPACE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "SPACE"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg0type.Name.ToUpper()); return null; } int len = tools.GetInt(arg0); if (len < 1) { return tools.AllocValue(mstring.Prepare("")); } else { mstring s = mstring.Prepare(); for (int i = 0; i < len; i++) { s = s.AppendM(" "); } return tools.AllocValue(s); } }
public static DbValue REPLACE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "REPLACE"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); } DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (Types.IsNullValue(arg2)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg2type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg2type.Name.ToUpper()); } mstring sentence = tools.GetString(arg0); mstring word = tools.GetString(arg1); mstring replacement = tools.GetString(arg2); sentence = sentence.ReplaceM(ref word, ref replacement); return(tools.AllocValue(sentence)); }
public static DbValue LEFT(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "LEFT"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 1, "count INT, got " + arg1type.Name.ToUpper()); } mstring x = tools.GetString(arg0); int LeftCount = tools.GetInt(arg1); if (LeftCount >= x.Length) { // User requested the whole string. return(tools.AllocValue(arg0, arg0type)); } else if (LeftCount < 0) { throw new ArgumentException(FunctionName + " count cannot be negative"); } else { x = x.SubstringM(0, LeftCount); return(tools.AllocValue(x)); } }
public static DbValue REPLACE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "REPLACE"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); } DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (Types.IsNullValue(arg2)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg2type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg2type.Name.ToUpper()); } mstring sentence = tools.GetString(arg0); mstring word = tools.GetString(arg1); mstring replacement = tools.GetString(arg2); sentence = sentence.ReplaceM(ref word, ref replacement); return tools.AllocValue(sentence); }
public static DbValue PATINDEX(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "PATINDEX"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); } string pat = tools.GetString(arg0).ToString(); string str = tools.GetString(arg1).ToString(); pat = pat.Trim('%'); string rpat = GetRegexString(pat); System.Text.RegularExpressions.Regex regx = new System.Text.RegularExpressions.Regex(rpat); System.Text.RegularExpressions.Match match = regx.Match(str); int indx = -1; if (match != null) { indx = match.Index; } return(tools.AllocValue(indx)); }
public static DbValue LEFT(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "LEFT"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 1, "count INT, got " + arg1type.Name.ToUpper()); } mstring x = tools.GetString(arg0); int LeftCount = tools.GetInt(arg1); if (LeftCount >= x.Length) { // User requested the whole string. return tools.AllocValue(arg0, arg0type); } else if (LeftCount < 0) { throw new ArgumentException(FunctionName + " count cannot be negative"); } else { x = x.SubstringM(0, LeftCount); return tools.AllocValue(x); } }
public static DbValue ISLIKE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "ISLIKE"; args.EnsureCount(FunctionName, 2); int ismatch = 0; DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocValue(ismatch)); } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 1, "pattern CHAR(n), got " + arg1type.Name.ToUpper()); } string x = tools.GetString(arg0).ToString(); string y = tools.GetString(arg1).ToString(); string pattern = GetRegexString(y); if (pattern != null) { System.Text.RegularExpressions.Regex regx = new System.Text.RegularExpressions.Regex(pattern, System.Text.RegularExpressions.RegexOptions.IgnoreCase); if (regx.IsMatch(x)) { ismatch = 1; } } return(tools.AllocValue(ismatch)); }
public static DbValue ISLIKE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "ISLIKE"; args.EnsureCount(FunctionName, 2); int ismatch = 0; DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocValue(ismatch); } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 1, "pattern CHAR(n), got " + arg1type.Name.ToUpper()); } string x = tools.GetString(arg0).ToString(); string y = tools.GetString(arg1).ToString(); string pattern = GetRegexString(y); if (pattern != null) { System.Text.RegularExpressions.Regex regx = new System.Text.RegularExpressions.Regex(pattern, System.Text.RegularExpressions.RegexOptions.IgnoreCase); if(regx.IsMatch(x)) { ismatch = 1; } } return tools.AllocValue(ismatch); }
public static DbValue PATINDEX(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "PATINDEX"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); } string pat = tools.GetString(arg0).ToString(); string str = tools.GetString(arg1).ToString(); pat = pat.Trim('%'); string rpat = GetRegexString(pat); System.Text.RegularExpressions.Regex regx = new System.Text.RegularExpressions.Regex(rpat); System.Text.RegularExpressions.Match match = regx.Match(str); int indx = -1; if (match != null) { indx = match.Index; } return tools.AllocValue(indx); }
public static DbValue FORMAT(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "FORMAT"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg1type.Name.ToUpper()); } string formatstr = tools.GetString(arg0).ToString(); DateTime dt = tools.GetDateTime(arg1); mstring result = mstring.Prepare(dt.ToString(formatstr)); while (result.Length < 80) { result.MAppend('\0'); } return(tools.AllocValue(result)); }
public static DbValue FORMAT(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "FORMAT"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg1type.Name.ToUpper()); } string formatstr = tools.GetString(arg0).ToString(); DateTime dt = tools.GetDateTime(arg1); mstring result = mstring.Prepare(dt.ToString(formatstr)); while (result.Length < 80) { result.MAppend('\0'); } return tools.AllocValue(result); }
public static DbValue DEGREES(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "DEGREES"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } double d = 0; switch (arg0type.ID) { case DbTypeID.INT: { int x = tools.GetInt(arg0); d = (double)x; } break; case DbTypeID.LONG: { long x = tools.GetLong(arg0); d = (double)x; } break; case DbTypeID.DOUBLE: { d = tools.GetDouble(arg0); } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return(null); // Doesn't reach here. } double r = (d * 180d) / Math.PI; return(tools.AllocValue(r)); }
public static DbValue ABS(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "ABS"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } switch (arg0type.ID) { case DbTypeID.INT: { int x = tools.GetInt(arg0); x = Math.Abs(x); return tools.AllocValue(x); } break; case DbTypeID.LONG: { long x = tools.GetLong(arg0); x = Math.Abs(x); return tools.AllocValue(x); } break; case DbTypeID.DOUBLE: { double x = tools.GetDouble(arg0); x = Math.Abs(x); return tools.AllocValue(x); } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return null; // Doesn't reach here. } }
public static DbValue FLOOR(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "FLOOR"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DOUBLE) { args.Expected(FunctionName, 0, "input DOUBLE, got " + arg0type.Name.ToUpper()); } double x = tools.GetDouble(arg0); x = Math.Floor(x); return tools.AllocValue(x); }
public static DbValue LOWER(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "LOWER"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } mstring x = tools.GetString(arg0); mstring lower = x.ToLowerM(); return tools.AllocValue(lower); }
public static DbValue LTRIM(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "LTRIM"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } string x = tools.GetString(arg0).ToString(); string y = x.TrimStart(); return tools.AllocValue(mstring.Prepare(y)); }
public static DbValue LAST_DAY(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "LAST_DAY"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg0type.Name.ToUpper()); } DateTime dt = tools.GetDateTime(arg0); dt = dt.AddMonths(1); dt = dt.AddDays(-1); return tools.AllocValue(dt); }
public static DbValue LTRIM(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "LTRIM"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } string x = tools.GetString(arg0).ToString(); string y = x.TrimStart(); return(tools.AllocValue(mstring.Prepare(y))); }
public static DbValue NEXT_DAY(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "NEXT_DAY"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg0type.Name.ToUpper()); } DateTime dt = tools.GetDateTime(arg0); dt = dt.AddDays(1); return(tools.AllocValue(dt)); }
public static DbValue CEILING(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "CEILING"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DOUBLE) { args.Expected(FunctionName, 0, "input DOUBLE, got " + arg0type.Name.ToUpper()); } double x = tools.GetDouble(arg0); x = Math.Ceiling(x); return(tools.AllocValue(x)); }
public static DbValue LEN(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "LEN"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } mstring x = tools.GetString(arg0); int len = x.Length; return(tools.AllocValue(len)); }
public static DbValue SPACE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "SPACE"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg0type.Name.ToUpper()); return(null); } int len = tools.GetInt(arg0); if (len < 1) { return(tools.AllocValue(mstring.Prepare(""))); } else { mstring s = mstring.Prepare(); for (int i = 0; i < len; i++) { s = s.AppendM(" "); } return(tools.AllocValue(s)); } }
public static DbValue RAND(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "RAND"; if (args.Length == 1) { DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { if (null == _rnd) { _rnd = new Random(); } } else { if (arg0type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg0type.Name.ToUpper()); } int seed = tools.GetInt(arg0); _rnd = new Random(seed); } } else { if (null == _rnd) { _rnd = new Random(); } } return tools.AllocValue(_rnd.NextDouble()); }
public static DbValue DATEPART_HOUR(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "DATEPART_HOUR"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DateTime, got " + arg0type.Name.ToUpper()); return(null); // Doesn't reach here. } DateTime dt = tools.GetDateTime(arg0); return(tools.AllocValue(dt.Hour)); }
public static DbValue DATEPART_YEAR(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "DATEPART_YEAR"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DateTime, got " + arg0type.Name.ToUpper()); return null; // Doesn't reach here. } DateTime dt = tools.GetDateTime(arg0); return tools.AllocValue(dt.Year); }
public static DbValue RAND(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "RAND"; if (args.Length == 1) { DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { if (null == _rnd) { _rnd = new Random(); } } else { if (arg0type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg0type.Name.ToUpper()); } int seed = tools.GetInt(arg0); _rnd = new Random(seed); } } else { if (null == _rnd) { _rnd = new Random(); } } return(tools.AllocValue(_rnd.NextDouble())); }
public static DbValue SUBSTRING(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "SUBSTRING"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); return(null); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 1, "count INT, got " + arg1type.Name.ToUpper()); return(null); } DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (arg2type.ID != DbTypeID.INT) { args.Expected(FunctionName, 1, "count INT, got " + arg2type.Name.ToUpper()); return(null); } mstring x = tools.GetString(arg0); int startIndex = tools.GetInt(arg1); if (startIndex < 0) { startIndex = 0; } int len = tools.GetInt(arg2); if (len < 0) { throw new ArgumentException(FunctionName + " length cannot be negative"); } if (startIndex + len > x.Length) { return(tools.AllocValue(mstring.Prepare())); } else { mstring sub = x.SubstringM(startIndex, len); return(tools.AllocValue(sub)); } }
public static DbValue DATEADD(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "DATEADD"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg1type.Name.ToUpper()); } if (Types.IsNullValue(arg2)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg2type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg2type.Name.ToUpper()); } string datepart = tools.GetString(arg0).ToUpperM().ToString(); int num = tools.GetInt(arg1); DateTime dt = tools.GetDateTime(arg2); DateTime newdt = dt; switch (datepart) { case "YEAR": case "YY": case "YYYY": newdt = dt.AddYears(num); break; case "QUARTER": case "QQ": case "Q": newdt = dt.AddMonths(num * 3); break; case "MONTH": case "MM": case "M": newdt = dt.AddMonths(num); break; case "DAY": case "DD": case "D": newdt = dt.AddDays(num); break; case "WEEK": case "WK": case "WW": newdt = dt.AddDays(7 * num); break; case "HOUR": case "HH": newdt = dt.AddHours(num); break; case "MINUTE": case "MI": case "N": newdt = dt.AddMinutes(num); break; case "SECOND": case "SS": case "S": newdt = dt.AddSeconds(num); break; case "MILLISECOND": case "MS": newdt = dt.AddMilliseconds(num); break; default: args.Expected(FunctionName, 0, "input datepart invalid"); return(null); } return(tools.AllocValue(newdt)); }
public static DbValue ATN2(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "ATN2"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0) || Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } double d1 = 0; double d2 = 0; switch (arg0type.ID) { case DbTypeID.INT: { int x = tools.GetInt(arg0); d1 = (double)x; } break; case DbTypeID.LONG: { long x = tools.GetLong(arg0); d1 = (double)x; } break; case DbTypeID.DOUBLE: { d1 = tools.GetDouble(arg0); } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return null; // Doesn't reach here. } switch (arg1type.ID) { case DbTypeID.INT: { int x = tools.GetInt(arg1); d2 = (double)x; } break; case DbTypeID.LONG: { long x = tools.GetLong(arg1); d2 = (double)x; } break; case DbTypeID.DOUBLE: { d2 = tools.GetDouble(arg1); } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return null; // Doesn't reach here. } d1 = Math.Atan2(d1, d2); return tools.AllocValue(d1); }
private static DbValue _PAD(string functionName, DbFunctionTools tools, DbFunctionArguments args, bool isLeft) { args.EnsureCount(functionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(functionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg1type.ID != DbTypeID.INT) { args.Expected(functionName, 0, "input INT, got " + arg1type.Name.ToUpper()); } DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (Types.IsNullValue(arg2)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg2type.ID != DbTypeID.CHARS) { args.Expected(functionName, 0, "input CHAR(n), got " + arg2type.Name.ToUpper()); } mstring str = tools.GetString(arg0); int totallen = tools.GetInt(arg1); mstring padstr = tools.GetString(arg2); if (str.Length > totallen) { str = str.SubstringM(0, totallen); } else if(str.Length < totallen) { int delta = totallen - str.Length; int padlen = padstr.Length; mstring newstr = mstring.Prepare(); for (int remain = delta; remain > 0; ) { newstr = newstr.AppendM(padstr); remain -= padlen; } //if we go over, truncate. if (newstr.Length > delta) { newstr = newstr.SubstringM(0, delta); } if (isLeft) { str = newstr.AppendM(str); } else { str = str.AppendM(newstr); } } return tools.AllocValue(str); }
public static DbValue DATEDIFF(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "DATEDIFF"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg1type.Name.ToUpper()); } if (Types.IsNullValue(arg2)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg2type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg2type.Name.ToUpper()); } string datepart = tools.GetString(arg0).ToUpperM().ToString(); DateTime startdate = tools.GetDateTime(arg1); DateTime enddate = tools.GetDateTime(arg2); double partdiff = 0; switch (datepart) { case "YEAR": case "YY": case "YYYY": partdiff = enddate.Year - startdate.Year; break; case "QUARTER": case "QQ": case "Q": partdiff = GetMonthDiff(startdate.Year, startdate.Month, enddate.Year, enddate.Month) / 3; break; case "MONTH": case "MM": case "M": partdiff = GetMonthDiff(startdate.Year, startdate.Month, enddate.Year, enddate.Month); break; case "DAY": case "DD": case "D": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day); TimeSpan sp = edate - sdate; partdiff = sp.TotalDays; } break; case "WEEK": case "WK": case "WW": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day); TimeSpan sp = edate - sdate; partdiff = (int)sp.TotalDays / 7; } break; case "HOUR": case "HH": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day, startdate.Hour, 0, 0); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day, enddate.Hour, 0, 0); TimeSpan sp = edate - sdate; partdiff = sp.TotalHours; } break; case "MINUTE": case "MI": case "N": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day, startdate.Hour, startdate.Minute, 0); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day, enddate.Hour, enddate.Minute, 0); TimeSpan sp = edate - sdate; partdiff = sp.TotalMinutes; } break; case "SECOND": case "SS": case "S": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day, startdate.Hour, startdate.Minute, startdate.Second); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day, enddate.Hour, enddate.Minute, enddate.Second); TimeSpan sp = edate - sdate; partdiff = sp.TotalSeconds; } break; case "MILLISECOND": case "MS": { TimeSpan sp = enddate - startdate; partdiff = sp.TotalMilliseconds; } break; default: args.Expected(FunctionName, 0, "input datepart invalid"); return null; } return tools.AllocValue(partdiff); }
private static DbValue _PAD(string functionName, DbFunctionTools tools, DbFunctionArguments args, bool isLeft) { args.EnsureCount(functionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(functionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.INT) { args.Expected(functionName, 0, "input INT, got " + arg1type.Name.ToUpper()); } DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (Types.IsNullValue(arg2)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg2type.ID != DbTypeID.CHARS) { args.Expected(functionName, 0, "input CHAR(n), got " + arg2type.Name.ToUpper()); } mstring str = tools.GetString(arg0); int totallen = tools.GetInt(arg1); mstring padstr = tools.GetString(arg2); if (str.Length > totallen) { str = str.SubstringM(0, totallen); } else if (str.Length < totallen) { int delta = totallen - str.Length; int padlen = padstr.Length; mstring newstr = mstring.Prepare(); for (int remain = delta; remain > 0;) { newstr = newstr.AppendM(padstr); remain -= padlen; } //if we go over, truncate. if (newstr.Length > delta) { newstr = newstr.SubstringM(0, delta); } if (isLeft) { str = newstr.AppendM(str); } else { str = str.AppendM(newstr); } } return(tools.AllocValue(str)); }
public static DbValue SIGN(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "SIGN"; args.EnsureCount(FunctionName, 1); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } int sign = 0; switch (arg0type.ID) { case DbTypeID.INT: { int x = tools.GetInt(arg0); if (x > 0) { sign = 1; } else if (x < 0) { sign = -1; } } break; case DbTypeID.LONG: { long x = tools.GetLong(arg0); if (x > 0) { sign = 1; } else if (x < 0) { sign = -1; } } break; case DbTypeID.DOUBLE: { double x = tools.GetDouble(arg0); if (x > 0) { sign = 1; } else if (x < 0) { sign = -1; } } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return(null); // Doesn't reach here. } return(tools.AllocValue(sign)); }
public static DbValue MOD(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "MOD"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } int i0, i1 = 0; long l0, l1 = 0; double d0, d1 = 0; switch (arg1type.ID) { case DbTypeID.INT: i1 = tools.GetInt(arg1); break; case DbTypeID.LONG: l1 = tools.GetLong(arg1); break; case DbTypeID.DOUBLE: d1 = tools.GetDouble(arg1); break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg1type.Name.ToUpper()); return(null); // Doesn't reach here. } if (i1 == 0 && l1 == 0 && d1 == 0) { args.Expected(FunctionName, 0, "Division by zero"); return(null); } switch (arg0type.ID) { case DbTypeID.INT: { i0 = tools.GetInt(arg0); switch (arg1type.ID) { case DbTypeID.INT: { int rem = i0 % i1; return(tools.AllocValue(rem)); } break; case DbTypeID.LONG: { long rem = (long)i0 % l1; return(tools.AllocValue(rem)); } break; case DbTypeID.DOUBLE: { double rem = (double)i0 % d1; return(tools.AllocValue(rem)); } break; } } break; case DbTypeID.LONG: { l0 = tools.GetLong(arg0); switch (arg1type.ID) { case DbTypeID.INT: { long rem = l0 % (long)i1; return(tools.AllocValue(rem)); } break; case DbTypeID.LONG: { long rem = l0 % l1; return(tools.AllocValue(rem)); } break; case DbTypeID.DOUBLE: { double rem = (double)l0 % d1; return(tools.AllocValue(rem)); } break; } } break; case DbTypeID.DOUBLE: { d0 = tools.GetDouble(arg0); switch (arg1type.ID) { case DbTypeID.INT: { double rem = d0 % (double)i1; return(tools.AllocValue(rem)); } break; case DbTypeID.LONG: { double rem = d0 % (double)l1; return(tools.AllocValue(rem)); } break; case DbTypeID.DOUBLE: { double rem = d0 % d1; return(tools.AllocValue(rem)); } break; } } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return(null); // Doesn't reach here. } return(null); // Doesn't reach here. }
public static DbValue POWER(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "POWER"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); double b = 0; double p = 0; switch (arg0type.ID) { case DbTypeID.INT: { int x = tools.GetInt(arg0); b = (double)x; } break; case DbTypeID.LONG: { long x = tools.GetLong(arg0); b = (double)x; } break; case DbTypeID.DOUBLE: { b = tools.GetDouble(arg0); } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return(null); // Doesn't reach here. } switch (arg1type.ID) { case DbTypeID.INT: { int x = tools.GetInt(arg1); p = (double)x; } break; case DbTypeID.LONG: { long x = tools.GetLong(arg1); p = (double)x; } break; case DbTypeID.DOUBLE: { p = tools.GetDouble(arg1); } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg1type.Name.ToUpper()); return(null); // Doesn't reach here. } double r = Math.Pow(b, p); return(tools.AllocValue(r)); }
public static DbValue COMPARE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "COMPARE"; args.EnsureCount(FunctionName, 2); int result; DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0)) { result = int.MaxValue; return(tools.AllocValue(result)); } if (Types.IsNullValue(arg1)) { result = int.MinValue; return(tools.AllocValue(result)); } int i0 = 0, i1 = 0; long l0 = 0, l1 = 0; double d0 = 0, d1 = 0; switch (arg0type.ID) { case DbTypeID.INT: i0 = tools.GetInt(arg0); break; case DbTypeID.LONG: l0 = tools.GetLong(arg0); break; case DbTypeID.DOUBLE: d0 = tools.GetDouble(arg0); break; case DbTypeID.CHARS: { if (arg1type.ID != DbTypeID.CHARS && arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input CHAR(n) or DATETIME, got " + arg1type.Name.ToUpper()); return(null); // Doesn't reach here. } if (arg1type.ID == DbTypeID.CHARS) { for (int i = 1; ; i += 2) { bool b1end = (i + 2 > arg0.Length) || (arg0[i] == 0 && arg0[i + 1] == 0); bool b2end = (i + 2 > arg1.Length) || (arg1[i] == 0 && arg1[i + 1] == 0); if (b1end) { if (b2end) { result = 0; break; } result = -1; break; } else if (b2end) { result = 1; break; } int diff = Types.UTF16BytesToLowerChar(arg0[i], arg0[i + 1]) - Types.UTF16BytesToLowerChar(arg1[i], arg1[i + 1]); if (0 != diff) { char ch0 = Types.UTF16BytesToChar(arg0[i], arg0[i + 1]); char ch1 = Types.UTF16BytesToChar(arg1[i], arg1[i + 1]); if (!Char.IsLetter(ch0) || !Char.IsLetter(ch1)) { result = ch0 - ch1; } result = diff; break; } } } else { string sdt = tools.GetString(arg0).ToString(); DateTime dt0 = DateTime.Parse(sdt); DateTime dt1 = tools.GetDateTime(arg1); result = dt0.CompareTo(dt1); } return(tools.AllocValue(result)); } break; case DbTypeID.DATETIME: { if (arg1type.ID != DbTypeID.CHARS && arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input CHAR(n) or DATETIME, got " + arg1type.Name.ToUpper()); return(null); // Doesn't reach here. } if (arg1type.ID == DbTypeID.DATETIME) { DateTime dt0 = tools.GetDateTime(arg0); DateTime dt1 = tools.GetDateTime(arg1); result = dt0.CompareTo(dt1); } else { DateTime dt0 = tools.GetDateTime(arg0); string sdt = tools.GetString(arg1).ToString(); DateTime dt1 = DateTime.Parse(sdt); result = dt0.CompareTo(dt1); } return(tools.AllocValue(result)); } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got1 " + arg0type.Name.ToUpper()); return(null); // Doesn't reach here. } switch (arg1type.ID) { case DbTypeID.INT: i1 = tools.GetInt(arg1); break; case DbTypeID.LONG: l1 = tools.GetLong(arg1); break; case DbTypeID.DOUBLE: d1 = tools.GetDouble(arg1); break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got2 " + arg1type.Name.ToUpper()); return(null); // Doesn't reach here. } switch (arg0type.ID) { case DbTypeID.INT: switch (arg1type.ID) { case DbTypeID.INT: result = i0.CompareTo(i1); break; case DbTypeID.LONG: result = ((long)i0).CompareTo(l1); break; case DbTypeID.DOUBLE: result = ((double)i0).CompareTo(d1); break; default: return(null); // Should never happen. } break; case DbTypeID.LONG: switch (arg1type.ID) { case DbTypeID.INT: result = l0.CompareTo((long)i1); break; case DbTypeID.LONG: result = l0.CompareTo(l1); break; case DbTypeID.DOUBLE: result = ((double)l0).CompareTo(d1); break; default: return(null); // Should never happen. } break; case DbTypeID.DOUBLE: switch (arg1type.ID) { case DbTypeID.INT: result = d0.CompareTo((double)i1); break; case DbTypeID.LONG: result = d0.CompareTo((double)l1); break; case DbTypeID.DOUBLE: result = d0.CompareTo(d1); break; default: return(null); // Should never happen. } break; default: return(null); // Should never happen. } return(tools.AllocValue(result)); }
public static DbValue COMPARE(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "COMPARE"; args.EnsureCount(FunctionName, 2); int result; DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0)) { result = int.MaxValue; return tools.AllocValue(result); } if (Types.IsNullValue(arg1)) { result = int.MinValue; return tools.AllocValue(result); } int i0 = 0, i1 = 0; long l0 = 0, l1 = 0; double d0 = 0, d1 = 0; switch (arg0type.ID) { case DbTypeID.INT: i0 = tools.GetInt(arg0); break; case DbTypeID.LONG: l0 = tools.GetLong(arg0); break; case DbTypeID.DOUBLE: d0 = tools.GetDouble(arg0); break; case DbTypeID.CHARS: { if (arg1type.ID != DbTypeID.CHARS && arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input CHAR(n) or DATETIME, got " + arg1type.Name.ToUpper()); return null; // Doesn't reach here. } if (arg1type.ID == DbTypeID.CHARS) { for (int i = 1; ; i += 2) { bool b1end = (i + 2 > arg0.Length) || (arg0[i] == 0 && arg0[i + 1] == 0); bool b2end = (i + 2 > arg1.Length) || (arg1[i] == 0 && arg1[i + 1] == 0); if (b1end) { if (b2end) { result = 0; break; } result = -1; break; } else if (b2end) { result = 1; break; } int diff = Types.UTF16BytesToLowerChar(arg0[i], arg0[i + 1]) - Types.UTF16BytesToLowerChar(arg1[i], arg1[i + 1]); if (0 != diff) { char ch0 = Types.UTF16BytesToChar(arg0[i], arg0[i + 1]); char ch1 = Types.UTF16BytesToChar(arg1[i], arg1[i + 1]); if (!Char.IsLetter(ch0) || !Char.IsLetter(ch1)) { result = ch0 - ch1; } result = diff; break; } } } else { string sdt = tools.GetString(arg0).ToString(); DateTime dt0 = DateTime.Parse(sdt); DateTime dt1 = tools.GetDateTime(arg1); result = dt0.CompareTo(dt1); } return tools.AllocValue(result); } break; case DbTypeID.DATETIME: { if (arg1type.ID != DbTypeID.CHARS && arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input CHAR(n) or DATETIME, got " + arg1type.Name.ToUpper()); return null; // Doesn't reach here. } if (arg1type.ID == DbTypeID.DATETIME) { DateTime dt0 = tools.GetDateTime(arg0); DateTime dt1 = tools.GetDateTime(arg1); result = dt0.CompareTo(dt1); } else { DateTime dt0 = tools.GetDateTime(arg0); string sdt = tools.GetString(arg1).ToString(); DateTime dt1 = DateTime.Parse(sdt); result = dt0.CompareTo(dt1); } return tools.AllocValue(result); } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got1 " + arg0type.Name.ToUpper()); return null; // Doesn't reach here. } switch (arg1type.ID) { case DbTypeID.INT: i1 = tools.GetInt(arg1); break; case DbTypeID.LONG: l1 = tools.GetLong(arg1); break; case DbTypeID.DOUBLE: d1 = tools.GetDouble(arg1); break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got2 " + arg1type.Name.ToUpper()); return null; // Doesn't reach here. } switch (arg0type.ID) { case DbTypeID.INT: switch (arg1type.ID) { case DbTypeID.INT: result = i0.CompareTo(i1); break; case DbTypeID.LONG: result = ((long)i0).CompareTo(l1); break; case DbTypeID.DOUBLE: result = ((double)i0).CompareTo(d1); break; default: return null; // Should never happen. } break; case DbTypeID.LONG: switch (arg1type.ID) { case DbTypeID.INT: result = l0.CompareTo((long)i1); break; case DbTypeID.LONG: result = l0.CompareTo(l1); break; case DbTypeID.DOUBLE: result = ((double)l0).CompareTo(d1); break; default: return null; // Should never happen. } break; case DbTypeID.DOUBLE: switch (arg1type.ID) { case DbTypeID.INT: result = d0.CompareTo((double)i1); break; case DbTypeID.LONG: result = d0.CompareTo((double)l1); break; case DbTypeID.DOUBLE: result = d0.CompareTo(d1); break; default: return null; // Should never happen. } break; default: return null; // Should never happen. } return tools.AllocValue(result); }
public static DbValue CHARINDEX(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "CHARINDEX"; args.EnsureMinCount(FunctionName, 2); int index = -1; DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0) || Types.IsNullValue(arg1)) { return(tools.AllocValue(index)); } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); return(null); } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); return(null); } int startIndex = 0; if (args.Length > 2) { DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (arg2type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg2type.Name.ToUpper()); return(null); } startIndex = tools.GetInt(arg2); if (startIndex < 0) { startIndex = 0; } } mstring word = tools.GetString(arg0); mstring sentence = tools.GetString(arg1); if (startIndex > sentence.Length - 1) { index = -1; } else if (startIndex == 0) { index = sentence.IndexOf(word); } else { mstring partsentence = sentence.SubstringM(startIndex); int ix = partsentence.IndexOf(word); if (ix == -1) { index = -1; } else { index = startIndex + ix; } } return(tools.AllocValue(index)); }
public static DbValue CHARINDEX(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "CHARINDEX"; args.EnsureMinCount(FunctionName, 2); int index = -1; DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg0) || Types.IsNullValue(arg1)) { return tools.AllocValue(index); } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); return null; } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); return null; } int startIndex = 0; if (args.Length > 2) { DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (arg2type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg2type.Name.ToUpper()); return null; } startIndex = tools.GetInt(arg2); if (startIndex < 0) { startIndex = 0; } } mstring word = tools.GetString(arg0); mstring sentence = tools.GetString(arg1); if (startIndex > sentence.Length - 1) { index = -1; } else if (startIndex == 0) { index = sentence.IndexOf(word); } else { mstring partsentence = sentence.SubstringM(startIndex); int ix = partsentence.IndexOf(word); if (ix == -1) { index = -1; } else { index = startIndex + ix; } } return tools.AllocValue(index); }
public static DbValue INSTR(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "INSTR"; args.EnsureMinCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg1type.Name.ToUpper()); } int startIndex = 0; if (args.Length > 2) { DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (arg2type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg2type.Name.ToUpper()); } if (!Types.IsNullValue(arg2)) { startIndex = tools.GetInt(arg2); } } mstring sentence = tools.GetString(arg0); mstring word = tools.GetString(arg1); int index = -1; if (startIndex < sentence.Length) { if (startIndex > 0) { sentence = sentence.SubstringM(startIndex); } index = sentence.IndexOf(word); if (index > -1) { index += startIndex; } } return(tools.AllocValue(index)); }
public static DbValue DATEADD(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "DATEADD"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg1type.ID != DbTypeID.INT) { args.Expected(FunctionName, 0, "input INT, got " + arg1type.Name.ToUpper()); } if (Types.IsNullValue(arg2)) { return tools.AllocNullValue(); // Give a null, take a null. } if (arg2type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg2type.Name.ToUpper()); } string datepart = tools.GetString(arg0).ToUpperM().ToString(); int num = tools.GetInt(arg1); DateTime dt = tools.GetDateTime(arg2); DateTime newdt = dt; switch (datepart) { case "YEAR": case "YY": case "YYYY": newdt = dt.AddYears(num); break; case "QUARTER": case "QQ": case "Q": newdt = dt.AddMonths(num * 3); break; case "MONTH": case "MM": case "M": newdt = dt.AddMonths(num); break; case "DAY": case "DD": case "D": newdt = dt.AddDays(num); break; case "WEEK": case "WK": case "WW": newdt = dt.AddDays(7 * num); break; case "HOUR": case "HH": newdt = dt.AddHours(num); break; case "MINUTE": case "MI": case "N": newdt = dt.AddMinutes(num); break; case "SECOND": case "SS": case "S": newdt = dt.AddSeconds(num); break; case "MILLISECOND": case "MS": newdt = dt.AddMilliseconds(num); break; default: args.Expected(FunctionName, 0, "input datepart invalid"); return null; } return tools.AllocValue(newdt); }
public static DbValue SUB(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "SUB"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return(tools.AllocValue(arg0, arg0type)); // Give a null, take a null. } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return(tools.AllocValue(arg1, arg1type)); // Give a null, take a null. } switch (arg0type.ID) { case DbTypeID.INT: { int x = tools.GetInt(arg0); switch (arg1type.ID) { case DbTypeID.INT: { int y = tools.GetInt(arg1); return(tools.AllocValue(x - y)); } break; case DbTypeID.LONG: { long y = tools.GetLong(arg1); return(tools.AllocValue(x - y)); } break; case DbTypeID.DOUBLE: { double y = tools.GetDouble(arg1); return(tools.AllocValue(x - y)); } break; default: args.Expected(FunctionName, 1, "input INT, LONG or DOUBLE, got " + arg1type.Name.ToUpper()); return(null); // Doesn't reach here. } } break; case DbTypeID.LONG: { long x = tools.GetLong(arg0); switch (arg1type.ID) { case DbTypeID.INT: { int y = tools.GetInt(arg1); return(tools.AllocValue(x - y)); } break; case DbTypeID.LONG: { long y = tools.GetLong(arg1); return(tools.AllocValue(x - y)); } break; case DbTypeID.DOUBLE: { double y = tools.GetDouble(arg1); return(tools.AllocValue(x - y)); } break; default: args.Expected(FunctionName, 1, "input INT, LONG or DOUBLE, got " + arg1type.Name.ToUpper()); return(null); // Doesn't reach here. } } break; case DbTypeID.DOUBLE: { double x = tools.GetDouble(arg0); switch (arg1type.ID) { case DbTypeID.INT: { int y = tools.GetInt(arg1); return(tools.AllocValue(x - y)); } break; case DbTypeID.LONG: { long y = tools.GetLong(arg1); return(tools.AllocValue(x - y)); } break; case DbTypeID.DOUBLE: { double y = tools.GetDouble(arg1); return(tools.AllocValue(x - y)); } break; default: args.Expected(FunctionName, 1, "input INT, LONG or DOUBLE, got " + arg1type.Name.ToUpper()); return(null); // Doesn't reach here. } } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return(null); // Doesn't reach here. } }
public static DbValue MOD(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "MOD"; args.EnsureCount(FunctionName, 2); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); if (Types.IsNullValue(arg0)) { return tools.AllocNullValue(); // Give a null, take a null. } DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); if (Types.IsNullValue(arg1)) { return tools.AllocNullValue(); // Give a null, take a null. } int i0, i1 = 0; long l0, l1 = 0; double d0, d1 = 0; switch (arg1type.ID) { case DbTypeID.INT: i1 = tools.GetInt(arg1); break; case DbTypeID.LONG: l1 = tools.GetLong(arg1); break; case DbTypeID.DOUBLE: d1 = tools.GetDouble(arg1); break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg1type.Name.ToUpper()); return null; // Doesn't reach here. } if (i1 == 0 && l1 == 0 && d1 == 0) { args.Expected(FunctionName, 0, "Division by zero"); return null; } switch (arg0type.ID) { case DbTypeID.INT: { i0 = tools.GetInt(arg0); switch (arg1type.ID) { case DbTypeID.INT: { int rem = i0 % i1; return tools.AllocValue(rem); } break; case DbTypeID.LONG: { long rem = (long)i0 % l1; return tools.AllocValue(rem); } break; case DbTypeID.DOUBLE: { double rem = (double)i0 % d1; return tools.AllocValue(rem); } break; } } break; case DbTypeID.LONG: { l0 = tools.GetLong(arg0); switch (arg1type.ID) { case DbTypeID.INT: { long rem = l0 % (long)i1; return tools.AllocValue(rem); } break; case DbTypeID.LONG: { long rem = l0 % l1; return tools.AllocValue(rem); } break; case DbTypeID.DOUBLE: { double rem = (double)l0 % d1; return tools.AllocValue(rem); } break; } } break; case DbTypeID.DOUBLE: { d0 = tools.GetDouble(arg0); switch (arg1type.ID) { case DbTypeID.INT: { double rem = d0 % (double)i1; return tools.AllocValue(rem); } break; case DbTypeID.LONG: { double rem = d0 % (double)l1; return tools.AllocValue(rem); } break; case DbTypeID.DOUBLE: { double rem = d0 % d1; return tools.AllocValue(rem); } break; } } break; default: args.Expected(FunctionName, 0, "input INT, LONG or DOUBLE, got " + arg0type.Name.ToUpper()); return null; // Doesn't reach here. } return null; // Doesn't reach here. }
public static DbValue DATEDIFF(DbFunctionTools tools, DbFunctionArguments args) { string FunctionName = "DATEDIFF"; args.EnsureCount(FunctionName, 3); DbType arg0type; ByteSlice arg0 = args[0].Eval(out arg0type); DbType arg1type; ByteSlice arg1 = args[1].Eval(out arg1type); DbType arg2type; ByteSlice arg2 = args[2].Eval(out arg2type); if (Types.IsNullValue(arg0)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg0type.ID != DbTypeID.CHARS) { args.Expected(FunctionName, 0, "input CHAR(n), got " + arg0type.Name.ToUpper()); } if (Types.IsNullValue(arg1)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg1type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg1type.Name.ToUpper()); } if (Types.IsNullValue(arg2)) { return(tools.AllocNullValue()); // Give a null, take a null. } if (arg2type.ID != DbTypeID.DATETIME) { args.Expected(FunctionName, 0, "input DATETIME, got " + arg2type.Name.ToUpper()); } string datepart = tools.GetString(arg0).ToUpperM().ToString(); DateTime startdate = tools.GetDateTime(arg1); DateTime enddate = tools.GetDateTime(arg2); double partdiff = 0; switch (datepart) { case "YEAR": case "YY": case "YYYY": partdiff = enddate.Year - startdate.Year; break; case "QUARTER": case "QQ": case "Q": partdiff = GetMonthDiff(startdate.Year, startdate.Month, enddate.Year, enddate.Month) / 3; break; case "MONTH": case "MM": case "M": partdiff = GetMonthDiff(startdate.Year, startdate.Month, enddate.Year, enddate.Month); break; case "DAY": case "DD": case "D": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day); TimeSpan sp = edate - sdate; partdiff = sp.TotalDays; } break; case "WEEK": case "WK": case "WW": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day); TimeSpan sp = edate - sdate; partdiff = (int)sp.TotalDays / 7; } break; case "HOUR": case "HH": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day, startdate.Hour, 0, 0); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day, enddate.Hour, 0, 0); TimeSpan sp = edate - sdate; partdiff = sp.TotalHours; } break; case "MINUTE": case "MI": case "N": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day, startdate.Hour, startdate.Minute, 0); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day, enddate.Hour, enddate.Minute, 0); TimeSpan sp = edate - sdate; partdiff = sp.TotalMinutes; } break; case "SECOND": case "SS": case "S": { DateTime sdate = new DateTime(startdate.Year, startdate.Month, startdate.Day, startdate.Hour, startdate.Minute, startdate.Second); DateTime edate = new DateTime(enddate.Year, enddate.Month, enddate.Day, enddate.Hour, enddate.Minute, enddate.Second); TimeSpan sp = edate - sdate; partdiff = sp.TotalSeconds; } break; case "MILLISECOND": case "MS": { TimeSpan sp = enddate - startdate; partdiff = sp.TotalMilliseconds; } break; default: args.Expected(FunctionName, 0, "input datepart invalid"); return(null); } return(tools.AllocValue(partdiff)); }