From 3a44dd8750a212b5ed26cb0882dd1ad3dc3085d6 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Tue, 8 Nov 2022 16:40:55 +0300
Subject: Migrations: Init `resource_categories` with initial categories

* migrations/auth/20221108_04_CKcSL-init-data-in-resource-categories-table.py:
  new migration.
* tests/unit/auth/test_migration_init_data_in_resource_categories_table.py:
  test new migration.
---
 ...CKcSL-init-data-in-resource-categories-table.py | 25 ++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 migrations/auth/20221108_04_CKcSL-init-data-in-resource-categories-table.py

(limited to 'migrations/auth')

diff --git a/migrations/auth/20221108_04_CKcSL-init-data-in-resource-categories-table.py b/migrations/auth/20221108_04_CKcSL-init-data-in-resource-categories-table.py
new file mode 100644
index 0000000..76ffbef
--- /dev/null
+++ b/migrations/auth/20221108_04_CKcSL-init-data-in-resource-categories-table.py
@@ -0,0 +1,25 @@
+"""
+Init data in resource_categories table
+"""
+
+from yoyo import step
+
+__depends__ = {'20221108_03_Pbhb1-create-resource-categories-table'}
+
+steps = [
+    step(
+        """
+        INSERT INTO resource_categories VALUES
+        ('fad071a3-2fc8-40b8-992b-cdefe7dcac79', 'mrna', 'mRNA Dataset'),
+        ('548d684b-d4d1-46fb-a6d3-51a56b7da1b3', 'phenotype', 'Phenotype (Publish) Dataset'),
+        ('48056f84-a2a6-41ac-8319-0e1e212cba2a', 'genotype', 'Genotype Dataset')
+        """,
+        """
+        DELETE FROM resource_categories WHERE resource_category_id IN
+        (
+            'fad071a3-2fc8-40b8-992b-cdefe7dcac79',
+            '548d684b-d4d1-46fb-a6d3-51a56b7da1b3',
+            '48056f84-a2a6-41ac-8319-0e1e212cba2a'
+        )
+        """)
+]
-- 
cgit v1.2.3