Examples of loadResult()


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

        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()

        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()

        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()

        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()

    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()

       
        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()

       
        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()

       
        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()

       
        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()

       
        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.