NodeJS source (view on github)

const subscriptions = require('../../../../../index.js')

module.exports = {
  get: async (req) => {
    req.query = req.query || {}
    const where = {
      appid: req.appid || global.appid
    }
    if (req.query.customerid) {
      const customer = await global.api.administrator.subscriptions.Customer.get(req)
      if (!customer) {
        throw new Error('invalid-customerid')
      }
      where.customerid = req.query.customerid
    } else if (req.query.subscriptionid) {
      const subscription = await global.api.administrator.subscriptions.Subscription.get(req)
      if (!subscription) {
        throw new Error('invalid-subscriptionid')
      }
      where.subscriptionid = req.query.subscriptionid
    } else if (req.query.accountid) {
      const account = await global.api.administrator.Account.get(req)
      if (!account) {
        throw new Error('invalid-accountid')
      }
      where.accountid = req.query.accountid
    }
    let usagerecordids
    if (req.query.all) {
      usagerecordids = await subscriptions.Storage.UsageRecord.findAll({
        where,
        attributes: ['usagerecordid'],
        order: [
          ['createdAt', 'DESC']
        ]
      })
    } else {
      const offset = req.query.offset ? parseInt(req.query.offset, 10) : 0
      const limit = req.query.limit ? parseInt(req.query.limit, 10) : global.pageSize
      usagerecordids = await subscriptions.Storage.UsageRecord.findAll({
        where,
        attributes: ['usagerecordid'],
        offset,
        limit,
        order: [
          ['createdAt', 'DESC']
        ]
      })
    }
    if (!usagerecordids || !usagerecordids.length) {
      return null
    }
    const items = []
    for (const taxRateInfo of usagerecordids) {
      req.query.usagerecordid = taxRateInfo.dataValues.usagerecordid
      const usageRecord = await global.api.administrator.subscriptions.UsageRecord.get(req)
      items.push(usageRecord)
    }
    return items
  }
}

Test source (view on github)

/* eslint-env mocha */
const assert = require('assert')
const TestHelper = require('../../../../../test-helper.js')
const TestStripeAccounts = require('../../../../../test-stripe-accounts.js')
const DashboardTestHelper = require('@layeredapps/dashboard/test-helper.js')

