Package com.dotmarketing.common.db

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

69
70
71
72
73
74
75
76
77
78
79
             String query = " SELECT * FROM identifier WHERE (asset_type='file_asset' or asset_type='htmlpage') " +
                         " and host_inode = ? " +
                         " and id NOT IN (SELECT identifier FROM folder where host_inode = ?) ";

             dc.setSQL(query);
             dc.addParam(hostInode);
             dc.addParam(hostInode);
             List<HashMap<String, String>> assetIds = dc.getResults();
             total = total + assetIds.size();
             FixAssetsProcessStatus.setTotal(total);
             for(HashMap<String, String> asset:assetIds){
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
                         " and host_inode = ? " +
                         " and id NOT IN (SELECT identifier FROM folder where host_inode = ?) ";

             dc.setSQL(query);
             dc.addParam(hostInode);
             dc.addParam(hostInode);
             List<HashMap<String, String>> assetIds = dc.getResults();
             total = total + assetIds.size();
             FixAssetsProcessStatus.setTotal(total);
             for(HashMap<String, String> asset:assetIds){
               String identifier = asset.get("id");
View Full Code Here
283
284
285
286
287
288
289
290
291
292
293
          String query = " SELECT * FROM identifier WHERE (asset_type='file_asset' or asset_type='htmlpage') " +
                      " and host_inode = ? " +
                      " and id NOT IN (SELECT identifier FROM folder where host_inode = ?) ";

          dc.setSQL(query);
          dc.addParam(hostInode);
          dc.addParam(hostInode);
          List<HashMap<String, String>> assetIds ;
          assetIds = dc.getResults();
          total = total + assetIds.size();
        }
View Full Code Here
284
285
286
287
288
289
290
291
292
293
294
                      " and host_inode = ? " +
                      " and id NOT IN (SELECT identifier FROM folder where host_inode = ?) ";

          dc.setSQL(query);
          dc.addParam(hostInode);
          dc.addParam(hostInode);
          List<HashMap<String, String>> assetIds ;
          assetIds = dc.getResults();
          total = total + assetIds.size();
        }
      }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
       
         for (int i = 0; i < identifiersToDeleteResult.size(); ++i) {
          identifierToDelete = identifiersToDeleteResult.get(i);
          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())) {
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
         for (int i = 0; i < identifiersToDeleteResult.size(); ++i) {
          identifierToDelete = identifiersToDeleteResult.get(i);
          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);
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
          identifierToDelete = identifiersToDeleteResult.get(i);
          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);
           
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
           
            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);
               
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
             
              if ((assetsToDeleteResult != null) && (0 < assetsToDeleteResult.size())) {
                modifiedData.addAll(assetsToDeleteResult);
               
                dc.setSQL(deleteHTMLPages);
                dc.addParam(identifierToDelete.get("id"));
                dc.loadResult();
               
                assetDeleted = true;
              }
            } else if (inodesToDeleteResult.get(0).get("type").equals("links")) {
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
              }
            } 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);
               
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.