Skip to content
Snippets Groups Projects

Experiment: "Build iOS app guide" email campaign

Merged Eugie Limpin requested to merge experiment/publish-ios-apps-with-fastlane into master
1 file
+ 3
1
Compare changes
  • Side-by-side
  • Inline
@@ -6,6 +6,8 @@ class AddCampaignToInProductMarketingEmail < Gitlab::Database::Migration[1.0]
TARGET_TABLE = :in_product_marketing_emails
UNIQUE_INDEX_NAME = 'index_in_product_marketing_emails_on_user_campaign'
CONSTRAINT_NAME = :in_product_marketing_emails_track_and_series_or_campaign
TRACK_AND_SERIES_NOT_NULL_CONSTRAINT = 'track IS NOT NULL AND series IS NOT NULL AND campaign IS NULL'
CAMPAIGN_NOT_NULL_CONSTRAINT = 'track IS NULL AND series IS NULL AND campaign IS NOT NULL'
def up
change_column_null TARGET_TABLE, :track, true
@@ -13,7 +15,7 @@ def up
add_column TARGET_TABLE, :campaign, :text, limit: 255, if_not_exists: true
add_concurrent_index TARGET_TABLE, [:user_id, :campaign], unique: true, name: UNIQUE_INDEX_NAME
add_check_constraint TARGET_TABLE,
'(track IS NOT NULL AND series IS NOT NULL AND campaign IS NULL) OR (track IS NULL AND series IS NULL AND campaign IS NOT NULL)',
"(#{TRACK_AND_SERIES_NOT_NULL_CONSTRAINT}) OR (#{CAMPAIGN_NOT_NULL_CONSTRAINT})",
CONSTRAINT_NAME
end
Loading