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

     1  -- +goose Up
     2  
     3  drop view if exists referral_set_referee_stats;
     4  
     5  alter table referral_set_stats
     6      alter column referral_set_running_notional_taker_volume type text using (referral_set_running_notional_taker_volume::text);
     7  
     8  alter table referral_set_stats
     9      alter column referral_set_running_notional_taker_volume set not null;
    10  
    11  alter table referral_set_stats
    12      alter column reward_factor type text using (reward_factor::text);
    13  
    14  alter table referral_set_stats
    15      alter column reward_factor set not null;
    16  
    17  
    18  -- +goose Down
    19  
    20  create view referral_set_referee_stats as
    21  (
    22  select set_id,
    23         at_epoch,
    24         referral_set_running_notional_taker_volume,
    25         stats.referee_stats ->> 'party_id'        as party_id,
    26         stats.referee_stats ->> 'discount_factor' as discount_factor,
    27         reward_factor,
    28         vega_time
    29  from referral_set_stats,
    30       jsonb_array_elements(referees_stats) with ordinality stats(referee_stats, position)
    31      );