diff options
| -rw-r--r-- | migrations/auth/20221110_06_Pq2kT-create-generic-roles-table.py | 24 | ||||
| -rw-r--r-- | tests/unit/auth/test_create_table_migrations.py | 3 |
2 files changed, 26 insertions, 1 deletions
diff --git a/migrations/auth/20221110_06_Pq2kT-create-generic-roles-table.py b/migrations/auth/20221110_06_Pq2kT-create-generic-roles-table.py new file mode 100644 index 0000000..2b55c2b --- /dev/null +++ b/migrations/auth/20221110_06_Pq2kT-create-generic-roles-table.py @@ -0,0 +1,24 @@ +""" +Create 'generic_roles' table + +The roles in this table will be template roles, defining some common roles that +can be used within the groups. + +They could also be used to define system-level roles, though those will not be +provided to the "common" users. +""" + +from yoyo import step + +__depends__ = {'20221110_05_BaNtL-create-roles-table'} + +steps = [ + step( + """ + CREATE TABLE IF NOT EXISTS generic_roles( + role_id TEXT PRIMARY KEY, + role_name TEXT NOT NULL + ) WITHOUT ROWID + """, + "DROP TABLE IF EXISTS generic_roles") +] diff --git a/tests/unit/auth/test_create_table_migrations.py b/tests/unit/auth/test_create_table_migrations.py index 99d045e..9e638d6 100644 --- a/tests/unit/auth/test_create_table_migrations.py +++ b/tests/unit/auth/test_create_table_migrations.py @@ -19,7 +19,8 @@ migrations_and_tables = ( ("20221110_02_z1dWf-create-mrna-resources-table.py", "mrna_resources"), ("20221110_03_ka3W0-create-phenotype-resources-table.py", "phenotype_resources"), ("20221110_04_6PRFQ-create-genotype-resources-table.py", "genotype_resources"), - ("20221110_05_BaNtL-create-roles-table.py", "roles")) + ("20221110_05_BaNtL-create-roles-table.py", "roles"), + ("20221110_06_Pq2kT-create-generic-roles-table.py", "generic_roles")) @pytest.mark.unit_test @pytest.mark.parametrize("migration_file,the_table", migrations_and_tables) |