META-INF.dirigible.db.v4.database.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 Database
 *
 * Note: This module is supported only with the Mozilla Rhino engine
 */
const bytes = require('io/v4/bytes');

exports.getDatabaseTypes = function() {
	const types = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getDatabaseTypes();
	if (types) {
		return JSON.parse(types);
	}
	return types;
};

exports.getDataSources = function(databaseType) {
	const datasources = databaseType ?
		org.eclipse.dirigible.api.v3.db.DatabaseFacade.getDataSources(databaseType) :
		org.eclipse.dirigible.api.v3.db.DatabaseFacade.getDataSources();
	if (datasources) {
		return JSON.parse(datasources);
	}
	return datasources;
};

exports.createDataSource = function(name, driver, url, username, password, properties) {
	org.eclipse.dirigible.api.v3.db.DatabaseFacade.createDataSource(name, driver, url, username, password, properties);
};

exports.getMetadata = function(databaseType, datasourceName) {
	let metadata;
	if (databaseType && datasourceName) {
		metadata = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getMetadata(databaseType, datasourceName);
	} else if (databaseType && !datasourceName) {
		metadata = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getMetadata(databaseType);
	} else {
		metadata = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getMetadata();
	}

	if (metadata) {
		return JSON.parse(metadata);
	}
	return metadata;
};

exports.getProductName = function(databaseType, datasourceName) {
	let productName;
	if (databaseType && datasourceName) {
		productName = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getProductName(databaseType, datasourceName);
	} else if (databaseType && !datasourceName) {
		productName = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getProductName(databaseType);
	} else {
		productName = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getProductName();
	}
	return productName;
};

exports.getConnection = function(databaseType, datasourceName) {
	const connection = new Connection();
	var native;
	if (databaseType && datasourceName) {
		native = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getConnection(databaseType, datasourceName);
	} else if (databaseType && !datasourceName) {
		native = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getConnection(databaseType);
	} else {
		native = org.eclipse.dirigible.api.v3.db.DatabaseFacade.getConnection();
	}
	connection.native = native;
	return connection;
};

/**
 * Connection object
 */
function Connection() {

	this.prepareStatement = function(sql) {
		const preparedStatement = new PreparedStatement();
		const native = this.native.prepareStatement(sql);
		preparedStatement.native = native;
		return preparedStatement;
	};

	this.prepareCall = function(sql) {
		const callableStatement = new CallableStatement();
		const native = this.native.prepareCall(sql);
		callableStatement.native = native;
		return callableStatement;
	};

	this.close = function() {
		this.native.close();
	};

	this.commit = function() {
		this.native.commit();
	};

	this.getAutoCommit = function() {
		return this.native.getAutoCommit();
	};

	this.getCatalog = function() {
		return this.native.getCatalog();
	};

	this.getSchema = function() {
		return this.native.getSchema();
	};

	this.getTransactionIsolation = function() {
		return this.native.getTransactionIsolation();
	};

	this.isClosed = function() {
		return this.native.isClosed();
	};

	this.isReadOnly = function() {
		return this.native.isReadOnly();
	};

	this.isValid = function() {
		return this.native.isValid();
	};

	this.rollback = function() {
		return this.native.rollback();
	};

	this.setAutoCommit = function(autoCommit) {
		this.native.setAutoCommit(autoCommit);
	};

	this.setCatalog = function(catalog) {
		this.native.setCatalog(catalog);
	};

	this.setReadOnly = function(readOnly) {
		this.native.setReadOnly(readOnly);
	};

	this.setSchema = function(schema) {
		this.native.setSchema(schema);
	};

	this.setTransactionIsolation = function(transactionIsolation) {
		this.native.setTransactionIsolation(transactionIsolation);
	};
}

/**
 * Statement object
 */
