#!/usr/bin/python3
import logging
import psycopg2

from procrusql import HaveTable, HaveColumn, HaveData, Ref, fit, dump_dot

logging.basicConfig(format="%(asctime)s %(levelname)s %(name)s %(lineno)d | %(message)s", level=logging.DEBUG)

want = [
    HaveTable("table_service", depends=[],
        table="service"
    ),
    HaveColumn("column_service_id", depends=["table_service"],
        table="service",
        column="id",
        definition="serial primary key",
    ),
    HaveColumn("column_service_type", depends=["table_service"],
        table="service",
        column="type",
        definition="text",
    ),
    HaveColumn("column_service_feature", depends=["table_service"],
        table="service",
        column="feature",
        definition="text",
    ),
    HaveColumn("column_service_description", depends=["table_service"],
        table="service",
        column="description",
        definition="text",
    ),
    HaveColumn("column_service_hidden", depends=["table_service"],
        table="service",
        column="hidden",
        definition="boolean",
    ),

    HaveData("data_login_unix", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "login", "feature": "unix"},
        extra={"description": "Can login on Unix systems", "hidden": False},
    ),
    HaveData("data_login_wds", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "login", "feature": "wds"},
        extra={"description": "Can login into WDS", "hidden": False},
    ),
    HaveData("data_login_wwa", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "login", "feature": "wwa"},
        extra={"description": "Can login into WWA", "hidden": False},
    ),
    HaveData("data_service_type_group", depends=[],
        table="service_type",
        key={"type": "group"},
        extra={},
    ),
    HaveData("data_group_wifo", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "group", "feature": "wifo"},
        extra={"hidden": False},
    ),
    HaveData("data_group_wifo_intern", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "group", "feature": "wifo-intern"},
        extra={"hidden": False},
    ),
    HaveData("data_group_wsr", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "group", "feature": "wsr"},
        extra={"hidden": False},
    ),
    HaveData("data_mailinglist2_wifo_aktuell", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "mailinglist2", "feature": "wifo-aktuell"},
        extra={"hidden": False},
    ),
    HaveData("data_org_wifo", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "org", "feature": "WIFO"},
        extra={"hidden": False},
    ),
    HaveData("data_org_wsr", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "org", "feature": "WSR"},
        extra={"hidden": False},
    ),
    HaveData("data_service_type_publ", depends=[],
        table="service_type",
        key={"type": "publ"},
        extra={},
    ),
    HaveData("data_publ_wifo_intern", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "publ", "feature": "wifo_intern"},
        extra={"hidden": False},
    ),
    HaveData("data_publ_wifo_temporary", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "publ", "feature": "wifo_temporary"},
        extra={"hidden": False},
    ),
    HaveData("data_service_type_rolle", depends=[],
        table="service_type",
        key={"type": "rolle"},
        extra={},
    ),
    HaveData("data_rolle_administrative_staff_member", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "administrative_staff_member"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_associate", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "associate"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_economist", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "economist"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_emeritus_consultant", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "emeritus_consultant"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_research_assistant", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "research_assistant"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_scientific_administration_staff_member", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature":
        "scientific_administration_staff_member"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_scientific_administrative_assistant", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "scientific_administrative_assistant"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_scientific_consultant", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "scientific_consultant"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_senior_economist", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "senior_economist"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_guest_researcher", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "guest_researcher"},
        extra={"hidden": False},
    ),
    HaveData("data_rolle_guest_researcher", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
        table="service",
        key={"type": "rolle", "feature": "guest_researcher"},
        extra={"hidden": False},
    ),

    HaveData("data_template_std", depends=["column_template_name", "column_template_sortorder"],
        table="template",
        key={"name": "Standard Vorlage"},
        extra={"sortorder": 1},
    ),
    HaveData("data_template_wifo_wa", depends=["column_template_name", "column_template_sortorder", "column_template_email_pattern", "column_template_email_after", "column_template_funktion", "column_template_status"],
        table="template",
        key={"name": "WIFO Wissenschaftliche Assistenz"},
        extra={"sortorder": 10, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", "funktion": "FB (1-5)", "status": "FU, FM"},
    ),
    HaveData("data_template_wifo_wiss", depends=["column_template_name", "column_template_sortorder", "column_template_email_pattern", "column_template_email_after", "column_template_funktion", "column_template_status"],
        table="template",
        key={"name": "WIFO Wissenschaftler"},
        extra={"sortorder": 11, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", "funktion": "FB (1-5)", "status": "FU, FM"},
    ),
    HaveData("data_template_wifo_dl", depends=["column_template_name", "column_template_sortorder", "column_template_email_pattern", "column_template_email_after", "column_template_funktion", "column_template_status"],
        table="template",
        key={"name": "WIFO Dienstleister"},
        extra={"sortorder": 12, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", "funktion": "Dienstleister", "status": "FU, FM"},
    ),
    HaveData("data_template_wifo_gf", depends=["column_template_name", "column_template_sortorder", "column_template_email_pattern", "column_template_email_after", "column_template_funktion", "column_template_status"],
        table="template",
        key={"name": "WIFO Gastforscher"},
        extra={"sortorder": 13, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", "funktion": None, "status": "GU, GM"},
    ),
    HaveData("data_template_wifo_kons", depends=["column_template_name", "column_template_sortorder", "column_template_email_pattern", "column_template_email_after", "column_template_funktion", "column_template_status"],
        table="template",
        key={"name": "WIFO Konsulenten"},
        extra={"sortorder": 13, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", "funktion": "FB (1-5)", "status": "KU, KM"},
    ),
    HaveData("data_template_wifo_ass", depends=["column_template_name", "column_template_sortorder", "column_template_email_pattern", "column_template_email_after", "column_template_funktion", "column_template_status"],
        table="template",
        key={"name": "WIFO Associates"},
        extra={"sortorder": 14, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", "funktion": "FB (1-5)", "status": "KU, KM"},
    ),
    HaveData("data_template_wifo_tmp", depends=["column_template_name", "column_template_sortorder", "column_template_email_pattern", "column_template_email_after", "column_template_funktion", "column_template_status"],
        table="template",
        key={"name": "WIFO Temporäre User"},
        extra={"sortorder": 15, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", "funktion": None, "status": "TU, TM"},
    ),
    HaveData("data_template_wsr", depends=["column_template_name", "column_template_sortorder", "column_template_email_pattern", "column_template_email_after", "column_template_funktion", "column_template_status"],
        table="template",
        key={"name": "WSR Vorlage"},
        extra={"sortorder": 20, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", "funktion": None, "status": "TU, TM"},
    ),

    HaveColumn("column_template_name", depends=["table_template"],
        table="template",
        column="name",
        definition="text not null unique",
    ),
    HaveTable("table_template", depends=[],
        table="template"
    ),
    HaveColumn("column_template_sortorder", depends=["table_template"],
        table="template",
        column="sortorder",
        definition="int",
    ),
    HaveColumn("column_template_email_pattern", depends=["table_template"],
        table="template",
        column="email_pattern",
        definition="text",
    ),
    HaveColumn("column_template_email_after", depends=["table_template"],
        table="template",
        column="email_after",
        definition="text",
    ),
    HaveColumn("column_template_funktion", depends=["table_template"],
        table="template",
        column="funktion",
        definition="text",
    ),
    HaveColumn("column_template_status", depends=["table_template"],
        table="template",
        column="status",
        definition="text",
    ),

    HaveData("data_template_std_login_wwa", depends=["data_template_std", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_std", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),

    HaveColumn("column_template_id", depends=["table_template"],
        table="template",
        column="id",
        definition="serial primary key",
    ),

    HaveColumn("column_template_service_template", depends=["table_template_service"],
        table="template_service",
        column="template",
        definition="int references template",
    ),

    HaveTable("table_template_service", depends=[],
        table="template_service",
    ),
    HaveColumn("column_template_service_service", depends=["table_template_service"],
        table="template_service",
        column="service",
        definition="int references service",
    ),

    # WA
    HaveData("data_template_wifo_wa_login_wwa", depends=["data_template_wifo_wa", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wa", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wa_org_wifo", depends=["data_template_wifo_wa", "data_org_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wa", 0, "id"), "service": Ref("data_org_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wa_group_wifo", depends=["data_template_wifo_wa", "data_group_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wa", 0, "id"), "service": Ref("data_group_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wa_group_wifo_intern", depends=["data_template_wifo_wa", "data_group_wifo_intern", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wa", 0, "id"), "service": Ref("data_group_wifo_intern", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wa_publ_wifo_intern", depends=["data_template_wifo_wa", "data_publ_wifo_intern", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wa", 0, "id"), "service": Ref("data_publ_wifo_intern", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wa_rolle_research_assistant", depends=["data_template_wifo_wa", "data_rolle_research_assistant", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wa", 0, "id"), "service": Ref("data_rolle_research_assistant", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wa_mailinglist2_wifo_aktuell", depends=["data_template_wifo_wa", "data_mailinglist2_wifo_aktuell", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wa", 0, "id"), "service": Ref("data_mailinglist2_wifo_aktuell", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wa_login_wds", depends=["data_template_wifo_wa", "data_login_wds", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wa", 0, "id"), "service": Ref("data_login_wds", 0, "id")},
        extra={}
    ),

    # WISS
    HaveData("data_template_wifo_wiss_login_wwa", depends=["data_template_wifo_wiss", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wiss_org_wifo", depends=["data_template_wifo_wiss", "data_org_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_org_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wiss_group_wifo", depends=["data_template_wifo_wiss", "data_group_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_group_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wiss_group_wifo_intern", depends=["data_template_wifo_wiss", "data_group_wifo_intern", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_group_wifo_intern", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wiss_publ_wifo_intern", depends=["data_template_wifo_wiss", "data_publ_wifo_intern", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_publ_wifo_intern", 0, "id")},
        extra={}
    ),

    HaveData("data_template_wifo_wiss_rolle_economist", depends=["data_template_wifo_wiss", "data_rolle_economist", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_rolle_economist", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wiss_rolle_senior_economist", depends=["data_template_wifo_wiss", "data_rolle_senior_economist", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_rolle_senior_economist", 0, "id")},
        extra={}
    ),

    HaveData("data_template_wifo_wiss_mailinglist2_wifo_aktuell", depends=["data_template_wifo_wiss", "data_mailinglist2_wifo_aktuell", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_mailinglist2_wifo_aktuell", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_wiss_login_wds", depends=["data_template_wifo_wiss", "data_login_wds", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_wiss", 0, "id"), "service": Ref("data_login_wds", 0, "id")},
        extra={}
    ),

    # DL
    HaveData("data_template_wifo_dl_login_wwa", depends=["data_template_wifo_dl", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_dl_org_wifo", depends=["data_template_wifo_dl", "data_org_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_org_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_dl_group_wifo", depends=["data_template_wifo_dl", "data_group_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_group_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_dl_group_wifo_intern", depends=["data_template_wifo_dl", "data_group_wifo_intern", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_group_wifo_intern", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_dl_publ_wifo_intern", depends=["data_template_wifo_dl", "data_publ_wifo_intern", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_publ_wifo_intern", 0, "id")},
        extra={}
    ),

    HaveData("data_template_wifo_dl_rolle_economist", depends=["data_template_wifo_dl", "data_rolle_administrative_staff_member", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_rolle_administrative_staff_member", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_dl_rolle_economist", depends=["data_template_wifo_dl", "data_rolle_scientific_administration_staff_member", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_rolle_scientific_administration_staff_member", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_dl_rolle_economist", depends=["data_template_wifo_dl", "data_rolle_scientific_administrative_assistant", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_rolle_scientific_administrative_assistant", 0, "id")},
        extra={}
    ),

    HaveData("data_template_wifo_dl_mailinglist2_wifo_aktuell", depends=["data_template_wifo_dl", "data_mailinglist2_wifo_aktuell", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_mailinglist2_wifo_aktuell", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_dl_login_wds", depends=["data_template_wifo_dl", "data_login_wds", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_dl", 0, "id"), "service": Ref("data_login_wds", 0, "id")},
        extra={}
    ),

    # Gastforscher
    HaveData("data_template_wifo_gf_login_wwa", depends=["data_template_wifo_gf", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_gf", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_gf_org_wifo", depends=["data_template_wifo_gf", "data_org_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_gf", 0, "id"), "service": Ref("data_org_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_gf_group_wifo", depends=["data_template_wifo_gf", "data_group_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_gf", 0, "id"), "service": Ref("data_group_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_gf_publ_wifo_temporary", depends=["data_template_wifo_gf", "data_publ_wifo_temporary", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_gf", 0, "id"), "service": Ref("data_publ_wifo_temporary", 0, "id")},
        extra={}
    ),

    HaveData("data_template_wifo_gf_rolle_guest_researcher", depends=["data_template_wifo_gf", "data_rolle_guest_researcher", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_gf", 0, "id"), "service": Ref("data_rolle_guest_researcher", 0, "id")},
        extra={}
    ),

    # Konsuienten
    HaveData("data_template_wifo_kons_login_wwa", depends=["data_template_wifo_kons", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_kons", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_kons_org_wifo", depends=["data_template_wifo_kons", "data_org_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_kons", 0, "id"), "service": Ref("data_org_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_kons_group_wifo", depends=["data_template_wifo_kons", "data_group_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_kons", 0, "id"), "service": Ref("data_group_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_kons_publ_wifo_temporary", depends=["data_template_wifo_kons", "data_publ_wifo_temporary", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_kons", 0, "id"), "service": Ref("data_publ_wifo_temporary", 0, "id")},
        extra={}
    ),

    HaveData("data_template_wifo_kons_rolle_emeritus_consultant", depends=["data_template_wifo_kons", "data_rolle_emeritus_consultant", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_kons", 0, "id"), "service": Ref("data_rolle_emeritus_consultant", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_kons_rolle_emeritus_consultant", depends=["data_template_wifo_kons", "data_rolle_emeritus_consultant", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_kons", 0, "id"), "service": Ref("data_rolle_emeritus_consultant", 0, "id")},
        extra={}
    ),

    # Associates
    HaveData("data_template_wifo_ass_login_wwa", depends=["data_template_wifo_ass", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_ass", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_ass_org_wifo", depends=["data_template_wifo_ass", "data_org_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_ass", 0, "id"), "service": Ref("data_org_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_ass_group_wifo", depends=["data_template_wifo_ass", "data_group_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_ass", 0, "id"), "service": Ref("data_group_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_ass_publ_wifo_temporary", depends=["data_template_wifo_ass", "data_publ_wifo_temporary", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_ass", 0, "id"), "service": Ref("data_publ_wifo_temporary", 0, "id")},
        extra={}
    ),

    HaveData("data_template_wifo_ass_rolle_associate", depends=["data_template_wifo_ass", "data_rolle_associate", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_ass", 0, "id"), "service": Ref("data_rolle_associate", 0, "id")},
        extra={}
    ),

    # Temporäre User
    HaveData("data_template_wifo_tmp_login_wwa", depends=["data_template_wifo_tmp", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_tmp", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_tmp_org_wifo", depends=["data_template_wifo_tmp", "data_org_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_tmp", 0, "id"), "service": Ref("data_org_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_tmp_group_wifo", depends=["data_template_wifo_tmp", "data_group_wifo", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_tmp", 0, "id"), "service": Ref("data_group_wifo", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wifo_tmp_publ_wifo_temporary", depends=["data_template_wifo_tmp", "data_publ_wifo_temporary", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wifo_tmp", 0, "id"), "service": Ref("data_publ_wifo_temporary", 0, "id")},
        extra={}
    ),

    # WSR
    HaveData("data_template_wsr_login_wwa", depends=["data_template_wsr", "data_login_wwa", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wsr", 0, "id"), "service": Ref("data_login_wwa", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wsr_org_wsr", depends=["data_template_wsr", "data_org_wsr", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wsr", 0, "id"), "service": Ref("data_org_wsr", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wsr_group_wsr", depends=["data_template_wsr", "data_group_wsr", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wsr", 0, "id"), "service": Ref("data_group_wsr", 0, "id")},
        extra={}
    ),
    HaveData("data_template_wsr_login_unix", depends=["data_template_wsr", "data_login_unix", "column_service_id", "column_template_id", "column_template_service_template", "column_template_service_service"],
        table="template_service",
        key={"template": Ref("data_template_wsr", 0, "id"), "service": Ref("data_login_unix", 0, "id")},
        extra={}
    ),

]

db = psycopg2.connect(dbname="usradm_test", user="usradm")
fit(db, want)
dump_dot()

# vim: tw=0