taipy/tests/core/data/test_csv_data_node.py

# Copyright 2021-2025 Avaiga Private Limited
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
#        http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on
# an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the
# specific language governing permissions and limitations under the License.

import dataclasses
import os
import pathlib
import re
import uuid
from datetime import datetime, timedelta
from time import sleep

import freezegun
import numpy as np
import pandas as pd
import pytest
from pandas.testing import assert_frame_equal

from taipy import Scope
from taipy.common.config import Config
from taipy.common.config.exceptions.exceptions import InvalidConfigurationId
from taipy.core.common._utils import _normalize_path
from taipy.core.data._data_manager import _DataManager
from taipy.core.data._data_manager_factory import _DataManagerFactory
from taipy.core.data.csv import CSVDataNode
from taipy.core.data.data_node_id import DataNodeId
from taipy.core.exceptions.exceptions import InvalidExposedType
from taipy.core.reason import NoFileToDownload, NotAFile


@pytest.fixture(scope="function", autouse=True)
def cleanup():
    yield
    path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/temp.csv")
    if os.path.isfile(path):
        os.remove(path)


@dataclasses.dataclass
class MyCustomObject:
    id: int
    integer: int
    text: str


class TestCSVDataNode:
    def test_create(self):
        default_path = "data/node/path"
        csv_dn_config = Config.configure_csv_data_node(
            id="foo_bar", default_path=default_path, has_header=False, name="super name"
        )
        dn = _DataManagerFactory._build_manager()._create(csv_dn_config, None, None)
        assert isinstance(dn, CSVDataNode)
        assert dn.storage_type() == "csv"
        assert dn.config_id == "foo_bar"
        assert dn.name == "super name"
        assert dn.scope == Scope.SCENARIO
        assert dn.id is not None
        assert dn.owner_id is None
        assert dn.last_edit_date is None
        assert dn.job_ids == []
        assert not dn.is_ready_for_reading
        assert dn.path == default_path
        assert dn.properties["has_header"] is False
        assert dn.properties["exposed_type"] == "pandas"

        csv_dn_config = Config.configure_csv_data_node(
            id="foo", default_path=default_path, has_header=True, exposed_type=MyCustomObject
        )
        dn = _DataManagerFactory._build_manager()._create(csv_dn_config, None, None)
        assert dn.storage_type() == "csv"
        assert dn.config_id == "foo"
        assert dn.properties["has_header"] is True
        assert dn.properties["exposed_type"] == MyCustomObject

        with pytest.raises(InvalidConfigurationId):
            CSVDataNode(
                "foo bar", Scope.SCENARIO, properties={"path": default_path, "has_header": False, "name": "super name"}
            )

    def test_modin_deprecated_in_favor_of_pandas(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        # Create CSVDataNode with modin exposed_type
        csv_data_node_as_modin = CSVDataNode("bar", Scope.SCENARIO, properties={"path": path, "exposed_type": "modin"})
        assert csv_data_node_as_modin.properties["exposed_type"] == "pandas"
        data_modin = csv_data_node_as_modin.read()
        assert isinstance(data_modin, pd.DataFrame)

    def test_get_user_properties(self, csv_file):
        dn_1 = CSVDataNode("dn_1", Scope.SCENARIO, properties={"path": "data/node/path"})
        assert dn_1._get_user_properties() == {}

        dn_2 = CSVDataNode(
            "dn_2",
            Scope.SCENARIO,
            properties={
                "exposed_type": "numpy",
                "default_data": "foo",
                "default_path": csv_file,
                "has_header": False,
                "foo": "bar",
            },
        )

        # exposed_type, default_data, default_path, path, has_header, sheet_name are filtered out
        assert dn_2._get_user_properties() == {"foo": "bar"}

    def test_new_csv_data_node_with_existing_file_is_ready_for_reading(self):
        not_ready_dn_cfg = Config.configure_data_node("not_ready_data_node_config_id", "csv", path="NOT_EXISTING.csv")
        not_ready_dn = _DataManager._bulk_get_or_create([not_ready_dn_cfg])[not_ready_dn_cfg]
        assert not not_ready_dn.is_ready_for_reading

        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        ready_dn_cfg = Config.configure_data_node("ready_data_node_config_id", "csv", path=path)
        ready_dn = _DataManager._bulk_get_or_create([ready_dn_cfg])[ready_dn_cfg]
        assert ready_dn.is_ready_for_reading

    @pytest.mark.parametrize(
        ["properties", "exists"],
        [
            ({}, False),
            ({"default_data": ["foo", "bar"]}, True),
        ],
    )
    def test_create_with_default_data(self, properties, exists):
        dn = CSVDataNode("foo", Scope.SCENARIO, DataNodeId(f"dn_id_{uuid.uuid4()}"), properties=properties)
        assert dn.path == f"{Config.core.storage_folder}csvs/{dn.id}.csv"
        assert os.path.exists(dn.path) is exists

    def test_set_path(self):
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"default_path": "foo.csv"})
        _DataManagerFactory._build_manager()._repository._save(dn)
        assert dn.path == "foo.csv"
        dn.path = "bar.csv"
        assert dn.path == "bar.csv"

    def test_read_write_after_modify_path(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        new_path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/temp.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"default_path": path})
        _DataManagerFactory._build_manager()._repository._save(dn)
        read_data = dn.read()
        assert read_data is not None
        dn.path = new_path
        with pytest.raises(FileNotFoundError):
            dn.read()
        dn.write(read_data)
        assert dn.read().equals(read_data)

    def test_pandas_exposed_type(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": "pandas"})
        assert isinstance(dn.read(), pd.DataFrame)

    def test_pandas_dataframe_exposed_type(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": pd.DataFrame})
        assert isinstance(dn.read(), pd.DataFrame)

    def test_pandas_dataframe_exposed_type_a(self):
        import pandas

        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": pandas.DataFrame})
        assert isinstance(dn.read(), pandas.DataFrame)

    def test_pandas_dataframe_exposed_type_b(self):
        from pandas import DataFrame

        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": DataFrame})
        assert isinstance(dn.read(), DataFrame)

    def test_pandas_dataframe_exposed_type_c(self):
        from pandas import DataFrame as DF

        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": DF})
        assert isinstance(dn.read(), DF)

    def test_numpy_ndarray_exposed_type(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": np.ndarray})
        assert isinstance(dn.read(), np.ndarray)

    def test_numpy_ndarray_exposed_type_a(self):
        import numpy

        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": numpy.ndarray})
        assert isinstance(dn.read(), numpy.ndarray)

    def test_numpy_ndarray_exposed_type_b(self):
        from numpy import ndarray

        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": ndarray})
        assert isinstance(dn.read(), ndarray)

    def test_numpy_ndarray_exposed_type_c(self):
        from numpy import ndarray as nd_array

        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": nd_array})
        assert isinstance(dn.read(), nd_array)

    def test_raise_error_invalid_exposed_type(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        with pytest.raises(InvalidExposedType):
            CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": "foo"})

    def test_get_system_modified_date_instead_of_last_edit_date(self, tmpdir_factory):
        temp_file_path = str(tmpdir_factory.mktemp("data").join("temp.csv"))
        pd.DataFrame([]).to_csv(temp_file_path)
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": temp_file_path, "exposed_type": "pandas"})
        _DataManagerFactory._build_manager()._repository._save(dn)

        dn.write(pd.DataFrame([1, 2, 3]))
        previous_edit_date = dn.last_edit_date

        sleep(0.1)

        pd.DataFrame([4, 5, 6]).to_csv(temp_file_path)
        new_edit_date = datetime.fromtimestamp(os.path.getmtime(temp_file_path))

        assert previous_edit_date < dn.last_edit_date
        assert new_edit_date == dn.last_edit_date

        sleep(0.1)

        dn.write(pd.DataFrame([7, 8, 9]))
        assert new_edit_date < dn.last_edit_date
        os.unlink(temp_file_path)

    def test_migrate_to_new_path(self, tmp_path):
        _base_path = os.path.join(tmp_path, ".data")
        path = os.path.join(_base_path, "test.csv")
        # create a file on old path
        os.mkdir(_base_path)
        with open(path, "w"):
            pass

        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": "pandas"})

        assert ".data" not in dn.path
        assert os.path.exists(dn.path)

    def test_is_downloadable(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": "pandas"})
        reasons = dn.is_downloadable()
        assert reasons
        assert reasons.reasons == ""

    def test_is_not_downloadable_no_file(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/wrong_example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": "pandas"})
        reasons = dn.is_downloadable()
        assert not reasons
        assert len(reasons._reasons) == 1
        assert str(NoFileToDownload(_normalize_path(path), dn.id)) in reasons.reasons

    def test_is_not_downloadable_not_a_file(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": "pandas"})
        reasons = dn.is_downloadable()
        assert not reasons
        assert len(reasons._reasons) == 1
        assert str(NotAFile(_normalize_path(path), dn.id)) in reasons.reasons

    def test_get_downloadable_path(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": "pandas"})
        assert re.split(r"[\\/]", dn._get_downloadable_path()) == re.split(r"[\\/]", path)

    def test_get_downloadable_path_with_not_existing_file(self):
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": "NOT_EXISTING.csv", "exposed_type": "pandas"})
        assert dn._get_downloadable_path() == ""

    def is_uploadable(self):
        path = os.path.join(pathlib.Path(__file__).parent.resolve(), "data_sample/example.csv")
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": path, "exposed_type": "pandas"})
        assert dn.is_uploadable()

    def test_upload(self, csv_file, tmpdir_factory):
        old_csv_path = tmpdir_factory.mktemp("data").join("df.csv").strpath
        old_data = pd.DataFrame([{"a": 0, "b": 1, "c": 2}, {"a": 3, "b": 4, "c": 5}])

        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": old_csv_path, "exposed_type": "pandas"})
        _DataManagerFactory._build_manager()._repository._save(dn)
        dn.write(old_data)
        old_last_edit_date = dn.last_edit_date

        upload_content = pd.read_csv(csv_file)

        with freezegun.freeze_time(old_last_edit_date + timedelta(seconds=1)):
            dn._upload(csv_file)

        assert_frame_equal(dn.read(), upload_content)  # The content of the dn should change to the uploaded content
        assert dn.last_edit_date > old_last_edit_date
        assert dn.path == _normalize_path(old_csv_path)  # The path of the dn should not change

    def test_upload_fails_if_data_node_locked(self, csv_file, tmpdir_factory):
        old_csv_path = tmpdir_factory.mktemp("data").join("df.csv").strpath
        old_data = pd.DataFrame([{"a": 0, "b": 1, "c": 2}, {"a": 3, "b": 4, "c": 5}])

        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": old_csv_path, "exposed_type": "pandas"})
        _DataManagerFactory._build_manager()._repository._save(dn)
        dn.write(old_data)
        upload_content = pd.read_csv(csv_file)
        dn.lock_edit("editor_id_1")

        reasons = dn._upload(csv_file, editor_id="editor_id_2")
        assert not reasons

        assert dn._upload(csv_file, editor_id="editor_id_1")

        assert_frame_equal(dn.read(), upload_content)  # The content of the dn should change to the uploaded content

    def test_upload_with_upload_check_with_exception(self, csv_file, tmpdir_factory, caplog):
        old_csv_path = tmpdir_factory.mktemp("data").join("df.csv").strpath
        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": old_csv_path, "exposed_type": "pandas"})

        def check_with_exception(upload_path, upload_data):
            raise Exception("An error with check_with_exception")

        reasons = dn._upload(csv_file, upload_checker=check_with_exception)
        assert bool(reasons) is False
        assert (
            f"Error with the upload checker `check_with_exception` "
            f"while checking `df.csv` file for upload to the data "
            f"node `{dn.id}`:" in caplog.text
        )

    def test_upload_with_upload_check_pandas(self, csv_file, tmpdir_factory):
        old_csv_path = tmpdir_factory.mktemp("data").join("df.csv").strpath
        old_data = pd.DataFrame([{"a": 0, "b": 1, "c": 2}, {"a": 3, "b": 4, "c": 5}])

        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": old_csv_path, "exposed_type": "pandas"})
        _DataManagerFactory._build_manager()._repository._save(dn)
        dn.write(old_data)
        old_last_edit_date = dn.last_edit_date

        def check_data_column(upload_path, upload_data):
            return upload_path.endswith(".csv") and upload_data.columns.tolist() == ["a", "b", "c"]

        not_exists_csv_path = tmpdir_factory.mktemp("data").join("not_exists.csv").strpath
        reasons = dn._upload(not_exists_csv_path, upload_checker=check_data_column)
        assert bool(reasons) is False
        assert (
            str(list(reasons._reasons[dn.id])[0]) == "The uploaded file 'not_exists.csv' can not be read,"
            f" therefore is not a valid data file for data node '{dn.id}'"
        )

        not_csv_path = tmpdir_factory.mktemp("data").join("wrong_format_df.not_csv").strpath
        old_data.to_csv(not_csv_path, index=False)
        # The upload should fail when the file is not a csv
        reasons = dn._upload(not_csv_path, upload_checker=check_data_column)
        assert bool(reasons) is False
        assert (
            str(list(reasons._reasons[dn.id])[0])
            == f"The uploaded file 'wrong_format_df.not_csv' has invalid data for data node '{dn.id}'"
        )

        wrong_format_csv_path = tmpdir_factory.mktemp("data").join("wrong_format_df.csv").strpath
        pd.DataFrame([{"a": 1, "b": 2, "d": 3}, {"a": 4, "b": 5, "d": 6}]).to_csv(wrong_format_csv_path, index=False)
        # The upload should fail when check_data_column() return False
        reasons = dn._upload(wrong_format_csv_path, upload_checker=check_data_column)
        assert bool(reasons) is False
        assert (
            str(list(reasons._reasons[dn.id])[0])
            == f"The uploaded file 'wrong_format_df.csv' has invalid data for data node '{dn.id}'"
        )

        assert_frame_equal(dn.read(), old_data)  # The content of the dn should not change when upload fails
        assert dn.last_edit_date == old_last_edit_date  # The last edit date should not change when upload fails
        assert dn.path == _normalize_path(old_csv_path)  # The path of the dn should not change

        # The upload should succeed when check_data_column() return True
        assert dn._upload(csv_file, upload_checker=check_data_column)

    def test_upload_with_upload_check_numpy(self, tmpdir_factory):
        old_csv_path = tmpdir_factory.mktemp("data").join("df.csv").strpath
        old_data = np.array([[1, 2, 3], [4, 5, 6]])

        new_csv_path = tmpdir_factory.mktemp("data").join("new_upload_data.csv").strpath
        new_data = np.array([[1, 2, 3], [4, 5, 6]])
        pd.DataFrame(new_data).to_csv(new_csv_path, index=False)

        dn = CSVDataNode("foo", Scope.SCENARIO, properties={"path": old_csv_path, "exposed_type": "numpy"})
        _DataManagerFactory._build_manager()._repository._save(dn)
        dn.write(old_data)
        old_last_edit_date = dn.last_edit_date

        def check_data_is_positive(upload_path, upload_data):
            return upload_path.endswith(".csv") and np.all(upload_data > 0)

        not_exists_csv_path = tmpdir_factory.mktemp("data").join("not_exists.csv").strpath
        reasons = dn._upload(not_exists_csv_path, upload_checker=check_data_is_positive)
        assert bool(reasons) is False
        assert (
            str(list(reasons._reasons[dn.id])[0]) == "The uploaded file 'not_exists.csv' can not be read"
            f", therefore is not a valid data file for data node '{dn.id}'"
        )

        not_csv_path = tmpdir_factory.mktemp("data").join("wrong_format_df.not_csv").strpath
        pd.DataFrame(old_data).to_csv(not_csv_path, index=False)
        # The upload should fail when the file is not a csv
        reasons = dn._upload(not_csv_path, upload_checker=check_data_is_positive)
        assert bool(reasons) is False
        assert (
            str(list(reasons._reasons[dn.id])[0])
            == f"The uploaded file 'wrong_format_df.not_csv' has invalid data for data node '{dn.id}'"
        )

        wrong_format_csv_path = tmpdir_factory.mktemp("data").join("wrong_format_df.csv").strpath
        pd.DataFrame(np.array([[-1, 2, 3], [-4, -5, -6]])).to_csv(wrong_format_csv_path, index=False)
        # The upload should fail when check_data_is_positive() return False
        reasons = dn._upload(wrong_format_csv_path, upload_checker=check_data_is_positive)
        assert bool(reasons) is False
        assert (
            str(list(reasons._reasons[dn.id])[0])
            == f"The uploaded file 'wrong_format_df.csv' has invalid data for data node '{dn.id}'"
        )

        np.array_equal(dn.read(), old_data)  # The content of the dn should not change when upload fails
        assert dn.last_edit_date == old_last_edit_date  # The last edit date should not change when upload fails
        assert dn.path == _normalize_path(old_csv_path)  # The path of the dn should not change

        # The upload should succeed when check_data_is_positive() return True
        assert dn._upload(new_csv_path, upload_checker=check_data_is_positive)