예제 #1
0
  @Override
  public String getConnectionInfoMessage(String connectionToken)
      throws IllegalArgumentException, DatabaseConnectionException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Connection conn = connMgr.getConnection(connectionToken, clientIP, userAgent);

    String db = "";
    String user = "";
    try {
      db = conn.getCatalog();
      user = conn.getMetaData().getUserName();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

    String ret = db + " as " + user;
    return ret;
  }
예제 #2
0
  @Override
  public String createSequence(
      String connectionToken,
      int schema,
      String sequenceName,
      boolean temporary,
      int increment,
      int minValue,
      int maxValue,
      int start,
      int cache,
      boolean cycle)
      throws DatabaseConnectionException, PostgreSQLException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Sequences sequences =
        new Sequences(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return sequences.create(
          schema, sequenceName, temporary, increment, minValue, maxValue, start, cache, cycle);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #3
0
  @Override
  public String renameItem(String connectionToken, int item, ITEM_TYPE type, String newName)
      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.rename(item, type, q.addQuote(newName));
        case TABLE:
          Tables tables = new Tables(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return tables.rename(item, type, q.addQuote(newName));
        case VIEW:
        case MATERIALIZED_VIEW:
          Views views = new Views(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return views.rename(item, type, newName);
        default:
          return "";
      }
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #4
0
  @Override
  public String createForeignKeyConstraint(
      String connectionToken,
      int item,
      String constraintName,
      ArrayList<String> columnList,
      String referenceTable,
      ArrayList<String> referenceList)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Constraints constraints;

    constraints = new Constraints(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return constraints.createForeignKeyConstraint(
          item, constraintName, columnList, referenceTable, referenceList);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #5
0
  @Override
  public void doLogout(String connectionToken, String source) throws DatabaseConnectionException {
    /*The argument source keeps a track of the origin of the doLogout call.
     * 	doLogout strictly works with three strings , viz:
     * WINDOW_CLOSE : pass this when logging out due to a window/tab close action
     * USER_INITIATED : pass this when logging out from the Disconnect button
     * SESSION_TIMEOUT : pass this when logging out due to timeout.
     */
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");
    ConnectionManager connMgr = new ConnectionManager();

    connMgr.closeConnection(connectionToken, clientIP, userAgent);

    if (request.getSession(false) != null) {
      if (source.equals("WINDOW_CLOSE")) {
        request.getSession(false).invalidate();
      } else if (source.equals("USER_INITIATED") || source.equals("SESSION_TIMEOUT")) {
        request.getSession(false).setAttribute("dbToken", null);
        request.getSession(false).setAttribute("dbName", null);
        request.getSession(false).setAttribute("dbURL", null);
        request.getSession(false).setAttribute("username", null);
      }
    }
  }
예제 #6
0
  @Override
  public String createRule(
      String connectionToken,
      int item,
      ITEM_TYPE type,
      String ruleName,
      String event,
      String ruleType,
      String definition)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Rules rules;

    rules = new Rules(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return rules.createRule(item, type, ruleName, event, ruleType, definition);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #7
0
  @Override
  public String createFunction(
      String connectionToken,
      int schema,
      String functionName,
      String returns,
      String language,
      ArrayList<String> paramList,
      String definition)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Functions funcs;

    funcs = new Functions(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return funcs.create(schema, functionName, returns, language, paramList, definition);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #8
0
  @Override
  public String createTrigger(
      String connectionToken,
      int item,
      ITEM_TYPE type,
      String triggerName,
      String event,
      String triggerType,
      String forEach,
      String function)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Triggers triggers = new Triggers(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return triggers.createTrigger(item, type, triggerName, event, triggerType, forEach, function);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #9
0
  @Override
  public String getList(String connectionToken, DATABASE_OBJECT_TYPE type)
      throws IllegalArgumentException, DatabaseConnectionException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Database db;

    switch (type) {
      case DATA_TYPE:
        db = new Database(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return db.getDataTypes();
      case FOREIGN_SERVER:
        db = new Database(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return db.getForeignServerList();
      case SCHEMA:
        Schemas schemas = new Schemas(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return schemas.getList();
      case LANGUAGE:
        db = new Database(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return db.getLanguageList();
      case ROLE:
        db = new Database(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return db.getRoleList();
      default:
        return "";
    }
  }
예제 #10
0
  @Override
  public String createTable(
      String connectionToken,
      int schema,
      String tableName,
      boolean unlogged,
      boolean temporary,
      String fill,
      ArrayList<String> col_list,
      HashMap<Integer, String> commentLog,
      ArrayList<String> col_index)
      throws DatabaseConnectionException, PostgreSQLException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Tables tables = new Tables(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return tables.create(
          schema,
          q.addQuote(tableName),
          unlogged,
          temporary,
          fill,
          col_list,
          commentLog,
          col_index);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #11
0
  @Override
  public String createColumn(
      String connectionToken,
      int item,
      String columnName,
      String datatype,
      String comment,
      boolean not_null,
      String defaultval)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Columns columns;

    columns = new Columns(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return columns.create(item, q.addQuote(columnName), datatype, comment, not_null, defaultval);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #12
0
  @Override
  public String getItemObjectList(
      String connectionToken, int item, ITEM_TYPE type, ITEM_OBJECT_TYPE object)
      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 (object) {
        case TRIGGER:
          Triggers triggers =
              new Triggers(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return triggers.getList(item);
        case COLUMN:
          Columns columns =
              new Columns(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return columns.getList(item);
        case CONSTRAINT:
          Constraints constraints =
              new Constraints(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return constraints.getList(item);
        case GRANT:
          Privileges priv =
              new Privileges(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return priv.getPrivileges(item, type);
        case INDEX:
          Indexes indexes =
              new Indexes(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return indexes.getList(item);
        case RULE:
          Rules rules = new Rules(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return rules.getList(item);
        case SOURCE:
          SourceCode sc =
              new SourceCode(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return sc.getSourceCode(item, type);
        case STATS:
          Stats stats = new Stats(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return stats.getList(item);
        default:
          return "";
      }
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #13
0
  /**
   * ********************************************************************************************
   */
  @Override
  public String refreshMaterializedView(String connectionToken, String schema, String viewName)
      throws DatabaseConnectionException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Views views = new Views(connMgr.getConnection(connectionToken, clientIP, userAgent));

    return views.refreshMaterializedView(schema, q.addQuote(viewName));
  }
예제 #14
0
  @Override
  public String getExplainResult(String connectionToken, String query)
      throws IllegalArgumentException, DatabaseConnectionException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    ItemData id;

    id = new ItemData(connMgr.getConnection(connectionToken, clientIP, userAgent));

    return id.getExplainResult(query);
  }
예제 #15
0
  @Override
  public String createSchema(String connectionToken, String schemaName)
      throws DatabaseConnectionException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Schemas schemas;

    schemas = new Schemas(connMgr.getConnection(connectionToken, clientIP, userAgent));

    return schemas.createSchema(schemaName);
  }
예제 #16
0
  @Override
  public String executeQuery(String connectionToken, String query, String queryType)
      throws IllegalArgumentException, DatabaseConnectionException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    QueryExecutor id;

    id = new QueryExecutor(connMgr.getConnection(connectionToken, clientIP, userAgent));

    return id.Execute(query, queryType);
  }
예제 #17
0
  @Override
  public String truncate(String connectionToken, int item, ITEM_TYPE type)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Tables tables = new Tables(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return tables.truncate(item, type);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #18
0
  @Override
  public String renameItemObject(
      String connectionToken,
      int item,
      ITEM_TYPE type,
      String objectName,
      ITEM_OBJECT_TYPE objType,
      String newObjectName)
      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.rename(item, q.addQuote(objectName), q.addQuote(newObjectName));
        case CONSTRAINT:
          Constraints constraints =
              new Constraints(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return constraints.rename(item, q.addQuote(objectName), q.addQuote(newObjectName));
        case INDEX:
          Indexes indexes =
              new Indexes(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return indexes.rename(item, q.addQuote(objectName), q.addQuote(newObjectName));
        case RULE:
          // A RULE can not be renamed so just return a blank string if if get
          // here for some reason
          return "";
        case TRIGGER:
          Triggers triggers =
              new Triggers(connMgr.getConnection(connectionToken, clientIP, userAgent));
          return triggers.rename(item, q.addQuote(objectName), q.addQuote(newObjectName));

        default:
          return "";
      }
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #19
0
  @Override
  public String getTriggerFunctionList(String connectionToken, int schema)
      throws IllegalArgumentException, DatabaseConnectionException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Functions funcs;

    funcs = new Functions(connMgr.getConnection(connectionToken, clientIP, userAgent));

    String funcList = funcs.getTriggerFunctionList(schema);

    return funcList;
  }
예제 #20
0
  @Override
  public String getItemMetaData(String connectionToken, int item, ITEM_TYPE type)
      throws IllegalArgumentException, DatabaseConnectionException, PostgreSQLException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    ItemMetaData id = new ItemMetaData(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return id.getMetaData(item, type);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #21
0
  @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());
    }
  }
예제 #22
0
  @Override
  public String createCheckConstraint(
      String connectionToken, int item, String constraintName, String definition)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Constraints constraints;

    constraints = new Constraints(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return constraints.createCheckConstraint(item, constraintName, definition);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #23
0
  @Override
  public String grant(
      String connectionToken,
      int item,
      ITEM_TYPE type,
      ArrayList<String> privileges,
      String grantee)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Privileges priv = new Privileges(connMgr.getConnection(connectionToken, clientIP, userAgent));
    try {
      return priv.grant(item, type, privileges, grantee);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }
예제 #24
0
  @Override
  public String createType(
      String connectionToken,
      String schema,
      String typeName,
      TYPE_FORM form,
      String baseType,
      String definition,
      ArrayList<String> attributeList)
      throws DatabaseConnectionException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Types types;

    types = new Types(connMgr.getConnection(connectionToken, clientIP, userAgent));

    return types.createType(
        connectionToken, schema, typeName, form, baseType, definition, attributeList);
  }
예제 #25
0
  @Override
  public String getList(String connectionToken, int schema, ITEM_TYPE type)
      throws IllegalArgumentException, DatabaseConnectionException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    switch (type) {
      case TABLE:
        Tables tables = new Tables(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return tables.getList(schema);
      case MATERIALIZED_VIEW:
      case VIEW:
        Views views = new Views(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return views.getList(schema);
      case FOREIGN_TABLE:
        ForeignTables fTables =
            new ForeignTables(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return fTables.getList(schema);
      case FUNCTION:
        Functions funcs =
            new Functions(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return funcs.getList(schema);
      case SEQUENCE:
        Sequences seqs = new Sequences(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return seqs.getList(schema);
      case TYPE:
        Types types = new Types(connMgr.getConnection(connectionToken, clientIP, userAgent));
        return types.getList(schema);
      default:
        return "";
    }
  }
예제 #26
0
  @Override
  public String createForeignTable(
      String connectionToken,
      String schema,
      String tableName,
      String server,
      ArrayList<String> columns,
      HashMap<Integer, String> comments,
      ArrayList<String> options)
      throws IllegalArgumentException, DatabaseConnectionException {

    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    ForeignTables tables;

    tables = new ForeignTables(connMgr.getConnection(connectionToken, clientIP, userAgent));

    return tables.createForeignTable(
        connectionToken, schema, tableName, server, columns, comments, options);
  }
예제 #27
0
  @Override
  public String createIndex(
      String connectionToken,
      int item,
      String indexName,
      INDEX_TYPE indexType,
      boolean isUnique,
      boolean isConcurrently,
      ArrayList<String> columnList)
      throws DatabaseConnectionException, PostgreSQLException {
    ConnectionManager connMgr = new ConnectionManager();
    HttpServletRequest request = this.getThreadLocalRequest();

    String clientIP = ConnectionInfo.remoteAddr(request);
    String userAgent = request.getHeader("User-Agent");

    Indexes indexes = new Indexes(connMgr.getConnection(connectionToken, clientIP, userAgent));

    try {
      return indexes.create(item, indexName, indexType, isUnique, isConcurrently, columnList);
    } catch (SQLException e) {
      throw new PostgreSQLException(e.getMessage());
    }
  }