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