Examples of ResultList


Examples of org.apache.pivot.sql.ResultList

        String connectionURL = args[0];

        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        ResultList resultList = null;

        try {
            connection = DriverManager.getConnection(connectionURL);
            statement = connection.createStatement();

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet);
            resultList.setFields(new ResultList.Field("i"),
                new ResultList.Field("f"),
                new ResultList.Field("s"),
                new ResultList.Field("b"));
            out.println(JSONSerializer.toString(resultList));

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet);
            resultList.setFields(new ResultList.Field("i", "integer"),
                new ResultList.Field("f", "float"),
                new ResultList.Field("s", "string"),
                new ResultList.Field("b", "boolean"));
            out.println(JSONSerializer.toString(resultList));

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet);
            resultList.setFields(new ResultList.Field("i", "integer", Integer.class),
                new ResultList.Field("f", "float", Float.class),
                new ResultList.Field("s", "string", String.class),
                new ResultList.Field("b", "boolean", Boolean.class));
            out.println(JSONSerializer.toString(resultList));

            // Test forward and backward iteration
            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet);
            resultList.setFields(new ResultList.Field("i"),
                new ResultList.Field("f"),
                new ResultList.Field("s"),
                new ResultList.Field("b"));

            Iterator<Map<String, Object>> iterator = resultList.iterator();
            while (iterator.hasNext()) {
                out.println(JSONSerializer.toString(iterator.next()));
            }
        } finally {
            if (resultSet != null) {
View Full Code Here

Examples of org.apache.pivot.sql.ResultList

        try {
            connection = DriverManager.getConnection(connectionURL);
            Statement statement = connection.createStatement();
            ResultSet resultSet;
            ResultList resultList;

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet);
            resultList.setFields(new ResultList.Field("i"),
                new ResultList.Field("f"),
                new ResultList.Field("s"),
                new ResultList.Field("b"));
            out.println(JSONSerializer.toString(resultList));

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet);
            resultList.setFields(new ResultList.Field("i", "integer"),
                new ResultList.Field("f", "float"),
                new ResultList.Field("s", "string"),
                new ResultList.Field("b", "boolean"));
            out.println(JSONSerializer.toString(resultList));

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet);
            resultList.setFields(new ResultList.Field("i", "integer", Integer.class),
                new ResultList.Field("f", "float", Float.class),
                new ResultList.Field("s", "string", String.class),
                new ResultList.Field("b", "boolean", Boolean.class));
            out.println(JSONSerializer.toString(resultList));

            // Test forward and backward iteration
            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet);
            resultList.setFields(new ResultList.Field("i"),
                new ResultList.Field("f"),
                new ResultList.Field("s"),
                new ResultList.Field("b"));

            Iterator<Map<String, Object>> iterator = resultList.iterator();
            while (iterator.hasNext()) {
                out.println(JSONSerializer.toString(iterator.next()));
            }
        } finally {
            if (connection != null) {
View Full Code Here

Examples of org.apache.pivot.sql.ResultList

        try {
            connection = DriverManager.getConnection(connectionURL);
            Statement statement = connection.createStatement();
            ResultSet resultSet;
            ResultList resultList;

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet,
                new ResultList.Field("i"),
                new ResultList.Field("f"),
                new ResultList.Field("s"),
                new ResultList.Field("b"));
            out.println(JSONSerializer.toString(resultList));

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet,
                new ResultList.Field("i", "integer"),
                new ResultList.Field("f", "float"),
                new ResultList.Field("s", "string"),
                new ResultList.Field("b", "boolean"));
            out.println(JSONSerializer.toString(resultList));

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet,
                new ResultList.Field("i", "integer", Integer.class),
                new ResultList.Field("f", "float", Float.class),
                new ResultList.Field("s", "string", String.class),
                new ResultList.Field("b", "boolean", Boolean.class));
            out.println(JSONSerializer.toString(resultList));

            // Test forward and backward iteration
            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet,
                new ResultList.Field("i"),
                new ResultList.Field("f"),
                new ResultList.Field("s"),
                new ResultList.Field("b"));

            Iterator<Map<String, Object>> iterator = resultList.iterator();
            while (iterator.hasNext()) {
                out.println(JSONSerializer.toString(iterator.next()));
            }
        } finally {
            if (connection != null) {
View Full Code Here

Examples of org.apache.pivot.sql.ResultList

        try {
            connection = DriverManager.getConnection(connectionURL);
            Statement statement = connection.createStatement();
            ResultSet resultSet;
            ResultList resultList;

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet,
                new ResultList.Field("i"),
                new ResultList.Field("f"),
                new ResultList.Field("s"),
                new ResultList.Field("b"));
            out.println(JSONSerializer.toString(resultList));

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet,
                new ResultList.Field("i", "integer"),
                new ResultList.Field("f", "float"),
                new ResultList.Field("s", "string"),
                new ResultList.Field("b", "boolean"));
            out.println(JSONSerializer.toString(resultList));

            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet,
                new ResultList.Field("i", "integer", Integer.class),
                new ResultList.Field("f", "float", Float.class),
                new ResultList.Field("s", "string", String.class),
                new ResultList.Field("b", "boolean", Boolean.class));
            out.println(JSONSerializer.toString(resultList));

            // Test forward and backward iteration
            resultSet = statement.executeQuery("SELECT * FROM result_list_test");
            resultList = new ResultList(resultSet,
                new ResultList.Field("i"),
                new ResultList.Field("f"),
                new ResultList.Field("s"),
                new ResultList.Field("b"));

            List.ItemIterator<Map<String, Object>> iterator = resultList.iterator();
            while (iterator.hasNext()) {
                out.println(JSONSerializer.toString(iterator.next()));
            }

            while(iterator.hasPrevious()) {
View Full Code Here

Examples of org.eclipse.ecf.presence.search.ResultList

   *
   * @see IUserSearchManager#search(ICriteria).
   */
  public ISearch search(ICriteria criteria) throws UserSearchException {

    ResultList resultList = new ResultList();
    try {
      // initialize the form by chance it is null
      if (form == null)
        form = manager.getSearchForm(ecfConnection.getXMPPConnection(),
            SERVICE_SEARCH
                + ecfConnection.getXMPPConnection()
                    .getServiceName());

      /*
       * For XMPP criterion is considered. The XMPP server will deal with
       * the search.
       */
      List criterions = criteria.getCriterions();
      // add the fields for the search dynamically
      // consider just the fields used on the search
      // fields checked by user

      String fields[] = getUserPropertiesFields();
      for (int i = 0; i < fields.length; i++) {
        Iterator criterionsIterator = criterions.iterator();
        // for each user properties field check if it
        // was added by user for the criteria
        // for each field, a search is performed, and
        // the partial result is added to the result list
        while (criterionsIterator.hasNext()) {
          ICriterion criterion = (ICriterion) criterionsIterator
              .next();
          if (criterion.equals(fields[i])) {
            Form answerForm = form.createAnswerForm();
            answerForm.setAnswer(fields[i], true);
            answerForm.setAnswer(SEARCH_ACTION, criterion
                .toExpression());
            ReportedData data = manager.sendSearchForm(
                ecfConnection.getXMPPConnection(), answerForm,
                SERVICE_SEARCH
                    + ecfConnection.getXMPPConnection()
                        .getServiceName());
            // create a result list from ReportedData
            IResultList partialResultList = createResultList(data);
            resultList.addAll(partialResultList.getResults());
          }
        }
      }

      return new XMPPSearch(resultList);
View Full Code Here

Examples of org.eclipse.ecf.presence.search.ResultList

   *            ReportedData
   * @return {@link IResultList} a list of users
   * @throws
   */
  protected IResultList createResultList(ReportedData data) {
    ResultList result = new ResultList();
    Iterator rows = data.getRows();
    while (rows.hasNext()) {
      Row row = (Row) rows.next();
      Iterator jids = row.getValues(JID);
      Iterator names = row.getValues(NAME);
      String jid = null;
      String name = null;
      // XMPP server returns the same length for both
      while (jids.hasNext() && names.hasNext()) {
        try {
          jid = (String) jids.next();
          name = (String) names.next();
          IUser user = new User(new XMPPID(connectNamespace, jid),
              name);
          result.add(new XMPPResultItem(user));
        } catch (URISyntaxException e) {
          throw new RuntimeException(
              "cannot create connect id for client " + jid //$NON-NLS-1$
                  + " , name = " + name, e); //$NON-NLS-1$
        }
View Full Code Here

Examples of org.fcrepo.server.types.gen.FieldSearchResult.ResultList

            FieldSearchResult result =
                    Administrator.APIA.findObjects(TypeUtility.convertStringtoAOS(fields),
                                                   new BigInteger("50"),
                                                   query);
            while (result != null) {
                ResultList resultList = result.getResultList();
                if (resultList != null && resultList.getObjectFields() != null) {
                    for (ObjectFields element : resultList.getObjectFields()) {
                        labelMap.put(element.getPid(), element.getLabel());
                    }
                }
                if (result.getListSession() != null) {
                    result =
View Full Code Here

Examples of org.fcrepo.server.types.gen.FieldSearchResult.ResultList

                    Administrator.APIA
                            .findObjects(TypeUtility.convertStringtoAOS(fields),
                                         new BigInteger("50"),
                                         query);
            while (result != null) {
                ResultList resultList = result.getResultList();
                if (resultList != null && resultList.getObjectFields() != null) {
                    for (ObjectFields element : resultList.getObjectFields()) {
                        labelMap.put(element.getPid(), element.getLabel());
                    }
                }
                if (result.getListSession() != null) {
                    result =
View Full Code Here

Examples of org.fcrepo.server.types.gen.FieldSearchResult.ResultList

        FieldSearchResult result =
                Administrator.APIA
                        .findObjects(TypeUtility.convertStringtoAOS(fields),
                                     new BigInteger("1"),
                                     query);
        ResultList resultList = result.getResultList();
        if (resultList == null || resultList.getObjectFields() == null
                && resultList.getObjectFields().size() == 0) {
            throw new IOException("Object not found in repository");
        }
        return resultList.getObjectFields().get(0);
    }
View Full Code Here

Examples of org.fcrepo.server.types.gen.FieldSearchResult.ResultList

        query.setConditions(factory.createFieldSearchQueryConditions(conds));
        FieldSearchResult result =
                apia.findObjects(TypeUtility.convertStringtoAOS(resultFields),
                                 maxResults,
                                 query);
        ResultList resultList = result.getResultList();
        List<ObjectFields> fields = resultList.getObjectFields();
        assertEquals(1, fields.size());
        assertEquals("demo:5", fields.get(0).getPid().getValue());
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.