X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=db%2Fmigrations.go;h=7576668ba1acc98c04f64562dd53d56c9f240b13;hb=c86c484700c6ce6953847128f3d50aa497568350;hp=9246eaa930c11d1bcec7df75236046877945eca1;hpb=215e478fa347e922ad47ace89316113f1b7f15cd;p=perso%2FImmae%2FProjets%2FCryptomonnaies%2FCryptoportfolio%2FFront.git

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",
+		},
+	},
 }