Add sell_strategy to bot_settings.

diff --git a/db/migrations.go b/db/migrations.go
index 9246eaa930c11d1bcec7df75236046877945eca1..7576668ba1acc98c04f64562dd53d56c9f240b13 100644 (file)
--- 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",
+               },
+       },
 }