import { EntityRoot, SelectQuery, SmartList, TeaQLDataService, UserContext, executeRelationFacets } from '../../teaql-ts'; import { School } from '../models/School'; import { mergeGeneratedScalarSearch, DynamicSearchWarning, QueryIntent } from 'teaql-ts'; import { GENERATED_SEARCH_MODELS } from '../../generated-search-models'; export class SchoolRequest { private query: SelectQuery; private filters: any[] = []; private _purpose: string | undefined; private _comment: string | undefined; private _pageCountAlias: string | undefined; private _pageCountMethod: "count" | "countAs" | undefined; private _dynamicSearchWarnings: DynamicSearchWarning[] = []; constructor(minimal = false) { this.query = new SelectQuery("School"); this.filters.push({ version: { "$gte": 1 } }); if (minimal) { this.selectId(); this.selectVersion(); } else this.selectSelfFields(); } comment(c: string): this { this.query.comment(c); this._comment = c; return this; } filterByJson(source: unknown, warn?: (warning: DynamicSearchWarning) => void): this { const base = this.query.clone(); if (this.filters.length > 0) base.filter({ "$and": this.filters }); const merged = mergeGeneratedScalarSearch(base, source, GENERATED_SEARCH_MODELS, warn); this.query = merged.query as SelectQuery; this.filters = this.query.filterCondition ? [this.query.filterCondition] : []; this._dynamicSearchWarnings.push(...merged.warnings); return this; } get dynamicSearchWarnings(): readonly DynamicSearchWarning[] { return this._dynamicSearchWarnings.map(warning => ({ ...warning })); } purpose(p: string): ExecutableSchoolRequest { this.query.purpose(p); this._purpose = p; return new ExecutableSchoolRequest( (context) => context.withQueryRequest(this.query, () => this.executeForListInternal(context)), (context) => context.withQueryRequest(this.query, () => this.executeForRowsInternal(context)), (context, chunkSize) => this.executeForStreamInternal(context, chunkSize), () => this.limit(1), (c) => this.comment(c), () => this.ensureIntent()); } optimizeForContinuousPageFetch(): this { this.query.optimizeForContinuousPageFetch(); return this; } optimizeForContinuousPageFetchWith(namespace: string, ttlSeconds: number): this { this.query.optimizeForContinuousPageFetchWith(namespace, ttlSeconds); return this; } optimizePaginationWithIdSet(): this { this.query.optimizePaginationWithIdSet(); return this; } optimizePaginationWithIdSetConfig(namespace: string, ttlSeconds: number, maxIds: number): this { this.query.optimizePaginationWithIdSetConfig(namespace, ttlSeconds, maxIds); return this; } topNProbeParentThreshold(threshold: number): this { this.query.topNProbeParentThreshold(threshold); return this; } limit(n: number): this { this.query.limit(n); return this; } offset(n: number): this { this.query.offset(n); return this; } toQuery(): SelectQuery { if (this.filters.length > 0) { this.query.filter({ "$and": this.filters }); } return this.query; } withDeletedRows(): this { this.filters = this.filters.filter(filter => !("version" in filter)); return this; } deletedRowsOnly(): this { this.withDeletedRows(); this.filters.push({ version: { "$lte": -1 } }); return this; } selectSelfFields(): this { this.query.select(["id", "platform", "schoolType", "name", "address", "establishedDate", "studentCapacity", "active", "createTime", "updateTime", "version"]); return this; } selectId(): this { this.query.select(["id"]); return this; } selectName(): this { this.query.select(["name"]); return this; } selectAddress(): this { this.query.select(["address"]); return this; } selectEstablishedDate(): this { this.query.select(["establishedDate"]); return this; } selectStudentCapacity(): this { this.query.select(["studentCapacity"]); return this; } selectActive(): this { this.query.select(["active"]); return this; } selectCreateTime(): this { this.query.select(["createTime"]); return this; } selectUpdateTime(): this { this.query.select(["updateTime"]); return this; } selectVersion(): this { this.query.select(["version"]); return this; } selectPlatformWith(request: { toQuery(): SelectQuery }): this { this.query.select(["platform"]); this.query.relationQuery( "platform", request.toQuery(), "platform", "id", false, { kind: "relation-select", method: "selectPlatformWith", relation: "platform" }); return this; } selectSchoolTypeWith(request: { toQuery(): SelectQuery }): this { this.query.select(["schoolType"]); this.query.relationQuery( "schoolType", request.toQuery(), "schoolType", "id", false, { kind: "relation-select", method: "selectSchoolTypeWith", relation: "schoolType" }); return this; } withPlatformMatching(request: { toQuery(): SelectQuery }): this { this.filters.push({ "platform": { "$inSubquery": { query: request.toQuery(), field: "id" }, }, }); return this; } withoutPlatformMatching(request: { toQuery(): SelectQuery }): this { this.filters.push({ "platform": { "$notInSubquery": { query: request.toQuery(), field: "id" }, }, }); return this; } withSchoolTypeMatching(request: { toQuery(): SelectQuery }): this { this.filters.push({ "schoolType": { "$inSubquery": { query: request.toQuery(), field: "id" }, }, }); return this; } withoutSchoolTypeMatching(request: { toQuery(): SelectQuery }): this { this.filters.push({ "schoolType": { "$notInSubquery": { query: request.toQuery(), field: "id" }, }, }); return this; } withIdIs(val: any): this { this.filters.push({ "id": { "$eq": val } }); return this; } withIdIsNot(val: any): this { this.filters.push({ "id": { "$ne": val } }); return this; } withIdIn(...vals: any[]): this { this.filters.push({ "id": { "$in": vals } }); return this; } withIdNotIn(...vals: any[]): this { this.filters.push({ "id": { "$notIn": vals } }); return this; } withIdGreaterThan(val: any): this { this.filters.push({ "id": { "$gt": val } }); return this; } withIdGreaterThanOrEqualTo(val: any): this { this.filters.push({ "id": { "$gte": val } }); return this; } withIdLessThan(val: any): this { this.filters.push({ "id": { "$lt": val } }); return this; } withIdLessThanOrEqualTo(val: any): this { this.filters.push({ "id": { "$lte": val } }); return this; } withIdBetween(lower: any, upper: any): this { this.filters.push({ "id": { "$between": [lower, upper] } }); return this; } withIdIsKnown(): this { this.filters.push({ "id": { "$isNull": false } }); return this; } withIdIsUnknown(): this { this.filters.push({ "id": { "$isNull": true } }); return this; } filterByPlatform(val: any): this { this.filters.push({ "platform": { "$eq": val } }); return this; } filterByPlatformIn(...vals: any[]): this { this.filters.push({ "platform": { "$in": vals } }); return this; } withPlatformIsKnown(): this { this.filters.push({ "platform": { "$isNull": false } }); return this; } withPlatformIsUnknown(): this { this.filters.push({ "platform": { "$isNull": true } }); return this; } filterBySchoolType(val: any): this { this.filters.push({ "schoolType": { "$eq": val } }); return this; } filterBySchoolTypeIn(...vals: any[]): this { this.filters.push({ "schoolType": { "$in": vals } }); return this; } withSchoolTypeIsKnown(): this { this.filters.push({ "schoolType": { "$isNull": false } }); return this; } withSchoolTypeIsUnknown(): this { this.filters.push({ "schoolType": { "$isNull": true } }); return this; } withSchoolTypeIsPrimary(): this { this.filters.push({ "schoolType": { "$eq": "1001" } }); return this; } withSchoolTypeIsSecondary(): this { this.filters.push({ "schoolType": { "$eq": "1002" } }); return this; } withNameContaining(val: string): this { this.filters.push({ "name": { "$contains": val } }); return this; } withNameIs(val: string): this { this.filters.push({ "name": { "$eq": val } }); return this; } withNameIsNot(val: any): this { this.filters.push({ "name": { "$ne": val } }); return this; } withNameIn(...vals: any[]): this { this.filters.push({ "name": { "$in": vals } }); return this; } withNameNotIn(...vals: any[]): this { this.filters.push({ "name": { "$notIn": vals } }); return this; } withNameGreaterThan(val: any): this { this.filters.push({ "name": { "$gt": val } }); return this; } withNameGreaterThanOrEqualTo(val: any): this { this.filters.push({ "name": { "$gte": val } }); return this; } withNameLessThan(val: any): this { this.filters.push({ "name": { "$lt": val } }); return this; } withNameLessThanOrEqualTo(val: any): this { this.filters.push({ "name": { "$lte": val } }); return this; } withNameBetween(lower: any, upper: any): this { this.filters.push({ "name": { "$between": [lower, upper] } }); return this; } withNameIsKnown(): this { this.filters.push({ "name": { "$isNull": false } }); return this; } withNameIsUnknown(): this { this.filters.push({ "name": { "$isNull": true } }); return this; } withNameNotContaining(val: string): this { this.filters.push({ "name": { "$notContains": val } }); return this; } withNameStartingWith(val: string): this { this.filters.push({ "name": { "$startsWith": val } }); return this; } withNameNotStartingWith(val: string): this { this.filters.push({ "name": { "$notStartsWith": val } }); return this; } withNameEndingWith(val: string): this { this.filters.push({ "name": { "$endsWith": val } }); return this; } withNameNotEndingWith(val: string): this { this.filters.push({ "name": { "$notEndsWith": val } }); return this; } withNameSoundingLike(val: string): this { this.filters.push({ "name": { "$soundLike": val } }); return this; } withAddressContaining(val: string): this { this.filters.push({ "address": { "$contains": val } }); return this; } withAddressIs(val: string): this { this.filters.push({ "address": { "$eq": val } }); return this; } withAddressIsNot(val: any): this { this.filters.push({ "address": { "$ne": val } }); return this; } withAddressIn(...vals: any[]): this { this.filters.push({ "address": { "$in": vals } }); return this; } withAddressNotIn(...vals: any[]): this { this.filters.push({ "address": { "$notIn": vals } }); return this; } withAddressGreaterThan(val: any): this { this.filters.push({ "address": { "$gt": val } }); return this; } withAddressGreaterThanOrEqualTo(val: any): this { this.filters.push({ "address": { "$gte": val } }); return this; } withAddressLessThan(val: any): this { this.filters.push({ "address": { "$lt": val } }); return this; } withAddressLessThanOrEqualTo(val: any): this { this.filters.push({ "address": { "$lte": val } }); return this; } withAddressBetween(lower: any, upper: any): this { this.filters.push({ "address": { "$between": [lower, upper] } }); return this; } withAddressIsKnown(): this { this.filters.push({ "address": { "$isNull": false } }); return this; } withAddressIsUnknown(): this { this.filters.push({ "address": { "$isNull": true } }); return this; } withAddressNotContaining(val: string): this { this.filters.push({ "address": { "$notContains": val } }); return this; } withAddressStartingWith(val: string): this { this.filters.push({ "address": { "$startsWith": val } }); return this; } withAddressNotStartingWith(val: string): this { this.filters.push({ "address": { "$notStartsWith": val } }); return this; } withAddressEndingWith(val: string): this { this.filters.push({ "address": { "$endsWith": val } }); return this; } withAddressNotEndingWith(val: string): this { this.filters.push({ "address": { "$notEndsWith": val } }); return this; } withAddressSoundingLike(val: string): this { this.filters.push({ "address": { "$soundLike": val } }); return this; } withEstablishedDateIs(val: any): this { this.filters.push({ "establishedDate": { "$eq": val } }); return this; } withEstablishedDateIsNot(val: any): this { this.filters.push({ "establishedDate": { "$ne": val } }); return this; } withEstablishedDateIn(...vals: any[]): this { this.filters.push({ "establishedDate": { "$in": vals } }); return this; } withEstablishedDateNotIn(...vals: any[]): this { this.filters.push({ "establishedDate": { "$notIn": vals } }); return this; } withEstablishedDateGreaterThan(val: any): this { this.filters.push({ "establishedDate": { "$gt": val } }); return this; } withEstablishedDateGreaterThanOrEqualTo(val: any): this { this.filters.push({ "establishedDate": { "$gte": val } }); return this; } withEstablishedDateLessThan(val: any): this { this.filters.push({ "establishedDate": { "$lt": val } }); return this; } withEstablishedDateLessThanOrEqualTo(val: any): this { this.filters.push({ "establishedDate": { "$lte": val } }); return this; } withEstablishedDateBetween(lower: any, upper: any): this { this.filters.push({ "establishedDate": { "$between": [lower, upper] } }); return this; } withEstablishedDateIsKnown(): this { this.filters.push({ "establishedDate": { "$isNull": false } }); return this; } withEstablishedDateIsUnknown(): this { this.filters.push({ "establishedDate": { "$isNull": true } }); return this; } withStudentCapacityIs(val: any): this { this.filters.push({ "studentCapacity": { "$eq": val } }); return this; } withStudentCapacityIsNot(val: any): this { this.filters.push({ "studentCapacity": { "$ne": val } }); return this; } withStudentCapacityIn(...vals: any[]): this { this.filters.push({ "studentCapacity": { "$in": vals } }); return this; } withStudentCapacityNotIn(...vals: any[]): this { this.filters.push({ "studentCapacity": { "$notIn": vals } }); return this; } withStudentCapacityGreaterThan(val: any): this { this.filters.push({ "studentCapacity": { "$gt": val } }); return this; } withStudentCapacityGreaterThanOrEqualTo(val: any): this { this.filters.push({ "studentCapacity": { "$gte": val } }); return this; } withStudentCapacityLessThan(val: any): this { this.filters.push({ "studentCapacity": { "$lt": val } }); return this; } withStudentCapacityLessThanOrEqualTo(val: any): this { this.filters.push({ "studentCapacity": { "$lte": val } }); return this; } withStudentCapacityBetween(lower: any, upper: any): this { this.filters.push({ "studentCapacity": { "$between": [lower, upper] } }); return this; } withStudentCapacityIsKnown(): this { this.filters.push({ "studentCapacity": { "$isNull": false } }); return this; } withStudentCapacityIsUnknown(): this { this.filters.push({ "studentCapacity": { "$isNull": true } }); return this; } whichAreActive(): this { this.filters.push({ "active": { "$eq": true } }); return this; } whichAreNotActive(): this { this.filters.push({ "active": { "$eq": false } }); return this; } withActiveIsNot(val: any): this { this.filters.push({ "active": { "$ne": val } }); return this; } withActiveIn(...vals: any[]): this { this.filters.push({ "active": { "$in": vals } }); return this; } withActiveNotIn(...vals: any[]): this { this.filters.push({ "active": { "$notIn": vals } }); return this; } withActiveGreaterThan(val: any): this { this.filters.push({ "active": { "$gt": val } }); return this; } withActiveGreaterThanOrEqualTo(val: any): this { this.filters.push({ "active": { "$gte": val } }); return this; } withActiveLessThan(val: any): this { this.filters.push({ "active": { "$lt": val } }); return this; } withActiveLessThanOrEqualTo(val: any): this { this.filters.push({ "active": { "$lte": val } }); return this; } withActiveBetween(lower: any, upper: any): this { this.filters.push({ "active": { "$between": [lower, upper] } }); return this; } withActiveIsKnown(): this { this.filters.push({ "active": { "$isNull": false } }); return this; } withActiveIsUnknown(): this { this.filters.push({ "active": { "$isNull": true } }); return this; } withCreateTimeIs(val: any): this { this.filters.push({ "createTime": { "$eq": val } }); return this; } withCreateTimeIsNot(val: any): this { this.filters.push({ "createTime": { "$ne": val } }); return this; } withCreateTimeIn(...vals: any[]): this { this.filters.push({ "createTime": { "$in": vals } }); return this; } withCreateTimeNotIn(...vals: any[]): this { this.filters.push({ "createTime": { "$notIn": vals } }); return this; } withCreateTimeGreaterThan(val: any): this { this.filters.push({ "createTime": { "$gt": val } }); return this; } withCreateTimeGreaterThanOrEqualTo(val: any): this { this.filters.push({ "createTime": { "$gte": val } }); return this; } withCreateTimeLessThan(val: any): this { this.filters.push({ "createTime": { "$lt": val } }); return this; } withCreateTimeLessThanOrEqualTo(val: any): this { this.filters.push({ "createTime": { "$lte": val } }); return this; } withCreateTimeBetween(lower: any, upper: any): this { this.filters.push({ "createTime": { "$between": [lower, upper] } }); return this; } withCreateTimeIsKnown(): this { this.filters.push({ "createTime": { "$isNull": false } }); return this; } withCreateTimeIsUnknown(): this { this.filters.push({ "createTime": { "$isNull": true } }); return this; } withUpdateTimeIs(val: any): this { this.filters.push({ "updateTime": { "$eq": val } }); return this; } withUpdateTimeIsNot(val: any): this { this.filters.push({ "updateTime": { "$ne": val } }); return this; } withUpdateTimeIn(...vals: any[]): this { this.filters.push({ "updateTime": { "$in": vals } }); return this; } withUpdateTimeNotIn(...vals: any[]): this { this.filters.push({ "updateTime": { "$notIn": vals } }); return this; } withUpdateTimeGreaterThan(val: any): this { this.filters.push({ "updateTime": { "$gt": val } }); return this; } withUpdateTimeGreaterThanOrEqualTo(val: any): this { this.filters.push({ "updateTime": { "$gte": val } }); return this; } withUpdateTimeLessThan(val: any): this { this.filters.push({ "updateTime": { "$lt": val } }); return this; } withUpdateTimeLessThanOrEqualTo(val: any): this { this.filters.push({ "updateTime": { "$lte": val } }); return this; } withUpdateTimeBetween(lower: any, upper: any): this { this.filters.push({ "updateTime": { "$between": [lower, upper] } }); return this; } withUpdateTimeIsKnown(): this { this.filters.push({ "updateTime": { "$isNull": false } }); return this; } withUpdateTimeIsUnknown(): this { this.filters.push({ "updateTime": { "$isNull": true } }); return this; } withVersionIs(val: any): this { this.filters.push({ "version": { "$eq": val } }); return this; } withVersionIsNot(val: any): this { this.filters.push({ "version": { "$ne": val } }); return this; } withVersionIn(...vals: any[]): this { this.filters.push({ "version": { "$in": vals } }); return this; } withVersionNotIn(...vals: any[]): this { this.filters.push({ "version": { "$notIn": vals } }); return this; } withVersionGreaterThan(val: any): this { this.filters.push({ "version": { "$gt": val } }); return this; } withVersionGreaterThanOrEqualTo(val: any): this { this.filters.push({ "version": { "$gte": val } }); return this; } withVersionLessThan(val: any): this { this.filters.push({ "version": { "$lt": val } }); return this; } withVersionLessThanOrEqualTo(val: any): this { this.filters.push({ "version": { "$lte": val } }); return this; } withVersionBetween(lower: any, upper: any): this { this.filters.push({ "version": { "$between": [lower, upper] } }); return this; } withVersionIsKnown(): this { this.filters.push({ "version": { "$isNull": false } }); return this; } withVersionIsUnknown(): this { this.filters.push({ "version": { "$isNull": true } }); return this; } orderByIdAscending(): this { this.query.orderBy("id", "asc"); return this; } orderByIdDescending(): this { this.query.orderBy("id", "desc"); return this; } orderByNameAscending(): this { this.query.orderBy("name", "asc"); return this; } orderByNameDescending(): this { this.query.orderBy("name", "desc"); return this; } orderByAddressAscending(): this { this.query.orderBy("address", "asc"); return this; } orderByAddressDescending(): this { this.query.orderBy("address", "desc"); return this; } orderByEstablishedDateAscending(): this { this.query.orderBy("establishedDate", "asc"); return this; } orderByEstablishedDateDescending(): this { this.query.orderBy("establishedDate", "desc"); return this; } orderByStudentCapacityAscending(): this { this.query.orderBy("studentCapacity", "asc"); return this; } orderByStudentCapacityDescending(): this { this.query.orderBy("studentCapacity", "desc"); return this; } orderByActiveAscending(): this { this.query.orderBy("active", "asc"); return this; } orderByActiveDescending(): this { this.query.orderBy("active", "desc"); return this; } orderByCreateTimeAscending(): this { this.query.orderBy("createTime", "asc"); return this; } orderByCreateTimeDescending(): this { this.query.orderBy("createTime", "desc"); return this; } orderByUpdateTimeAscending(): this { this.query.orderBy("updateTime", "asc"); return this; } orderByUpdateTimeDescending(): this { this.query.orderBy("updateTime", "desc"); return this; } orderByVersionAscending(): this { this.query.orderBy("version", "asc"); return this; } orderByVersionDescending(): this { this.query.orderBy("version", "desc"); return this; } // --- Aggregations --- count(): this { this.query.aggregate("Count", "id", "count"); this._pageCountAlias = "count"; this._pageCountMethod = "count"; return this; } countAs(retName: string): this { this.query.aggregate("Count", "id", retName); this._pageCountAlias = retName; this._pageCountMethod = "countAs"; return this; } minStudentCapacity(): this { return this.minStudentCapacityAs("minOfStudentCapacity"); } minStudentCapacityAs(retName: string): this { this.query.aggregate("min", "studentCapacity", retName); return this; } maxStudentCapacity(): this { return this.maxStudentCapacityAs("maxOfStudentCapacity"); } maxStudentCapacityAs(retName: string): this { this.query.aggregate("max", "studentCapacity", retName); return this; } sumStudentCapacity(): this { return this.sumStudentCapacityAs("sumOfStudentCapacity"); } sumStudentCapacityAs(retName: string): this { this.query.aggregate("sum", "studentCapacity", retName); return this; } avgStudentCapacity(): this { return this.avgStudentCapacityAs("avgOfStudentCapacity"); } avgStudentCapacityAs(retName: string): this { this.query.aggregate("avg", "studentCapacity", retName); return this; } standardDeviationStudentCapacity(): this { return this.standardDeviationStudentCapacityAs("standardDeviationOfStudentCapacity"); } standardDeviationStudentCapacityAs(retName: string): this { this.query.aggregate("stddev", "studentCapacity", retName); return this; } squareRootOfPopulationStandardDeviationStudentCapacity(): this { return this.squareRootOfPopulationStandardDeviationStudentCapacityAs("squareRootOfPopulationStandardDeviationOfStudentCapacity"); } squareRootOfPopulationStandardDeviationStudentCapacityAs(retName: string): this { this.query.aggregate("stddev_pop", "studentCapacity", retName); return this; } sampleVarianceStudentCapacity(): this { return this.sampleVarianceStudentCapacityAs("sampleVarianceOfStudentCapacity"); } sampleVarianceStudentCapacityAs(retName: string): this { this.query.aggregate("var_samp", "studentCapacity", retName); return this; } samplePopulationVarianceStudentCapacity(): this { return this.samplePopulationVarianceStudentCapacityAs("samplePopulationVarianceOfStudentCapacity"); } samplePopulationVarianceStudentCapacityAs(retName: string): this { this.query.aggregate("var_pop", "studentCapacity", retName); return this; } // --- Group By --- groupById(): this { this.query.groupBy("id"); return this; } groupByIdAs(retName: string): this { this.query.groupBy("id"); // In TS we don't alias group by yet natively return this; } groupByPlatform(): this { this.query.groupBy("platform"); return this; } groupByPlatformAs(retName: string): this { this.query.groupBy("platform"); // In TS we don't alias group by yet natively return this; } groupBySchoolType(): this { this.query.groupBy("schoolType"); return this; } groupBySchoolTypeAs(retName: string): this { this.query.groupBy("schoolType"); // In TS we don't alias group by yet natively return this; } groupByName(): this { this.query.groupBy("name"); return this; } groupByNameAs(retName: string): this { this.query.groupBy("name"); // In TS we don't alias group by yet natively return this; } groupByAddress(): this { this.query.groupBy("address"); return this; } groupByAddressAs(retName: string): this { this.query.groupBy("address"); // In TS we don't alias group by yet natively return this; } groupByEstablishedDate(): this { this.query.groupBy("establishedDate"); return this; } groupByEstablishedDateAs(retName: string): this { this.query.groupBy("establishedDate"); // In TS we don't alias group by yet natively return this; } groupByStudentCapacity(): this { this.query.groupBy("studentCapacity"); return this; } groupByStudentCapacityAs(retName: string): this { this.query.groupBy("studentCapacity"); // In TS we don't alias group by yet natively return this; } groupByActive(): this { this.query.groupBy("active"); return this; } groupByActiveAs(retName: string): this { this.query.groupBy("active"); // In TS we don't alias group by yet natively return this; } groupByCreateTime(): this { this.query.groupBy("createTime"); return this; } groupByCreateTimeAs(retName: string): this { this.query.groupBy("createTime"); // In TS we don't alias group by yet natively return this; } groupByUpdateTime(): this { this.query.groupBy("updateTime"); return this; } groupByUpdateTimeAs(retName: string): this { this.query.groupBy("updateTime"); // In TS we don't alias group by yet natively return this; } groupByVersion(): this { this.query.groupBy("version"); return this; } groupByVersionAs(retName: string): this { this.query.groupBy("version"); // In TS we don't alias group by yet natively return this; } // --- Facets --- facetByPlatformAs( facetName: string, request: { toQuery(): SelectQuery }, includeAllFacets = true, ): this { this.query.facetBy(facetName, "platform", request, includeAllFacets, { kind: "facet", method: "facetByPlatformAs", relation: "platform", alias: facetName }); return this; } facetBySchoolTypeAs( facetName: string, request: { toQuery(): SelectQuery }, includeAllFacets = true, ): this { this.query.facetBy(facetName, "schoolType", request, includeAllFacets, { kind: "facet", method: "facetBySchoolTypeAs", relation: "schoolType", alias: facetName }); return this; } private async executeForListInternal(context: UserContext): Promise> { this.ensureIntent(); if (this._pageCountAlias !== undefined) return this.executeCountedListInternal(context); if (this.filters.length > 0) { this.query.filter({ "$and": this.filters }); } const service = context.requireResource("dataService"); const rows = await service.executeQuery(context.prepareQuery(this.query)); const aggregateOnly = this.query.aggregateItems.length > 0 && this.query.groupByItems.length === 0; const data = aggregateOnly ? [] : rows.map((row: unknown) => row instanceof School ? row : School.fromRecord(row as Record, new EntityRoot())); const result = new SmartList(data); if (aggregateOnly && rows[0]) Object.assign(result.aggregations, rows[0]); if (this.query.facets.length > 0) { result.facets = await executeRelationFacets( service, (query: any) => context.prepareQuery(query), this.query, this.query.facets); } return result; } private async executeForRowsInternal(context: UserContext): Promise>> { this.ensureIntent(); if (this.filters.length > 0) this.query.filter({ "$and": this.filters }); const service = context.requireResource("dataService"); return new SmartList>( await service.executeQuery(context.prepareQuery(this.query)) as Record[]); } private async executeCountedListInternal( context: UserContext, ): Promise> { this.ensureIntent(); if (this.filters.length > 0) this.query.filter({ "$and": this.filters }); const service = context.requireResource("dataService"); const preparedQuery = context.prepareQuery(this.query); const useIdSet = preparedQuery.localIdSetPaginationOptions() !== undefined; const countOperation = { kind: "named-count" as const, method: this._pageCountMethod ?? "count", ...(this._pageCountMethod === "countAs" ? { alias: this._pageCountAlias } : {}) }; const totalCountBeforeRows = useIdSet ? undefined : await service.executeCount( preparedQuery, this._pageCountAlias, countOperation); const pageQuery = preparedQuery.clone(); // A page count describes the full filtered set, not an aggregate-only page row. pageQuery.aggregateItems = pageQuery.aggregateItems.filter(item => !(String(item.function).toLowerCase() === "count" && item.alias === this._pageCountAlias)); const rows = await service.executeQuery(pageQuery); const totalCount = useIdSet && context.idSetPaginationCountAccuracy === "EXACT" ? context.idSetPaginationCount! : (totalCountBeforeRows ?? await service.executeCount(preparedQuery, this._pageCountAlias, countOperation)); const data = new SmartList(rows.map((row: unknown) => row instanceof School ? row : School.fromRecord(row as Record, new EntityRoot()))); data.totalCount = totalCount; if (this._pageCountAlias !== undefined) data.aggregations[this._pageCountAlias] = totalCount; if (this.query.facets.length > 0) { data.facets = await executeRelationFacets( service, (query: any) => context.prepareQuery(query), preparedQuery, preparedQuery.facets); } return data; } private executeForStreamInternal(context: UserContext, chunkSize: number): AsyncIterable { this.ensureIntent(); if (this.filters.length > 0) this.query.filter({ "$and": this.filters }); const service = context.requireResource("dataService"); const preparedQuery = context.prepareQuery(this.query); // Prepare Context and capture the runtime request before returning a lazy iterator. const chunks = service.executeForStream(preparedQuery, chunkSize); return (async function* () { for await (const chunk of chunks) { for (const entity of chunk) { yield entity instanceof School ? entity : School.fromRecord(entity as Record, new EntityRoot()); } } })(); } private ensureIntent(): void { // Runtime owns validation, Unicode whitespace rules and typed diagnostics. new QueryIntent(this._comment, this._purpose); } } export class ExecutableSchoolRequest { constructor( private readonly execute: (context: UserContext) => Promise>, private readonly executeRows: (context: UserContext) => Promise>>, private readonly stream: (context: UserContext, chunkSize: number) => AsyncIterable, private readonly limitOne: () => void, private readonly addComment: (comment: string) => void, private readonly ensureIntent: () => void, ) {} comment(c: string): this { this.addComment(c); return this; } newEntity(context: UserContext): School { this.ensureIntent(); return new School(); } executeForList(context: UserContext): Promise> { this.ensureIntent(); return this.execute(context); } executeForRows(context: UserContext): Promise>> { this.ensureIntent(); return this.executeRows(context); } executeForStream(context: UserContext, chunkSize = 1000): AsyncIterable { this.ensureIntent(); return this.stream(context, chunkSize); } async executeForOne(context: UserContext): Promise { this.limitOne(); return (await this.executeForList(context))[0]; } }