Examples of Query


Examples of com.dotcms.repackage.net.sf.hibernate.Query

      query.append(
        "FROM PortletPreferences IN CLASS com.liferay.portal.ejb.PortletPreferencesHBM WHERE ");
      query.append("layoutId = ?");
      query.append(" ");

      Query q = session.createQuery(query.toString());
      int queryPos = 0;
      q.setString(queryPos++, layoutId);

      Iterator itr = q.list().iterator();
      List list = new ArrayList();

      while (itr.hasNext()) {
        PortletPreferencesHBM portletPreferencesHBM = (PortletPreferencesHBM)itr.next();
        list.add(PortletPreferencesHBMUtil.model(portletPreferencesHBM));
View Full Code Here

Examples of com.dotcms.repackage.org.apache.lucene.search.Query

      if (text.indexOf(StringPool.SPACE) == -1) {
        text = KeywordsUtil.toWildcard(text);
      }

      QueryParser parser = new QueryParser(Version.LUCENE_CURRENT, field, new SimpleAnalyzer(Version.LUCENE_CURRENT));
      Query query = parser.parse(text);

      booleanQuery.add(query, BooleanClause.Occur.SHOULD);
    }
  }
View Full Code Here

Examples of com.dotmarketing.business.query.GenericQueryFactory.Query

    }
    sql.append(" FROM host ");
    sql.append("WHERE identifier='" + id + "'");
    //sql.append("working=" + DbConnectionFactory.getDBTrue().replaceAll("'", ""));
    SQLQueryFactory sqlQueryFactory = new SQLQueryFactory(sql.toString());
    Query query = sqlQueryFactory.getQuery();

    List<Map<String, Serializable>> list = APILocator.getContentletAPI().DBSearch(query, user, respectFrontendRoles);
    if (1 < list.size())
      Logger.error(this, "More of one working version of host match the same identifier " + id + "!!");
    else if (list.size() == 0)
View Full Code Here

