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

     1  -- +goose Up
     2  
     3  ALTER TABLE markets ADD COLUMN IF NOT EXISTS liquidity_sla_parameters jsonb;
     4  
     5  ALTER TABLE markets_current ADD COLUMN IF NOT EXISTS liquidity_sla_parameters jsonb;
     6  
     7  -- +goose StatementBegin
     8  CREATE OR REPLACE FUNCTION update_current_markets()
     9      RETURNS TRIGGER
    10      LANGUAGE PLPGSQL AS
    11  $$
    12  BEGIN
    13  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)
    14  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)
    15      ON CONFLICT(id) DO UPDATE SET
    16      tx_hash=EXCLUDED.tx_hash,
    17                             instrument_id=EXCLUDED.instrument_id,
    18                             tradable_instrument=EXCLUDED.tradable_instrument,
    19                             decimal_places=EXCLUDED.decimal_places,
    20                             fees=EXCLUDED.fees,
    21                             opening_auction=EXCLUDED.opening_auction,
    22                             price_monitoring_settings=EXCLUDED.price_monitoring_settings,
    23                             liquidity_monitoring_parameters=EXCLUDED.liquidity_monitoring_parameters,
    24                             trading_mode=EXCLUDED.trading_mode,
    25                             state=EXCLUDED.state,
    26                             market_timestamps=EXCLUDED.market_timestamps,
    27                             position_decimal_places=EXCLUDED.position_decimal_places,
    28                             lp_price_range=EXCLUDED.lp_price_range,
    29                             linear_slippage_factor=EXCLUDED.linear_slippage_factor,
    30                             quadratic_slippage_factor=EXCLUDED.quadratic_slippage_factor,
    31                             vega_time=EXCLUDED.vega_time,
    32                             parent_market_id=EXCLUDED.parent_market_id,
    33                             insurance_pool_fraction=EXCLUDED.insurance_pool_fraction,
    34                             liquidity_sla_parameters=EXCLUDED.liquidity_sla_parameters;
    35  RETURN NULL;
    36  END;
    37  $$;
    38  -- +goose StatementEnd
    39  
    40  
    41  -- +goose Down
    42  
    43  -- +goose StatementBegin
    44  CREATE OR REPLACE FUNCTION update_current_markets()
    45      RETURNS TRIGGER
    46      LANGUAGE PLPGSQL AS
    47  $$
    48  BEGIN
    49  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)
    50  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)
    51      ON CONFLICT(id) DO UPDATE SET
    52      tx_hash=EXCLUDED.tx_hash,
    53                             instrument_id=EXCLUDED.instrument_id,
    54                             tradable_instrument=EXCLUDED.tradable_instrument,
    55                             decimal_places=EXCLUDED.decimal_places,
    56                             fees=EXCLUDED.fees,
    57                             opening_auction=EXCLUDED.opening_auction,
    58                             price_monitoring_settings=EXCLUDED.price_monitoring_settings,
    59                             liquidity_monitoring_parameters=EXCLUDED.liquidity_monitoring_parameters,
    60                             trading_mode=EXCLUDED.trading_mode,
    61                             state=EXCLUDED.state,
    62                             market_timestamps=EXCLUDED.market_timestamps,
    63                             position_decimal_places=EXCLUDED.position_decimal_places,
    64                             lp_price_range=EXCLUDED.lp_price_range,
    65                             linear_slippage_factor=EXCLUDED.linear_slippage_factor,
    66                             quadratic_slippage_factor=EXCLUDED.quadratic_slippage_factor,
    67                             vega_time=EXCLUDED.vega_time,
    68                             parent_market_id=EXCLUDED.parent_market_id,
    69                             insurance_pool_fraction=EXCLUDED.insurance_pool_fraction;
    70  RETURN NULL;
    71  END;
    72  $$;
    73  -- +goose StatementEnd