@Override
public String dropItemObject(
String connectionToken, int item, ITEM_TYPE type, String objectName, ITEM_OBJECT_TYPE objType)
throws DatabaseConnectionException, PostgreSQLException {
ConnectionManager connMgr = new ConnectionManager();
HttpServletRequest request = this.getThreadLocalRequest();
String clientIP = ConnectionInfo.remoteAddr(request);
String userAgent = request.getHeader("User-Agent");
try {
switch (objType) {
case COLUMN:
Columns columns =
new Columns(connMgr.getConnection(connectionToken, clientIP, userAgent));
return columns.drop(item, q.addQuote(objectName));
case CONSTRAINT:
Constraints constraints =
new Constraints(connMgr.getConnection(connectionToken, clientIP, userAgent));
return constraints.drop(item, q.addQuote(objectName));
case INDEX:
Indexes indexes =
new Indexes(connMgr.getConnection(connectionToken, clientIP, userAgent));
return indexes.drop(item, q.addQuote(objectName));
case RULE:
Rules rules = new Rules(connMgr.getConnection(connectionToken, clientIP, userAgent));
return rules.drop(item, q.addQuote(objectName));
case TRIGGER:
Triggers triggers =
new Triggers(connMgr.getConnection(connectionToken, clientIP, userAgent));
return triggers.drop(item, q.addQuote(objectName));
default:
return "";
}
} catch (SQLException e) {
throw new PostgreSQLException(e.getMessage());
}
}