function PreparedStatement(internalStatement) {

	this.close = function() {
		this.native.close();
	};

	this.getResultSet = function() {
		const resultset = new ResultSet();
		const native = this.native.getResultSet();
		resultset.native = native;
		return resultset;
	};

	this.execute = function() {
		return this.native.execute();
	};

	this.executeQuery = function() {
		const resultset = new ResultSet();
		resultset.native = this.native.executeQuery();
		return resultset;
	};

	this.executeUpdate = function() {
		return this.native.executeUpdate();
	};

	// getMetaData
	// setBigDecimal
	// setBlob

	this.SQLTypes = Object.freeze({
		"BOOLEAN": 16,
		"DATE": 91,
		"TIME": 92,
		"TIMESTAMP": 93,
		"DOUBLE": 8,
		"FLOAT": 6,
		"REAL": 7,
		"TINYINT": -6,
		"SMALLINT": 5,
		"INTEGER": 4,
		"BIGINT": -5,
		"VARCHAR": 12,
		"CHAR": 1,
		"CLOB": 2005,
		"BLOB": 2004,
		"VARBINARY": -3
	});

	this.setNull = function(index, sqlType){
		this.native.setNull(index, sqlType);
	};

	this.setBoolean = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setBoolean(index, value);
		} else {
			this.setNull(index, this.SQLTypes.BOOLEAN);
		}
	};

	this.setByte = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setByte(index, value);
		} else {
			this.setNull(index, this.SQLTypes.TINYINT);
		}
	};

	this.setClob = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setClob(index, value);
		} else {
			this.setNull(index, this.SQLTypes.CLOB);
		}
	};

	this.setBlob = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setBlob(index, value);
		} else {
			this.setNull(index, this.SQLTypes.BLOB);
		}
	};

	this.setBytesNative = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setBytes(index, value);
		} else {
			this.setNull(index, this.SQLTypes.VARBINARY);
		}
	};

	this.setBytes = function(index, value) {
		if(value!==null && value!==undefined) {
			var data = bytes.toJavaBytes(value);
			this.native.setBytes(index, data);
		} else {
			this.setNull(index, this.SQLTypes.VARBINARY);
		}
	};

	this.setDate = function(index, value) {
		if(value!==null && value!==undefined) {
			var dateInstance = new java.sql.Date(value.getTime());
			this.native.setDate(index, dateInstance);
		} else {
			this.setNull(index, this.SQLTypes.DATE);
		}
	};

	this.setDouble = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setDouble(index, value);
		} else {
			this.setNull(index, this.SQLTypes.DOUBLE);
		}
	};

	this.setFloat = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setFloat(index, value);
		} else {
			this.setNull(index, this.SQLTypes.FLOAT);
		}
	};

	this.setInt = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setInt(index, value);
		} else {
			this.setNull(index, this.SQLTypes.INTEGER);
		}
	};

	this.setLong = function(index, value) {
		index = parseInt(index, 10); //Rhino things..
		if(value!==null && value!==undefined) {
			this.native.setLong(index, value);
		} else {
			this.setNull(index, this.SQLTypes.BIGINT);
		}
	};

	this.setShort = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setShort(index, value);
		} else {
			this.setNull(index, this.SQLTypes.SMALLINT);
		}
	};

	this.setString = function(index, value) {
		if(value!==null && value!==undefined) {
			this.native.setString(index, value);
		} else {
			this.setNull(index, this.SQLTypes.VARCHAR);
		}
	};

	this.setTime = function(index, value) {
		if(value!==null && value!==undefined) {
			var timeInstance = new java.sql.Time(value.getTime());
			this.native.setTime(index, timeInstance);
		} else {
			this.setNull(index, this.SQLTypes.TIME);
		}
	};

	this.setTimestamp = function(index, value) {
		if(value!==null && value!==undefined) {
			var timestampInstance = new java.sql.Timestamp(value.getTime());
			this.native.setTimestamp(index, timestampInstance);
		} else {
			this.setNull(index, this.SQLTypes.TIMESTAMP);
		}
	};

	this.execute = function() {
    	return this.native.execute();
    };

    this.addBatch = function() {
        this.native.addBatch();
    };

    this.executeBatch = function() {
        return this.native.executeBatch();
    };

    this.getMetaData = function() {
        return this.native.getMetaData();
    };

    this.getMoreResults = function() {
		return this.native.getMoreResults();
    };

    this.getParameterMetaData = function() {
        return this.native.getParameterMetaData();
    };

    this.getSQLWarning = function() {
        return this.native.getWarnings();
    };

    this.isClosed = function() {
        return this.native.isClosed();
    };
    this.setDecimal = function(index, value) {
        this.native.setBigDecimal(index, value);
    };
    this.setNClob = function(index, value) {
        this.native.setNClob(index, value);
    };
    this.setNString = function(index, value) {
        this.native.setNString(index, value);
    };
}

