from mm_stats.config import POSTGRES_USER, PGPASSWORD


def load_sql() -> str:
    """Load sql template."""
    sql = f"""
        DROP TABLE IF EXISTS data_preparation.project_info;
        CREATE TABLE data_preparation.project_info as
        select
          *
        from public.dblink('
            dbname=hot_tm
            user={POSTGRES_USER}
            password={PGPASSWORD}
            options=-csearch_path=',
            'select * from public.project_info')
        AS p(
            project_id integer,
            locale character varying(10) COLLATE pg_catalog."default",
            name character varying(512) COLLATE pg_catalog."default",
            short_description character varying COLLATE pg_catalog."default",
            description character varying COLLATE pg_catalog."default",
            instructions character varying COLLATE pg_catalog."default",
            project_id_str character varying COLLATE pg_catalog."default",
            text_searchable tsvector,
            per_task_instructions character varying COLLATE pg_catalog."default"
        );
    """

    return sql