1package io.protobase.f7.spreadsheet;
  2
  3import io.protobase.f7.errors.RefException;
  4import io.protobase.f7.testutils.TestExecution;
  5import org.junit.Test;
  6
  7public class GeneralGreaterThanOrEqualToComparisonTest extends TestExecution {
  8  @Test
  9  public void test_Number() {
 10    runner().addCell("Alpha", "A1", "= 1 >= 1").addExpectedValue("Alpha", "A1", true).run();
 11    runner().addCell("Alpha", "A1", "= 1 >= 2").addExpectedValue("Alpha", "A1", false).run();
 12    runner().addCell("Alpha", "A1", "= 2 >= 1").addExpectedValue("Alpha", "A1", true).run();
 13    runner().addCell("Alpha", "A1", "= -10 >= 0").addExpectedValue("Alpha", "A1", false).run();
 14    runner().addCell("Alpha", "A1", "= 0 >= -10").addExpectedValue("Alpha", "A1", true).run();
 15    runner().addCell("Alpha", "A1", "= 1.1928731 >= 1.1928731").addExpectedValue("Alpha", "A1", true).run();
 16  }
 17
 18  @Test
 19  public void test_String() {
 20    runner().addCell("Alpha", "A1", "= \"Yes\" >= \"Yes\"").addExpectedValue("Alpha", "A1", true).run();
 21    runner().addCell("Alpha", "A1", "= \"Yes\" >= \"No\"").addExpectedValue("Alpha", "A1", true).run();
 22    runner().addCell("Alpha", "A1", "= \"No\">= \"Yes\"").addExpectedValue("Alpha", "A1", false).run();
 23    runner().addCell("Alpha", "A1", "= \"\" >= \"\"").addExpectedValue("Alpha", "A1", true).run();
 24    runner().addCell("Alpha", "A1", "= \" \" >= \"\"").addExpectedValue("Alpha", "A1", true).run();
 25  }
 26
 27  @Test
 28  public void test_Boolean() {
 29    runner().addCell("Alpha", "A1", "= TRUE >= TRUE").addExpectedValue("Alpha", "A1", true).run();
 30    runner().addCell("Alpha", "A1", "= FALSE >= FALSE").addExpectedValue("Alpha", "A1", true).run();
 31    runner().addCell("Alpha", "A1", "= TRUE >= FALSE").addExpectedValue("Alpha", "A1", true).run();
 32    runner().addCell("Alpha", "A1", "= FALSE >= TRUE").addExpectedValue("Alpha", "A1", false).run();
 33  }
 34
 35  @Test
 36  public void test_ArrayLiteral() {
 37    runner().addCell("Alpha", "A1", "= {1, 2, 3} >= {1, 2, 3}").addExpectedValue("Alpha", "A1", true).run();
 38    runner().addCell("Alpha", "A1", "= {1, 2, 3} >= {44}").addExpectedValue("Alpha", "A1", false).run();
 39    runner().addCell("Alpha", "A1", "= {44, 2, 3} >= {1}").addExpectedValue("Alpha", "A1", true).run();
 40    runner().addCell("Alpha", "A1", "= {44, #REF!} >= {44, #REF!}").addExpectedValue("Alpha", "A1", true).run();
 41  }
 42
 43  @Test
 44  public void test_NumberToBoolean() {
 45    runner().addCell("Alpha", "A1", "= 0 >= TRUE").addExpectedValue("Alpha", "A1", false).run();
 46    runner().addCell("Alpha", "A1", "= 1 >= TRUE").addExpectedValue("Alpha", "A1", false).run();
 47    runner().addCell("Alpha", "A1", "= 1 >= FALSE").addExpectedValue("Alpha", "A1", false).run();
 48    runner().addCell("Alpha", "A1", "= 0 >= FALSE").addExpectedValue("Alpha", "A1", false).run();
 49    runner().addCell("Alpha", "A1", "= -1 >= TRUE").addExpectedValue("Alpha", "A1", false).run();
 50    runner().addCell("Alpha", "A1", "= -1 >= FALSE").addExpectedValue("Alpha", "A1", false).run();
 51  }
 52
 53  @Test
 54  public void test_NumberToString() {
 55    runner().addCell("Alpha", "A1", "= 0 >= \"\"").addExpectedValue("Alpha", "A1", false).run();
 56    runner().addCell("Alpha", "A1", "= 0 >= \"0\"").addExpectedValue("Alpha", "A1", false).run();
 57    runner().addCell("Alpha", "A1", "= 1 >= \"0\"").addExpectedValue("Alpha", "A1", false).run();
 58    runner().addCell("Alpha", "A1", "= 1 >= \"1\"").addExpectedValue("Alpha", "A1", false).run();
 59    runner().addCell("Alpha", "A1", "= -1 >= \"1\"").addExpectedValue("Alpha", "A1", false).run();
 60    runner().addCell("Alpha", "A1", "= 1000 >= \"-100\"").addExpectedValue("Alpha", "A1", false).run();
 61    runner().addCell("Alpha", "A1", "= 1000 >= \"Anything in the world.\"").addExpectedValue("Alpha", "A1", false).run();
 62  }
 63
 64  @Test
 65  public void test_NumberToArrayLiteral() {
 66    runner().addCell("Alpha", "A1", "= -1 >= {0, 1, 2}").addExpectedValue("Alpha", "A1", false).run();
 67    runner().addCell("Alpha", "A1", "= 0 >= {0, 1, 2}").addExpectedValue("Alpha", "A1", true).run();
 68    runner().addCell("Alpha", "A1", "= 1 >= {0, 1, 2}").addExpectedValue("Alpha", "A1", true).run();
 69    runner().addCell("Alpha", "A1", "= 0 >= {1, 1, 2}").addExpectedValue("Alpha", "A1", false).run();
 70    runner().addCell("Alpha", "A1", "= 0 >= {1, \"Ignore me.\"}").addExpectedValue("Alpha", "A1", false).run();
 71  }
 72
 73  @Test
 74  public void test_NumberToBlank() {
 75    runner().addCell("Alpha", "A1", "= 0 >= M9").addExpectedValue("Alpha", "A1", true).run();
 76    runner().addCell("Alpha", "A1", "= 1 >= M9").addExpectedValue("Alpha", "A1", true).run();
 77    runner().addCell("Alpha", "A1", "= M9 >= 0").addExpectedValue("Alpha", "A1", true).run();
 78    runner().addCell("Alpha", "A1", "= M9 >= 1").addExpectedValue("Alpha", "A1", false).run();
 79    runner().addCell("Alpha", "A1", "= -1 >= M9").addExpectedValue("Alpha", "A1", false).run();
 80    runner().addCell("Alpha", "A1", "= M9 >= -1").addExpectedValue("Alpha", "A1", true).run();
 81  }
 82
 83  @Test
 84  public void test_StringToBoolean() {
 85    runner().addCell("Alpha", "A1", "= \"TRUE\" >= TRUE").addExpectedValue("Alpha", "A1", false).run();
 86    runner().addCell("Alpha", "A1", "= \"FALSE\" >= FALSE").addExpectedValue("Alpha", "A1", false).run();
 87    runner().addCell("Alpha", "A1", "= \"TRUE\" >= TRUE").addExpectedValue("Alpha", "A1", false).run();
 88    runner().addCell("Alpha", "A1", "= \"\" >= TRUE").addExpectedValue("Alpha", "A1", false).run();
 89    runner().addCell("Alpha", "A1", "= \"\" >= FALSE").addExpectedValue("Alpha", "A1", false).run();
 90  }
 91
 92  @Test
 93  public void test_StringToBlank() {
 94    runner().addCell("Alpha", "A1", "= \"\" >= M10").addExpectedValue("Alpha", "A1", true).run();
 95    runner().addCell("Alpha", "A1", "= M10 >= \"\"").addExpectedValue("Alpha", "A1", true).run();
 96    runner().addCell("Alpha", "A1", "= \" \" >= M10").addExpectedValue("Alpha", "A1", true).run();
 97    runner().addCell("Alpha", "A1", "= M10 >= \" \"").addExpectedValue("Alpha", "A1", false).run();
 98    runner().addCell("Alpha", "A1", "= \"One\" >= M10").addExpectedValue("Alpha", "A1", true).run();
 99    runner().addCell("Alpha", "A1", "= M10 >= \"One\"").addExpectedValue("Alpha", "A1", false).run();
100  }
101
102  @Test
103  public void test_BooleanToBlank() {
104    runner().addCell("Alpha", "A1", "= TRUE >= M10").addExpectedValue("Alpha", "A1", true).run();
105    runner().addCell("Alpha", "A1", "= FALSE >= M10").addExpectedValue("Alpha", "A1", true).run();
106    runner().addCell("Alpha", "A1", "= M10 >= TRUE").addExpectedValue("Alpha", "A1", false).run();
107    runner().addCell("Alpha", "A1", "= M10 >= FALSE").addExpectedValue("Alpha", "A1", true).run();
108  }
109
110  @Test
111  public void test_ArrayLiteralToString() {
112    runner().addCell("Alpha", "A1", "= {\"A\", \"B\"} >= \"A\"").addExpectedValue("Alpha", "A1", true).run();
113    runner().addCell("Alpha", "A1", "= {\"A\", \"B\"} >= \"B\"").addExpectedValue("Alpha", "A1", false).run();
114    runner().addCell("Alpha", "A1", "= \"A\" >= {\"A\", \"B\"}").addExpectedValue("Alpha", "A1", true).run();
115    runner().addCell("Alpha", "A1", "= \"B\" >= {\"A\", \"B\"}").addExpectedValue("Alpha", "A1", true).run();
116  }
117
118  @Test
119  public void test_ArrayLiteralToBoolean() {
120    runner().addCell("Alpha", "A1", "= {TRUE, FALSE} >= TRUE").addExpectedValue("Alpha", "A1", true).run();
121    runner().addCell("Alpha", "A1", "= TRUE >= {TRUE, FALSE}").addExpectedValue("Alpha", "A1", true).run();
122    runner().addCell("Alpha", "A1", "= {FALSE, FALSE} >= TRUE").addExpectedValue("Alpha", "A1", false).run();
123    runner().addCell("Alpha", "A1", "= TRUE >= {FALSE, FALSE}").addExpectedValue("Alpha", "A1", true).run();
124  }
125
126  @Test
127  public void test_Error() {
128    runner().addCell("Alpha", "A1", "= 10 >= #REF!").addExpectedValue("Alpha", "A1", new RefException()).run();
129    runner().addCell("Alpha", "A1", "= #REF! >= TRUE").addExpectedValue("Alpha", "A1", new RefException()).run();
130  }
131}