function CallableStatement() {

	this.getResultSet = function() {
		const resultset = new ResultSet();
		resultset.native = this.native.getResultSet();
		return resultset;
	};

	this.executeQuery = function() {
		const resultset = new ResultSet();
		resultset.native = this.native.executeQuery();
		return resultset;
	};

	this.executeUpdate = function() {
		return this.native.executeUpdate();
	};

	this.registerOutParameter = function(parameterIndex, sqlType) {
		this.native.registerOutParameter(parameterIndex, sqlType);
	};

	this.registerOutParameterByScale = function(parameterIndex, sqlType, scale) {
		this.native.registerOutParameter(parameterIndex, sqlType, scale);
	};

	this.registerOutParameterByTypeName = function(parameterIndex, sqlType, typeName) {
		this.native.registerOutParameter(parameterIndex, sqlType, typeName);
	};

	this.wasNull = function() {
		return this.native.wasNull();
	};

	this.getString = function(parameter) {
		return this.native.getString(parameter);
	};

	this.getBoolean = function(parameter) {
		return this.native.getBoolean(parameter);
	};

	this.getByte = function(parameter) {
		return this.native.getByte(parameter);
	};

	this.getShort = function(parameter) {
		return this.native.getShort(parameter);
	};

	this.getInt = function(parameter) {
		return this.native.getInt(parameter);
	};

	this.getLong = function(parameter) {
		return this.native.getLong(parameter);
	};

	this.getFloat = function(parameter) {
		return this.native.getFloat(parameter);
	};

	this.getDouble = function(parameter) {
		return this.native.getDouble(parameter);
	};

	this.getBytes = function(parameter) {
		return this.native.getBytes(parameter);
	};

	this.getDate = function(parameter) {
		return this.native.getDate(parameter);
	};

	this.getTime = function(parameter) {
		return this.native.getTime(parameter);
	};

	this.getTimestamp = function(parameter) {
		return this.native.getTimestamp(parameter);
	};

	this.getObject = function(parameter) {
		return this.native.getObject(parameter);
	};

	this.getBigDecimal = function(parameter) {
		return this.native.getBigDecimal(parameter);
	};

	this.getRef = function(parameter) {
		return this.native.getRef(parameter);
	};

	this.getBlob = function(parameter) {
		return this.native.getBlob(parameter);
	};

	this.getClob = function(parameter) {
		return this.native.getClob(parameter);
	};

	this.getNClob = function(parameter) {
		return this.native.getNClob(parameter);
	};

	this.getNString = function(parameter) {
		return this.native.getNString(parameter);
	};

	this.getArray = function(parameter) {
		return this.native.getArray(parameter);
	};

	this.getURL = function(parameter) {
		return this.native.getURL(parameter);
	};

	this.getRowId = function(parameter) {
		return this.native.getRowId(parameter);
	};

	this.getSQLXML = function(parameter) {
		return this.native.getSQLXML(parameter);
	};

	this.setURL = function(parameter, value) {
		this.native.setURL(parameter, value);
	};

	this.setNull = function(parameter, sqlTypeStr, typeName) {
		const sqlType = PreparedStatement.SQLTypes[sqlTypeStr];
		if (typeName !== undefined && typeName !== null) {
			this.native.setNull(parameter, sqlType, typeName);
		} else {
			this.native.setNull(parameter, sqlType);
		}
	};

	this.setBoolean = function(parameter, value) {
		this.native.setBoolean(parameter, value);
	};

	this.setByte = function(parameter, value) {
		this.native.setByte(parameter, value);
	};

	this.setShort = function(parameter, value) {
		this.native.setShort(parameter, value);
	};

	this.setInt = function(parameter, value) {
		this.native.setInt(parameter, value);
	};

	this.setLong = function(parameter, value) {
		this.native.setLong(parameter, value);
	};

	this.setFloat = function(parameter, value) {
		this.native.setFloat(parameter, value);
	};

	this.setDouble = function(parameter, value) {
		this.native.setDouble(parameter, value);
	};

	this.setBigDecimal = function(parameter, value) {
		this.native.setBigDecimal(parameter, value);
	};

	this.setString = function(parameter, value) {
		this.native.setString(parameter, value);
	};

	this.setBytes = function(parameter, value) {
		this.native.setBytes(parameter, value);
	};

	this.setDate = function(parameter, value) {
		this.native.setDate(parameter, value);
	};

	this.setTime = function(parameter, value) {
		this.native.setTime(parameter, value);
	};

	this.setTimestamp = function(parameter, value) {
		this.native.setTimestamp(parameter, value);
	};

	this.setAsciiStream = function(parameter, inputStream, length) {
		if (length !== undefined && length !== null) {
			this.native.setAsciiStream(parameter, inputStream, length);
		} else {
			this.native.setAsciiStream(parameter, inputStream);
		}
	};

	this.setBinaryStream = function(parameter, inputStream, length) {
		if (length !== undefined && length !== null) {
			this.native.setBinaryStream(parameter, inputStream, length);
		} else {
			this.native.setBinaryStream(parameter, inputStream);
		}
	};

	this.setObject = function(parameter, value, targetSqlType, scale) {
		if (scale !== undefined && scale !== null && targetSqlType !== undefined && targetSqlType !== null) {
			this.native.setObject(parameter, value, targetSqlType, scale);
		} else if (targetSqlType !== undefined && targetSqlType !== null) {
			this.native.setObject(parameter, value, targetSqlType);
		} else {
			this.native.setObject(parameter, value);
		}
	};

	this.setRowId = function(parameter, value) {
		this.native.setRowId(parameter, value);
	};

	this.setNString = function(parameter, value) {
		this.native.setNString(parameter, value);
	};

	this.setSQLXML = function(parameter, value) {
		this.native.setSQLXML(parameter, value);
	};

	this.setBlob = function(parameter, value) {
		this.native.setBlob(parameter, value);
	};

	this.setClob = function(parameter, value) {
		this.native.setClob(parameter, value);
	};

	this.execute = function() {
		return this.native.execute();
	};

	this.getMoreResults = function() {
		return this.native.getMoreResults();
    };

    this.getParameterMetaData = function() {
        return this.native.getParameterMetaData();
    };

    this.isClosed = function() {
        return this.native.isClosed();
    };

    this.setNClob = function(parameter, value) {
    	this.native.setNClob(parameter, value);
    };

	this.close = function() {
		this.native.close();
	};
}

