From c86c484700c6ce6953847128f3d50aa497568350 Mon Sep 17 00:00:00 2001 From: jloup Date: Sat, 4 Aug 2018 23:05:19 +0200 Subject: [PATCH] Add sell_strategy to bot_settings. --- db/migrations.go | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) 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", + }, + }, } -- 2.41.0