getl.jdbc.ViewDataset.groovy Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of getl Show documentation

GETL - based package in Groovy, which automates the work of loading and transforming data

There is a newer version: 4.18.9

package getl.jdbc

import com.fasterxml.jackson.annotation.JsonIgnore
import groovy.transform.InheritConstructors

/**
 * View dataset class
 * @author Alexsey Konstantinov
 *
 */
@InheritConstructors
class ViewDataset extends TableDataset {
	@Override
	protected void registerParameters() {
		super.registerParameters()
		methodParams.register('createView', ['select', 'replace', 'ifNotExists'])
	}

	@Override
	protected void initParams() {
		super.initParams()

		sysParams.isView = true
		type = viewType
	}

	/** Use specified connection */
	JDBCConnection useConnection(JDBCConnection value) {
		setConnection(value)
		return value
	}

	/**
	 * Validation exists view
	 * @return
	 */
	@Override
	@JsonIgnore
	Boolean isExists() {
		def ds = currentJDBCConnection.retrieveDatasets(dbName: dbName(), schemaName: schemaName(),
					tableName: tableName, type: ["VIEW"], retrieveInfo: false)
		
		return (!ds.isEmpty())
	}

	/**
	 * Create view in database
	 * @param params creation options
	 */
	void createView(Map procParams) {
		validConnection()

		methodParams.validation('createView', procParams,
				[connection.driver.methodParams.params('createView')])

		currentJDBCConnection.currentJDBCDriver.createView(this, procParams)
	}
}