From: jloup <jean-loup.jamet@trainline.com>
Date: Sat, 4 Aug 2018 21:05:19 +0000 (+0200)
Subject: Add sell_strategy to bot_settings.
X-Git-Url: https://git.immae.eu/?p=perso%2FImmae%2FProjets%2FCryptomonnaies%2FCryptoportfolio%2FFront.git;a=commitdiff_plain;h=refs%2Fheads%2Fsell-strategy

Add sell_strategy to bot_settings.
---

diff --git a/db/migrations.go b/db/migrations.go
index 9246eaa..7576668 100644
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -137,4 +137,39 @@ var migrations []Migration = []Migration{
 			"DROP VIEW market_configs_augmented",
 		},
 	},
+	{
+		Version: 201808041000,
+		Up: []string{
+			"CREATE TYPE sell_strategy AS ENUM ('sell-needed', 'sell-all')",
+			"ALTER TABLE bot_settings ADD sell_strategy sell_strategy",
+			`CREATE OR REPLACE VIEW market_configs_augmented AS
+				SELECT market_configs.*,
+					COALESCE(u.portfolio_profile, g.portfolio_profile) AS portfolio_profile,
+					COALESCE(u.sell_strategy, g.sell_strategy) AS sell_strategy
+				FROM market_configs
+					LEFT JOIN bot_settings AS u
+						ON u.user_id = market_configs.user_id,
+					(
+						SELECT portfolio_profile, sell_strategy
+							FROM bot_settings
+							WHERE user_id IS NULL
+					) AS g`,
+		},
+		Down: []string{
+			`CREATE OR REPLACE VIEW market_configs_augmented AS
+				SELECT market_configs.*,
+					COALESCE(u.portfolio_profile, g.portfolio_profile)
+						AS portfolio_profile
+				FROM market_configs
+					LEFT JOIN bot_settings AS u
+						ON u.user_id = market_configs.user_id,
+					(
+						SELECT portfolio_profile
+							FROM bot_settings
+							WHERE user_id IS NULL
+					) AS g`,
+			"ALTER TABLE bot_setttings DROP COLUMN sell_strategy",
+			"DROP TYPE sell_strategy",
+		},
+	},
 }