Method SetConfigValueFor

server/resource/cms_config.go:338–398

(key string, val interface{}, configtype string, transaction *sqlx.Tx)

}

func (configStore *ConfigStore) SetConfigValueFor(key string, val interface{}, configtype string, transaction *sqlx.Tx) error {
	var previousValue string

	s, v, err := statementbuilder.Squirrel.Select("value").Prepared(true).
		From(settingsTableName).
		Where(goqu.Ex{"name": key}).
		Where(goqu.Ex{"configstate": "enabled"}).
		Where(goqu.Ex{"configtype": configtype}).
		Where(goqu.Ex{"configenv": configStore.defaultEnv}).ToSQL()

	CheckErr(err, "Failed to create config select query")

	stmt1, err := transaction.Preparex(s)
	if err != nil {
		log.Errorf("[280] failed to prepare statment: %v", err)
		return nil
	}

	errScan := stmt1.QueryRowx(v...).Scan(&previousValue)

	err = stmt1.Close()
	if err != nil {
		log.Errorf("failed to close prepared statement: %v", err)
		return err
	}

	if errScan != nil {

		// row doesnt exist
		s, v, err := statementbuilder.Squirrel.
			Insert(settingsTableName).Prepared(true).Cols("name", "configstate", "configtype", "configenv", "value").
			Vals([]interface{}{key, "enabled", configtype, configStore.defaultEnv, val}).ToSQL()

		CheckErr(err, "failed to create config insert query")

		_, err = transaction.Exec(s, v...)
		CheckErr(err, "Failed to execute config insert query")
		return err
	} else {

		// row already exists

		s, v, err := statementbuilder.Squirrel.Update(settingsTableName).Prepared(true).
			Set(goqu.Record{
				"value":         val,
				"updated_at":    time.Now(),
				"previousvalue": previousValue,
			}).
			Where(goqu.Ex{"name": key}).
			Where(goqu.Ex{"configstate": "enabled"}).
			Where(goqu.Ex{"configtype": configtype}).
			Where(goqu.Ex{"configenv": configStore.defaultEnv}).ToSQL()

		CheckErr(err, "Failed to create config insert query")

		_, err = transaction.Exec(s, v...)
		CheckErr(err, "Failed to execute config update query")
		return err