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

Class com.dotmarketing.common.db.DotConnect

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

com.dotmarketing.common.db.DotConnect.loadResults()
Returns the results. @return ArrayList

        db.setSQL(GET_ALL_USERS);
        db.addParam(uri);
        db.addParam(startDate);
        db.addParam(endDate);
        db.addParam(hostId);
        return db.loadResults();
    }
    
    @SuppressWarnings("unchecked")
  public static List<String> getContentsInodesViewsBetweenDates(String uri, java.util.Date startDate, java.util.Date endDate, String hostId) throws DotDataException {
        DotConnect db = new DotConnect();

View Full Code Here

        db.setSQL(GET_CONTENTS_INODES_VIEWS);
        db.addParam(uri);
        db.addParam(startDate);
        db.addParam(endDate);
        db.addParam(hostId);
        List<HashMap<String, String>> result = db.loadResults();
        List<String> inodes = new ArrayList<String>();
        
        java.util.StringTokenizer parameters;
        String parameter;
        String inode;

View Full Code Here

        db.setSQL(GET_CONTENTS_INODES_UNIQUE_VISITORS);
        db.addParam(uri);
        db.addParam(startDate);
        db.addParam(endDate);
        db.addParam(hostId);
        List<HashMap<String, String>> result = db.loadResults();
        ArrayList<String> inodes = new ArrayList<String>();
        ArrayList<String> uniqueVisits = new ArrayList<String>();
        
        java.util.StringTokenizer parameters;
        String parameter;

View Full Code Here

    DotConnect dc = new DotConnect();


    dc.setSQL(getSystemRole);
    ArrayList<Map<String, String>> results;
    try {
      results = dc.loadResults();
    } catch (DotDataException e) {
      Logger.info(this, "Task not executing seems the roles has not been upgraded yet");
      return;
    }
    String systemRootRoleId = null;

View Full Code Here

    } else {
      systemRootRoleId = results.get(0).get("id");
    }
    
    dc.setSQL(getUsersRole);
    results = dc.loadResults();
    String usersRootRoleId = null; 
    if(results.size() == 0) {
      usersRootRoleId = UUIDGenerator.generateUuid();
      dc.setSQL(insertRole);
      dc.addParam(usersRootRoleId);

View Full Code Here

    }
    
    String[] systemRoles = PropsUtil.getArray(PropsUtil.SYSTEM_ROLES);
    dc.setSQL(selectSystemRoles);
    dc.addParam(systemRootRoleId);
    List<Map<String, String>> currentSystemRoles = dc.loadResults();


    Arrays.sort(rolesWithUsersLocked);
    
    for(String roleName : systemRoles) {
      if(!containsRole(roleName, currentSystemRoles)) {

View Full Code Here

    if(start > -1)
      dotConnect.setStartRow(start);
    if(limit > -1)
      dotConnect.setMaxRows(limit);


    ArrayList<Map<String, Object>> results = dotConnect.loadResults();
    
    // Since limit is a small number, convert each row to appropriate entity
    ArrayList<User> users = new ArrayList<User>();


    int length = results.size();

View Full Code Here

            dotConnect.setStartRow( start );
        }
        if ( limit > -1 ) {
            dotConnect.setMaxRows( limit );
        }
        ArrayList<Map<String, Object>> results = dotConnect.loadResults();


        ArrayList<String> ids = new ArrayList<String>();
        for ( Map<String, Object> hash : results ) {
            String userId = (String) hash.get( "userid" );
            ids.add( userId );

View Full Code Here

  @Override
  protected boolean exists(String folderInode) throws DotDataException {
    DotConnect dc = new DotConnect();
    dc.setSQL("select inode  from folder where inode = ?");
    dc.addParam(folderInode);
    return dc.loadResults().size() > 0;


  }




  @Override

View Full Code Here

    final ArrayList<String> childIdents=new ArrayList<String>();
    DotConnect dc=new DotConnect();
    dc.setSQL("select id from identifier where parent_path like ? and host_inode=?");
    dc.addParam(ident.getPath()+"%");
    dc.addParam(ident.getHostId());
    for(Map<String,Object> rr : (List<Map<String,Object>>)dc.loadResults()) {
        childIdents.add((String)rr.get("id"));
    }
    HibernateUtil.addCommitListener(new Runnable() {
            public void run() {
                for(String id : childIdents) {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.