Example #1
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());
    }
  }