directus

1
import type { Knex } from 'knex';
2
import { maybeStringifyBigInt } from '../utils/maybe-stringify-big-int.js';
3
import { numberInRange } from '../utils/number-in-range.js';
4
import { NumberDatabaseHelper, type NumberInfo } from '../types.js';
5
import type { NumericValue } from '@directus/types';
6

7
export class NumberHelperMSSQL extends NumberDatabaseHelper {
8
	override addSearchCondition(
9
		dbQuery: Knex.QueryBuilder,
10
		collection: string,
11
		name: string,
12
		value: NumericValue,
13
	): Knex.QueryBuilder {
14
		return dbQuery.orWhere({ [`${collection}.${name}`]: maybeStringifyBigInt(value) });
15
	}
16

17
	override isNumberValid(value: NumericValue, info: NumberInfo) {
18
		return numberInRange(value, info);
19
	}
20
}
21