from mm_stats.config import POSTGRES_USER, PGPASSWORD


def load_sql() -> str:
    """Load sql template."""
    sql = f"""
        DROP TABLE IF EXISTS data_preparation.users;
        CREATE TABLE data_preparation.users as
        select
          *
        from public.dblink('
            dbname=hot_tm
            user={POSTGRES_USER}
            password={PGPASSWORD}
            options=-csearch_path=',
            'select * from public.users')
        AS u(
            id bigint,
            username character varying,
            role integer,
            mapping_level integer,
            tasks_mapped integer,
            tasks_validated integer,
            tasks_invalidated integer,
            projects_mapped integer[],
            email_address character varying,
            facebook_id character varying,
            is_email_verified boolean,
            linkedin_id character varying,
            twitter_id character varying,
            date_registered timestamp without time zone,
            last_validation_date timestamp without time zone,
            tasks_notifications boolean,
            is_expert boolean,
            irc_id character varying,
            city character varying,
            country character varying,
            name character varying,
            skype_id character varying,
            slack_id character varying,
            default_editor character varying,
            mentions_notifications boolean,
            projects_notifications boolean,
            picture_url character varying,
            gender integer,
            self_description_gender character varying,
            projects_comments_notifications boolean,
            tasks_comments_notifications boolean,
            teams_announcement_notifications bool
        );
    """

    return sql