Package com.dotmarketing.common.db

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

1710
1711
1712
1713
1714
1715
1716
1717
1718
1719
1720
      if (limit != 0) {
        dc.setStartRow(startRow);
        dc.setMaxRows(limit);
      }
     
      List<Map<String, String>> list = dc.loadResults();
      List<Permissionable> assetsList = new ArrayList<Permissionable>();
      WebAsset permissionable;
     
      PermissionAPI permAPI = APILocator.getPermissionAPI();
     
View Full Code Here
1735
1736
1737
1738
1739
1740
1741
1742
1743
1744
1745
          dc = new DotConnect();
          dc.setSQL(sb.toString());
          startRow += limit;
          dc.setStartRow(startRow);
          dc.setMaxRows(limit);
          list = dc.loadResults();
        }
      }
     
      return assetsList.size();
    } catch (Exception e) {
View Full Code Here
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797
        dc.setSQL(sb.toString());

        dc.setStartRow(internalOffset);
        dc.setMaxRows(internalLimit);
       
        List<Map<String, String>> list = dc.loadResults();
        List<Permissionable> assetsList = new ArrayList<Permissionable>();
        WebAsset permissionable;
       
        for (Map<String, String> map: list) {
          permissionable = (WebAsset) c.newInstance();
View Full Code Here
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885
      if (limit != 0) {
        dc.setStartRow(startRow);
        dc.setMaxRows(limit);
      }
     
      List<Map<String, String>> list = dc.loadResults();
      List<Permissionable> assetsList = new ArrayList<Permissionable>();
      WebAsset permissionable;
     
      PermissionAPI permAPI = APILocator.getPermissionAPI();
     
View Full Code Here
1900
1901
1902
1903
1904
1905
1906
1907
1908
1909
1910
          dc = new DotConnect();
          dc.setSQL(sb.toString());
          startRow += limit;
          dc.setStartRow(startRow);
          dc.setMaxRows(limit);
          list = dc.loadResults();
        }
      }
     
      return assetsList.size();
     
View Full Code Here
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
        dc.setSQL(sb.toString());

        dc.setStartRow(internalOffset);
        dc.setMaxRows(internalLimit);
       
        List<Map<String, String>> list = dc.loadResults();
        List<Permissionable> assetsList = new ArrayList<Permissionable>();
        WebAsset permissionable;
       
        for (Map<String, String> map: list) {
          permissionable = (WebAsset) c.newInstance();
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
  protected Object loadField(String inode, String fieldContentlet) throws DotDataException {
      String sql="SELECT "+fieldContentlet+" FROM contentlet WHERE inode=?";
      DotConnect dc=new DotConnect();
      dc.setSQL(sql);
      dc.addParam(inode);
      ArrayList results=dc.loadResults();
      if(results.size()==0) return null;
      Map m=(Map)results.get(0);
      return m.get(fieldContentlet);
  }
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
        sql.append(" where id in (select identifier from contentlet where structure_inode = ?)");
        DotConnect dc = new DotConnect();
        dc.setSQL(sql.toString());
        dc.addParam(APILocator.getHostAPI().findSystemHost().getIdentifier());
        dc.addParam(structureInode);
        dc.loadResults();
        //we could do a select here to figure out exactly which guys to evict
        cc.clearCache();
        CacheLocator.getIdentifierCache().clearCache();
  }
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
  @Override
  protected long contentletCount() throws DotDataException {
      DotConnect dc = new DotConnect();
        dc.setSQL("select count(*) as count from contentlet");
        List<Map<String,String>> results = dc.loadResults();
        long count = Long.parseLong(results.get(0).get("count"));
        return count;
  }

  @Override
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
            dc.setSQL("select count(*) as count from (select distinct identifier from contentlet)");
        }else{
            dc.setSQL("select count(*) as count from (select distinct identifier from contentlet) as t");
        }

        List<Map<String,String>> results = dc.loadResults();
        long count = Long.parseLong(results.get(0).get("count"));
        return count;
  }

  @Override
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.