From 299b6b6d9fb879c06e675ef240f361348629ff6c Mon Sep 17 00:00:00 2001 From: jloup Date: Thu, 10 May 2018 16:22:29 +0200 Subject: Add column 'status' to market_configs. --- db/market_config.go | 25 ++++++++++++++++++++++--- 1 file changed, 22 insertions(+), 3 deletions(-) (limited to 'db/market_config.go') diff --git a/db/market_config.go b/db/market_config.go index b26c092..30b4538 100644 --- a/db/market_config.go +++ b/db/market_config.go @@ -1,11 +1,20 @@ package db -import "github.com/go-pg/pg" +import ( + "github.com/go-pg/pg" +) + +type MarketConfigStatus string + +const MarketConfigEnabled = "enabled" +const MarketConfigDisabled = "disabled" +const MarketConfigInvalidCredentials = "invalid_credentials" type MarketConfig struct { Id int64 - MarketName string `sql:",notnull"` - UserId int64 `sql:",notnull"` + MarketName string + UserId int64 + Status MarketConfigStatus Config map[string]string } @@ -43,3 +52,13 @@ func SetUserMarketConfig(userId int64, market string, newConfig map[string]strin return &config, err } + +func SetMarketConfigStatus(marketConfig MarketConfig, status MarketConfigStatus) (*MarketConfig, error) { + marketConfig.Status = status + _, err := DB.Model(&marketConfig). + OnConflict("(user_id, market_name) DO UPDATE"). + Set("status = ?", status). + Insert() + + return &marketConfig, err +} -- cgit v1.2.3