aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2022-11-17 09:07:51 +0300
committerFrederick Muriuki Muriithi2022-11-17 09:07:51 +0300
commit4ad8763086197422266841b106c7da08d480f249 (patch)
tree5c691bcf6eb3dfb45dd68861021b1509aee1faa6 /migrations/auth
parent73667aa26b6726735f9b7e458aee6d8a37333b8a (diff)
downloadgenenetwork3-4ad8763086197422266841b106c7da08d480f249.tar.gz
Migrations: Add column `group_role_id` to `group_roles` table
* migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py: new migration * tests/unit/auth/test_migrations_add_remove_columns.py: test new migration
Diffstat (limited to 'migrations/auth')
-rw-r--r--migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py47
1 files changed, 47 insertions, 0 deletions
diff --git a/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py b/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py
new file mode 100644
index 0000000..7115bc3
--- /dev/null
+++ b/migrations/auth/20221117_01_RDlfx-modify-group-roles-add-group-role-id.py
@@ -0,0 +1,47 @@
+"""
+Modify 'group_roles': add 'group_role_id'
+
+At this point, there is no data in the `group_roles` table and therefore, it
+should be safe to simply recreate it.
+"""
+
+from yoyo import step
+
+__depends__ = {'20221116_01_nKUmX-add-privileges-to-group-leader-role'}
+
+steps = [
+ step(
+ "DROP INDEX IF EXISTS idx_tbl_group_roles_cols_group_id",
+ """
+ CREATE INDEX IF NOT EXISTS idx_tbl_group_roles_cols_group_id
+ ON group_roles(group_id)
+ """),
+ step(
+ "DROP TABLE IF EXISTS group_roles",
+ """
+ CREATE TABLE IF NOT EXISTS group_roles(
+ group_id TEXT NOT NULL,
+ role_id TEXT NOT NULL,
+ PRIMARY KEY(group_id, role_id),
+ FOREIGN KEY(group_id) REFERENCES groups(group_id),
+ FOREIGN KEY(role_id) REFERENCES roles(role_id)
+ ) WITHOUT ROWID
+ """),
+ step(
+ """
+ CREATE TABLE IF NOT EXISTS group_roles(
+ group_role_id TEXT PRIMARY KEY,
+ group_id TEXT NOT NULL,
+ role_id TEXT NOT NULL,
+ FOREIGN KEY(group_id) REFERENCES groups(group_id),
+ FOREIGN KEY(role_id) REFERENCES roles(role_id)
+ ) WITHOUT ROWID
+ """,
+ "DROP TABLE IF EXISTS group_roles"),
+ step(
+ """
+ CREATE INDEX IF NOT EXISTS idx_tbl_group_roles_cols_group_id
+ ON group_roles(group_id)
+ """,
+ "DROP INDEX IF EXISTS idx_tbl_group_roles_cols_group_id")
+]