public static void DbFunctions_EQUAL()
{
DbFunctionTools tools = new DbFunctionTools();
Random rnd = new Random();
{
Console.WriteLine("Testing DbFunctions.EQUAL(char(n), char(n))...");
mstring s1 = Utils.GenString(rnd.Next(1, 200));
mstring s2 = Utils.GenString(rnd.Next(1, 200));
List <DbValue> args = new List <DbValue>();
args.Add(tools.AllocValue(s1));
args.Add(tools.AllocValue(s2));
DbFunctionArguments fargs = new DbFunctionArguments(args);
DbValue valOutput = DbFunctions.EQUAL(tools, fargs);
ByteSlice bs = valOutput.Eval();
int output = tools.GetInt(bs);
int expected = (s1.ToString().CompareTo(s2.ToString()) == 0 ? 1 : 0);
if (expected != output)
{
throw new Exception("DbFunctions.EQUAL(char(n), char(n)) has failed. Expected result: " + expected.ToString() + ", but received: " + output.ToString());
}
else
{
Console.WriteLine("Expected results received.");
}
}
{
Console.WriteLine("Testing DbFunctions.EQUAL(Int32, Int32)...");
int x = rnd.Next(Int32.MinValue, Int32.MaxValue);
int y = rnd.Next(Int32.MinValue, Int32.MaxValue);
List <DbValue> args = new List <DbValue>();
args.Add(tools.AllocValue(x));
args.Add(tools.AllocValue(y));
DbFunctionArguments fargs = new DbFunctionArguments(args);
DbValue valOutput = DbFunctions.EQUAL(tools, fargs);
ByteSlice bs = valOutput.Eval();
int output = tools.GetInt(bs);
int expected = (x == y ? 1 : 0);
if (expected != output)
{
throw new Exception("DbFunctions.EQUAL(Int32, Int32) has failed. Expected result: " + expected.ToString() + ", but received: " + output.ToString());
}
else
{
Console.WriteLine("Expected results received.");
}
}
{
Console.WriteLine("Testing DbFunctions.EQUAL(Double, Double)...");
double x = rnd.NextDouble();
double y = rnd.NextDouble();
List <DbValue> args = new List <DbValue>();
args.Add(tools.AllocValue(x));
args.Add(tools.AllocValue(y));
DbFunctionArguments fargs = new DbFunctionArguments(args);
DbValue valOutput = DbFunctions.EQUAL(tools, fargs);
ByteSlice bs = valOutput.Eval();
int output = tools.GetInt(bs);
int expected = (x == y ? 1 : 0);
if (expected != output)
{
throw new Exception("DbFunctions.EQUAL(Double, Double) has failed. Expected result: " + expected.ToString() + ", but received: " + output.ToString());
}
else
{
Console.WriteLine("Expected results received.");
}
}
{
Console.WriteLine("Testing DbFunctions.EQUAL(Long, Long)...");
long x = DateTime.Now.Ticks;
long y = DateTime.Now.Ticks;
List <DbValue> args = new List <DbValue>();
args.Add(tools.AllocValue(x));
args.Add(tools.AllocValue(y));
DbFunctionArguments fargs = new DbFunctionArguments(args);
DbValue valOutput = DbFunctions.EQUAL(tools, fargs);
ByteSlice bs = valOutput.Eval();
int output = tools.GetInt(bs);
int expected = (x == y ? 1 : 0);
if (expected != output)
{
throw new Exception("DbFunctions.EQUAL(Long, Long) has failed. Expected result: " + expected.ToString() + ", but received: " + output.ToString());
}
else
{
Console.WriteLine("Expected results received.");
}
}
{
Console.WriteLine("Testing DbFunctions.EQUAL(Double, Int32)...");
double x = rnd.NextDouble();
int y = rnd.Next();
List <DbValue> args = new List <DbValue>();
args.Add(tools.AllocValue(x));
args.Add(tools.AllocValue(y));
DbFunctionArguments fargs = new DbFunctionArguments(args);
DbValue valOutput = DbFunctions.EQUAL(tools, fargs);
ByteSlice bs = valOutput.Eval();
int output = tools.GetInt(bs);
int expected = (x == y ? 1 : 0);
if (expected != output)
{
throw new Exception("DbFunctions.EQUAL(Double, Int32) has failed. Expected result: " + expected.ToString() + ", but received: " + output.ToString());
}
else
{
Console.WriteLine("Expected results received.");
}
}
{
Console.WriteLine("Testing DbFunctions.EQUAL(Double, Long)...");
double x = rnd.NextDouble();
long y = DateTime.Now.Ticks;
List <DbValue> args = new List <DbValue>();
args.Add(tools.AllocValue(x));
args.Add(tools.AllocValue(y));
DbFunctionArguments fargs = new DbFunctionArguments(args);
DbValue valOutput = DbFunctions.EQUAL(tools, fargs);
ByteSlice bs = valOutput.Eval();
int output = tools.GetInt(bs);
int expected = (x == y ? 1 : 0);
if (expected != output)
{
throw new Exception("DbFunctions.EQUAL(Double, Long) has failed. Expected result: " + expected.ToString() + ", but received: " + output.ToString());
}
else
{
Console.WriteLine("Expected results received.");
}
}
}
