code.vegaprotocol.io/vega@v0.79.0/datanode/sqlstore/migrations/0122_add_allowed_sellers.sql (about)

     1  -- +goose Up
     2  ALTER TABLE markets
     3    ADD COLUMN IF NOT EXISTS allowed_sellers JSONB default '[]'::jsonb;
     4  
     5  ALTER TABLE markets_current
     6    ADD COLUMN IF NOT EXISTS allowed_sellers JSONB default '[]'::jsonb;
     7  
     8  ALTER TYPE stop_order_rejection_reason ADD VALUE IF NOT EXISTS 'REJECTION_REASON_SELL_ORDER_NOT_ALLOWED';
     9  
    10  -- +goose StatementBegin
    11  CREATE OR REPLACE FUNCTION update_current_markets()
    12      RETURNS TRIGGER
    13      LANGUAGE PLPGSQL AS
    14  $$
    15  BEGIN
    16  INSERT INTO markets_current(id,tx_hash,vega_time,instrument_id,tradable_instrument,decimal_places,fees,opening_auction,price_monitoring_settings,liquidity_monitoring_parameters,trading_mode,state,market_timestamps,position_decimal_places,lp_price_range, linear_slippage_factor, quadratic_slippage_factor, parent_market_id, insurance_pool_fraction, liquidity_sla_parameters, liquidation_strategy, mark_price_configuration, tick_size, enable_tx_reordering, allowed_empty_amm_levels, allowed_sellers)
    17  VALUES (NEW.id,NEW.tx_hash,NEW.vega_time,NEW.instrument_id,NEW.tradable_instrument,NEW.decimal_places,NEW.fees,NEW.opening_auction,NEW.price_monitoring_settings,NEW.liquidity_monitoring_parameters,NEW.trading_mode,NEW.state,NEW.market_timestamps,NEW.position_decimal_places,NEW.lp_price_range, NEW.linear_slippage_factor, NEW.quadratic_slippage_factor, NEW.parent_market_id, NEW.insurance_pool_fraction, NEW.liquidity_sla_parameters, NEW.liquidation_strategy, NEW.mark_price_configuration, NEW.tick_size, NEW.enable_tx_reordering, NEW.allowed_empty_amm_levels, NEW.allowed_sellers)
    18      ON CONFLICT(id) DO UPDATE SET
    19      tx_hash=EXCLUDED.tx_hash,
    20                             instrument_id=EXCLUDED.instrument_id,
    21                             tradable_instrument=EXCLUDED.tradable_instrument,
    22                             decimal_places=EXCLUDED.decimal_places,
    23                             fees=EXCLUDED.fees,
    24                             opening_auction=EXCLUDED.opening_auction,
    25                             price_monitoring_settings=EXCLUDED.price_monitoring_settings,
    26                             liquidity_monitoring_parameters=EXCLUDED.liquidity_monitoring_parameters,
    27                             trading_mode=EXCLUDED.trading_mode,
    28                             state=EXCLUDED.state,
    29                             market_timestamps=EXCLUDED.market_timestamps,
    30                             position_decimal_places=EXCLUDED.position_decimal_places,
    31                             lp_price_range=EXCLUDED.lp_price_range,
    32                             linear_slippage_factor=EXCLUDED.linear_slippage_factor,
    33                             quadratic_slippage_factor=EXCLUDED.quadratic_slippage_factor,
    34                             vega_time=EXCLUDED.vega_time,
    35                             parent_market_id=EXCLUDED.parent_market_id,
    36                             insurance_pool_fraction=EXCLUDED.insurance_pool_fraction,
    37                             liquidity_sla_parameters=EXCLUDED.liquidity_sla_parameters,
    38                             liquidation_strategy=EXCLUDED.liquidation_strategy,
    39                             mark_price_configuration=EXCLUDED.mark_price_configuration,
    40                             tick_size=EXCLUDED.tick_size,
    41                             enable_tx_reordering=EXCLUDED.enable_tx_reordering,
    42                             allowed_empty_amm_levels=EXCLUDED.allowed_empty_amm_levels,
    43                             allowed_sellers=EXCLUDED.allowed_sellers;
    44  RETURN NULL;
    45  END;
    46  $$;
    47  -- +goose StatementEnd
    48  
    49  
    50  -- +goose Down
    51  
    52  ALTER TABLE markets
    53    DROP COLUMN IF EXISTS allowed_sellers;
    54  ALTER TABLE markets_current
    55    DROP COLUMN IF EXISTS allowed_sellers;
    56  
    57  -- +goose StatementBegin
    58  CREATE OR REPLACE FUNCTION update_current_markets()
    59      RETURNS TRIGGER
    60      LANGUAGE PLPGSQL AS
    61  $$
    62  BEGIN
    63  INSERT INTO markets_current(id,tx_hash,vega_time,instrument_id,tradable_instrument,decimal_places,fees,opening_auction,price_monitoring_settings,liquidity_monitoring_parameters,trading_mode,state,market_timestamps,position_decimal_places,lp_price_range, linear_slippage_factor, quadratic_slippage_factor, parent_market_id, insurance_pool_fraction, liquidity_sla_parameters, liquidation_strategy, mark_price_configuration, tick_size, enable_tx_reordering, allowed_empty_amm_levels)
    64  VALUES (NEW.id,NEW.tx_hash,NEW.vega_time,NEW.instrument_id,NEW.tradable_instrument,NEW.decimal_places,NEW.fees,NEW.opening_auction,NEW.price_monitoring_settings,NEW.liquidity_monitoring_parameters,NEW.trading_mode,NEW.state,NEW.market_timestamps,NEW.position_decimal_places,NEW.lp_price_range, NEW.linear_slippage_factor, NEW.quadratic_slippage_factor, NEW.parent_market_id, NEW.insurance_pool_fraction, NEW.liquidity_sla_parameters, NEW.liquidation_strategy, NEW.mark_price_configuration, NEW.tick_size, NEW.enable_tx_reordering, NEW.allowed_empty_amm_levels)
    65      ON CONFLICT(id) DO UPDATE SET
    66      tx_hash=EXCLUDED.tx_hash,
    67                             instrument_id=EXCLUDED.instrument_id,
    68                             tradable_instrument=EXCLUDED.tradable_instrument,
    69                             decimal_places=EXCLUDED.decimal_places,
    70                             fees=EXCLUDED.fees,
    71                             opening_auction=EXCLUDED.opening_auction,
    72                             price_monitoring_settings=EXCLUDED.price_monitoring_settings,
    73                             liquidity_monitoring_parameters=EXCLUDED.liquidity_monitoring_parameters,
    74                             trading_mode=EXCLUDED.trading_mode,
    75                             state=EXCLUDED.state,
    76                             market_timestamps=EXCLUDED.market_timestamps,
    77                             position_decimal_places=EXCLUDED.position_decimal_places,
    78                             lp_price_range=EXCLUDED.lp_price_range,
    79                             linear_slippage_factor=EXCLUDED.linear_slippage_factor,
    80                             quadratic_slippage_factor=EXCLUDED.quadratic_slippage_factor,
    81                             vega_time=EXCLUDED.vega_time,
    82                             parent_market_id=EXCLUDED.parent_market_id,
    83                             insurance_pool_fraction=EXCLUDED.insurance_pool_fraction,
    84                             liquidity_sla_parameters=EXCLUDED.liquidity_sla_parameters,
    85                             liquidation_strategy=EXCLUDED.liquidation_strategy,
    86                             mark_price_configuration=EXCLUDED.mark_price_configuration,
    87                             tick_size=EXCLUDED.tick_size,
    88                             enable_tx_reordering=EXCLUDED.enable_tx_reordering,
    89                             allowed_empty_amm_levels=EXCLUDED.allowed_empty_amm_levels;
    90  RETURN NULL;
    91  END;
    92  $$;
    93  -- +goose StatementEnd