/**
 * ResultSet object
 */
function ResultSet(internalResultset) {

	this.toJson = function(limited) {
		if (limited === undefined || limited === false) {
			limited = false;
		}
		return org.eclipse.dirigible.databases.helpers.DatabaseResultSetHelper.toJson(this.native, limited);
	};

	this.close = function() {
		this.native.close();
	};

	this.getBlob = function(identifier) {
		return this.native.getBlob(identifier);
	};

	this.getBigDecimal = function(identifier) {
		return this.native.getBigDecimal(identifier);
	};

	this.getBoolean = function(identifier) {
		return this.native.getBoolean(identifier);
	};

	this.getByte = function(identifier) {
		return this.native.getByte(identifier);
	};

	this.getBytesNative = function(identifier) {
		return this.native.getBytes(identifier);
	};

	this.getBytes = function(identifier) {
		var data = this.native.getBytes(identifier);
		return bytes.toJavaScriptBytes(data);
	};

	this.getClob = function(identifier) {
		return this.native.getClob(identifier);
	};

	this.getDate = function(identifier) {
		const dateInstance = this.native.getDate(identifier);
		return new Date(dateInstance.getTime());
	};

	this.getDouble = function(identifier) {
		return this.native.getDouble(identifier);
	};

	this.getFloat = function(identifier) {
		return this.native.getFloat(identifier);
	};

	this.getInt = function(identifier) {
		return this.native.getInt(identifier);
	};

	this.getLong = function(identifier) {
		return this.native.getLong(identifier);
	};

	this.getShort = function(identifier) {
		return this.native.getShort(identifier);
	};

	this.getString = function(identifier) {
		return this.native.getString(identifier);
	};

	this.getTime = function(identifier) {
		const dateInstance = this.native.getTime(identifier);
		return new Date(dateInstance.getTime());
	};

	this.getTimestamp = function(identifier) {
		const dateInstance = this.native.getTimestamp(identifier);
		const date = new Date(dateInstance.getTime());
		return date;
	};

	this.isAfterLast = function() {
		return this.native.isAfterLast();
	};

	this.isBeforeFirst = function() {
		return this.native.isBeforeFirst();
	};

	this.isClosed = function() {
		return this.native.isClosed();
	};

	this.isFirst = function() {
		return this.native.isFirst();
	};

	this.isLast = function() {
		return this.native.isLast();
	};

	this.next = function() {
		return this.native.next();
	};

	this.getMetaData = function() {
	    return this.native.getMetaData();
	}

	this.getNClob = function(columnIndex){
	    return this.native.getNClob(columnIndex);
	}

	this.getNString = function(columnIndex){
    	return this.native.getNString(columnIndex);
    }
}