Examples of Query

Examples of com.javaeye.jert.domain.query.Query

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
    public void generateItems(QueryParameter[] parameters) {
        Connection connection = null;
        PreparedStatement statement = null;
        ResultSet rs = null;
        Query query = reportDefinition.getQuery();

        try {
            connection = reportDefinition.getDatabase().getConnection();
            statement = connection.prepareStatement(query.getSql(parameters), ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            if (parameters != null) {
                int index = 0;
                for (int i = 0; i < parameters.length; i++) {
                    if (parameters[i].isNeedToSet()) {
                        index++;
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.Query

493
494
495
496
497
498
499
500
501
502
503
          query.append(WallEntryModelImpl.ORDER_BY_JPQL);
        }

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
View Full Code Here

Examples of com.mobixess.jodb.soda.api.Query

1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
        sessionContainer.commit();
        if(reopen){
            sessionContainer.close();
            sessionContainer = getContainerForFile(testFile);
        }
        Query query = sessionContainer.query();
       
        query.descend("_val1").constrain(objectWithEnum._val1);
        List list = query.execute();
       
        if(list.size()!=1){
            throw new RuntimeException(""+list.size());
        }
       
        Object_Enum objectWithEnumFromDb = (Object_Enum) list.get(0);
       
        if(!objectWithEnumFromDb._val1.equals(objectWithEnum._val1)){
            throw new RuntimeException();
        }
       
        Object_Enum objectWithEnum1 = new Object_Enum();
        objectWithEnum1._val1 = TEST_ENUM.ENUM_VAL2;
       
        sessionContainer.set(objectWithEnum1);
        sessionContainer.commit();
       
        if(reopen){
            sessionContainer.close();
            sessionContainer = getContainerForFile(testFile);
        }
       
        query = sessionContainer.query();
       
        query.descend("_val1").constrain(objectWithEnum._val1).not();
       
        list = query.execute();
       
        if(list.size()!=1){
            throw new RuntimeException();
        }
       
        objectWithEnumFromDb = (Object_Enum) list.get(0);
       
        if(!objectWithEnumFromDb._val1.equals(objectWithEnum1._val1)){
            throw new RuntimeException();
        }
       
        if(reopen){
            sessionContainer.close();
            sessionContainer = getContainerForFile(testFile);
        }
       
        query = sessionContainer.query();
       
        query.constrain(objectWithEnum._val1);
       
        list = query.execute();
       
        if(list.size()!=1){
            throw new RuntimeException();
        }
       
        Enum enumFromDb = (Enum) list.get(0);
       
        if(!enumFromDb.equals(objectWithEnum._val1)){
            throw new RuntimeException();
        }
       
        query = sessionContainer.query();
       
        query.constrain(objectWithEnum._val1).not();
       
        list = query.execute();
       
        if(list.size()!=1){
            throw new RuntimeException();
        }
       
        enumFromDb = (Enum) list.get(0);
       
        if(!enumFromDb.equals(objectWithEnum1._val1)){
            throw new RuntimeException();
        }
       
        query = sessionContainer.query();
       
        query.constrain(objectWithEnum._val1).greater();
       
        list = query.execute();
       
        if(list.size()!=1){
            throw new RuntimeException();
        }
       
        enumFromDb = (Enum) list.get(0);
       
        if(!enumFromDb.equals(objectWithEnum1._val1)){
            throw new RuntimeException();
        }
       
        query = sessionContainer.query();
       
        query.constrain(objectWithEnum._val1).greater().or(query.constrain(objectWithEnum._val1));
       
        list = query.execute();
       
        if(list.size()!=2){
            throw new RuntimeException(""+list.size());
        }
        sessionContainer.close();
View Full Code Here

Examples of com.mozilla.grouperfish.model.Query

40
41
42
43
44
45
46
47
48
49
50
    /** Run all transforms configurations of this namespace over the results of all queries. */
    public void schedule(final Scope ns) {
        final Map<String, String> queries = ns.queries();
        final Map<String, String> transforms = ns.map(Type.CONFIGURATION_TRANSFORM);
        for (final Map.Entry<String, String> queryEntry : queries.entrySet()) {
            final Query query = new Query(queryEntry.getKey(), queryEntry.getValue());
            for (final Map.Entry<String, String> item : transforms.entrySet()) {
                schedule(ns, query, new TransformConfig(item.getKey(), item.getValue()));
            }
        }
    }
View Full Code Here

Examples of com.mysql.clusterj.Query

77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
        // compare the column with the parameter
        Predicate compare = column.equal(param);
        // set the where clause into the query
        dobj.where(compare);
        // create a query instance
        Query query = session.createQuery(dobj);

        // set the parameter value
        query.setParameter("eid", (long)8);
        // get the results
        List<Dn2id> results = query.getResultList();
        // consistency check the results
        consistencyCheck(results);
        Set<Long> expected = new HashSet<Long>();
        expected.add((long)8);
        Set<Long> actual = new HashSet<Long>();
View Full Code Here

Examples of com.netfever.dbmanager.object.Query

140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
    }
  }

  public RunnableQuery getQueryStatement(String queryName,
      String statementName) throws QueryBuilderException {
    Query query;
    Statement statement;

    if (queryName == null)
      throw new QueryBuilderException(
          "queryName parameter cannot be null.");

    if (statementName == null)
      throw new QueryBuilderException(
          "queryName parameter cannot be null.");

    query = this.manager.getQueries().get(queryName);
    if (query == null)
      throw new QueryBuilderException("Query '" + queryName
          + "' not found.");

    statement = query.getStatements().get(statementName);
    if (statement == null)
      throw new QueryBuilderException("Statement '" + statementName
          + "' not found.");

    return getQueryStatement(query, statement);
View Full Code Here

Examples of com.onpositive.commons.ui.tableeditor.Query

664
665
666
667
668
669
670
671
672
673
674
          eqFilters.add(a);
        } else {
          otherFilters.add(a);
        }
      }
      Query simpleQuery = new Query(
          eqFilters.toArray(new Filter[eqFilters.size()]), new Sort(
              "", true), limit, 0);
      ArrayList<IComplexQueryRequest> s = new ArrayList<IComplexQueryRequest>();
      SimpleRequest simpleRequest = new SimpleRequest(kind, simpleQuery,
          limit);
View Full Code Here

Examples of com.ponysdk.core.query.Query

71
72
73
74
75
76
77
78
79
80
81
                final String msg = "Selected item : " + event.getSelectedItem().getReplacementString();
                UIContext.getRootEventBus().fireEvent(new DemoBusinessEvent(msg));
            }
        });

        final Query query = new Query();
        final FindPonysCommand command = new FindPonysCommand(query);
        final Result<List<Pony>> ponys = command.execute();

        final List<String> datas = new ArrayList<String>();
        for (final Pony pony : ponys.getData()) {
View Full Code Here

Examples of com.projity.algorithm.Query

82
83
84
85
86
87
88
89
90
  }
  /* (non-Javadoc)
   * @see org.apache.commons.collections.Closure#execute(java.lang.Object)
   */
  public void execute(Object arg0) {
    Query query = (Query)arg0;
    AbstractContourBucket fromBucket = (AbstractContourBucket) query.currentGroupByObject();
    costContour[index++] = PersonalContourBucket.getInstance(fromBucket.getBucketDuration(assignmentDuration),cost.getValue());
  }
View Full Code Here

Examples of com.proverby.api.Query

59
60
61
62
63
64
65
66
67
68
  }

  public void testFilterProverbs()
  {
    api.attachProverbListener(detailListener);
    Query query = Query.createSearchProverbQuery()
        .addParameter(CriteriaParameter.create("leader"));
    query.addParameter(SortParameter.create(SortOrder.NAME_DESCENDING));
    api.listProverbs(query);
  }
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.