tbrugz.sqldiff.model.GrantDiff Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of sqldump Show documentation
Utility to dump schema and data from a RDBMS
There is a newer version: 0.9.17
package tbrugz.sqldiff.model;

import tbrugz.sqldump.dbmodel.DBObject;
import tbrugz.sqldump.dbmodel.DBObjectType;
import tbrugz.sqldump.dbmodel.Grant;
import tbrugz.sqldump.dbmodel.NamedDBObject;
import tbrugz.sqldump.dbmodel.PrivilegeType;

public class GrantDiff extends SingleDiff implements Diff, Comparable {

	// grant properties
	final String schemaName;
	final String tableName;
	final PrivilegeType privilege;
	final String grantee;
	final boolean withGrantOption;

	// grant "diff" properties
	final ChangeType changeType;
	//final transient Grant grant;
	final transient ColumnDiff.NamedTable namedTable;
	
	public GrantDiff(String schemaName, String tableName, PrivilegeType privilege, String grantee, boolean withGrantOption, boolean revoke) {
		this.schemaName = schemaName;
		this.tableName = tableName;
		this.privilege = privilege;
		this.grantee = grantee;
		this.withGrantOption = withGrantOption;
		//this.grant = grant;
		this.changeType = revoke?ChangeType.DROP:ChangeType.ADD;
		this.namedTable = new ColumnDiff.NamedTable(schemaName, tableName);
	}
	
	//TODO: add column
	public GrantDiff(Grant grant, String schemaName, boolean isRevoke) {
		this(schemaName, grant.getTable(), grant.getPrivilege(), grant.getGrantee(), grant.isWithGrantOption(), isRevoke);
	}

	@Override
	public ChangeType getChangeType() {
		return changeType;
	}

	@Override
	public String getDiff() {
		return 
			(changeType.equals(ChangeType.DROP)?"revoke ":"grant ")
			+privilege
			+" on "
			+DBObject.getFinalName(namedTable, true)
			+(changeType.equals(ChangeType.DROP)?" from ":" to ")
			+grantee;
			//+";\n\n";
	}

	/*@Override
	public List getDiffList() {
		return DiffUtil.singleElemList( getDiff() );
	}*/

	@Override
	public DBObjectType getObjectType() {
		return DBObjectType.GRANT;
	}

	@Override
	public NamedDBObject getNamedObject() {
		return namedTable;
	}

	@Override
	public Diff inverse() {
		return new GrantDiff(schemaName, tableName, privilege, grantee, withGrantOption, changeType.equals(ChangeType.ADD)?true:false);
	}
	
	@Override
	public int compareTo(GrantDiff o) {
		//int compare = grant.compareTo(o.grant);
		//if(compare!=0) return compare;
		
		int compare = tableName.compareTo(o.tableName);
		if(compare!=0) return compare;
		
		compare = privilege.compareTo(o.privilege);
		if(compare!=0) return compare;
		
		compare = grantee.compareTo(o.grantee);
		if(compare!=0) return compare;
		
		compare = withGrantOption==o.withGrantOption?0:1;
		if(compare!=0) return compare;
		
		return changeType.compareTo(o.changeType);
	}
	
	@Override
	public String getDefinition() {
		return changeType.equals(ChangeType.ADD)?getDiff():"";
	}
	
	@Override
	public String getPreviousDefinition() {
		return changeType.equals(ChangeType.DROP)?inverse().getDiff():"";
	}

}