From 35bf3419be0ec5296457908d87266f178c7830f1 Mon Sep 17 00:00:00 2001 From: Frederick Muriuki Muriithi Date: Fri, 8 Sep 2023 05:06:17 +0300 Subject: Add `system` and `group` resource categories. --- ...tor-add-system-and-group-resource-categories.py | 29 ++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 migrations/auth/20230907_02_Enicg-refactor-add-system-and-group-resource-categories.py diff --git a/migrations/auth/20230907_02_Enicg-refactor-add-system-and-group-resource-categories.py b/migrations/auth/20230907_02_Enicg-refactor-add-system-and-group-resource-categories.py new file mode 100644 index 0000000..c4397c9 --- /dev/null +++ b/migrations/auth/20230907_02_Enicg-refactor-add-system-and-group-resource-categories.py @@ -0,0 +1,29 @@ +""" +refactor: add 'system' and 'group' resource categories +""" + +from yoyo import step + +__depends__ = {'20230907_01_pjnxz-refactor-add-resource-ownership-table'} + +steps = [ + step( + """ + INSERT INTO resource_categories VALUES + ('aa3d787f-af6a-44fa-9b0b-c82d40e54ad2', + 'system', + 'The overall system.', + '{"default-access-level": "public-read"}'), + ('1e0f70ee-add5-4358-8c6c-43de77fa4cce', + 'group', + 'A group resource.', + '{}') + """, + """ + DELETE FROM resource_categories + WHERE resource_category_id IN ( + 'aa3d787f-af6a-44fa-9b0b-c82d40e54ad2', + '1e0f70ee-add5-4358-8c6c-43de77fa4cce' + ) + """) +] -- cgit v1.2.3