Package com.knowgate.dataobjs

Examples of com.knowgate.dataobjs.DBSubset.load()


    }
    // Deleting the category will delete the associated MimeMessages, but it is faster to do it first
    // for avoiding lots of calls to MimeMessage.delete() method
    for (int d=0; d<iSize; d++) {
      DBSubset oDeleted = new DBSubset(DB.k_mime_msgs, DB.gu_mimemsg, DB.gu_category+"=?", 100);
      oDeleted.load(oConn, new Object[]{oCatgSet.getString(0,d)});
      final int iDeleted = oDeleted.getRowCount();
      if (oConn.getDataBaseProduct()==JDCConnection.DBMS_POSTGRESQL) {
        Statement oStmt = oConn.createStatement();
        for (int m=0; m<iDeleted; m++) {
          oStmt.executeQuery("SELECT k_sp_del_mime_msg('" + oDeleted.getString(0,m) + "')");
View Full Code Here


  public boolean delete(JDCConnection oConn)
    throws SQLException {
    ACLUser oUsr = new ACLUser(getString(DB.gu_user));
    Category oRootCat = new Category(oConn, oUsr.getMailRoot(oConn));
    DBSubset oMailFoldersCatgs = new DBSubset(DB.k_cat_tree, DB.gu_child_cat, DB.gu_parent_cat+"=?", 10);
    oMailFoldersCatgs.load(oConn, new Object[]{oRootCat.getString(DB.gu_category)});
    try {
      deleteCategorySet(oConn, oMailFoldersCatgs);
    } catch (IOException ioe) {
      throw new SQLException (ioe.getMessage());
    }
View Full Code Here

      DebugFile.writeln("Begin QueryByForm.delete([Connection]," + sQBFGUID + ")");
      DebugFile.incIdent();
    }

    DBSubset oLists = new DBSubset(DB.k_lists, DB.gu_list, DB.gu_query+"=?", 10);
    int iLists = oLists.load(oConn, new Object[]{sQBFGUID});

    for (int l=0; l<iLists; l++) {
      DistributionList.delete(oConn, oLists.getString(0,l));
    } // next
View Full Code Here

    }

    try { oDuties.store(oConn, oDuty.getClass(), true); }
    catch (java.lang.InstantiationException ignore) { /* never thrown*/ }

    int iBugs = oBugs.load (oConn, new Object[]{get(DB.gu_project)});

    if (DebugFile.trace) DebugFile.writeln(String.valueOf(iBugs) + " bugs loaded for " + getString(DB.gu_project));

    for (int b=0; b<iBugs; b++) {
      oBugs.setElementAt(Gadgets.generateUUID(), 0, b);
View Full Code Here

      try {
        oDuties.store(oConn, oDuty.getClass(), true);
      }
      catch (java.lang.InstantiationException ignore) { /* never thrown*/ }

      iBugs = oBugs.load (oConn, new Object[]{oProj.get(DB.gu_project)});

      if (DebugFile.trace) DebugFile.writeln(String.valueOf(iBugs) + " bugs loaded for " + oProj.getString(DB.gu_project));

      for (int b=0; b<iBugs; b++) {
        oBugs.setElementAt(Gadgets.generateUUID(), 0, b);
View Full Code Here

    DBSubset oTree = new DBSubset(DB.k_project_expand + " e," + DB.k_projects + " p",
                                  "e."+DB.gu_project + ",e." + DB.nm_project + ",e." + DB.od_level + ",e." + DB.od_walk + ",e." + DB.gu_parent + ",p." +DB.id_status + ",p." +DB.gu_company + ",p." +DB.gu_contact + ",p." +DB.gu_user,
                                  "e."+DB.gu_project + "=p." + DB.gu_project + " AND " +
                                  DB.gu_rootprj + "='" + getString(DB.gu_project) + "' ORDER BY " + DB.od_walk, 50);

    int iChildCount = oTree.load(oConn);

    if (DebugFile.trace) {
      for (int c=0; c<iChildCount; c++)
        DebugFile.writeln(String.valueOf(oTree.getInt(3,c))+" lv="+String.valueOf(oTree.getInt(2,c))+",gu="+oTree.getString(0,c)+",nm="+oTree.getString(1,c));
      DebugFile.decIdent();
View Full Code Here

  oAttrs.put("id_project", String.valueOf(aIdCounters[0]));
 
  String sXml = toXML(oConn, sIdent, "\n", oAttrs);

  DBSubset oDuties = new DBSubset (DB.k_duties, "*", DB.gu_project+"=? ORDER BY "+DB.dt_modified+" DESC", 50);
  int nDuties = oDuties.load(oConn, new Object[]{getString(DB.gu_project)});

    if (DebugFile.trace) DebugFile.writeln("duties count is "+String.valueOf(nDuties));

  DBSubset oBugs = new DBSubset (DB.k_bugs, "*", DB.gu_project+"=? ORDER BY "+DB.dt_modified+" DESC", 50);
  int nBugs = oBugs.load(oConn, new Object[]{getString(DB.gu_project)});
View Full Code Here

  int nDuties = oDuties.load(oConn, new Object[]{getString(DB.gu_project)});

    if (DebugFile.trace) DebugFile.writeln("duties count is "+String.valueOf(nDuties));

  DBSubset oBugs = new DBSubset (DB.k_bugs, "*", DB.gu_project+"=? ORDER BY "+DB.dt_modified+" DESC", 50);
  int nBugs = oBugs.load(oConn, new Object[]{getString(DB.gu_project)});

    if (DebugFile.trace) DebugFile.writeln("bugs count is "+String.valueOf(nBugs));

  DBSubset oSubp = new DBSubset (DB.k_projects, "*", DB.  id_parent+"=? ORDER BY "+DB.dt_start+","+DB.dt_end, 20);
  int nSubp = oSubp.load(oConn, new Object[]{getString(DB.gu_project)});
View Full Code Here

  int nBugs = oBugs.load(oConn, new Object[]{getString(DB.gu_project)});

    if (DebugFile.trace) DebugFile.writeln("bugs count is "+String.valueOf(nBugs));

  DBSubset oSubp = new DBSubset (DB.k_projects, "*", DB.  id_parent+"=? ORDER BY "+DB.dt_start+","+DB.dt_end, 20);
  int nSubp = oSubp.load(oConn, new Object[]{getString(DB.gu_project)});

    if (DebugFile.trace) DebugFile.writeln("subprojects count is "+String.valueOf(nSubp));

    StringBuffer oSS = new StringBuffer(sXml.length()+256*nDuties+256*nBugs+4000*nSubp);

 
View Full Code Here

    iUsrPerms = oUsrPerms.load(oConn);

    if (DebugFile.trace) DebugFile.writeln("  loading group permissions from " + DB.k_x_cat_group_acl);

    iGrpPerms = oGrpPerms.load(oConn);

    if (DebugFile.trace) DebugFile.writeln("  Connection.executeUpdate(" + "DELETE FROM " + DB.k_x_cat_user_acl + " WHERE " + DB.gu_category + "='" + sIdCategory + "')");

    oDelete.executeUpdate("DELETE FROM " + DB.k_x_cat_user_acl + " WHERE " + DB.gu_category + "='" + sIdCategory + "'");
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.