Method applyHexCriteria

src/repositories/event-repository.ts:151–180

(builder: any, tableFields: string[], criteria?: string[])

  }

  private applyHexCriteria(builder: any, tableFields: string[], criteria?: string[]): void {
    if (typeof criteria === 'undefined') {
      return
    }

    if (!criteria.length) {
      builder.whereRaw('1 = 0')
      return
    }

    const groups = this.groupHexCriteria(criteria)

    tableFields.forEach((tableField) => {
      if (groups.exact.length) {
        builder.orWhereIn(tableField, groups.exact.map(toBuffer))
      }

      groups.even.forEach((prefix) => {
        builder.orWhereRaw(`substring("${tableField}" from 1 for ?) = ?`, [prefix.length >> 1, toBuffer(prefix)])
      })

      groups.odd.forEach((prefix) => {
        builder.orWhereRaw(`substring("${tableField}" from 1 for ?) BETWEEN ? AND ?`, [
          (prefix.length >> 1) + 1,
          `\\x${prefix}0`,
          `\\x${prefix}f`,
        ])
      })
    })
  }

  private groupHexCriteria(criteria: string[]): HexCriterionGroups {
    return criteria.reduce<HexCriterionGroups>(