@Override public String dropItem(String connectionToken, int item, ITEM_TYPE type, boolean cascade) throws IllegalArgumentException, DatabaseConnectionException, PostgreSQLException { ConnectionManager connMgr = new ConnectionManager(); HttpServletRequest request = this.getThreadLocalRequest(); String clientIP = ConnectionInfo.remoteAddr(request); String userAgent = request.getHeader("User-Agent"); try { switch (type) { case FOREIGN_TABLE: ForeignTables fTables = new ForeignTables(connMgr.getConnection(connectionToken, clientIP, userAgent)); return fTables.drop(item, cascade); case TABLE: Tables tables = new Tables(connMgr.getConnection(connectionToken, clientIP, userAgent)); return tables.drop(item, cascade); case VIEW: case MATERIALIZED_VIEW: boolean isMaterialized = false; if (type == ITEM_TYPE.MATERIALIZED_VIEW) isMaterialized = true; Views views = new Views(connMgr.getConnection(connectionToken, clientIP, userAgent)); return views.dropView(item, cascade, isMaterialized); case FUNCTION: Functions functions = new Functions(connMgr.getConnection(connectionToken, clientIP, userAgent)); return functions.dropFunction(item, cascade); case SEQUENCE: Sequences sequences = new Sequences(connMgr.getConnection(connectionToken, clientIP, userAgent)); return sequences.drop(item, cascade); case TYPE: Types types = new Types(connMgr.getConnection(connectionToken, clientIP, userAgent)); return types.dropType(item, cascade); default: return ""; } } catch (SQLException e) { throw new PostgreSQLException(e.getMessage()); } }