Function applySelectiveFilters

src/clean-db.ts:161–173

(query: Knex.QueryBuilder, options: CleanDbOptions)

}

const applySelectiveFilters = (query: Knex.QueryBuilder, options: CleanDbOptions): Knex.QueryBuilder => {
  if (options.olderThanDays !== undefined) {
    const olderThanSeconds = options.olderThanDays * 24 * 60 * 60
    const cutoff = Math.floor(Date.now() / 1000) - olderThanSeconds
    query.where('event_created_at', '<', cutoff)
  }

  if (options.kinds.length) {
    query.whereIn('event_kind', options.kinds)
  }

  return query
}

const getMatchingEventsCount = async (dbClient: Knex, options: CleanDbOptions): Promise<number> => {
  const query = dbClient('events')