Add sell_strategy to bot_settings.sell-strategy

1 files changed, 35 insertions, 0 deletions

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