diff options
| author | Frederick Muriuki Muriithi | 2022-12-08 05:52:57 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-12-08 08:35:42 +0300 |
| commit | b939c1fc96398708accc84c3026ce9f48654d7a8 (patch) | |
| tree | d73960bf00661c3fbee0ebfe1cce71b6afc2b0d7 | |
| parent | c75ed75c6a5987eed6672be924870f86282ed6d6 (diff) | |
| download | genenetwork3-b939c1fc96398708accc84c3026ce9f48654d7a8.tar.gz | |
migrations: Add column `public` to `resources` table
* migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py: new migration script. * tests/unit/auth/test_migrations_add_remove_columns.py: test new migration script
| -rw-r--r-- | migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py | 16 | ||||
| -rw-r--r-- | tests/unit/auth/test_migrations_add_remove_columns.py | 4 |
2 files changed, 19 insertions, 1 deletions
diff --git a/migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py b/migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py new file mode 100644 index 0000000..2238069 --- /dev/null +++ b/migrations/auth/20221208_01_sSdHz-add-public-column-to-resources-table.py @@ -0,0 +1,16 @@ +""" +Add 'public' column to 'resources' table +""" + +from yoyo import step + +__depends__ = {'20221206_01_BbeF9-create-group-user-roles-on-resources-table'} + +steps = [ + step( + """ + ALTER TABLE resources ADD COLUMN + public INTEGER NOT NULL DEFAULT 0 CHECK (public=0 or public=1) + """, + "ALTER TABLE resources DROP COLUMN public") +] diff --git a/tests/unit/auth/test_migrations_add_remove_columns.py b/tests/unit/auth/test_migrations_add_remove_columns.py index d149c64..ea9bf7b 100644 --- a/tests/unit/auth/test_migrations_add_remove_columns.py +++ b/tests/unit/auth/test_migrations_add_remove_columns.py @@ -18,7 +18,9 @@ TEST_PARAMS = ( "columns-to-privileges-table.py"), "privileges", "privilege_description TEXT", True), ("20221117_01_RDlfx-modify-group-roles-add-group-role-id.py", "group_roles", - "group_role_id", True)) + "group_role_id", True), + ("20221208_01_sSdHz-add-public-column-to-resources-table.py", "resources", + "public", True)) def found(haystack: str, needle: str) -> bool: """Check whether `needle` is found in `haystack`""" |