directus

1
import type { Knex } from 'knex';
2

3
export async function up(knex: Knex): Promise<void> {
4
	await knex('directus_fields')
5
		.update({ special: knex.raw(`REPLACE(??, 'geometry,', 'geometry.')`, ['special']) })
6
		.where('special', 'like', '%geometry,Point%')
7
		.orWhere('special', 'like', '%geometry,LineString%')
8
		.orWhere('special', 'like', '%geometry,Polygon%')
9
		.orWhere('special', 'like', '%geometry,MultiPoint%')
10
		.orWhere('special', 'like', '%geometry,MultiLineString%')
11
		.orWhere('special', 'like', '%geometry,MultiPolygon%');
12
}
13

14
export async function down(knex: Knex): Promise<void> {
15
	await knex('directus_fields')
16
		.update({ special: knex.raw(`REPLACE(??, 'geometry.', 'geometry,')`, ['special']) })
17
		.where('special', 'like', '%geometry.Point%')
18
		.orWhere('special', 'like', '%geometry.LineString%')
19
		.orWhere('special', 'like', '%geometry.Polygon%')
20
		.orWhere('special', 'like', '%geometry.MultiPoint%')
21
		.orWhere('special', 'like', '%geometry.MultiLineString%')
22
		.orWhere('special', 'like', '%geometry.MultiPolygon%');
23
}
24