hjp
/
procrusql
1
0
Fork 0
Code Issues 2 Pull Requests Releases Wiki Activity
procrusql/demo_usradm_templates

558 lines
34 KiB
Plaintext
Raw Permalink Normal View History

Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
#!/usr/bin/python3
import logging
import psycopg2
Dump dependencies as dot file
2022-02-03 16:36:16 +01:00
from procrusql import HaveTable, HaveColumn, HaveData, Ref, fit, dump_dot
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
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},
),
Add some service types to demo
2022-02-25 16:19:41 +01:00
HaveData("data_service_type_group", depends=[],
table="service_type",
key={"type": "group"},
extra={},
),
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
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},
),
Add some service types to demo
2022-02-25 16:19:41 +01:00
HaveData("data_service_type_publ", depends=[],
table="service_type",
key={"type": "publ"},
extra={},
),
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
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},
),
Add some service types to demo
2022-02-25 16:19:41 +01:00
HaveData("data_service_type_rolle", depends=[],
table="service_type",
key={"type": "rolle"},
extra={},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_administrative_staff_member", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
key={"type": "rolle", "feature": "administrative_staff_member"},
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_associate", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
Complete demo
2022-02-03 16:31:10 +01:00
key={"type": "rolle", "feature": "associate"},
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_economist", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
key={"type": "rolle", "feature": "economist"},
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_emeritus_consultant", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
key={"type": "rolle", "feature": "emeritus_consultant"},
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_research_assistant", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
key={"type": "rolle", "feature": "research_assistant"},
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_scientific_administration_staff_member", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
key={"type": "rolle", "feature":
"scientific_administration_staff_member"},
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_scientific_administrative_assistant", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
key={"type": "rolle", "feature": "scientific_administrative_assistant"},
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_scientific_consultant", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
key={"type": "rolle", "feature": "scientific_consultant"},
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
HaveData("data_rolle_senior_economist", depends=["column_service_id", "column_service_type", "column_service_feature", "column_service_description", "column_service_hidden"],
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
table="service",
key={"type": "rolle", "feature": "senior_economist"},
extra={"hidden": False},
),
Complete demo
2022-02-03 16:31:10 +01:00
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},
),
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
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"},
),
Complete demo
2022-02-03 16:31:10 +01:00
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"},
),
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
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",
),
Complete demo
2022-02-03 16:31:10 +01:00
# 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={}
),
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
]
Complete demo
2022-02-03 16:31:10 +01:00
db = psycopg2.connect(dbname="usradm_test", user="usradm")
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
fit(db, want)
Dump dependencies as dot file
2022-02-03 16:36:16 +01:00
dump_dot()
Implement PoC The prototype can create tables and their columns and insert data, including data from existing tables. This is sufficient for a small demo from a real-world project. The demo uses all of the above capabilities. It also deliberately includes rules in arbitrary order to demonstrate dependency resolution. We don't have a DSL yet, so all the nodes/rules/requirements (need to decide on a catchy name) are instantiated directly in the source code by calling their constructors. This is overly verbose but gives a first impression on what a ruleset might look like.
2022-01-29 11:56:10 +01:00
# vim: tw=0