Examples of com.eclipsesource.tabris.passepartout.Query

  public void testNotifiesMultipleValidListenerActivated() {
    QueryNotifier notifier = new QueryNotifier();
    QueryListener listener = mock( QueryListener.class );
    QueryListener listener2 = mock( QueryListener.class );
    QueryImpl query = new QueryImpl( new AlwaysTrueContidtion() );
    Query query2 = new QueryImpl( new AlwaysTrueContidtion() ).and( new MaxWidthCondition( px( 99 ) ) );
    notifier.addQueryListener( query, listener );
    notifier.addQueryListener( query2, listener2 );

    notifier.notifyListeners( createEnvironment( new Bounds( 0, 0, 90, 0 ) ) );
View Full Code Here

Examples of com.enioka.jqm.api.Query

    @SuppressWarnings("unused")
    @Override
    public List<JobInstance> load(int first, int pageSize, List<SortMeta> multiSortMeta, Map<String, String> filters)
    {
        // Pagination is very important here - we are querying a table that could count millions of rows
        Query q = Query.create().setFirstRow(first).setPageSize(pageSize);

        // Add filters
        for (String key : filters.keySet())
        {
            if ("queue.name".equals(key))
            {
                q.setQueueName(filters.get(key));
            }
            else if ("h.id".equals(key))
            {
                q.setJobInstanceId(Integer.parseInt(filters.get(key)));
            }
            else if ("jd.applicationName".equals(key))
            {
                q.setApplicationName(filters.get(key));
            }
            else if ("h.user".equals(key))
            {
                q.setUser(filters.get(key));
            }
            else if ("h.parent".equals(key))
            {
                q.setParentId(Integer.parseInt(filters.get(key)));
            }
            else if ("jd.keyword1".equals(key))
            {
                q.setJobDefKeyword1(filters.get(key));
            }
            else if ("jd.keyword2".equals(key))
            {
                q.setJobDefKeyword2(filters.get(key));
            }
            else if ("jd.keyword3".equals(key))
            {
                q.setJobDefKeyword3(filters.get(key));
            }
            else if ("jd.application".equals(key))
            {
                q.setJobDefApplication(filters.get(key));
            }
            else if ("jd.module".equals(key))
            {
                q.setJobDefModule(filters.get(key));
            }
        }
        if (this.fromFilter != null)
        {
            Calendar tCalendar = Calendar.getInstance();
            tCalendar.setTime(fromFilter);
            q.setBeganRunningAfter(tCalendar);
        }
        if (this.untilFilter != null)
        {
            Calendar tCalendar = Calendar.getInstance();
            tCalendar.setTime(untilFilter);
            q.setBeganRunningBefore(tCalendar);
        }

        // Add sorts
        if (multiSortMeta == null && sortCache != null)
        {
            multiSortMeta = sortCache;
        }
        if (multiSortMeta != null)
        {
            sortCache = multiSortMeta;
            for (SortMeta sm : multiSortMeta)
            {
                if ("queue.name".equals(sm.getSortField()))
                {
                    Object p = sm.getSortOrder().equals(SortOrder.ASCENDING) ? q.addSortAsc(Sort.QUEUENAME) : q.addSortDesc(Sort.QUEUENAME);
                }
                else if ("h.id".equals(sm.getSortField()))
                {
                    Object p = sm.getSortOrder().equals(SortOrder.ASCENDING) ? q.addSortAsc(Sort.ID) : q.addSortDesc(Sort.ID);
                }
                else if ("jd.applicationName".equals(sm.getSortField()))
                {
                    Object p = sm.getSortOrder().equals(SortOrder.ASCENDING) ? q.addSortAsc(Sort.APPLICATIONNAME) : q
                            .addSortDesc(Sort.APPLICATIONNAME);
                }
                else if ("h.user".equals(sm.getSortField()))
                {
                    Object p = sm.getSortOrder().equals(SortOrder.ASCENDING) ? q.addSortAsc(Sort.USERNAME) : q.addSortDesc(Sort.USERNAME);
                }
                else if ("h.parent".equals(sm.getSortField()))
                {
                    Object p = sm.getSortOrder().equals(SortOrder.ASCENDING) ? q.addSortAsc(Sort.PARENTID) : q.addSortDesc(Sort.PARENTID);
                }

                else if ("h.enqueue".equals(sm.getSortField()))
                {
                    Object p = sm.getSortOrder().equals(SortOrder.ASCENDING) ? q.addSortAsc(Sort.DATEENQUEUE) : q
                            .addSortDesc(Sort.DATEENQUEUE);
                }
                else if ("h.begin".equals(sm.getSortField()))
                {
                    Object p = sm.getSortOrder().equals(SortOrder.ASCENDING) ? q.addSortAsc(Sort.DATEEXECUTION) : q
                            .addSortDesc(Sort.DATEENQUEUE);
                }
                else if ("h.end".equals(sm.getSortField()))
                {
                    Object p = sm.getSortOrder().equals(SortOrder.ASCENDING) ? q.addSortAsc(Sort.DATEEND) : q.addSortDesc(Sort.DATEEND);
                }
            }
        }

        // Run the query
        q.run();
        this.setRowCount(q.getResultSize());
        jiCache = q.getResults();
        return q.getResults();
    }
View Full Code Here

Examples of com.esri.gpt.framework.resource.query.Query

    this.publishMetadata(this.systemId, readXml());
  }

  @Override
  public Query createQuery(IterationContext context, Criteria criteria) {
    Query query = new Query() {
      @Override
      public Result execute() {
        return new CommonResult(new NativeImpl());
      }
    };
View Full Code Here

Examples of com.facebook.presto.sql.tree.Query

        if (likePattern != null) {
            Expression likePredicate = new LikePredicate(nameReference("table_name"), new StringLiteral(likePattern), null);
            predicate = logicalAnd(predicate, likePredicate);
        }

        Query query = new Query(
                Optional.<With>absent(),
                new QuerySpecification(
                        selectList(aliasedName("table_name", "Table")),
                        table(QualifiedName.of(catalogName, TABLE_TABLES.getSchemaName(), TABLE_TABLES.getTableName())),
                        Optional.of(predicate),
View Full Code Here

Examples of com.flaptor.indextank.query.Query

        this.npi = suggestor.getPopularityIndex();
        this.dictAutomaton = NewPopularityIndex.PopularityIndexAutomaton.adapt(this.npi);
    }

    public List<Pair<Query, String>> suggest(Query query) {
        Query newQuery = query.duplicate();
       
        String newOriginal = traverseNode(newQuery.getRoot(), newQuery.getOriginalStr());
       
        if (newQuery.equals(query)) {
            return Lists.newArrayList();
        }

        return Lists.newArrayList(new Pair<Query, String>(newQuery, newOriginal));
    }
View Full Code Here

Examples of com.gemstone.gemfire.cache.query.Query

  @Override
  @SuppressWarnings("unchecked")
  public <E> SelectResults<E> find(final String queryString, final Object... params) throws InvalidDataAccessApiUsageException {
    try {
      QueryService queryService = lookupQueryService(getRegion());
      Query query = queryService.newQuery(queryString);
      Object result = query.execute(params);

      if (result instanceof SelectResults) {
        return (SelectResults<E>) result;
      }
      else {
View Full Code Here

Examples of com.github.jmkgreen.morphia.query.Query

        final String cacheKey = getCacheKey(params);


        if (cacheReadEnable) {

            final Query q = ds.find(Cache.class);
            q.filter("cacheKey", cacheKey).filter("servletName", this.getClass().getName());

            final Cache c = (Cache) q.get();

            if (c == null) {
                log.info("cacheKey:" + cacheKey + " on servletName: " + this.getClass().getName() + " not found");
            }

            if (c != null) {
                final GridFSDBFile imageForOutput = MongoConnectionHelper.getGridFS().findOne(new ObjectId(c.getGridId()));
                if (imageForOutput != null) {
                    ds.save(c);

                    try {
                        response.setHeader("Content-Length", "" + imageForOutput.getLength());
                        response.setHeader("Content-Disposition", "inline; filename=\"" + imageForOutput.getFilename() + "\"");
                        final OutputStream out = response.getOutputStream();
                        final InputStream in = imageForOutput.getInputStream();
                        final byte[] content = new byte[(int) imageForOutput.getLength()];
                        in.read(content);
                        out.write(content);
                        in.close();
                        out.close();
                        return;
                    } catch (Exception e) {
                        log.error(e);
                    }

                } else {
                    log.error("file not in db");
                }
            }
        }


        final String formatIn = getFormatIn(period);
        final String formatOut = getFormatOut(period);

        final Query q = ds.createQuery(MapReduceMinMax.class).disableValidation();

        final Date dFrom = DateTimeUtil.getDate("yyyy-MM-dd hh:mm:ss", from);
        final Date dTo = DateTimeUtil.getDate("yyyy-MM-dd hh:mm:ss", to);


        final List<Date> datesIn = getRangeDate(dFrom, dTo);
        final HashSet<String> datesInString = new HashSet<String>();

        for (Date d : datesIn) {
            datesInString.add(DateTimeUtil.dateFormat(formatIn, d));
        }

        if (datesIn != null && !datesIn.isEmpty()) {
            q.filter("_id in", datesInString);
        }
        q.order("_id");

        final List<MapReduceMinMax> mapReduceResult = q.asList();
        final TimeSeries serieMin = new TimeSeries("Min");
        final TimeSeries serieMax = new TimeSeries("Max");

        for (MapReduceMinMax m : mapReduceResult) {
            try {
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.