com.antiaction.raptor.sql.mssql.MSSql Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of raptor-dbl Show documentation
Raptor database layer implementation.
The newest version!
/*
 * Created on 31/03/2010
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

package com.antiaction.raptor.sql.mssql;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import com.antiaction.raptor.dao.AttributeBase;
import com.antiaction.raptor.dao.AttributeTypeBase;
import com.antiaction.raptor.dao.EntityBase;
import com.antiaction.raptor.dao.EntityTypeBase;
import com.antiaction.raptor.dao.SecurityChain;
import com.antiaction.raptor.dao.SecurityEntityBase;
import com.antiaction.raptor.dao.SecurityGrantOnType;
import com.antiaction.raptor.dao.SecurityPermission;
import com.antiaction.raptor.dao.SecurityPermissionType;
import com.antiaction.raptor.dao.SecurityRule;
import com.antiaction.raptor.dao.TreeItem;
import com.antiaction.raptor.dao.ViewBase;
import com.antiaction.raptor.dao.ViewTypeBase;
import com.antiaction.raptor.i18n.I18N;
import com.antiaction.raptor.i18n.Language;
import com.antiaction.raptor.sql.DBWrapper;
import com.antiaction.raptor.sql.SqlResult;

public class MSSql extends DBWrapper {

	private static MSSql mssql = null;

	private DataSource dataSource = null;

	public ClassLoader classLoader = null;

	protected MSSql() {
	}

	public static MSSql getInstance(DataSource dataSource, ClassLoader classLoader) {
		mssql = new MSSql();
		mssql.dataSource = dataSource;
		mssql.classLoader = classLoader;
		return mssql;
	}

	@Override
	public Connection getConnection() throws SQLException {
		Connection conn = dataSource.getConnection();
		return conn;
	}

	/*
	 * Languages.
	 */

	@Override
	public List getLanguages(Connection conn) {
		return MSSql_Language.getLanguages( conn );
	}

	/*
	 * I18N.
	 */

	@Override
	public I18N getI18N(Connection conn, int translation_id) {
		return MSSql_I18N.getI18N( conn, translation_id );
	}

	/*
	 * Views.
	 */

	@Override
	public List getViews(Connection conn, ClassLoader classLoader) {
		return MSSql_View.getViews( conn, classLoader );
	}

	/*
	 * Tree.
	 */

	@Override
	public void tree_insert(Connection conn, int tree_id, int parent_id, int id) {
		MSSql_Tree.insert( conn, tree_id, parent_id, id );
	}

	@Override
	public int tree_delete(Connection conn, int tree_id, int id) {
		return MSSql_Tree.delete( conn, tree_id, id );
	}

	@Override
	public void tree_move(Connection conn, int tree_id, int id, int to_parent_id) {
		MSSql_Tree.move( conn, tree_id, id, to_parent_id );
	}

	@Override
	public List getParentTreePathList(Connection conn, int tree_id, int id) {
		return MSSql_Tree.getParentTreePathList( conn, tree_id, id );
	}

	@Override
	public List getParentPathIds(Connection conn, int tree_id, int id) {
		return MSSql_Tree.getParentPathIdList( conn, tree_id, id );
	}

	@Override
	public List getSubtreeComplete(Connection conn, int tree_id, int id) {
		return MSSql_Tree.getSubtreeComplete( conn, tree_id, id );
	}

	@Override
	public List getSubtree(Connection conn, int tree_id, int id) {
		return MSSql_Tree.getSubtree( conn, tree_id, id );
	}

	@Override
	public int getSubtreeCount(Connection conn, int tree_id, int id) {
		return MSSql_Tree.getSubtreeCount( conn, tree_id, id );
	}

	/*
	 * View types.
	 */

	@Override
	public List getViewTypes(Connection conn) {
		return MSSql_ViewType.getViewTypes( conn, classLoader );
	}

	@Override
	public void viewtype_update(Connection conn, ViewTypeBase viewType) {
		MSSql_ViewType.update( conn, viewType );
	}

	@Override
	public void viewtype_deleteByObj(Connection conn, ViewTypeBase viewType) {
		MSSql_ViewType.deleteByObj( conn, viewType );
	}

	@Override
	public void viewtype_deleteById(Connection conn, int id) {
		MSSql_ViewType.deleteById( conn, id );
	}

	/*
	 * Entity types.
	 */

	@Override
	public EntityTypeBase entitytype_insert(Connection conn, ClassLoader classLoader, int tree_id, int id, String name, String class_namespace, String class_name) {
		return MSSql_EntityType.insert( conn, classLoader, tree_id, id, name, class_namespace, class_name );
	}

	@Override
	public List getEntityTypes(Connection conn, ClassLoader classLoader, int tree_id) {
		return MSSql_EntityType.getEntityTypes( conn, classLoader, tree_id );
	}

	@Override
	public void entitytype_update(Connection conn, EntityTypeBase entityType) {
		MSSql_EntityType.update( conn, entityType );
	}

	@Override
	public void entitytype_deleteByObj(Connection conn, EntityTypeBase entityType) {
		MSSql_EntityType.deleteByObj( conn, entityType );
	}

	@Override
	public void entitytype_deleteById(Connection conn, int tree_id, int id) {
		MSSql_EntityType.deleteById( conn, tree_id, id );
	}

	/*
	 * Attribute types.
	 */

	@Override
	public void attributetype_insert(Connection conn, AttributeTypeBase attributeType) {
		MSSql_AttributeTypes.insert( conn, attributeType );
	}

	@Override
	public List getAttributeTypes(Connection conn, ClassLoader classLoader, int tree_id) {
		return MSSql_AttributeTypes.getAttributeTypes( conn, classLoader, tree_id );
	}

	@Override
	public void attributetype_update(Connection conn, AttributeTypeBase attributeType) {
		MSSql_AttributeTypes.update( conn, attributeType );
	}

	@Override
	public void attributetype_deleteByObj(Connection conn, AttributeTypeBase attributeType) {
		MSSql_AttributeTypes.deleteByObj( conn, attributeType );
	}

	@Override
	public void attributetype_deleteById(Connection conn, int tree_id, int id) {
		MSSql_AttributeTypes.deleteById( conn, tree_id, id );
	}

	/*
	 * Entity.
	 */

	@Override
	public SqlResult entity_insert(Connection conn, int tree_id, int type_id) {
		return MSSql_Entity.insert( conn, tree_id, type_id );
	}

	@Override
	public SqlResult entity_getById(Connection conn, int tree_id, int id) {
		return MSSql_Entity.getById( conn, tree_id, id );
	}

	@Override
	public void entity_update(Connection conn, EntityBase entity) {
		MSSql_Entity.update( conn, entity );
	}

	@Override
	public void entity_deleteByObj(Connection conn, EntityBase entity) {
		MSSql_Entity.deleteByObj( conn, entity );
	}

	@Override
	public void entity_deleteById(Connection conn, int tree_id, int id) {
		MSSql_Entity.deleteById( conn, tree_id, id );
	}

	@Override
	public void entities_deleteSubtreeByObj(Connection conn, EntityBase entity) {
		MSSql_Entity.deleteSubtreeByObj( conn, entity );
	}

	@Override
	public void entities_deleteSubtreeById(Connection conn, int tree_id, int id) {
		MSSql_Entity.deleteSubtreeById( conn, tree_id, id );
	}

	@Override
	public List entity_children(Connection conn, int tree_id, int parent_id) {
		return MSSql_Entity.children( conn, tree_id, parent_id );
	}

	/*
	 * Attribute.
	 */

	@Override
	public void attribute_insert(Connection conn, AttributeBase attribute) {
		MSSql_Attribute.insert( conn, attribute );
	}

	@Override
	public SqlResult attributes_getAttributes(Connection conn, int tree_id, int entity_id) {
		return MSSql_Attribute.getAttributes( conn, tree_id, entity_id );
	}

	@Override
	public SqlResult attributes_getTypedAttributes(Connection conn, int tree_id, int entity_id) {
		return MSSql_Attribute.getTypedAttributes( conn, tree_id, entity_id );
	}

	@Override
	public void attribute_update(Connection conn, AttributeBase attribute) {
		MSSql_Attribute.update( conn, attribute );
	}

	@Override
	public void attribute_deleteByObj(Connection conn, AttributeBase attribute) {
		MSSql_Attribute.deleteByObj( conn, attribute );
	}

	@Override
	public void attribute_deleteById(Connection conn, int tree_id, int attribute_id, int entity_id) {
		MSSql_Attribute.deleteById( conn, tree_id, attribute_id, entity_id );
	}

	@Override
	public void attributes_deleteByEntityObj(Connection conn, EntityBase entity) {
		MSSql_Attribute.deleteByEntityObj( conn, entity );
	}

	@Override
	public void attributes_deleteByEntityId(Connection conn, int tree_id, int entity_id) {
		MSSql_Attribute.deleteByEntityId( conn, tree_id, entity_id );
	}

	@Override
	public void attributes_deleteSubtreeByObj(Connection conn, EntityBase entity) {
		MSSql_Attribute.deleteSubtreeByObj( conn, entity );
	}

	@Override
	public void attributes_deleteSubtreeByEntityId(Connection conn, int tree_id, int entity_id) {
		MSSql_Attribute.deleteSubtreeByEntityId( conn, tree_id, entity_id );
	}

	/*
	 * Security entity.
	 */

	@Override
	public SqlResult securityentity_insert(Connection conn, int tree_id, int type_id) {
		return MSSql_SecurityEntity.insert( conn, tree_id, type_id );
	}

	@Override
	public SqlResult securityentity_getById(Connection conn, int tree_id, int id) {
		return MSSql_SecurityEntity.getById( conn, tree_id, id );
	}

	@Override
	public SqlResult securityentity_getByLoginCredentials(Connection conn, int tree_id, String login) {
		// , String password
		// , password
		return MSSql_SecurityEntity.getByLoginCredentials( conn, tree_id, login );
	}

	@Override
	public void securityentity_update(Connection conn, SecurityEntityBase securityEntity) {
		MSSql_SecurityEntity.update( conn, securityEntity );
	}

	@Override
	public void securityentity_deleteByObj(Connection conn, SecurityEntityBase securityEntity) {
		MSSql_SecurityEntity.deleteByObj( conn, securityEntity );
	}

	@Override
	public void securityentity_deleteById(Connection conn, int tree_id, int id) {
		MSSql_SecurityEntity.deleteById( conn, tree_id, id );
	}

	@Override
	public void securityentities_deleteSubtreeByObj(Connection conn, SecurityEntityBase securityEntity) {
		MSSql_SecurityEntity.deleteSubtreeByObj( conn, securityEntity );
	}

	@Override
	public void securityentities_deleteSubtreeById(Connection conn, int tree_id, int id) {
		MSSql_SecurityEntity.deleteSubtreeById( conn, tree_id, id );
	}

	@Override
	public List securityentity_children(Connection conn, int tree_id, int parent_id) {
		return MSSql_SecurityEntity.children( conn, tree_id, parent_id );
	}

	/*
	 * Security tree permission types.
	 */

	@Override
	public List getPermissionTypes(Connection conn) {
		return MSSql_SecurityTreePermissionType.getPermissionTypes( conn );
	}

	/*
	 * Security tree grant types.
	 */

	@Override
	public List getGrantOnTypes(Connection conn) {
		return MSSql_SecurityTreeGrantType.getGrantOnTypes( conn );
	}

	/*
	 * Security tree permission.
	 */

	@Override
	public int tree_permission_insert(Connection conn, SecurityPermission permission) {
		return MSSql_SecurityTreePermission.insert( conn, permission );
	}

	@Override
	public SecurityPermission tree_permission_getById(Connection conn, int id) {
		return MSSql_SecurityTreePermission.getById( conn, id );
	}

	@Override
	public void tree_permission_update(Connection conn, SecurityPermission permission) {
		MSSql_SecurityTreePermission.update( conn, permission );
	}

	@Override
	public void tree_permission_deleteByObj(Connection conn, SecurityPermission permission) {
		MSSql_SecurityTreePermission.deleteByObj( conn, permission );
	}

	@Override
	public void tree_permission_deleteById(Connection conn, int id) {
		MSSql_SecurityTreePermission.deleteById( conn, id );
	}

	/*
	 * Security tree chain.
	 */

	@Override
	public int tree_chain_insert(Connection conn, SecurityChain chain) {
		return MSSql_SecurityTreeChain.insert( conn, chain );
	}

	@Override
	public SecurityChain tree_chain_getById(Connection conn, int id) {
		return MSSql_SecurityTreeChain.getById( conn, id );
	}

	@Override
	public void tree_chain_update(Connection conn, SecurityChain chain) {
		MSSql_SecurityTreeChain.update( conn, chain );
	}

	@Override
	public void tree_chain_deleteByObj(Connection conn, SecurityChain chain) {
		MSSql_SecurityTreeChain.deleteByObj( conn, chain );
	}

	@Override
	public void tree_chain_deleteById(Connection conn, int id) {
		MSSql_SecurityTreeChain.deleteById( conn, id );
	}

	@Override
	public void tree_chain_deleteByPermissionObj(Connection conn, SecurityPermission permission) {
		MSSql_SecurityTreeChain.deleteByPermissionObj( conn, permission );
	}

	@Override
	public void tree_chain_deleteByPermissionId(Connection conn, int permission_id) {
		MSSql_SecurityTreeChain.deleteByPermissionId( conn, permission_id );
	}

	/*
	 * Security tree rule.
	 */

	@Override
	public int tree_rule_insert(Connection conn, SecurityRule grant) {
		return MSSql_SecurityTreeRule.insert( conn, grant );
	}

	@Override
	public SecurityRule tree_rule_getById(Connection conn, int id) {
		return MSSql_SecurityTreeRule.getById( conn, id );
	}

	@Override
	public void tree_rule_update(Connection conn, SecurityRule grant) {
		MSSql_SecurityTreeRule.update( conn, grant );
	}

	@Override
	public void tree_rule_deleteByObj(Connection conn, SecurityRule grant) {
		MSSql_SecurityTreeRule.deleteByObj( conn, grant );
	}

	@Override
	public void tree_rule_deleteById(Connection conn, int id) {
		MSSql_SecurityTreeRule.deleteById( conn, id );
	}

	@Override
	public void tree_rule_deleteByChainObj(Connection conn, SecurityChain chain) {
		MSSql_SecurityTreeRule.deleteByChainObj( conn, chain );
	}

	@Override
	public void tree_rule_deleteByChainId(Connection conn, int chain_id) {
		MSSql_SecurityTreeRule.deleteByChainId( conn, chain_id );
	}

	@Override
	public void tree_rule_deleteByPermissionObj(Connection conn, SecurityPermission permission) {
		MSSql_SecurityTreeRule.deleteByPermissionObj( conn, permission );
	}

	@Override
	public void tree_rule_deleteByPermissionId(Connection conn, int permission_id) {
		MSSql_SecurityTreeRule.deleteByPermissionId( conn, permission_id );
	}

	@Override
	public Map getPermissionsByUserObj(Connection conn, SecurityEntityBase securityEntity) {
		return MSSql_SecurityTreeRule.getPermissionsByUserObj( conn, securityEntity );
	}

	@Override
	public Map getPermissionsByUserId(Connection conn, int tree_id, int user_id) {
		return MSSql_SecurityTreeRule.getPermissionsByUserId( conn, tree_id, user_id );
	}

}