Package com.dotmarketing.common.db

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

79
80
81
82
83
84
85
86
87
88
89
      HibernateUtil.startTransaction();
      int total = 0;
      try {
         DotConnect dc = new DotConnect();
           dc.setSQL(identifiersToDelete);
           List<Map<String, String>> identifiersToDeleteResult = dc.loadResults();
       
           total = total + identifiersToDeleteResult.size();
         FixAssetsProcessStatus.setTotal(total);
   
           if ((identifiersToDeleteResult != null) && (0 < identifiersToDeleteResult.size())) {
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
          assetDeleted = false;
          dc.setSQL(inodesToDelete);
          dc.addParam(identifierToDelete.get("id"));
          dc.addParam(identifierToDelete.get("id"));
          dc.addParam(identifierToDelete.get("id"));
          inodesToDeleteResult = dc.loadResults();
         
          if ((inodesToDeleteResult != null) && (0 < inodesToDeleteResult.size())) {
            modifiedData.addAll(inodesToDeleteResult);
           
            if (inodesToDeleteResult.get(0).get("type").equals("htmlpage")) {
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
            if (inodesToDeleteResult.get(0).get("type").equals("htmlpage")) {
              Logger.debug(this, "Deleting orphan HTMLPage with Identifier='" + identifierToDelete.get("id") + "'");
             
              dc.setSQL(htmlPagesToDelete);
              dc.addParam(identifierToDelete.get("id"));
              assetsToDeleteResult = dc.loadResults();
             
              if ((assetsToDeleteResult != null) && (0 < assetsToDeleteResult.size())) {
                modifiedData.addAll(assetsToDeleteResult);
               
                dc.setSQL(deleteHTMLPages);
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
            } else if (inodesToDeleteResult.get(0).get("type").equals("links")) {
              Logger.debug(this, "Deleting orphan Link with Identifier='" + identifierToDelete.get("id") + "'");
             
              dc.setSQL(linksToDelete);
              dc.addParam(identifierToDelete.get("id"));
              assetsToDeleteResult = dc.loadResults();
             
              if ((assetsToDeleteResult != null) && (0 < assetsToDeleteResult.size())) {
                modifiedData.addAll(assetsToDeleteResult);
               
                dc.setSQL(deleteLinks);
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
            } else if (inodesToDeleteResult.get(0).get("type").equals("file_asset")) {
              Logger.debug(this, "Deleting orphan File Asset with Identifier='" + identifierToDelete.get("id") + "'");
             
              dc.setSQL(fileAssetsToDelete);
              dc.addParam(identifierToDelete.get("id"));
              assetsToDeleteResult = dc.loadResults();
             
              if ((assetsToDeleteResult != null) && (0 < assetsToDeleteResult.size())) {
                modifiedData.addAll(assetsToDeleteResult);
               
                dc.setSQL(deleteFileAssets);
View Full Code Here
763
764
765
766
767
768
769
770
771
772
773
      //Thread.dumpStack();
      DotConnect dc = new DotConnect();
      dc.setSQL("select type from inode where inode = ?");
      dc.addParam(x);
      try {
        if(dc.loadResults().size()>0){
          c = InodeUtils.getClassByDBType(dc.getString("type"));
        }
        else{
          Logger.debug(InodeFactory.class,  x + " is not an Inode " );
          return new Inode();
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
      int total=0; 
      int error=0;
        try {
        DotConnect dc = new DotConnect();
        dc.setSQL(treesToDelete);
        modifiedData = dc.loadResults();
        total = total + dc.getResults().size();
        dc.setSQL(identifiersToDelete);
        modifiedData.addAll(dc.loadResults());
        total = total + dc.getResults().size();
        FixAssetsProcessStatus.setTotal(total);
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
        DotConnect dc = new DotConnect();
        dc.setSQL(treesToDelete);
        modifiedData = dc.loadResults();
        total = total + dc.getResults().size();
        dc.setSQL(identifiersToDelete);
        modifiedData.addAll(dc.loadResults());
        total = total + dc.getResults().size();
        FixAssetsProcessStatus.setTotal(total);
        getModifiedData();
        if(total > 0){
          try{
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
        String serverId = ConfigUtils.getServerId();
        long count = 0;
        try {
            dc.setSQL("select count(*) as count from dist_reindex_journal");
            dc.addParam(serverId);
            List<Map<String, String>> results = dc.loadResults();
            String c = results.get(0).get("count");
            count = Long.parseLong(c);
        } catch (Exception ex) {
            Logger
            .fatal(this,"Error  unlocking the reindex journal table" +  ex);
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
            dc.setSQL("SELECT object_to_index , max(id) as id from dist_journal " +
                " where journal_type = ? and serverid = ? GROUP BY id, object_to_index,time_entered ORDER BY time_entered ASC");
            dc.addParam(JOURNAL_TYPE_CACHE);
            dc.addParam(serverId);

            List<Map<String, String>> results = dc.loadResults(con);
            long id = 0;
            for (Map<String, String> r : results) {
                x.add(r.get("object_to_index"));
                id = new Long(r.get("id"));
            }
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.