Examples of com.dotmarketing.common.db.DotConnect

com.dotmarketing.common.db.DotConnect
Description of the Class @author will @created February 25, 2002 Modified May 8, 2003 Hashtables converted toHashMaps results is now an arraylist

    sb.append("inner join inode i on (r.inode = i.inode)");
    sb.append("left join permission p on (r.inode = p.inode_id and p.roleid in (" + roles + ")) ");
    sb.append("group by r.inode,r.report_name,r.report_description,r.requires_input,r.ds,r.web_form_report,i.owner ");
    sb.append("order by r.report_name ");
    
    DotConnect dc = new DotConnect();
    dc.setSQL(sb.toString());
    ArrayList<HashMap<String, String>> results = dc.getResults();
    for (HashMap<String, String> map : results) {
      PermissionAsset pa = new PermissionAsset();
      Report report = new Report();
      report.setInode(map.get("inode"));
      report.setReportName(map.get("report_name"));

View Full Code Here

    sb.append("from report_asset r ");
    sb.append("inner join inode i on (r.inode = i.inode) ");
    sb.append("group by r.inode,r.report_name,r.report_description,r.requires_input,r.ds,r.web_form_report,i.owner ");
    sb.append("order by r.report_name ");
    
    DotConnect dc = new DotConnect();
    dc.setSQL(sb.toString());
    ArrayList<HashMap<String, String>> results =null;
    try {
      results = dc.getResults();
    } catch (DotDataException e) {
      Logger.error(ReportFactory.class, e.getMessage(), e);
    }
    for (HashMap<String, String> map : results) {
      PermissionAsset pa = new PermissionAsset();

View Full Code Here

        }else {
            concat=" (ii.parent_path || ii.asset_name) ";
        }
      
        StringBuilder bob = new StringBuilder();
        DotConnect dc = new DotConnect();
        
        // files modified itself
        bob = new StringBuilder();
        bob.append("SELECT vi.identifier as pident from fileasset_version_info vi ")
        .append("join identifier ii on (ii.id=vi.identifier) ")
        .append("where vi.version_ts >= ? ")
        .append(" and vi.version_ts <= ? ")
        .append(" and vi.live_inode is not null and vi.deleted=").append(DbConnectionFactory.getDBFalse())
        .append(" and ii.host_inode=? ")
        .append(" and ").append(concat).append(include?" LIKE ?":" NOT LIKE ?");
        dc.setSQL(bob.toString());
        dc.addParam(startDate);
        dc.addParam(endDate);
        dc.addParam(host.getIdentifier());
        dc.addParam(likepattern);
        
        try {
            for (Map<String,Object> row : dc.loadObjectResults())
                ret.add((String)row.get("pident"));
        } catch (DotDataException e) {
            Logger.error(HTMLPageFactoryImpl.class,e.getMessage(),e);
        }

View Full Code Here

//      _bout.close();
//      _list = null;
//      _bout = null;


      /* users_roles */
      DotConnect dc = new DotConnect();
//      dc.setSQL("select * from users_roles");
//      _list = dc.getResults();
//      _xstream = new XStream(new DomDriver());
//      _writing = new File(backupTempFilePath + "/Users_Roles.xml");
//      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
//      _xstream.toXML(_list, _bout);
//      _bout.close();
//      _list = null;
//      _bout = null;
//
//      /* users_groups */
//      dc.setSQL("select * from users_groups");
//      _list = dc.getResults();
//      _xstream = new XStream(new DomDriver());
//      _writing = new File(backupTempFilePath + "/Users_Groups.xml");
//      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
//      _xstream.toXML(_list, _bout);
//      _bout.close();
//      _list = null;
//      _bout = null;
//
//      /* users_groups */
//      dc.setSQL("select * from groups_roles");
//      _list = dc.getResults();
//      _xstream = new XStream(new DomDriver());
//      _writing = new File(backupTempFilePath + "/Groups_Roles.xml");
//      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
//      _xstream.toXML(_list, _bout);
//      _bout.close();
//      _list = null;
//      _bout = null;


      /* counter */
      dc.setSQL("select * from counter");
      _list = dc.getResults();
      _xstream = new XStream(new DomDriver());
      _writing = new File(backupTempFilePath + "/Counter.xml");
      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
      _xstream.toXML(_list, _bout);
      _bout.close();
      _list = null;
      _bout = null;


      /* counter */
      dc.setSQL("select * from address");
      _list = dc.getResults();
      _xstream = new XStream(new DomDriver());
      _writing = new File(backupTempFilePath + "/Address.xml");
      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
      _xstream.toXML(_list, _bout);
      _bout.close();
      _list = null;
      _bout = null;


      /* pollschoice */
      dc.setSQL("select * from pollschoice");
      _list = dc.getResults();
      _xstream = new XStream(new DomDriver());
      _writing = new File(backupTempFilePath + "/Pollschoice.xml");
      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
      _xstream.toXML(_list, _bout);
      _bout.close();
      _list = null;
      _bout = null;


      /* pollsdisplay */
      dc.setSQL("select * from pollsdisplay");
      _list = dc.getResults();
      _xstream = new XStream(new DomDriver());
      _writing = new File(backupTempFilePath + "/Pollsdisplay.xml");
      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
      _xstream.toXML(_list, _bout);
      _bout.close();
      _list = null;
      _bout = null;


      /* pollsquestion */
      dc.setSQL("select * from pollsquestion");
      _list = dc.getResults();
      _xstream = new XStream(new DomDriver());
      _writing = new File(backupTempFilePath + "/Pollsquestion.xml");
      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
      _xstream.toXML(_list, _bout);
      _bout.close();
      _list = null;
      _bout = null;


      /* pollsvote */
      dc.setSQL("select * from pollsvote");
      _list = dc.getResults();
      _xstream = new XStream(new DomDriver());
      _writing = new File(backupTempFilePath + "/Pollsvote.xml");
      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
      _xstream.toXML(_list, _bout);
      _bout.close();
      _list = null;
      _bout = null;


      /* image */
      _list = ImageLocalManagerUtil.getImages();


      /*
       * The changes in this part were made for Oracle databases. Oracle has problems when
       * getString() method is called on a LONG field on an Oracle database. Because of this,
       * the object is loaded from liferay and DotConnect is not used
       * http://jira.dotmarketing.net/browse/DOTCMS-1911
       */


      _xstream = new XStream(new DomDriver());
      _writing = new File(backupTempFilePath + "/Image.xml");
      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
      _xstream.toXML(_list, _bout);
      _bout.close();
      _list = null;
      _bout = null;


      /* portlet */


      /*
       * The changes in this part were made for Oracle databases. Oracle has problems when
       * getString() method is called on a LONG field on an Oracle database. Because of this,
       * the object is loaded from liferay and DotConnect is not used
       * http://jira.dotmarketing.net/browse/DOTCMS-1911
       */
      dc.setSQL("select * from portlet");
      _list = dc.getResults();
      _xstream = new XStream(new DomDriver());
      _writing = new File(backupTempFilePath + "/Portlet.xml");
      _bout = new BufferedOutputStream(new FileOutputStream(_writing));
      _xstream.toXML(_list, _bout);
      _bout.close();

View Full Code Here

        perm = contAPI.findContentletByIdentifier(assetId, false, APILocator.getLanguageAPI().getDefaultLanguage().getId(), user, respectFrontendRoles);
      } catch (DotContentletStateException e) {
      }
    }
    if(perm == null) {
      DotConnect dc = new DotConnect();
      String assetType ="";
      dc.setSQL("select asset_type as type from identifier where id = ?");
      dc.addParam(assetId);
      ArrayList idResults = dc.loadResults();
      if(idResults.size()>0){
         assetType = (String)((Map)idResults.get(0)).get("type");


         dc.setSQL("select inode, type from inode,"+assetType+" asset,identifier where inode.inode = asset.inode and " +
                "asset.identifier = identifier.id and asset.identifier = ?");
         dc.addParam(assetId);
         ArrayList results = dc.loadResults();


        if(results.size() > 0) {
          String inode = (String) ((Map)results.get(0)).get("inode");
          perm = InodeFactory.getInode(inode, Inode.class);
        }

View Full Code Here

   * 
   * @return If the inode has children return true, false otherwise
   */
  public boolean hasChildren() {


    DotConnect dc = new DotConnect();
    String query = "select count(*) as c from tree where tree.parent = '"
        + this.inode + "'";
    dc.setSQL(query);


    return dc.getInt("c") > 0;
  }

View Full Code Here

            // get working and live version for all languages based on the identifier
//            String sql = "select distinct inode from contentlet join contentlet_version_info " +
//                    " on (inode=live_inode or inode=working_inode) and contentlet.identifier=?";
            String sql = "select working_inode,live_inode from contentlet_version_info where identifier=?";
          
            DotConnect dc = new DotConnect();
            dc.setSQL(sql);
            dc.addParam(ident);
            List<Map<String,String>> ret = dc.loadResults();
            List<String> inodes = new ArrayList<String>(); 
            for(Map<String,String> m : ret) {
              String workingInode = m.get("working_inode");
              String liveInode = m.get("live_inode");
              inodes.add(workingInode);

View Full Code Here


      if(thereiscategory) {
          String categoriesSQL = "select category.category_velocity_var_name as cat_velocity_var "+
                    " from  category join tree on (tree.parent = category.inode) join contentlet c on (c.inode = tree.child) " +
                    " where c.inode = ?";
          DotConnect db = new DotConnect();
            db.setSQL(categoriesSQL);
            db.addParam(con.getInode());
            ArrayList<String> categories=new ArrayList<String>();
          List<HashMap<String, String>> categoriesResults = db.loadResults();
          for (HashMap<String, String> crow : categoriesResults)
              categories.add(crow.get("cat_velocity_var"));


          categoriesString=UtilMethods.join(categories, " ").trim();

View Full Code Here

      List<String> dependenciesToReindex = new ArrayList<String>();


      ContentletAPI conAPI=APILocator.getContentletAPI();


      String relatedSQL = "select tree.* from tree where parent = ? or child = ? order by tree_order";
      DotConnect db = new DotConnect();
      db.setSQL(relatedSQL);
        db.addParam(con.getIdentifier());
        db.addParam(con.getIdentifier());
        ArrayList<HashMap<String, String>> relatedContentlets = db.loadResults();


        if(relatedContentlets.size()>0) {


            List<Relationship> relationships = RelationshipFactory.getAllRelationshipsByStructure(con.getStructure());

View Full Code Here

        }
        return dependenciesToReindex;
  }


  protected void loadRelationshipFields(Contentlet con, Map<String,String> m) throws DotStateException, DotDataException {
      DotConnect db = new DotConnect();
        db.setSQL("select * from tree where parent = ? or child = ? order by tree_order asc");
        db.addParam(con.getIdentifier());
        db.addParam(con.getIdentifier());


        for(Map<String, Object> relatedEntry : db.loadObjectResults()) {


            String childId = relatedEntry.get("child").toString();
            String parentId = relatedEntry.get("parent").toString();
            String relType=relatedEntry.get("relation_type").toString();
            String order = relatedEntry.get("tree_order").toString();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.dotmarketing.common.db.DotConnect

com.dotcms.content.elasticsearch.business.ESContentFactoryImpl

com.dotcms.content.elasticsearch.business.ESContentFactoryImplTest

com.dotcms.content.elasticsearch.business.ESContentletAPIImpl

com.dotcms.content.elasticsearch.business.ESContentletIndexAPI

com.dotcms.content.elasticsearch.business.ESMappingAPIImpl

com.dotcms.content.elasticsearch.business.IndiciesFactoryImpl

com.dotcms.content.elasticsearch.util.ESReindexationProcessStatus

com.dotcms.journal.business.ESDistributedJournalFactoryImpl

com.dotcms.notifications.business.NotificationFactoryImpl

com.dotcms.publisher.assets.business.PushedAssetsFactoryImpl

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.