directus

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

4
export class GeometryHelperSQLite extends GeometryHelper {
5
	override async supported() {
6
		const res = await this.knex.select('name').from('pragma_function_list').where({ name: 'spatialite_version' });
7
		return res.length > 0;
8
	}
9

10
	asGeoJSON(table: string, column: string): Knex.Raw {
11
		return this.knex.raw('asgeojson(??.??) as ??', [table, column, column]);
12
	}
13
}
14