Examples of loadResults()

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

429
430
431
432
433
434
435
436
437
438
439
            con = DbConnectionFactory.getConnection();
            con.setAutoCommit(false);
            mutex = new ClusterMutex(con);
            mutex.lockTable();
            dc.setSQL("SELECT max(id) as max FROM dist_process");
            ArrayList<Map<String, String>> ret = dc.loadResults(con);
            if (ret != null && ret.size() > 0
                    && UtilMethods.isSet(ret.get(0).get("max"))) {

                Long max = Long.parseLong(ret.get(0).get("max"));
View Full Code Here

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

479
480
481
482
483
484
485
486
487
488
489
    @Override
    protected long recordsLeftToIndexForServer(Connection conn) throws DotDataException {
        DotConnect dc = new DotConnect();
        dc.setSQL("select count(*) as count from dist_reindex_journal");
        List<Map<String, String>> results = results = dc.loadResults(conn);
        String c = results.get(0).get("count");
        return Long.parseLong(c);
    }

    @Override
View Full Code Here

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

71
72
73
74
75
76
77
78
79
80
81
            Logger.warn(this, ex.getMessage());
        }
    }
    addWorkFlowTaskIndexes();
    dc.setSQL(workflowtask_fileasset_relations);
    List<Map<String, String>> relations = dc.loadResults();
      for(Map<String,String> relation : relations){
        String fileInode = relation.get("child");
        String workflowTaskId = relation.get("parent"); 
        String uuid = UUIDGenerator.generateUuid();
      dc.setSQL("insert into workflowtask_files(id,workflowtask_id,file_inode) values(?,?,?)");
View Full Code Here

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

133
134
135
136
137
138
139
140
141
142
143
        } catch(Exception ex) {
            Logger.warn(this, ex.getMessage());
        }
    }
    dc.setSQL(workflowtask_workflowcomment_relations);
    List<Map<String, String>> relations = dc.loadResults();
      for(Map<String,String> relation : relations){
        String workflowCommentId = relation.get("child");
        String workflowTaskId = relation.get("parent"); 
        dc.setSQL("UPDATE workflow_comment set workflowtask_id = ? where id = ?");
      dc.addParam(workflowTaskId);
View Full Code Here

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

194
195
196
197
198
199
200
201
202
203
204
            Logger.warn(this, ex.getMessage());
        }
    }
   
    dc.setSQL(workflowtask_workflowhistory_relations);
    List<Map<String, String>> relations = dc.loadResults();
      for(Map<String,String> relation : relations){
        String workflowHistoryInode = relation.get("child");
        String workflowTaskInode = relation.get("parent"); 
        dc.setSQL("UPDATE workflow_history set workflowtask_id = ? where id = ?");
      dc.addParam(workflowTaskInode);
View Full Code Here

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

37
38
39
40
41
42
43
44
45
46
47
        //Verify if we already have a contentlet version for the SYSTEM_HOST contentlet
        dc = new DotConnect();
        dc.setSQL( "select identifier from contentlet_version_info where identifier = ?" );
        dc.addParam( Host.SYSTEM_HOST );
        ArrayList<Map<String, String>> versionsResults = dc.loadResults();

        //Ok, we didn't found a version for this SYSTEM_HOST contentlet, so we need to create one
        if ( versionsResults == null || versionsResults.isEmpty() ) {

            //Getting the SYSTEM_HOST contentlet
View Full Code Here

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

45
46
47
48
49
50
51
52
53
54
55
        if ( versionsResults == null || versionsResults.isEmpty() ) {

            //Getting the SYSTEM_HOST contentlet
            dc = new DotConnect();
            dc.setSQL( "select inode, language_id from contentlet where title = 'System Host'" );
            ArrayList<Map<String, String>> results = dc.loadResults();

            if ( results != null && results.size() > 0 ) {

                String inode = results.get( 0 ).get( "inode" );
                String languageId = results.get( 0 ).get( "language_id" );
View Full Code Here

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

54
55
56
57
58
59
60
61
62
63
64
           + "parent in(select inode from structure)";
    dc.executeStatement(addStructure);
    dc.executeStatement(addFK);
   
    dc.setSQL(containerQuery);
    List<Map<String, String>> treeResults = dc.loadResults();
    for(Map<String,String> tree : treeResults){
      String stInode = tree.get("parent");
      String containerInode = tree.get("child");
      dc.setSQL("UPDATE containers set structure_inode = ? where inode = ?");
      dc.addParam(stInode);
View Full Code Here

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

78
79
80
81
82
83
84
85
86
87
88
   
    dc.executeStatement(addtemplate);
    dc.executeStatement(addFK);
   
    dc.setSQL(htmlQuery);
    List<Map<String, String>> treeResults = dc.loadResults();
    for(Map<String,String> tree : treeResults){
      String templateId = tree.get("parent");
      String htmlpageInode = tree.get("child");
      dc.setSQL("UPDATE htmlpage set template_id = ? where inode = ?");
      dc.addParam(templateId);
View Full Code Here

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

535
536
537
538
539
540
541
542
543
544
545
    @Override
    protected List<IndexJournal> viewReindexJournalData() throws DotDataException {
        DotConnect dc = new DotConnect();
        dc.setSQL("select count(*) as mycount,serverid,priority from dist_reindex_journal group by serverid,priority order by serverid, priority");
        List<IndexJournal> journalList = new ArrayList<IndexJournal>();
        List<Map<String, String>> results = dc.loadResults();
        for (Map<String, String> r : results) {
            IndexJournal index = new IndexJournal(r.get("serverid"),new Integer(r.get("mycount")),new Long(r.get("priority")));
            journalList.add(index);
        }
        return journalList;
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.