from typing import Dict
import pathlib


def get_asset_root() -> Dict[str, str]:
    """
    :return: the different assets paths to get sql and csv directories
    :rtype: dictionnary
    """
    dir = pathlib.Path(__file__).parent
    pql_root = str(pathlib.PurePath(dir, 'ext_files/pkl'))
    csv_root = str(pathlib.PurePath(dir, 'ext_files/csv'))
    txt_root = str(pathlib.PurePath(dir, 'ext_files/txt'))
    dict = {}
    dict["pql_root"] = pql_root
    dict["csv_root"] = csv_root
    dict["txt_root"] = txt_root
    return dict