Examples of loadResult()

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

487
488
489
490
491
492
493
494
495
496
497
        String inodesToDelete = "select inode from "+assetType+" where "+condition;

        String treeChildDelete = "delete from tree where child in ("+inodesToDelete+")";
        dc.setSQL(treeChildDelete);
        dc.addParam(date);
        dc.loadResult();

        String treeParentDelete = "delete from tree where parent in ("+inodesToDelete+")";
        dc.setSQL(treeParentDelete);
        dc.addParam(date);
        dc.loadResult();
View Full Code Here

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

492
493
494
495
496
497
498
499
500
501
502
        dc.loadResult();

        String treeParentDelete = "delete from tree where parent in ("+inodesToDelete+")";
        dc.setSQL(treeParentDelete);
        dc.addParam(date);
        dc.loadResult();

        String deleteContentletSQL = "delete from "+assetType+" where  "+condition;
        dc.setSQL(deleteContentletSQL);
        dc.addParam(date);
        dc.loadResult();
View Full Code Here

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

497
498
499
500
501
502
503
504
505
506
507
        dc.loadResult();

        String deleteContentletSQL = "delete from "+assetType+" where  "+condition;
        dc.setSQL(deleteContentletSQL);
        dc.addParam(date);
        dc.loadResult();

        String deleteInodesSQL = "delete from inode where type=? and idate < ? and inode not in (select inode from "+assetType+")";
        dc.setSQL(deleteInodesSQL);
        dc.addParam(assetType);
        dc.addParam(date);
View Full Code Here

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

503
504
505
506
507
508
509
510
511
512
513
        String deleteInodesSQL = "delete from inode where type=? and idate < ? and inode not in (select inode from "+assetType+")";
        dc.setSQL(deleteInodesSQL);
        dc.addParam(assetType);
        dc.addParam(date);
        dc.loadResult();

        dc.setSQL(countSQL);
        result = dc.loadResults();
        int after = Integer.parseInt(result.get(0).get("count"));
View Full Code Here

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

64
65
66
67
68
69
70
71
72
73
74
    public void point(Connection conn,IndiciesInfo info) throws DotDataException {
        DotConnect dc = new DotConnect();
       
        // first we delete them all
        dc.setSQL("DELETE FROM indicies");
        dc.loadResult(conn);
       
        final String insertSQL="INSERT INTO indicies VALUES(?,?)";
       
        if(info.working!=null) {
            dc.setSQL(insertSQL);
View Full Code Here

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

72
73
74
75
76
77
78
79
80
81
82
       
        if(info.working!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.working);
            dc.addParam(IndexTypes.WORKING.toString().toLowerCase());
            dc.loadResult(conn);
        }
       
        if(info.live!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.live);
View Full Code Here

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

79
80
81
82
83
84
85
86
87
88
89
       
        if(info.live!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.live);
            dc.addParam(IndexTypes.LIVE.toString().toLowerCase());
            dc.loadResult(conn);
        }
       
        if(info.reindex_live!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.reindex_live);
View Full Code Here

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

86
87
88
89
90
91
92
93
94
95
96
       
        if(info.reindex_live!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.reindex_live);
            dc.addParam(IndexTypes.REINDEX_LIVE.toString().toLowerCase());
            dc.loadResult(conn);
        }
       
        if(info.reindex_working!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.reindex_working);
View Full Code Here

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

93
94
95
96
97
98
99
100
101
102
103
       
        if(info.reindex_working!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.reindex_working);
            dc.addParam(IndexTypes.REINDEX_WORKING.toString().toLowerCase());
            dc.loadResult(conn);
        }
       
        if(info.site_search!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.site_search);
View Full Code Here

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

100
101
102
103
104
105
106
107
108
109
110
       
        if(info.site_search!=null) {
            dc.setSQL(insertSQL);
            dc.addParam(info.site_search);
            dc.addParam(IndexTypes.SITE_SEARCH.toString().toLowerCase());
            dc.loadResult(conn);
        }
       
        cache.clearCache();
       
        HibernateUtil.addCommitListener(new Runnable() {
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.