From d1ea02408be8ecaa2b67ff8f219674639999ebba Mon Sep 17 00:00:00 2001
From: multiple creatures <dev@multiple-creature.party>
Date: Fri, 14 Feb 2020 20:04:14 -0600
Subject: (actually) add `hidden` attribute to status table & model

---
 db/migrate/20200215014558_add_hidden_to_statuses.rb               | 5 +++++
 db/migrate/20200215020121_add_index_unhidden_to_statuses.rb       | 7 +++++++
 .../20200215021014_set_null_constraint_on_statuses_hidden.rb      | 7 +++++++
 db/migrate/20200215021730_set_default_unhidden_on_statuses.rb     | 8 ++++++++
 .../20200215021731_validate_set_default_unhidden_on_statuses.rb   | 7 +++++++
 5 files changed, 34 insertions(+)
 create mode 100644 db/migrate/20200215014558_add_hidden_to_statuses.rb
 create mode 100644 db/migrate/20200215020121_add_index_unhidden_to_statuses.rb
 create mode 100644 db/migrate/20200215021014_set_null_constraint_on_statuses_hidden.rb
 create mode 100644 db/migrate/20200215021730_set_default_unhidden_on_statuses.rb
 create mode 100644 db/migrate/20200215021731_validate_set_default_unhidden_on_statuses.rb

(limited to 'db/migrate')

diff --git a/db/migrate/20200215014558_add_hidden_to_statuses.rb b/db/migrate/20200215014558_add_hidden_to_statuses.rb
new file mode 100644
index 000000000..886a2f7c4
--- /dev/null
+++ b/db/migrate/20200215014558_add_hidden_to_statuses.rb
@@ -0,0 +1,5 @@
+class AddHiddenToStatuses < ActiveRecord::Migration[5.2]
+  def change
+    add_column :statuses, :hidden, :boolean
+  end
+end
diff --git a/db/migrate/20200215020121_add_index_unhidden_to_statuses.rb b/db/migrate/20200215020121_add_index_unhidden_to_statuses.rb
new file mode 100644
index 000000000..17f936a00
--- /dev/null
+++ b/db/migrate/20200215020121_add_index_unhidden_to_statuses.rb
@@ -0,0 +1,7 @@
+class AddIndexUnhiddenToStatuses < ActiveRecord::Migration[5.2]
+  disable_ddl_transaction!
+
+  def change
+    add_index :statuses, [:account_id, :id, :visibility], where: 'NOT hidden', algorithm: :concurrently, name: 'index_statuses_on_account_id_and_id_and_visibility_not_hidden'
+  end
+end
diff --git a/db/migrate/20200215021014_set_null_constraint_on_statuses_hidden.rb b/db/migrate/20200215021014_set_null_constraint_on_statuses_hidden.rb
new file mode 100644
index 000000000..70b3a764c
--- /dev/null
+++ b/db/migrate/20200215021014_set_null_constraint_on_statuses_hidden.rb
@@ -0,0 +1,7 @@
+class SetNullConstraintOnStatusesHidden < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured do
+      execute 'ALTER TABLE "statuses" ADD CONSTRAINT "statuses_hidden_null" CHECK ("hidden" IS NOT NULL) NOT VALID'
+    end
+  end
+end
diff --git a/db/migrate/20200215021730_set_default_unhidden_on_statuses.rb b/db/migrate/20200215021730_set_default_unhidden_on_statuses.rb
new file mode 100644
index 000000000..1d239d110
--- /dev/null
+++ b/db/migrate/20200215021730_set_default_unhidden_on_statuses.rb
@@ -0,0 +1,8 @@
+class SetDefaultUnhiddenOnStatuses < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured do
+      change_column_default :statuses, :hidden, false
+      Status.in_batches.update_all(hidden: false)
+    end
+  end
+end
diff --git a/db/migrate/20200215021731_validate_set_default_unhidden_on_statuses.rb b/db/migrate/20200215021731_validate_set_default_unhidden_on_statuses.rb
new file mode 100644
index 000000000..b87b61dcc
--- /dev/null
+++ b/db/migrate/20200215021731_validate_set_default_unhidden_on_statuses.rb
@@ -0,0 +1,7 @@
+class ValidateSetDefaultUnhiddenOnStatuses < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured do
+      execute 'ALTER TABLE "statuses" VALIDATE CONSTRAINT "statuses_hidden_null"'
+    end
+  end
+end
-- 
cgit