Package com.dotmarketing.common.db

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

11
12
13
14
15
16
17
18
19
20
21
    @Override
    public boolean forceRun() {
        try {
            DotConnect dc=new DotConnect();
            dc.setSQL("select mod_date from field");
            dc.loadResult();
        }
        catch(Exception ex) {
            return true;
        }
        return false;
View Full Code Here
20
21
22
23
24
25
26
27
28
29
30
            con=DbConnectionFactory.getDataSource().getConnection();
            con.setAutoCommit(true);
           
            DotConnect dc=new DotConnect();
            dc.setSQL("select expire_date_var,publish_date_var from structure");
            dc.loadResult(con);
        }
        catch(Exception ex) {
            return true;
        }
        finally {
View Full Code Here
497
498
499
500
501
502
503
504
505
506
507
        dc.addParam(REINDEX_JOURNAL_PRIORITY_CONTENT_REINDEX);
        dc.addParam(REINDEX_ACTION_REINDEX_OBJECT);
        dc.addParam(folder.getHostId());
        String folderPath = APILocator.getIdentifierAPI().find(folder).getPath();
        dc.addParam(folderPath+"%");
        dc.loadResult();
    }

    @Override
    protected void refreshContentUnderHost(Host host) throws DotDataException {
        String sql = " INSERT INTO dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action) "+
View Full Code Here
511
512
513
514
515
516
517
518
519
520
521
        DotConnect dc = new DotConnect();
        dc.setSQL(sql);
        dc.addParam(REINDEX_JOURNAL_PRIORITY_CONTENT_REINDEX);
        dc.addParam(REINDEX_ACTION_REINDEX_OBJECT);
        dc.addParam(host.getIdentifier());
        dc.loadResult();

        // https://github.com/dotCMS/dotCMS/issues/2229
        sql =   " INSERT INTO dist_reindex_journal(inode_to_index,ident_to_index,priority,dist_action) "+
                " SELECT asset_id, asset_id, ?, ? " +
                " FROM permission_reference "+
View Full Code Here
522
523
524
525
526
527
528
529
530
531
532
                " WHERE reference_id=?";
        dc.setSQL(sql);
        dc.addParam(REINDEX_JOURNAL_PRIORITY_CONTENT_REINDEX);
        dc.addParam(REINDEX_ACTION_REINDEX_OBJECT);
        dc.addParam(host.getIdentifier());
        dc.loadResult();
    }

    @Override
    protected void setIndexationEnabled(boolean indexationEnabled) {
      Config.setProperty("DIST_INDEXATION_ENABLED", Boolean.FALSE);
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
    db.addParam(asset.getBundleId());
    db.addParam(asset.getAssetId());
    db.addParam(asset.getAssetType());
    db.addParam(asset.getPushDate());
    db.addParam(asset.getEnvironmentId());
    db.loadResult();
  }

  @Override
  public void deletePushedAssets(String bundleId, String environmentId)
      throws DotDataException {
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
      throws DotDataException {
    final DotConnect db = new DotConnect();
    db.setSQL(DELETE_ASSETS_BY_BUNDLE_ENV);
    db.addParam(bundleId);
    db.addParam(environmentId);
    db.loadResult();

  }

  @Override
  public void deletePushedAssets(String assetId)
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
  public void deletePushedAssets(String assetId)
      throws DotDataException {
    final DotConnect db = new DotConnect();
    db.setSQL(DELETE_ASSETS_BY_ASSET_ID);
    db.addParam(assetId);
    db.loadResult();

  }

  @Override
  public void deletePushedAssetsByEnvironment(String environmentId)
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
  public void deletePushedAssetsByEnvironment(String environmentId)
      throws DotDataException {
    final DotConnect db = new DotConnect();
    db.setSQL(DELETE_ASSETS_BY_ENVIRONMENT_ID);
    db.addParam(environmentId);
    db.loadResult();

  }

  @Override
  public List<PushedAsset> getPushedAssets(String bundleId, String environmentId)
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
  @Override
  public void deleteAllPushedAssets() throws DotDataException {
    final DotConnect db = new DotConnect();
    db.setSQL(DELETE_ALL_ASSETS);
    db.loadResult();
  }

  @Override
  public List<PushedAsset> getPushedAssets(String assetId)
      throws DotDataException {
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.