from mm_stats.config import POSTGRES_USER, PGPASSWORD


def load_sql() -> str:
    """Load sql template."""
    sql = f"""
        DROP TABLE IF EXISTS data_preparation.task_history;
        CREATE TABLE data_preparation.task_history as
        select
          *
        from public.dblink('
            dbname=hot_tm
            user={POSTGRES_USER}
            password={PGPASSWORD}
            options=-csearch_path=',
            'select * from public.task_history')
        AS t(
            id integer,
            project_id integer,
            task_id integer,
            action character varying COLLATE pg_catalog."default",
            action_text character varying COLLATE pg_catalog."default",
            action_date timestamp without time zone,
            user_id bigint
        );
    """

    return sql