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 GeneralGreaterThanComparisonTest extends TestExecution {
  8  @Test
  9  public void test_Number() {
 10    runner().addCell("Alpha", "A1", "= 1 > 1").addExpectedValue("Alpha", "A1", false).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", false).run();
 16  }
 17
 18  @Test
 19  public void test_String() {
 20    runner().addCell("Alpha", "A1", "= \"Yes\" > \"Yes\"").addExpectedValue("Alpha", "A1", false).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", false).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", false).run();
 30    runner().addCell("Alpha", "A1", "= FALSE > FALSE").addExpectedValue("Alpha", "A1", false).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", false).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", false).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", false).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", false).run();
 76    runner().addCell("Alpha", "A1", "= 1 > M9").addExpectedValue("Alpha", "A1", true).run();
 77    runner().addCell("Alpha", "A1", "= M9 > 0").addExpectedValue("Alpha", "A1", false).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", false).run();
 95    runner().addCell("Alpha", "A1", "= M10 > \"\"").addExpectedValue("Alpha", "A1", false).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", false).run();
106    runner().addCell("Alpha", "A1", "= M10 > TRUE").addExpectedValue("Alpha", "A1", false).run();
107    runner().addCell("Alpha", "A1", "= M10 > FALSE").addExpectedValue("Alpha", "A1", false).run();
108  }
109
110  @Test
111  public void test_ArrayLiteralToString() {
112    runner().addCell("Alpha", "A1", "= {\"A\", \"B\"} > \"A\"").addExpectedValue("Alpha", "A1", false).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", false).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", false).run();
121    runner().addCell("Alpha", "A1", "= TRUE > {TRUE, FALSE}").addExpectedValue("Alpha", "A1", false).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}