directus

1
// dynamically adds fields to the sql strings as the schema grows
2
export const sqlFieldFormatter = (schema: Record<string, any>, table: string) => {
3
	const fields = [];
4

5
	// Exclude alias fields, unable to selected in DB
6
	for (const field of Object.keys(schema['collections'][table].fields)) {
7
		if (schema['collections'][table].fields[field].type !== 'alias') {
8
			fields.push(field);
9
		}
10
	}
11

12
	let sql = '';
13

14
	for (const field of fields.slice(0, fields.length - 1)) {
15
		sql += `"${table}"."${field}", `;
16
	}
17

18
	sql += `"${table}"."${fields[fields.length - 1]}"`;
19
	return sql;
20
};
21

22
export const sqlFieldList = (schema: Record<string, any>, table: string) => {
23
	const fields = [];
24

25
	// Exclude alias fields, unable to selected in DB
26
	for (const field of Object.keys(schema['collections'][table].fields)) {
27
		if (schema['collections'][table].fields[field].type !== 'alias') {
28
			fields.push(field);
29
		}
30
	}
31

32
	let sql = '';
33

34
	for (const field of fields.slice(0, fields.length - 1)) {
35
		sql += `"${field}", `;
36
	}
37

38
	sql += `"${fields[fields.length - 1]}"`;
39
	return sql;
40
};
41