directus

1
import type { Knex } from 'knex';
2
import { GeometryHelper } from '../types.js';
3

4
export class GeometryHelperMySQL extends GeometryHelper {
5
	override collect(table: string, column: string): Knex.Raw {
6
		return this.knex.raw(
7
			`concat('geometrycollection(', group_concat(? separator ', '), ')'`,
8
			this.asText(table, column),
9
		);
10
	}
11

12
	override fromText(text: string): Knex.Raw {
13
		return this.knex.raw('st_geomfromtext(?)', text);
14
	}
15

16
	asGeoJSON(table: string, column: string): Knex.Raw {
17
		return this.knex.raw('st_asgeojson(??.??) as ??', [table, column, column]);
18
	}
19
}
20