META-INF.dirigible.db.v4.query.js Maven / Gradle / Ivy

Go to download
/*
 * Copyright (c) 2022 SAP SE or an SAP affiliate company and Eclipse Dirigible contributors
 *
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v2.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v20.html
 *
 * SPDX-FileCopyrightText: 2022 SAP SE or an SAP affiliate company and Eclipse Dirigible contributors
 * SPDX-License-Identifier: EPL-2.0
 */
/**
 * API v4 Query
 *
 * Note: This module is supported only with the Mozilla Rhino engine
 */

exports.execute = function(sql, parameters, databaseType, datasourceName) {
	let resultset = [];
	if (parameters) {
		const params = JSON.stringify(parameters);
		resultset = org.eclipse.dirigible.api.v3.db.DatabaseFacade.query(sql,params,databaseType,datasourceName);
	} else {
		resultset = org.eclipse.dirigible.api.v3.db.DatabaseFacade.query(sql,null,databaseType,datasourceName);
	}
	if (resultset) {
		return JSON.parse(resultset);
	}
	return resultset;
};