test_json_data_node.py 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429
  1. # Copyright 2021-2024 Avaiga Private Limited
  2. #
  3. # Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with
  4. # the License. You may obtain a copy of the License at
  5. #
  6. # http://www.apache.org/licenses/LICENSE-2.0
  7. #
  8. # Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on
  9. # an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the
  10. # specific language governing permissions and limitations under the License.
  11. import datetime
  12. import json
  13. import os
  14. import pathlib
  15. import uuid
  16. from dataclasses import dataclass
  17. from enum import Enum
  18. from time import sleep
  19. import numpy as np
  20. import pandas as pd
  21. import pytest
  22. from taipy.config.common.scope import Scope
  23. from taipy.config.config import Config
  24. from taipy.config.exceptions.exceptions import InvalidConfigurationId
  25. from taipy.core.data._data_manager import _DataManager
  26. from taipy.core.data.data_node_id import DataNodeId
  27. from taipy.core.data.json import JSONDataNode
  28. from taipy.core.data.operator import JoinOperator, Operator
  29. from taipy.core.exceptions.exceptions import NoData
  30. @pytest.fixture(scope="function", autouse=True)
  31. def cleanup():
  32. yield
  33. path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/temp.json")
  34. if os.path.isfile(path):
  35. os.remove(path)
  36. class MyCustomObject:
  37. def __init__(self, id, integer, text):
  38. self.id = id
  39. self.integer = integer
  40. self.text = text
  41. class MyCustomObject2:
  42. def __init__(self, id, boolean, text):
  43. self.id = id
  44. self.boolean = boolean
  45. self.text = text
  46. class MyEnum(Enum):
  47. A = 1
  48. B = 2
  49. C = 3
  50. @dataclass
  51. class CustomDataclass:
  52. integer: int
  53. string: str
  54. class MyCustomEncoder(json.JSONEncoder):
  55. def default(self, o):
  56. if isinstance(o, MyCustomObject):
  57. return {"__type__": "MyCustomObject", "id": o.id, "integer": o.integer, "text": o.text}
  58. return super().default(self, o)
  59. class MyCustomDecoder(json.JSONDecoder):
  60. def __init__(self, *args, **kwargs):
  61. super().__init__(*args, **kwargs, object_hook=self.object_hook)
  62. def object_hook(self, o):
  63. if o.get("__type__") == "MyCustomObject":
  64. return MyCustomObject(o["id"], o["integer"], o["text"])
  65. else:
  66. return o
  67. class TestJSONDataNode:
  68. def test_create(self):
  69. path = "data/node/path"
  70. dn = JSONDataNode("foo_bar", Scope.SCENARIO, properties={"default_path": path, "name": "super name"})
  71. assert isinstance(dn, JSONDataNode)
  72. assert dn.storage_type() == "json"
  73. assert dn.config_id == "foo_bar"
  74. assert dn.name == "super name"
  75. assert dn.scope == Scope.SCENARIO
  76. assert dn.id is not None
  77. assert dn.owner_id is None
  78. assert dn.last_edit_date is None
  79. assert dn.job_ids == []
  80. assert not dn.is_ready_for_reading
  81. assert dn.path == path
  82. with pytest.raises(InvalidConfigurationId):
  83. dn = JSONDataNode(
  84. "foo bar", Scope.SCENARIO, properties={"default_path": path, "has_header": False, "name": "super name"}
  85. )
  86. def test_get_user_properties(self, json_file):
  87. dn_1 = JSONDataNode("dn_1", Scope.SCENARIO, properties={"path": json_file})
  88. assert dn_1._get_user_properties() == {}
  89. dn_2 = JSONDataNode(
  90. "dn_2",
  91. Scope.SCENARIO,
  92. properties={
  93. "default_data": "foo",
  94. "default_path": json_file,
  95. "encoder": MyCustomEncoder,
  96. "decoder": MyCustomDecoder,
  97. "foo": "bar",
  98. },
  99. )
  100. # default_data, default_path, path, encoder, decoder are filtered out
  101. assert dn_2._get_user_properties() == {"foo": "bar"}
  102. def test_new_json_data_node_with_existing_file_is_ready_for_reading(self):
  103. not_ready_dn_cfg = Config.configure_data_node(
  104. "not_ready_data_node_config_id", "json", default_path="NOT_EXISTING.json"
  105. )
  106. not_ready_dn = _DataManager._bulk_get_or_create([not_ready_dn_cfg])[not_ready_dn_cfg]
  107. assert not not_ready_dn.is_ready_for_reading
  108. assert not_ready_dn.path == "NOT_EXISTING.json"
  109. path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/json/example_list.json")
  110. ready_dn_cfg = Config.configure_data_node("ready_data_node_config_id", "json", default_path=path)
  111. ready_dn = _DataManager._bulk_get_or_create([ready_dn_cfg])[ready_dn_cfg]
  112. assert ready_dn.is_ready_for_reading
  113. def test_read_non_existing_json(self):
  114. not_existing_json = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": "WRONG.json"})
  115. with pytest.raises(NoData):
  116. assert not_existing_json.read() is None
  117. not_existing_json.read_or_raise()
  118. def test_read(self):
  119. path_1 = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/json/example_list.json")
  120. dn_1 = JSONDataNode("bar", Scope.SCENARIO, properties={"default_path": path_1})
  121. data_1 = dn_1.read()
  122. assert isinstance(data_1, list)
  123. assert len(data_1) == 4
  124. path_2 = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/json/example_dict.json")
  125. dn_2 = JSONDataNode("bar", Scope.SCENARIO, properties={"default_path": path_2})
  126. data_2 = dn_2.read()
  127. assert isinstance(data_2, dict)
  128. assert data_2["id"] == "1"
  129. path_3 = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/json/example_int.json")
  130. dn_3 = JSONDataNode("bar", Scope.SCENARIO, properties={"default_path": path_3})
  131. data_3 = dn_3.read()
  132. assert isinstance(data_3, int)
  133. assert data_3 == 1
  134. path_4 = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/json/example_null.json")
  135. dn_4 = JSONDataNode("bar", Scope.SCENARIO, properties={"default_path": path_4})
  136. data_4 = dn_4.read()
  137. assert data_4 is None
  138. def test_read_invalid_json(self):
  139. path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/invalid.json.txt")
  140. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": path})
  141. with pytest.raises(ValueError):
  142. dn.read()
  143. def test_append_to_list(self, json_file):
  144. json_dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": json_file})
  145. original_data = json_dn.read()
  146. # Append a dictionary
  147. append_data_1 = {"a": 1, "b": 2, "c": 3}
  148. json_dn.append(append_data_1)
  149. assert json_dn.read() == original_data + [append_data_1]
  150. # Append a list of dictionaries
  151. append_data_data_2 = [{"a": 1, "b": 2, "c": 3}, {"a": 4, "b": 5, "c": 6}]
  152. json_dn.append(append_data_data_2)
  153. assert json_dn.read() == original_data + [append_data_1] + append_data_data_2
  154. def test_append_to_a_dictionary(self, json_file):
  155. json_dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": json_file})
  156. original_data = {"a": 1, "b": 2, "c": 3}
  157. json_dn.write(original_data)
  158. # Append another dictionary
  159. append_data_1 = {"d": 1, "e": 2, "f": 3}
  160. json_dn.append(append_data_1)
  161. assert json_dn.read() == {**original_data, **append_data_1}
  162. # Append an overlap dictionary
  163. append_data_data_2 = {"a": 10, "b": 20, "g": 30}
  164. json_dn.append(append_data_data_2)
  165. assert json_dn.read() == {**original_data, **append_data_1, **append_data_data_2}
  166. def test_write(self, json_file):
  167. json_dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": json_file})
  168. data = {"a": 1, "b": 2, "c": 3}
  169. json_dn.write(data)
  170. assert np.array_equal(json_dn.read(), data)
  171. def test_write_with_different_encoding(self, json_file):
  172. data = {"≥a": 1, "b": 2}
  173. utf8_dn = JSONDataNode("utf8_dn", Scope.SCENARIO, properties={"default_path": json_file})
  174. utf16_dn = JSONDataNode(
  175. "utf16_dn", Scope.SCENARIO, properties={"default_path": json_file, "encoding": "utf-16"}
  176. )
  177. # If a file is written with utf-8 encoding, it can only be read with utf-8, not utf-16 encoding
  178. utf8_dn.write(data)
  179. assert np.array_equal(utf8_dn.read(), data)
  180. with pytest.raises(UnicodeError):
  181. utf16_dn.read()
  182. # If a file is written with utf-16 encoding, it can only be read with utf-16, not utf-8 encoding
  183. utf16_dn.write(data)
  184. assert np.array_equal(utf16_dn.read(), data)
  185. with pytest.raises(UnicodeError):
  186. utf8_dn.read()
  187. def test_write_non_serializable(self, json_file):
  188. json_dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": json_file})
  189. data = {"a": 1, "b": json_dn}
  190. with pytest.raises(TypeError):
  191. json_dn.write(data)
  192. def test_write_date(self, json_file):
  193. json_dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": json_file})
  194. now = datetime.datetime.now()
  195. data = {"date": now}
  196. json_dn.write(data)
  197. read_data = json_dn.read()
  198. assert read_data["date"] == now
  199. def test_write_enum(self, json_file):
  200. json_dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": json_file})
  201. data = [MyEnum.A, MyEnum.B, MyEnum.C]
  202. json_dn.write(data)
  203. read_data = json_dn.read()
  204. assert read_data == [MyEnum.A, MyEnum.B, MyEnum.C]
  205. def test_write_dataclass(self, json_file):
  206. json_dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": json_file})
  207. json_dn.write(CustomDataclass(integer=1, string="foo"))
  208. read_data = json_dn.read()
  209. assert read_data.integer == 1
  210. assert read_data.string == "foo"
  211. def test_write_custom_encoder(self, json_file):
  212. json_dn = JSONDataNode(
  213. "foo", Scope.SCENARIO, properties={"default_path": json_file, "encoder": MyCustomEncoder}
  214. )
  215. data = [MyCustomObject("1", 1, "abc"), 100]
  216. json_dn.write(data)
  217. read_data = json_dn.read()
  218. assert read_data[0]["__type__"] == "MyCustomObject"
  219. assert read_data[0]["id"] == "1"
  220. assert read_data[0]["integer"] == 1
  221. assert read_data[0]["text"] == "abc"
  222. assert read_data[1] == 100
  223. def test_read_write_custom_encoder_decoder(self, json_file):
  224. json_dn = JSONDataNode(
  225. "foo",
  226. Scope.SCENARIO,
  227. properties={"default_path": json_file, "encoder": MyCustomEncoder, "decoder": MyCustomDecoder},
  228. )
  229. data = [MyCustomObject("1", 1, "abc"), 100]
  230. json_dn.write(data)
  231. read_data = json_dn.read()
  232. assert isinstance(read_data[0], MyCustomObject)
  233. assert read_data[0].id == "1"
  234. assert read_data[0].integer == 1
  235. assert read_data[0].text == "abc"
  236. assert read_data[1] == 100
  237. def test_filter(self, json_file):
  238. json_dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": json_file})
  239. json_dn.write(
  240. [
  241. {"foo": 1, "bar": 1},
  242. {"foo": 1, "bar": 2},
  243. {"foo": 1},
  244. {"foo": 2, "bar": 2},
  245. {"bar": 2},
  246. {"KWARGS_KEY": "KWARGS_VALUE"},
  247. ]
  248. )
  249. assert len(json_dn.filter(("foo", 1, Operator.EQUAL))) == 3
  250. assert len(json_dn.filter(("foo", 1, Operator.NOT_EQUAL))) == 3
  251. assert len(json_dn.filter(("bar", 2, Operator.EQUAL))) == 3
  252. assert len(json_dn.filter([("bar", 1, Operator.EQUAL), ("bar", 2, Operator.EQUAL)], JoinOperator.OR)) == 4
  253. assert json_dn[0] == {"foo": 1, "bar": 1}
  254. assert json_dn[2] == {"foo": 1}
  255. assert json_dn[:2] == [{"foo": 1, "bar": 1}, {"foo": 1, "bar": 2}]
  256. @pytest.mark.parametrize(
  257. ["properties", "exists"],
  258. [
  259. ({"default_data": {"foo": "bar"}}, True),
  260. ({}, False),
  261. ],
  262. )
  263. def test_create_with_default_data(self, properties, exists):
  264. dn = JSONDataNode("foo", Scope.SCENARIO, DataNodeId(f"dn_id_{uuid.uuid4()}"), properties=properties)
  265. assert dn.path == os.path.join(Config.core.storage_folder.strip("/"), "jsons", dn.id + ".json")
  266. assert os.path.exists(dn.path) is exists
  267. def test_set_path(self):
  268. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": "foo.json"})
  269. assert dn.path == "foo.json"
  270. dn.path = "bar.json"
  271. assert dn.path == "bar.json"
  272. def test_read_write_after_modify_path(self):
  273. path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/json/example_dict.json")
  274. new_path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/temp.json")
  275. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"default_path": path})
  276. read_data = dn.read()
  277. assert read_data is not None
  278. dn.path = new_path
  279. with pytest.raises(FileNotFoundError):
  280. dn.read()
  281. dn.write({"other": "stuff"})
  282. assert dn.read() == {"other": "stuff"}
  283. def test_get_system_modified_date_instead_of_last_edit_date(self, tmpdir_factory):
  284. temp_file_path = str(tmpdir_factory.mktemp("data").join("temp.json"))
  285. pd.DataFrame([]).to_json(temp_file_path)
  286. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"path": temp_file_path})
  287. dn.write([1, 2, 3])
  288. previous_edit_date = dn.last_edit_date
  289. sleep(0.1)
  290. pd.DataFrame([4, 5, 6]).to_json(temp_file_path)
  291. new_edit_date = datetime.datetime.fromtimestamp(os.path.getmtime(temp_file_path))
  292. assert previous_edit_date < dn.last_edit_date
  293. assert new_edit_date == dn.last_edit_date
  294. sleep(0.1)
  295. dn.write([1, 2, 3])
  296. assert new_edit_date < dn.last_edit_date
  297. os.unlink(temp_file_path)
  298. def test_migrate_to_new_path(self, tmp_path):
  299. _base_path = os.path.join(tmp_path, ".data")
  300. path = os.path.join(_base_path, "test.json")
  301. # create a file on old path
  302. os.mkdir(_base_path)
  303. with open(path, "w"):
  304. pass
  305. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"path": path})
  306. assert ".data" not in dn.path
  307. assert os.path.exists(dn.path)
  308. def test_get_download_path(self):
  309. path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/json/example_dict.json")
  310. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"path": path})
  311. assert dn._get_downloadable_path() == path
  312. def test_get_download_path_with_not_existed_file(self):
  313. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"path": "NOT_EXISTED.json"})
  314. assert dn._get_downloadable_path() == ""
  315. def test_upload(self, json_file, tmpdir_factory):
  316. old_json_path = tmpdir_factory.mktemp("data").join("df.json").strpath
  317. old_data = [{"a": 0, "b": 1, "c": 2}, {"a": 3, "b": 4, "c": 5}]
  318. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"path": old_json_path})
  319. dn.write(old_data)
  320. old_last_edit_date = dn.last_edit_date
  321. with open(json_file, "r") as f:
  322. upload_content = json.load(f)
  323. sleep(0.1)
  324. dn._upload(json_file)
  325. assert dn.read() == upload_content # The content of the dn should change to the uploaded content
  326. assert dn.last_edit_date > old_last_edit_date
  327. assert dn.path == old_json_path # The path of the dn should not change
  328. def test_upload_with_upload_check(self, json_file, tmpdir_factory):
  329. old_json_path = tmpdir_factory.mktemp("data").join("df.json").strpath
  330. old_data = [{"a": 0, "b": 1, "c": 2}, {"a": 3, "b": 4, "c": 5}]
  331. dn = JSONDataNode("foo", Scope.SCENARIO, properties={"path": old_json_path})
  332. dn.write(old_data)
  333. old_last_edit_date = dn.last_edit_date
  334. def check_data_keys(upload_path, upload_data):
  335. all_column_is_abc = all(data.keys() == {"a", "b", "c"} for data in upload_data)
  336. return upload_path.endswith(".json") and all_column_is_abc
  337. wrong_format_not_json_path = tmpdir_factory.mktemp("data").join("wrong_format_df.not_json").strpath
  338. wrong_format_json_path = tmpdir_factory.mktemp("data").join("wrong_format_df.json").strpath
  339. with open(wrong_format_not_json_path, "w") as f:
  340. json.dump([{"a": 1, "b": 2, "d": 3}, {"a": 4, "b": 5, "d": 6}], f)
  341. # The upload should fail when the file is not a json
  342. assert not dn._upload(wrong_format_not_json_path, upload_checker=check_data_keys)
  343. # The upload should fail when check_data_keys() return False
  344. assert not dn._upload(wrong_format_json_path, upload_checker=check_data_keys)
  345. assert dn.read() == old_data # The content of the dn should not change when upload fails
  346. assert dn.last_edit_date == old_last_edit_date # The last edit date should not change when upload fails
  347. assert dn.path == old_json_path # The path of the dn should not change
  348. # The upload should succeed when check_data_keys() return True
  349. assert dn._upload(json_file, upload_checker=check_data_keys)