Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect

77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
      FixAssetsProcessStatus.startProgress();
      FixAssetsProcessStatus.setDescription("task 30: DeleteOrphanedAssets");
      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())) {
      
         modifiedData = identifiersToDeleteResult;
       
         List<Map<String, String>> inodesToDeleteResult;
         List<Map<String, String>> assetsToDeleteResult;
         Map<String, String> identifierToDelete;
         boolean assetDeleted;
       
         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);
           
            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);
                dc.addParam(identifierToDelete.get("id"));
                dc.loadResult();
               
                assetDeleted = true;
              }
            } 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);
                dc.addParam(identifierToDelete.get("id"));
                dc.loadResult();
               
                assetDeleted = true;
              }
            } 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);
                dc.addParam(identifierToDelete.get("id"));
                dc.loadResult();
               
                assetDeleted = true;
              }
            }
           
            if (assetDeleted) {
              dc.setSQL(deleteTrees);
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.loadResult();
             
              dc.setSQL(deleteInodes);
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.loadResult();
            }
          }
         
          if (assetDeleted) {
            dc.setSQL(deleteIdentifier);
            dc.addParam(identifierToDelete.get("id"));
            dc.loadResult();
           
            Logger.debug(this, "Delete completed");
          }
        }
         }
View Full Code Here
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
    }else if( c.equals(Folder.class)){
      throw new DotStateException("You should use the FolderAPI to get folder information");
    }else if(c.equals(Inode.class)){
      Logger.debug(InodeFactory.class, "You should not send Inode.class to getInode.  Send the extending class instead (inode:" + x + ")" );
      //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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
        if (!FixAssetsProcessStatus.getRunning()) {
            try {
                FixAssetsProcessStatus.startProgress();
                FixAssetsProcessStatus.setDescription("70 Fix versionInfo");
                int total=0;
                DotConnect dc=new DotConnect();
               
                String[] versionables=new String[] {
                        "file_asset","htmlpage",
                        "template","containers","links"};
                for(String table : versionables) {
                    String vitable=UtilMethods.getVersionInfoTableName(table);
                    String sql = " select distinct id from "+table+" join identifier on (id=identifier) " +
                             " left outer join " + vitable +
                             " on("+table+".identifier="+vitable+".identifier) " +
                             " where working_inode is null";
                    dc.setSQL(sql);
                    List<Map<String, Object>> results = dc.loadObjectResults();
                    for(Map<String, Object> rr : results) {
                        String id=rr.get("id").toString();
                        sql="select inode from "+table+" where identifier=? order by mod_date desc";
                        dc.setSQL(sql);
                        dc.addParam(id);
                        List<Map<String, Object>> versions = dc.loadObjectResults();
                        String inode=versions.get(0).get("inode").toString();
                       
                        HibernateUtil hu=new HibernateUtil(UtilMethods.getVersionableClass(table));
                        Versionable workingVersion=(Versionable) hu.load(inode);
                        APILocator.getVersionableAPI().setWorking(workingVersion);
                       
                        total++;
                    }
                }
               
                // contentlets are different because of language_id
                String sql="select distinct id,language_id from contentlet join identifier on(id=identifier) " +
                       "   left outer join contentlet_version_info " +
                       "   on (contentlet.identifier=contentlet_version_info.identifier " +
                       "   and contentlet.language_id=contentlet_version_info.lang) " +
                       " where working_inode is null";
                dc.setSQL(sql);
                List<Map<String, Object>> results = dc.loadObjectResults();
                for(Map<String, Object> rr : results) {
                    String id=rr.get("id").toString();
                    Integer langId=Integer.parseInt(rr.get("language_id").toString());
                    sql="select inode from contentlet where identifier=? and language_id=? order by mod_date desc";
                    dc.setSQL(sql);
                    dc.addParam(id);
                    dc.addParam(langId);
                    List<Map<String, Object>> versions = dc.loadObjectResults();
                    String inode=versions.get(0).get("inode").toString();
                    APILocator.getVersionableAPI().setWorking(
                       APILocator.getContentletAPI().find(inode, APILocator.getUserAPI().getSystemUser(), false)
                    );
                    total++;
View Full Code Here
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
    }
   

        // workaround for dbs where we can't have more than one constraint
        // or triggers
        DotConnect db = new DotConnect();
        db.setSQL("delete from tree where child = ? or parent =?");
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.getResult();
 
        // workaround for dbs where we can't have more than one constraint
        // or triggers
        db.setSQL("delete from multi_tree where child = ? or parent1 =? or parent2 = ?");
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.getResult();
                   
      HibernateUtil.delete(o);
      db.setSQL("delete from inode where inode = ?");
      db.addParam(inode.getInode());
      db.getResult();
  }
View Full Code Here
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
      throw new DotStateException("Identifiers are no longer Inodes!");
    }
    try {

      String tableName = ((Inode) c.newInstance()).getType();
      DotConnect db = new DotConnect();
      db
      .setSQL("select count(*) as test from inode, tree where inode.inode = tree.child and tree.parent = ?  and inode.type = '"
          + tableName + "' ");
      db.addParam(i.getInode());
      // db.addParam(tableName);
      return db.getInt("test");
    } catch (Exception e) {
      Logger.warn(InodeFactory.class, "countChildrenOfClass failed:" + e, e);
      throw new DotRuntimeException(e.toString());
      // return 0;
    }
View Full Code Here
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
       
        if( arrayParams.length() > 0 ) {
          params = arrayParams.toString().substring(0, arrayParams.length() - 1);
        }
 
        DotConnect db = new DotConnect();
        db
        .setSQL("select count(*) as test, inode.type from inode, tree where inode.inode = tree.child and tree.parent = ?  and inode.type IN (" + params + ") group by inode.type");
        db.addParam(i.getInode());
       
        for(String type: types) {
          db.addParam(type);
        }

        ArrayList<Map<String, Object>> results = db.getResults();
        int length = results.size();
        for(n = 0; n < length; n++)
        {
          Map<String, Object> hash = (Map<String, Object>) results.get(n);
          String type = (String) hash.get("type");
View Full Code Here
1593
1594
1595
1596
1597
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608
1609
  }
 
  //http://jira.dotmarketing.net/browse/DOTCMS-3232
    //To Check whether given inode exists in DB or not
  public static boolean isInode(String inode){
    DotConnect dc = new DotConnect();
    String InodeQuery = "Select count(*) as count from inode where inode = ?";
    dc.setSQL(InodeQuery);
    dc.addParam(inode);
    ArrayList<Map<String, String>> results = new ArrayList<Map<String, String>>();
    try {
      results = dc.getResults();
    } catch (DotDataException e) {
      Logger.error(InodeFactory.class,"isInode method failed:"+ e, e);
    }
    int count = Parameter.getInt(results.get(0).get("count"),0);
    if(count > 0){
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
      FixAssetsProcessStatus.setDescription("task 20: DeleteOrphanedIdentifiers");
      HibernateUtil.startTransaction();
      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);
        getModifiedData();
        if(total > 0){
          try{
          HibernateUtil.startTransaction();
          dc.executeStatement(deleteTreesToDelete);
          dc.executeStatement(deleteIdentifiersToDelete);
          FixAssetsProcessStatus.setError(total);
          /*if(DbConnectionFactory.getDBType().equals(DbConnectionFactory.MYSQL)){
            deleteInodesInMySQL(dc);
          }else{
              dc.executeStatement(deleteIdentifiersToDelete);
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
    if (!FixAssetsProcessStatus.getRunning()) {
      FixAssetsProcessStatus.startProgress();
      FixAssetsProcessStatus.setDescription("task 9: check for contentlets  that points to inexistent inodes and deleted them");     
      HibernateUtil.startTransaction();
      try {
        DotConnect db = new DotConnect();

        int total=0;
        String query = "select * from contentlet c where c.inode not in (select inode from inode where type='contentlet')";
        Logger.debug(CMSMaintenanceFactory.class,
            "Running query for Contentlets: " + query);
        db.setSQL(query);
        List<Map<String, String>> contentletIds = db.getResults();
       
        modifiedData=contentletIds;
        getModifiedData();
        Logger.debug(CMSMaintenanceFactory.class, "Found "
            + contentletIds.size() + " Contentlets");
        total += contentletIds.size();

       
        Logger.info(CMSMaintenanceFactory.class,
            "Total number of assets: " + total);
        FixAssetsProcessStatus.setTotal(total);

        // Check the working and live versions of contentlets
        String identifierInode;
     


        String inode;

        Logger.info(CMSMaintenanceFactory.class,"deleting " + contentletIds.size()+" contentlets that point to inexistent inodes ");
        for (Map<String, String> identifier : contentletIds) {
          identifierInode = identifier.get("inode");

          Logger.debug(CMSMaintenanceFactory.class,"identifier inode " + identifierInode);

            inode = identifier.get("inode");
            Logger.debug(CMSMaintenanceFactory.class,"Non Working Contentlet inode : " + inode);
            Logger.debug(CMSMaintenanceFactory.class,"Running query: " + fixContentletQuery);
            db.setSQL(fixContentletQuery);
            db.addParam(inode);
            db.getResult();

            FixAssetsProcessStatus.addAError();
            counter++;
          }
       
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
  }
   


  public boolean shouldRun() {
    DotConnect db = new DotConnect();

    String query = "select c.inode from contentlet c where c.inode not in (select inode from inode where type='contentlet') ";
   
    db.setSQL(query);
    List<HashMap<String, String>> contentletIds =null;
    try {
      contentletIds = db.getResults();
    } catch (DotDataException e) {
      Logger.error(this, e.getMessage(), e);
    }
    Logger.debug(CMSMaintenanceFactory.class, "Found "
        + contentletIds.size() + " Contentlets");
View Full Code Here
TOP

Related Classes of com.dotmarketing.common.db.DotConnect

  • com.dotcms.content.elasticsearch.business.ESContentFactoryImpl
  • com.dotcms.content.elasticsearch.business.ESContentFactoryImplTest
  • com.dotcms.content.elasticsearch.business.ESContentletAPIImpl
  • com.dotcms.content.elasticsearch.business.ESContentletIndexAPI
  • com.dotcms.content.elasticsearch.business.ESMappingAPIImpl
  • com.dotcms.content.elasticsearch.business.IndiciesFactoryImpl
  • com.dotcms.content.elasticsearch.util.ESReindexationProcessStatus
  • com.dotcms.journal.business.ESDistributedJournalFactoryImpl
  • com.dotcms.notifications.business.NotificationFactoryImpl
  • com.dotcms.publisher.assets.business.PushedAssetsFactoryImpl
    • Copyright © 2018 www.massapicom. 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.