TestSqlValueAndTuple.cpp 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557
  1. /*
  2. * Copyright (c) 2021, Jan de Visser <jan@de-visser.net>
  3. *
  4. * SPDX-License-Identifier: BSD-2-Clause
  5. */
  6. #include <unistd.h>
  7. #include <LibSQL/Meta.h>
  8. #include <LibSQL/Row.h>
  9. #include <LibSQL/Tuple.h>
  10. #include <LibSQL/Value.h>
  11. #include <LibTest/TestCase.h>
  12. TEST_CASE(null_value)
  13. {
  14. SQL::Value v(SQL::SQLType::Null);
  15. EXPECT(v.type() == SQL::SQLType::Null);
  16. EXPECT(v.is_null());
  17. v = "Test";
  18. EXPECT(v.is_null());
  19. EXPECT(v.to_string() == "(null)");
  20. }
  21. TEST_CASE(text_value)
  22. {
  23. {
  24. SQL::Value v(SQL::SQLType::Text);
  25. EXPECT(v.is_null());
  26. v = "Test";
  27. EXPECT(!v.is_null());
  28. EXPECT(v.to_string() == "Test");
  29. }
  30. {
  31. SQL::Value v(SQL::SQLType::Text, String("String Test"));
  32. EXPECT(!v.is_null());
  33. EXPECT(v.to_string() == "String Test");
  34. }
  35. {
  36. SQL::Value v(SQL::SQLType::Text, "const char * Test");
  37. EXPECT(!v.is_null());
  38. EXPECT_EQ(v.to_string(), "const char * Test");
  39. }
  40. {
  41. SQL::Value v(String("String Test"));
  42. EXPECT(v.type() == SQL::SQLType::Text);
  43. EXPECT(!v.is_null());
  44. EXPECT(v.to_string() == "String Test");
  45. }
  46. {
  47. SQL::Value v(SQL::SQLType::Text, SQL::Value(42));
  48. EXPECT(v.type() == SQL::SQLType::Text);
  49. EXPECT(!v.is_null());
  50. EXPECT(v.to_string() == "42");
  51. }
  52. }
  53. TEST_CASE(assign_null)
  54. {
  55. SQL::Value v("Test");
  56. EXPECT(!v.is_null());
  57. v = SQL::Value::null();
  58. EXPECT(v.is_null());
  59. }
  60. TEST_CASE(text_value_to_other_types)
  61. {
  62. {
  63. SQL::Value v(SQL::SQLType::Text, "42");
  64. EXPECT(v.to_int().has_value());
  65. EXPECT_EQ(v.to_int().value(), 42);
  66. EXPECT(v.to_double().has_value());
  67. EXPECT(v.to_double().value() - 42.0 < NumericLimits<double>().epsilon());
  68. }
  69. {
  70. SQL::Value v("true");
  71. EXPECT(v.to_bool().has_value());
  72. EXPECT(v.to_bool().value());
  73. }
  74. {
  75. SQL::Value v("false");
  76. EXPECT(v.to_bool().has_value());
  77. EXPECT(!v.to_bool().value());
  78. }
  79. }
  80. TEST_CASE(text_value_to_int_crash)
  81. {
  82. SQL::Value v(SQL::SQLType::Text, "Not a valid integer");
  83. EXPECT_CRASH("Can't convert 'Not a valid integer' to integer", [&]() { (void) (int) v; return Test::Crash::Failure::DidNotCrash; });
  84. }
  85. TEST_CASE(serialize_text_value)
  86. {
  87. SQL::Value v("Test");
  88. EXPECT(v.to_string() == "Test");
  89. SQL::Serializer serializer;
  90. serializer.serialize<SQL::Value>(v);
  91. serializer.rewind();
  92. auto v2 = serializer.deserialize<SQL::Value>();
  93. EXPECT((String)v2 == "Test");
  94. }
  95. TEST_CASE(integer_value)
  96. {
  97. {
  98. SQL::Value v(SQL::SQLType::Integer);
  99. EXPECT(v.is_null());
  100. v = 42;
  101. EXPECT(!v.is_null());
  102. EXPECT(v.to_int().value() == 42);
  103. EXPECT(v.to_string() == "42");
  104. EXPECT(v.to_double().has_value());
  105. EXPECT(v.to_double().value() - 42.0 < NumericLimits<double>().epsilon());
  106. EXPECT(v.to_bool().has_value());
  107. EXPECT(v.to_bool().value());
  108. }
  109. {
  110. SQL::Value v(0);
  111. EXPECT(!v.is_null());
  112. EXPECT(v.to_int().value() == 0);
  113. EXPECT(v.to_bool().has_value());
  114. EXPECT(!v.to_bool().value());
  115. }
  116. {
  117. SQL::Value v(SQL::SQLType::Integer, "42");
  118. EXPECT_EQ(v.to_int().value(), 42);
  119. }
  120. {
  121. SQL::Value v(SQL::SQLType::Integer, SQL::Value("42"));
  122. EXPECT_EQ(v.to_int().value(), 42);
  123. }
  124. {
  125. SQL::Value text("42");
  126. SQL::Value integer(SQL::SQLType::Integer);
  127. integer = text;
  128. EXPECT_EQ(integer.to_int().value(), 42);
  129. }
  130. }
  131. TEST_CASE(serialize_int_value)
  132. {
  133. SQL::Value v(42);
  134. EXPECT_EQ(v.type(), SQL::SQLType::Integer);
  135. EXPECT_EQ(v.to_int().value(), 42);
  136. SQL::Serializer serializer;
  137. serializer.serialize<SQL::Value>(v);
  138. serializer.rewind();
  139. auto v2 = serializer.deserialize<SQL::Value>();
  140. EXPECT(!v2.is_null());
  141. EXPECT_EQ(v2.type(), SQL::SQLType::Integer);
  142. EXPECT_EQ(v2.to_int().value(), 42);
  143. EXPECT(v2 == v);
  144. }
  145. TEST_CASE(float_value)
  146. {
  147. {
  148. SQL::Value v(SQL::SQLType::Float);
  149. EXPECT(v.is_null());
  150. v = 3.14;
  151. EXPECT(!v.is_null());
  152. EXPECT(v.to_double().has_value());
  153. EXPECT(v.to_double().value() - 3.14 < NumericLimits<double>().epsilon());
  154. EXPECT(v.to_int().has_value());
  155. EXPECT_EQ(v.to_int().value(), 3);
  156. EXPECT_EQ(v.to_string(), "3.14");
  157. EXPECT(!v.to_bool().has_value());
  158. }
  159. {
  160. SQL::Value v(3.14);
  161. EXPECT(!v.is_null());
  162. EXPECT(v.to_double().value() - 3.14 < NumericLimits<double>().epsilon());
  163. }
  164. {
  165. SQL::Value v(3.51);
  166. EXPECT(!v.is_null());
  167. EXPECT_EQ(v.to_int().value(), 4);
  168. }
  169. {
  170. SQL::Value v(-3.14);
  171. EXPECT_EQ(v.to_int().value(), -3);
  172. }
  173. {
  174. SQL::Value v(-3.51);
  175. EXPECT_EQ(v.to_int().value(), -4);
  176. }
  177. {
  178. SQL::Value v(SQL::SQLType::Float, "3.14");
  179. EXPECT(v.to_double().value() - 3.14 < NumericLimits<double>().epsilon());
  180. }
  181. }
  182. TEST_CASE(serialize_float_value)
  183. {
  184. SQL::Value v(3.14);
  185. EXPECT_EQ(v.type(), SQL::SQLType::Float);
  186. EXPECT(v.to_double().value() - 3.14 < NumericLimits<double>().epsilon());
  187. SQL::Serializer serializer;
  188. serializer.serialize<SQL::Value>(v);
  189. serializer.rewind();
  190. auto v2 = serializer.deserialize<SQL::Value>();
  191. EXPECT(!v2.is_null());
  192. EXPECT_EQ(v2.type(), SQL::SQLType::Float);
  193. EXPECT(v.to_double().value() - 3.14 < NumericLimits<double>().epsilon());
  194. }
  195. TEST_CASE(assign_int_to_text_value)
  196. {
  197. SQL::Value text(SQL::SQLType::Text);
  198. text = 42;
  199. EXPECT_EQ((String)text, "42");
  200. }
  201. TEST_CASE(copy_value)
  202. {
  203. SQL::Value text(SQL::SQLType::Text, 42);
  204. SQL::Value copy(text);
  205. EXPECT_EQ((String)copy, "42");
  206. }
  207. TEST_CASE(compare_text_to_int)
  208. {
  209. SQL::Value text(SQL::SQLType::Text);
  210. text = 42;
  211. SQL::Value integer(SQL::SQLType::Integer);
  212. integer = 42;
  213. EXPECT(text == integer);
  214. EXPECT(integer == text);
  215. }
  216. TEST_CASE(bool_value)
  217. {
  218. {
  219. SQL::Value v(SQL::SQLType::Boolean);
  220. EXPECT(v.is_null());
  221. v = true;
  222. EXPECT(!v.is_null());
  223. EXPECT(v.to_bool().has_value());
  224. EXPECT(v.to_bool().value());
  225. EXPECT_EQ(v.to_int().value(), 1);
  226. EXPECT_EQ(v.to_string(), "true");
  227. EXPECT(!v.to_double().has_value());
  228. }
  229. {
  230. SQL::Value v(SQL::SQLType::Boolean, false);
  231. EXPECT(!v.is_null());
  232. EXPECT(v.to_bool().has_value());
  233. EXPECT(!v.to_bool().value());
  234. EXPECT_EQ(v.to_int().value(), 0);
  235. EXPECT_EQ(v.to_string(), "false");
  236. EXPECT(!v.to_double().has_value());
  237. }
  238. {
  239. SQL::Value v(true);
  240. EXPECT_EQ(v.type(), SQL::SQLType::Boolean);
  241. EXPECT(!v.is_null());
  242. EXPECT(v.to_bool().has_value());
  243. EXPECT(v.to_bool().value());
  244. }
  245. }
  246. TEST_CASE(serialize_boolean_value)
  247. {
  248. SQL::Value v(true);
  249. EXPECT_EQ(v.type(), SQL::SQLType::Boolean);
  250. EXPECT(bool(v));
  251. SQL::Serializer serializer;
  252. serializer.serialize<SQL::Value>(v);
  253. serializer.rewind();
  254. auto v2 = serializer.deserialize<SQL::Value>();
  255. EXPECT(!v2.is_null());
  256. EXPECT_EQ(v2.type(), SQL::SQLType::Boolean);
  257. EXPECT(bool(v2));
  258. EXPECT_EQ(v, v2);
  259. }
  260. TEST_CASE(tuple_value)
  261. {
  262. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  263. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  264. descriptor->append({ "col2", SQL::SQLType::Integer, SQL::Order::Descending });
  265. auto v = SQL::Value::create_tuple(descriptor);
  266. Vector<SQL::Value> values;
  267. values.append(SQL::Value("Test"));
  268. values.append(SQL::Value(42));
  269. v = values;
  270. auto values2 = v.to_vector();
  271. EXPECT(values2.has_value());
  272. EXPECT_EQ(values, values2.value());
  273. }
  274. TEST_CASE(copy_tuple_value)
  275. {
  276. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  277. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  278. descriptor->append({ "col2", SQL::SQLType::Integer, SQL::Order::Descending });
  279. auto v = SQL::Value::create_tuple(descriptor);
  280. Vector<SQL::Value> values;
  281. values.append(SQL::Value("Test"));
  282. values.append(SQL::Value(42));
  283. v = values;
  284. auto values2 = v;
  285. EXPECT(values2.type() == v.type());
  286. EXPECT(!values2.is_null());
  287. EXPECT_EQ(values, values2.to_vector().value());
  288. }
  289. TEST_CASE(tuple_value_wrong_type)
  290. {
  291. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  292. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  293. auto v = SQL::Value::create_tuple(descriptor);
  294. Vector<SQL::Value> values;
  295. values.append(SQL::Value(42));
  296. v = values;
  297. EXPECT(v.is_null());
  298. }
  299. TEST_CASE(tuple_value_too_many_values)
  300. {
  301. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  302. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  303. auto v = SQL::Value::create_tuple(descriptor);
  304. Vector<SQL::Value> values;
  305. values.append(SQL::Value("Test"));
  306. values.append(SQL::Value(42));
  307. v = values;
  308. EXPECT(v.is_null());
  309. }
  310. TEST_CASE(tuple_value_not_enough_values)
  311. {
  312. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  313. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  314. descriptor->append({ "col2", SQL::SQLType::Integer, SQL::Order::Ascending });
  315. auto v = SQL::Value::create_tuple(descriptor);
  316. Vector<SQL::Value> values;
  317. values.append(SQL::Value("Test"));
  318. v = values;
  319. EXPECT(!v.is_null());
  320. auto values_opt = v.to_vector();
  321. EXPECT(values_opt.has_value());
  322. EXPECT_EQ(values_opt.value().size(), 2u);
  323. auto col2 = values_opt.value()[1];
  324. EXPECT_EQ(col2.type(), SQL::SQLType::Integer);
  325. EXPECT(col2.is_null());
  326. }
  327. TEST_CASE(serialize_tuple_value)
  328. {
  329. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  330. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  331. descriptor->append({ "col2", SQL::SQLType::Integer, SQL::Order::Descending });
  332. auto v = SQL::Value::create_tuple(descriptor);
  333. Vector<SQL::Value> values;
  334. values.append(SQL::Value("Test"));
  335. values.append(SQL::Value(42));
  336. v = values;
  337. SQL::Serializer serializer;
  338. serializer.serialize<SQL::Value>(v);
  339. serializer.rewind();
  340. auto v2 = serializer.deserialize<SQL::Value>();
  341. EXPECT(!v2.is_null());
  342. EXPECT_EQ(v2.type(), SQL::SQLType::Tuple);
  343. EXPECT_EQ(v, v2);
  344. }
  345. TEST_CASE(array_value)
  346. {
  347. auto v = SQL::Value::create_array(SQL::SQLType::Text, 3);
  348. Vector<SQL::Value> values;
  349. values.append(SQL::Value("Test 1"));
  350. values.append(SQL::Value("Test 2"));
  351. v = values;
  352. auto values2 = v.to_vector();
  353. EXPECT(values2.has_value());
  354. EXPECT_EQ(values, values2.value());
  355. }
  356. TEST_CASE(array_value_wrong_type)
  357. {
  358. auto v = SQL::Value::create_array(SQL::SQLType::Text, 2);
  359. Vector<SQL::Value> values;
  360. values.append(SQL::Value("Test 1"));
  361. values.append(SQL::Value(42));
  362. v = values;
  363. EXPECT(v.is_null());
  364. }
  365. TEST_CASE(array_value_too_many_values)
  366. {
  367. auto v = SQL::Value::create_array(SQL::SQLType::Text, 2);
  368. Vector<SQL::Value> values;
  369. values.append(SQL::Value("Test 1"));
  370. values.append(SQL::Value("Test 2"));
  371. values.append(SQL::Value("Test 3"));
  372. v = values;
  373. EXPECT(v.is_null());
  374. }
  375. TEST_CASE(copy_array_value)
  376. {
  377. auto v = SQL::Value::create_array(SQL::SQLType::Text, 3);
  378. Vector<SQL::Value> values;
  379. values.append(SQL::Value("Test 1"));
  380. values.append(SQL::Value("Test 2"));
  381. v = values;
  382. auto values2 = v;
  383. EXPECT(values2.type() == v.type());
  384. EXPECT(!values2.is_null());
  385. EXPECT_EQ(values, values2.to_vector().value());
  386. }
  387. TEST_CASE(serialize_array_value)
  388. {
  389. auto v = SQL::Value::create_array(SQL::SQLType::Text, 3);
  390. Vector<SQL::Value> values;
  391. values.append(SQL::Value("Test 1"));
  392. values.append(SQL::Value("Test 2"));
  393. v = values;
  394. SQL::Serializer serializer;
  395. serializer.serialize<SQL::Value>(v);
  396. serializer.rewind();
  397. auto v2 = serializer.deserialize<SQL::Value>();
  398. EXPECT(!v2.is_null());
  399. EXPECT_EQ(v2.type(), SQL::SQLType::Array);
  400. EXPECT_EQ(v, v2);
  401. }
  402. TEST_CASE(order_text_values)
  403. {
  404. SQL::Value v1(SQL::SQLType::Text);
  405. v1 = "Test_A";
  406. SQL::Value v2(SQL::SQLType::Text);
  407. v2 = "Test_B";
  408. EXPECT(v1 <= v2);
  409. EXPECT(v1 < v2);
  410. EXPECT(v2 >= v1);
  411. EXPECT(v2 > v1);
  412. }
  413. TEST_CASE(order_int_values)
  414. {
  415. SQL::Value v1(SQL::SQLType::Integer);
  416. v1 = 12;
  417. SQL::Value v2(SQL::SQLType::Integer);
  418. v2 = 42;
  419. EXPECT(v1 <= v2);
  420. EXPECT(v1 < v2);
  421. EXPECT(v2 >= v1);
  422. EXPECT(v2 > v1);
  423. }
  424. TEST_CASE(tuple)
  425. {
  426. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  427. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  428. descriptor->append({ "col2", SQL::SQLType::Integer, SQL::Order::Descending });
  429. SQL::Tuple tuple(descriptor);
  430. tuple["col1"] = "Test";
  431. tuple["col2"] = 42;
  432. EXPECT(tuple[0] == "Test");
  433. EXPECT(tuple[1] == 42);
  434. }
  435. TEST_CASE(serialize_tuple)
  436. {
  437. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  438. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  439. descriptor->append({ "col2", SQL::SQLType::Integer, SQL::Order::Descending });
  440. SQL::Tuple tuple(descriptor);
  441. tuple["col1"] = "Test";
  442. tuple["col2"] = 42;
  443. EXPECT_EQ((String)tuple[0], "Test");
  444. EXPECT_EQ((int)tuple[1], 42);
  445. SQL::Serializer serializer;
  446. serializer.serialize<SQL::Tuple>(tuple);
  447. serializer.rewind();
  448. auto tuple2 = serializer.deserialize<SQL::Tuple>();
  449. EXPECT(tuple2[0] == "Test");
  450. EXPECT(tuple2[1] == 42);
  451. }
  452. TEST_CASE(copy_tuple)
  453. {
  454. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  455. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  456. descriptor->append({ "col2", SQL::SQLType::Integer, SQL::Order::Descending });
  457. SQL::Tuple tuple(descriptor);
  458. tuple["col1"] = "Test";
  459. tuple["col2"] = 42;
  460. SQL::Tuple copy;
  461. copy = tuple;
  462. EXPECT(tuple == copy);
  463. SQL::Tuple copy_2(copy);
  464. EXPECT(tuple == copy_2);
  465. }
  466. TEST_CASE(compare_tuples)
  467. {
  468. NonnullRefPtr<SQL::TupleDescriptor> descriptor = adopt_ref(*new SQL::TupleDescriptor);
  469. descriptor->append({ "col1", SQL::SQLType::Text, SQL::Order::Ascending });
  470. descriptor->append({ "col2", SQL::SQLType::Integer, SQL::Order::Descending });
  471. SQL::Tuple tuple1(descriptor);
  472. tuple1["col1"] = "Test";
  473. tuple1["col2"] = 42;
  474. SQL::Tuple tuple2(descriptor);
  475. tuple2["col1"] = "Test";
  476. tuple2["col2"] = 12;
  477. SQL::Tuple tuple3(descriptor);
  478. tuple3["col1"] = "Text";
  479. tuple3["col2"] = 12;
  480. EXPECT(tuple1 <= tuple2);
  481. EXPECT(tuple1 < tuple2);
  482. EXPECT(tuple2 >= tuple1);
  483. EXPECT(tuple2 > tuple1);
  484. EXPECT(tuple1 <= tuple3);
  485. EXPECT(tuple1 < tuple3);
  486. EXPECT(tuple3 >= tuple1);
  487. EXPECT(tuple3 > tuple1);
  488. }