Package com.dotmarketing.common.db

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

114
115
116
117
118
119
120
121
122
123
124
                "Non Working File inode : " + inode);
            Logger.debug(CMSMaintenanceFactory.class,
                "Running query: " + fix3FileAssetQuery);
            db.setSQL(fix3FileAssetQuery);           
            db.addParam(inode);
            db.addParam(identifierInode);
            db.getResult();

            FixAssetsProcessStatus.addAError();
            counter++;
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
            dc.addParam(inodeS);
            result = dc.getResults();*/
           
            dc = new DotConnect();
            dc.setSQL(cleanInodeContentletWithoutContent);
            dc.addParam(inodeS);
            result = dc.getResults();

            /*dc = new DotConnect();
            dc.setSQL(cleanInodeIdentifierContentletWithoutContent);
            dc.addParam(identifierS);
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
        for (Map<String, String> ident: identifiers) {
          identifierS = ident.get("id");
          try{
            dc = new DotConnect();
            dc.setSQL(cleanInodeContentletWithoutContentPermissionReference);
            dc.addParam(identifierS);
            result = dc.getResults();
         
            dc = new DotConnect();
            dc.setSQL(cleanInodeContentletWithoutContentPermission);
            dc.addParam(identifierS);
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
            dc.addParam(identifierS);
            result = dc.getResults();
         
            dc = new DotConnect();
            dc.setSQL(cleanInodeContentletWithoutContentPermission);
            dc.addParam(identifierS);
            result = dc.getResults();
         
            dc = new DotConnect();
            dc.setSQL(cleanIdentifierInodeContentletWithoutContent);
            dc.addParam(identifierS);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
            dc.addParam(identifierS);
            result = dc.getResults();
         
            dc = new DotConnect();
            dc.setSQL(cleanIdentifierInodeContentletWithoutContent);
            dc.addParam(identifierS);
            result = dc.getResults();
          } catch (Exception e) {
            Logger.error(FixTask00050FixInodesWithoutContentlets.class,e.getMessage(),e);
          }   
         
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
                List<Map<String,String>> results = dc.getResults();
                total+=results.size();
                for(Map<String,String> rr : results) {
                    try {
                        dc.setSQL("update identifier set asset_type='contentlet' where id=?");
                        dc.addParam(rr.get("id"));
                        dc.loadResult();
                        modifiedData.add(rr);
                        total++;
                    } catch(Exception ex) {
                        Logger.warn(this, "error fixing asset_type on id="+rr.get("id"));
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
                results = dc.getResults();
                total+=results.size();
                for(Map<String,String> rr : results) {
                    try {
                        dc.setSQL("update identifier set asset_type='file_asset' where id=?");
                        dc.addParam(rr.get("id"));
                        dc.loadResult();
                        modifiedData.add(rr);
                        total++;
                    } catch(Exception ex) {
                        Logger.warn(this, "error fixing asset_type on id="+rr.get("id"));
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
                results = dc.getResults();
                total+=results.size();
                for(Map<String,String> rr : results) {
                    try {
                        dc.setSQL("update identifier set asset_type='containers' where id=?");
                        dc.addParam(rr.get("id"));
                        dc.loadResult();
                        modifiedData.add(rr);
                        total++;
                    } catch(Exception ex) {
                        Logger.warn(this, "error fixing asset_type on id="+rr.get("id"));
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
                results = dc.getResults();
                total+=results.size();
                for(Map<String,String> rr : results) {
                    try {
                        dc.setSQL("update identifier set asset_type='template' where id=?");
                        dc.addParam(rr.get("id"));
                        dc.loadResult();
                        modifiedData.add(rr);
                        total++;
                    } catch(Exception ex) {
                        Logger.warn(this, "error fixing asset_type on id="+rr.get("id"));
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
                results = dc.getResults();
                total+=results.size();
                for(Map<String,String> rr : results) {
                    try {
                        dc.setSQL("update identifier set asset_type='links' where id=?");
                        dc.addParam(rr.get("id"));
                        dc.loadResult();
                        modifiedData.add(rr);
                        total++;
                    } catch(Exception ex) {
                        Logger.warn(this, "error fixing asset_type on id="+rr.get("id"));
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.