org.eclipse.dirigible.database.sql.ISqlFactory Maven / Gradle / Ivy

Go to download
/**
 * Copyright (c) 2010-2018 SAP and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *   SAP - initial API and implementation
 */
package org.eclipse.dirigible.database.sql;

import java.sql.Connection;
import java.sql.SQLException;

import org.eclipse.dirigible.database.sql.builders.CreateBranchingBuilder;
import org.eclipse.dirigible.database.sql.builders.DropBranchingBuilder;
import org.eclipse.dirigible.database.sql.builders.ExpressionBuilder;
import org.eclipse.dirigible.database.sql.builders.records.DeleteBuilder;
import org.eclipse.dirigible.database.sql.builders.records.InsertBuilder;
import org.eclipse.dirigible.database.sql.builders.records.SelectBuilder;
import org.eclipse.dirigible.database.sql.builders.records.UpdateBuilder;
import org.eclipse.dirigible.database.sql.builders.sequence.LastValueIdentityBuilder;
import org.eclipse.dirigible.database.sql.builders.sequence.NextValueSequenceBuilder;

/**
 * A factory for creating ISql objects.
 *
 * @param  {

	/**
	 * Select.
	 *
	 * @return the select
	 */
	public SELECT select();

	/**
	 * Insert.
	 *
	 * @return the insert
	 */
	public INSERT insert();

	/**
	 * Update.
	 *
	 * @return the update
	 */
	public UPDATE update();

	/**
	 * Delete.
	 *
	 * @return the delete
	 */
	public DELETE delete();

	/**
	 * Expression.
	 *
	 * @return the expression builder
	 */
	public ExpressionBuilder expression();

	/**
	 * Creates the.
	 *
	 * @return the creates the
	 */
	public CREATE create();

	/**
	 * Drop.
	 *
	 * @return the drop
	 */
	public DROP drop();

	/**
	 * Exists.
	 *
	 * @param connection
	 *            the connection
	 * @param table
	 *            the table
	 * @return true, if successful
	 * @throws SQLException
	 *             the SQL exception
	 */
	public boolean exists(Connection connection, String table) throws SQLException;

	/**
	 * Count.
	 *
	 * @param connection
	 *            the connection
	 * @param table
	 *            the table
	 * @return the int
	 * @throws SQLException
	 *             the SQL exception
	 */
	public int count(Connection connection, String table) throws SQLException;

	/**
	 * Nextval.
	 *
	 * @param sequence
	 *            the sequence
	 * @return the next
	 */
	public NEXT nextval(String sequence);

	/**
	 * Lastval.
	 * 
	 * @param args
	 *            the arguments
	 * @return the last
	 */
	public LAST lastval(String... args);

}