acquisitions AS()

in bandit/src/query-lambda/build-query.ts [32:77]

• 46 lines of code
• 1 McCabe index (conditional complexity)

acquisitions AS (
    SELECT
      ab.name AS  test_name,
      ab.variant AS variant_name,
      CASE product
        WHEN 'SUPPORTER_PLUS' THEN
          CASE currency
            WHEN 'GBP' THEN
              CASE payment_frequency
                WHEN 'MONTHLY' THEN 12
                WHEN 'ANNUALLY' THEN 120
                END
            WHEN 'USD' THEN
              CASE payment_frequency
                WHEN 'MONTHLY' THEN 15
                WHEN 'ANNUALLY' THEN 150
                END
            WHEN 'AUD' THEN
              CASE payment_frequency
                WHEN 'MONTHLY' THEN 20
                WHEN 'ANNUALLY' THEN 200
                END
            WHEN 'EUR' THEN
              CASE payment_frequency
                WHEN 'MONTHLY' THEN 12
                WHEN 'ANNUALLY' THEN 120
                END
            WHEN 'NZD' THEN
              CASE payment_frequency
                WHEN 'MONTHLY' THEN 20
                WHEN 'ANNUALLY' THEN 200
                END
            WHEN 'CAD' THEN
              CASE payment_frequency
                WHEN 'MONTHLY' THEN 15
                WHEN 'ANNUALLY' THEN 150
                END
            END
        WHEN 'CONTRIBUTION' THEN amount
        WHEN 'RECURRING_CONTRIBUTION' THEN amount
        END
        AS amount,
      product,
      currency,
      payment_frequency,
    FROM datatech-platform-${stage.toLowerCase()}.datalake.fact_acquisition_event AS acq