Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect.loadObjectResults()

65
66
67
68
69
70
71
72
73
74
75
        } catch ( final Exception e ) {
            Logger.error( this.getClass(), e.getMessage(), e );
        }

        return (List<LogMapperRow>) this.convertListToObjects( db.loadObjectResults(), LogMapperRow.class );
    }

    public void updateLogMapper ( LogMapperRow r ) throws DotDataException {
       
        final DotConnect db = new DotConnect();
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
    @Test
    public void findContentlets() throws Exception {
        DotConnect dc=new DotConnect();
        dc.setSQL("select inode from contentlet");
        List<String> inodes=new ArrayList<String>();
        for(Map<String,Object> r : dc.loadObjectResults()) {
            inodes.add((String)r.get("inode"));
        }
       
        List<Contentlet> contentlets = instance.findContentlets(inodes);
       
View Full Code Here
819
820
821
822
823
824
825
826
827
828
829
            return new ArrayList<Contentlet>();

        DotConnect dc = new DotConnect();
        dc.setSQL("SELECT inode FROM contentlet WHERE identifier=? order by mod_date desc");
        dc.addObject(identifier.getId());
        List<Map<String,Object>> list=dc.loadObjectResults();
        ArrayList<String> inodes=new ArrayList<String>(list.size());
        for(Map<String,Object> r : list)
            inodes.add(r.get("inode").toString());
        return findContentlets(inodes);
  }
View Full Code Here
247
248
249
250
251
252
253
254
255
256
257
        DotConnect dc = new DotConnect();
        dc.setSQL("select inode,category_name,category_key,sort_order,active,keywords,category_velocity_var_name "+
                  " from category join tree on (category.inode = tree.child) where tree.parent = ? "+
                  " order by sort_order, category_name");
        dc.addParam(parent.getCategoryId());
        children = readCatFromDotConnect(dc.loadObjectResults());
     
      try {
        catCache.putChildren(parent, children);
      } catch (DotCacheException e) {
        throw new DotDataException(e.getMessage(), e);
View Full Code Here
387
388
389
390
391
392
393
394
395
396
397
        dc.addParam(startDate);
        dc.addParam(endDate);
        dc.addParam(host.getIdentifier());
        dc.addParam(likepattern);
        try {
            for (Map<String,Object> row : dc.loadObjectResults())
                ret.add((String)row.get("pident"));
        } catch (DotDataException e) {
            Logger.error(HTMLPageFactoryImpl.class,e.getMessage(),e);
        }
       
View Full Code Here
410
411
412
413
414
415
416
417
418
419
420
        dc.addParam(startDate);
        dc.addParam(endDate);
        dc.addParam(host.getIdentifier());
        dc.addParam(likepattern);
        try {
            for (Map<String,Object> row : dc.loadObjectResults())
                ret.add((String)row.get("pident"));
        } catch (DotDataException e) {
            Logger.error(HTMLPageFactoryImpl.class,e.getMessage(),e);
        }
       
View Full Code Here
433
434
435
436
437
438
439
440
441
442
443
        dc.addParam(endDate);
        dc.addParam(host.getIdentifier());
        dc.addParam(likepattern);
       
        try {
            for (Map<String,Object> row : dc.loadObjectResults())
                ret.add((String)row.get("pident"));
        } catch (DotDataException e) {
            Logger.error(HTMLPageFactoryImpl.class,e.getMessage(),e);
        }
       
View Full Code Here
454
455
456
457
458
459
460
461
462
463
464
        dc.addParam(endDate);
        dc.addParam(host.getIdentifier());
        dc.addParam(likepattern);
       
        try {
            for (Map<String,Object> row : dc.loadObjectResults())
                ret.add((String)row.get("pident"));
        } catch (DotDataException e) {
            Logger.error(HTMLPageFactoryImpl.class,e.getMessage(),e);
        }
       
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    @Override
    public List<SiteSearchAudit> findRecentAudits(String jobId, int offset, int limit) throws DotDataException {
        DotConnect dc=new DotConnect();
        dc.setSQL(auditSQL.findrecent);
        auditSQL.setRecentParams(dc, jobId, limit, offset);
        List<Map<String,Object>> results = dc.loadObjectResults();
        List<SiteSearchAudit> recents=new ArrayList<SiteSearchAudit>();
        for (Map<String, Object> map : results) {
            SiteSearchAudit audit=new SiteSearchAudit();
            audit.setAllHosts(DbConnectionFactory.isDBTrue(map.get("all_hosts").toString()));
            audit.setIncremental(DbConnectionFactory.isDBTrue(map.get("incremental").toString()));
View Full Code Here
551
552
553
554
555
556
557
558
559
560
561
      //At first try to search in Table Identifier.
      dotConnect.setSQL("SELECT asset_type FROM identifier WHERE id = ?");
      dotConnect.addParam(identifier);

      Connection connection = DbConnectionFactory.getConnection();
      results = dotConnect.loadObjectResults(connection);

      if(!results.isEmpty()){
        assetType = results.get(0).get("asset_type").toString();
      }
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.