Db2/forward_engineering/alterScript/alterScriptHelpers/viewHelpers/createDropViewHelper.js at 12c0f3eb9dbae9f93fca9565d6515b9ebc74c4cd · hackolade/Db2 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
const { get } = require('lodash');
const {
	getSchemaOfAlterCollection,
	getSchemaNameFromCollection,
	getFullCollectionName,
} = require('../../../utils/general');

/**
 * @param {{
 *  viewSchema: Object,
 *  collectionRefsDefinitionsMap: Object,
 *  mapProperties: Function,
 *  ddlProvider: Object
 * }} param
 */
const getKeys = ({ viewSchema, collectionRefsDefinitionsMap, mapProperties, ddlProvider }) => {
	return mapProperties(viewSchema, (propertyName, schema) => {
		const definition = collectionRefsDefinitionsMap[schema.refId];

		if (!definition) {
			return ddlProvider.hydrateViewColumn({
				name: propertyName,
				isActivated: schema.isActivated,
			});
		}

		const entityName =
			get(definition.collection, '[0].code', '') || get(definition.collection, '[0].collectionName', '') || '';
		const dbName = get(definition.bucket, '[0].code') || get(definition.bucket, '[0].name', '');
		const name = definition.name;

		if (name === propertyName) {
			return ddlProvider.hydrateViewColumn({
				containerData: definition.bucket,
				entityData: definition.collection,
				isActivated: schema.isActivated,
				definition: definition.definition,
				entityName,
				name,
				dbName,
			});
		}

		return ddlProvider.hydrateViewColumn({
			containerData: definition.bucket,
			entityData: definition.collection,
			isActivated: schema.isActivated,
			definition: definition.definition,
			alias: propertyName,
			entityName,
			name,
			dbName,
		});
	});
};

/**
 * @param {{
 *  ddlProvider: Object,
 *  mapProperties: Function,
 *  view: Object
 * }} param
 * @returns {string}
 */
const createView = ({ ddlProvider, mapProperties, view }) => {
	const viewSchema = getSchemaOfAlterCollection(view);
	const schemaName = getSchemaNameFromCollection({ collection: viewSchema }) || '';
	const schemaData = { schemaName };

	const viewData = {
		name: viewSchema.code || viewSchema.name,
		keys: getKeys({
			viewSchema,
			ddlProvider,
			mapProperties,
			collectionRefsDefinitionsMap: view.compMod?.collectionData?.collectionRefsDefinitionsMap ?? {},
		}),
		schemaData,
	};

	const hydratedView = ddlProvider.hydrateView({ viewData, entityData: [viewSchema] });
	const script = ddlProvider.createView(hydratedView, {}, viewSchema.isActivated);

	return script;
};

/**
 * @param {{
 *  ddlProvider: Object,
 *  viewSchema: Object
 * }} param
 * @returns {string}
 */
const dropView = ({ ddlProvider, viewSchema }) => {
	const viewName = getFullCollectionName({
		collectionSchema: viewSchema,
	});

	return ddlProvider.dropView({ viewName });
};

module.exports = {
	createView,
	dropView,
};