describe('/api/administrator/subscriptions/usage-records', function () {
  before(TestHelper.disableMetrics)
  after(TestHelper.enableMetrics)
  let cachedResponses, cachedUsageRecords
  async function bundledData (retryNumber) {
    if (retryNumber > 0) {
      cachedResponses = {}
    }
    if (cachedResponses && cachedResponses.finished) {
      return
    }
    cachedResponses = {}
    cachedUsageRecords = []
    await TestHelper.setupBefore()
    await DashboardTestHelper.setupBeforeEach()
    await TestHelper.setupBeforeEach()
    const administrator = await TestStripeAccounts.createOwnerWithPrice({
      active: 'true',
      currency: 'usd',
      recurring_interval: 'month',
      recurring_interval_count: '1',
      recurring_usage_type: 'metered',
      recurring_aggregate_usage: 'sum',
      billing_scheme: 'tiered',
      tax_behavior: 'inclusive',
      tiers_mode: 'volume',
      tier1_up_to: '1000',
      tier1_flat_amount: '9999',
      tier2_up_to: 'inf',
      tier2_flat_amount: '8999'
    })
    let accountUser
    for (let i = 0, len = global.pageSize; i < len; i++) {
      const user = accountUser = await TestStripeAccounts.createUserWithPaidSubscription(administrator.price)
      await TestHelper.createUsageRecord(user, 100)
      cachedUsageRecords.unshift(user.usageRecord.usagerecordid)
    }
    await TestHelper.createCustomer(accountUser, {
      email: accountUser.profile.contactEmail
    })
    await TestHelper.createPaymentMethod(accountUser, {
      cvc: '111',
      number: '4111111111111111',
      exp_month: '1',
      exp_year: (new Date().getFullYear() + 1).toString().substring(2),
      name: accountUser.profile.fullName,
      line1: '285 Fulton St',
      line2: 'Apt 893',
      city: 'New York',
      state: 'NY',
      postal_code: '90120',
      country: 'US',
      default: 'true'
    })
    await TestHelper.createSubscription(accountUser, [administrator.price.priceid])
    await TestHelper.createUsageRecord(accountUser, 100)
    cachedUsageRecords.unshift(accountUser.usageRecord.usagerecordid)
    await TestHelper.wait(1100)
    await TestHelper.createUsageRecord(accountUser, 100)
    cachedUsageRecords.unshift(accountUser.usageRecord.usagerecordid)
    const req1 = TestHelper.createRequest('/api/administrator/subscriptions/usage-records?offset=1')
    req1.account = administrator.account
    req1.session = administrator.session
    cachedResponses.offset = await req1.get()
    const req2 = TestHelper.createRequest('/api/administrator/subscriptions/usage-records?limit=1')
    req2.account = administrator.account
    req2.session = administrator.session
    cachedResponses.limit = await req2.get()
    const req3 = TestHelper.createRequest('/api/administrator/subscriptions/usage-records?all=true')
    req3.account = administrator.account
    req3.session = administrator.session
    cachedResponses.all = await req3.get()
    const req4 = TestHelper.createRequest(`/api/administrator/subscriptions/usage-records?accountid=${accountUser.account.accountid}&all=true`)
    req4.account = administrator.account
    req4.session = administrator.session
    cachedResponses.accountid = await req4.get()
    const req5 = TestHelper.createRequest(`/api/administrator/subscriptions/usage-records?customerid=${accountUser.customer.customerid}&all=true`)
    req5.account = administrator.account
    req5.session = administrator.session
    cachedResponses.customerid = await req5.get()
    const req6 = TestHelper.createRequest(`/api/administrator/subscriptions/usage-records?subscriptionid=${accountUser.subscription.subscriptionid}&all=true`)
    req6.account = administrator.account
    req6.session = administrator.session
    cachedResponses.subscriptionid = await req6.get()
    const req7 = TestHelper.createRequest('/api/administrator/subscriptions/usage-records')
    req7.account = administrator.account
    req7.session = administrator.session
    req7.filename = __filename
    req7.saveResponse = true
    cachedResponses.returns = await req7.get()
    global.pageSize = 3
    cachedResponses.pageSize = await req7.get()
    global.pageSize = 2
    cachedResponses.finished = true
  }
  describe('receives', () => {
    it('optional querystring offset (integer)', async function () {
      await bundledData(this.test.currentRetry())
      const offset = 1
      const usageRecordsNow = cachedResponses.offset
      for (let i = 0, len = global.pageSize; i < len; i++) {
        assert.strictEqual(usageRecordsNow[i].usagerecordid, cachedUsageRecords[offset + i])
      }
    })

    it('optional querystring limit (integer)', async function () {
      await bundledData(this.test.currentRetry())
      const limit = 1
      const usageRecordsNow = cachedResponses.limit
      assert.strictEqual(usageRecordsNow.length, limit)
    })

    it('optional querystring all (boolean)', async () => {
      const usageRecordsNow = cachedResponses.all
      assert.strictEqual(usageRecordsNow.length, cachedUsageRecords.length)
    })

    it('optional querystring accountid', async () => {
      const usageRecordsNow = cachedResponses.accountid
      assert.strictEqual(usageRecordsNow.length, 3)
    })

    it('optional querystring customerid', async () => {
      const usageRecordsNow = cachedResponses.customerid
      assert.strictEqual(usageRecordsNow.length, 2)
    })

    it('optional querystring subscriptionid', async () => {
      const usageRecordsNow = cachedResponses.subscriptionid
      assert.strictEqual(usageRecordsNow.length, 2)
    })
  })

  describe('returns', () => {
    it('array', async () => {
      const subscriptions = cachedResponses.returns
      assert.strictEqual(subscriptions.length, global.pageSize)
    })
  })

  describe('configuration', () => {
    it('environment PAGE_SIZE', async () => {
      const subscriptions = cachedResponses.pageSize
      assert.strictEqual(subscriptions.length, global.pageSize + 1)
    })
  })
})