Package com.dotmarketing.common.db

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


              dc.addParam(identifierToDelete.get("id"));
              dc.loadResult();
             
              dc.setSQL(deleteInodes);
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.loadResult();
            }
          }
         
View Full Code Here


              dc.loadResult();
             
              dc.setSQL(deleteInodes);
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.addParam(identifierToDelete.get("id"));
              dc.loadResult();
            }
          }
         
          if (assetDeleted) {
View Full Code Here

            }
          }
         
          if (assetDeleted) {
            dc.setSQL(deleteIdentifier);
            dc.addParam(identifierToDelete.get("id"));
            dc.loadResult();
           
            Logger.debug(this, "Delete completed");
          }
        }
View Full Code Here

    }else if(c.equals(Inode.class)){
      Logger.debug(InodeFactory.class, "You should not send Inode.class to getInode.  Send the extending class instead (inode:" + x + ")" );
      //Thread.dumpStack();
      DotConnect dc = new DotConnect();
      dc.setSQL("select type from inode where inode = ?");
      dc.addParam(x);
      try {
        if(dc.loadResults().size()>0){
          c = InodeUtils.getClassByDBType(dc.getString("type"));
        }
        else{
View Full Code Here

        // workaround for dbs where we can't have more than one constraint
        // or triggers
        DotConnect db = new DotConnect();
        db.setSQL("delete from tree where child = ? or parent =?");
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.getResult();
 
        // workaround for dbs where we can't have more than one constraint
        // or triggers
View Full Code Here

        // workaround for dbs where we can't have more than one constraint
        // or triggers
        DotConnect db = new DotConnect();
        db.setSQL("delete from tree where child = ? or parent =?");
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.getResult();
 
        // workaround for dbs where we can't have more than one constraint
        // or triggers
        db.setSQL("delete from multi_tree where child = ? or parent1 =? or parent2 = ?");
View Full Code Here

                    List<Map<String, Object>> results = dc.loadObjectResults();
                    for(Map<String, Object> rr : results) {
                        String id=rr.get("id").toString();
                        sql="select inode from "+table+" where identifier=? order by mod_date desc";
                        dc.setSQL(sql);
                        dc.addParam(id);
                        List<Map<String, Object>> versions = dc.loadObjectResults();
                        String inode=versions.get(0).get("inode").toString();
                       
                        HibernateUtil hu=new HibernateUtil(UtilMethods.getVersionableClass(table));
                        Versionable workingVersion=(Versionable) hu.load(inode);
View Full Code Here

        db.getResult();
 
        // workaround for dbs where we can't have more than one constraint
        // or triggers
        db.setSQL("delete from multi_tree where child = ? or parent1 =? or parent2 = ?");
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.getResult();
                   
      HibernateUtil.delete(o);
View Full Code Here

 
        // workaround for dbs where we can't have more than one constraint
        // or triggers
        db.setSQL("delete from multi_tree where child = ? or parent1 =? or parent2 = ?");
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.getResult();
                   
      HibernateUtil.delete(o);
      db.setSQL("delete from inode where inode = ?");
View Full Code Here

        // workaround for dbs where we can't have more than one constraint
        // or triggers
        db.setSQL("delete from multi_tree where child = ? or parent1 =? or parent2 = ?");
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.addParam(inode.getInode());
        db.getResult();
                   
      HibernateUtil.delete(o);
      db.setSQL("delete from inode where inode = ?");
      db.addParam(inode.getInode());
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.