aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--migrations/auth/20230907_02_Enicg-refactor-add-system-and-group-resource-categories.py29
1 files changed, 29 insertions, 0 deletions
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'
+ )
+ """)
+]