Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect

414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
      dc.executeStatement(trigger);
    }
  }

  public void executeUpgrade() throws DotHibernateException {
    DotConnect dc = new DotConnect();
    HibernateUtil.startTransaction();
    try {
      if (DbConnectionFactory.isMsSql())
          dc.executeStatement("SET TRANSACTION ISOLATION LEVEL READ COMMITTED");
      containerTableChanges();
      htmlpageTableChanges();
      triggerChanges();
      addTriggerToFolder();
      if(Config.getBooleanProperty("upgrade-cleanup-bad-data",true))
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
public class Task00768CreateTagStorageFieldOnHostStructure implements StartupTask {
   
    protected void upgradeStructureFields() throws DotDataException {
        try {
            DotConnect dc=new DotConnect();
            if(DbConnectionFactory.isOracle()) {
                dc.executeStatement("alter table structure add expire_date_var varchar2(255)");
                dc.executeStatement("alter table structure add publish_date_var varchar2(255)");
            }
            else {
                dc.executeStatement("alter table structure add expire_date_var varchar(255)");
                dc.executeStatement("alter table structure add publish_date_var varchar(255)");
            }
        }
        catch(Exception ex) {
            throw new DotDataException(ex.getMessage(),ex);
        }
View Full Code Here
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
      StructureCache.removeStructure(structure);
      StructureServices.removeStructureFile(structure);
      StructureFactory.saveStructure(structure);
     
      //Populate host contents with tag storage value = SYSTEM_HOST
      DotConnect dc = new DotConnect();
      dc.setSQL("update contentlet set "+fieldContentlet+" = ? " +
          "where live = ? and working = ? and structure_inode in (select inode from structure where name = 'Host')"
          + " and title not like ?") ;
      dc.addParam(Host.SYSTEM_HOST);
      if(DbConnectionFactory.isPostgres()){
        dc.addParam(true);
        dc.addParam(true); 
      }
      else {
        dc.addParam(DbConnectionFactory.getDBTrue());
        dc.addParam(DbConnectionFactory.getDBTrue());
      }

      dc.addParam("System Host");
      dc.loadResult();
     
    }
 
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
        }
    }

    @Override
    protected void addBuildNewIndexEntries() throws DotDataException {
        DotConnect dc = new DotConnect();
        try {
            String sql = "insert into dist_reindex_journal(inode_to_index,ident_to_index, priority, dist_action, time_entered) " +
                  " select distinct identifier,identifier," + REINDEX_JOURNAL_PRIORITY_NEWINDEX +"," + REINDEX_ACTION_REINDEX_OBJECT + ", " + TIMESTAMPSQL +
                  " from contentlet_version_info where identifier is not null";
            dc.setSQL(sql);
            dc.loadResult();
        } catch (Exception e) {
            throw new DotDataException(e.getMessage(), e);
        }
    }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
                con = DbConnectionFactory.getConnection();
                con.setAutoCommit(false);
                java.sql.Timestamp timestamp = new java.sql.Timestamp(new java.util.Date().getTime());
                for (String serversId : serversIds) {
                    if (!serverId.equals(serversId)) {
                        DotConnect dc = new DotConnect();
                        dc.setSQL("INSERT INTO dist_process(object_to_index, time_entered, serverid, journal_type)VALUES (?, ?, ?, ?)");
                        dc.addParam(key + ":" + group);
                        dc.addParam(timestamp);
                        dc.addParam(serversId);
                        dc.addParam(JOURNAL_TYPE_CACHE);
                        try {
                            dc.getResult(con);
                        } catch (Exception e) {
                            Logger
                                    .warn(this,
                                            "Usually not a problem but a cache entry failed to insert in the table.");
                            Logger.debug(this, e.getMessage(), e);
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
    }

    @Override
    protected void addStructureReindexEntries(T structureInode)
            throws DotDataException {
        DotConnect dc = new DotConnect();
        try {
            String sql = "insert into dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action, time_entered) " +
                " select distinct c.identifier,c.identifier,"+REINDEX_JOURNAL_PRIORITY_STRUCTURE_REINDEX+"," +
                    REINDEX_ACTION_REINDEX_OBJECT + "," + TIMESTAMPSQL  + " from contentlet c " +
                        " where c.structure_inode = ? and c.identifier is not null";
            dc.setSQL(sql);
            dc.addParam(structureInode);
            dc.loadResult();

        } catch (Exception ex) {
            Logger.fatal(this,"Error  unlocking the reindex journal table" +  ex);
        }
    }
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
        }
    }

    @Override
    protected boolean areRecordsLeftToIndex() throws DotDataException {
        DotConnect dc = new DotConnect();
        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
163
164
165
166
167
168
169
170
171
172
173
        return count > 0;
    }

    @Override
    protected void cleanDistReindexJournal() throws DotDataException {
        DotConnect dc = new DotConnect();
        dc.setSQL("DELETE From dist_reindex_journal where priority =? or priority=?");
        dc.addParam(REINDEX_JOURNAL_PRIORITY_NEWINDEX);
        dc.addParam(REINDEX_JOURNAL_PRIORITY_NEWINDEX-10);
        dc.loadResult();
    }
View Full Code Here
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
    }

    @Override
    protected void deleteContentIndexEntries(String serverId, long id)
            throws DotDataException {
        DotConnect dc = new DotConnect();
        try {
            dc.setSQL("DELETE FROM dist_journal where serverid = ? and journal_type = ? and id < ?");
            dc.addParam(serverId);
            dc.addParam(JOURNAL_TYPE_CONTENTENTINDEX);
            dc.addParam(id + 1);
            dc.loadResult();
        } catch (Exception e1) {
            throw new DotDataException(e1.getMessage(), e1);
        } finally {
            try {
                HibernateUtil.closeSession();
View Full Code Here
195
196
197
198
199
200
201
202
203
204
205
206
    @Override
    protected void deleteLikeJournalRecords(IndexJournal<T> ijournal) throws DotDataException {
        String deleteLikeReindexRecords = "DELETE FROM dist_reindex_journal where serverid = ? AND ident_to_index = ? AND id <> ? ";
        String serverId = ConfigUtils.getServerId();
        DotConnect dc = new DotConnect();
        dc.setSQL(deleteLikeReindexRecords);
        dc.addParam(serverId);
        dc.addParam(ijournal.getIdentToIndex());
        dc.addParam(ijournal.getId());
        dc.loadResult();
    }
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.