Examples of com.knowgate.dataobjs.DBSubset

com.knowgate.dataobjs.DBSubset

A bidimensional array representing data readed from a database table.
The DBSubset object is used for reading a collection of registers from the database and kept them in memory for inmediate access. As hipergate reuses database connections by recycling them at the {@link JDCConnectionPool}, it is a good programming practice to read just the needed number of registers in a single step operation and then free the connection as soon as possible for being used by another processs. Another reason for this "read fast and leave" tactic is that some JDBC drivers have problems managing multiple open resultsets with pending results in a single connection. @author Sergio Montoro Ten @version 3.0

    if (DebugFile.trace) {
      DebugFile.writeln("Begin WeekPlan.getDistinctFellows([JDCConnection])");
      DebugFile.incIdent();
    }
    
    DBSubset oFellows;
    Timestamp dtFirst = new Timestamp(dtFrom.getYear(),dtFrom.getMonth(),dtFrom.getDate(),0,0,0,0);
    Timestamp dtLast = new Timestamp(dtFirst.getTime()+WeekMilis);
    int nFellows = 0;
    Fellow[] aFellows;
    if (null==sWorkAreaGuid) {
      oFellows = new DBSubset (
        DB.k_fellows+" f",
        new Fellow().getTable(oConn).getColumnsStr(),
        "f."+DB.id_domain+"=? AND ("+
        "EXISTS (SELECT m."+DB.gu_fellow+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_fellow+"=f."+DB.gu_fellow+" AND m."+DB.dt_start+" BETWEEN ? AND ?) OR "+
        "EXISTS (SELECT x."+DB.gu_fellow+" FROM "+DB.k_x_meeting_fellow+" x WHERE x."+DB.gu_fellow+"=f."+DB.gu_fellow+" AND x."+DB.dt_start+" BETWEEN ? AND ?))"+
        " ORDER BY "+DB.tx_name+","+DB.tx_surname, 10);
      nFellows = oFellows.load(oConn, new Object[]{oDomainId,dtFirst,dtLast,dtFirst,dtLast});
    } else {
      oFellows = new DBSubset (
        DB.k_fellows+" f",
        new Fellow().getTable(oConn).getColumnsStr(),
        "f."+DB.id_domain+"=? AND f."+DB.gu_workarea+"=? AND ("+
        "EXISTS (SELECT m."+DB.gu_fellow+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_fellow+"=f."+DB.gu_fellow+" AND m."+DB.dt_start+" BETWEEN ? AND ?) OR "+
        "EXISTS (SELECT x."+DB.gu_fellow+" FROM "+DB.k_x_meeting_fellow+" x WHERE x."+DB.gu_fellow+"=f."+DB.gu_fellow+" AND x."+DB.dt_start+" BETWEEN ? AND ?))"+
        " ORDER BY "+DB.tx_name+","+DB.tx_surname, 10);
      nFellows = oFellows.load(oConn, new Object[]{oDomainId,sWorkAreaGuid,dtFirst,dtLast,dtFirst,dtLast});
    } // fi
    if (0==nFellows) {
      aFellows = null;
    } else {
      aFellows = new Fellow[nFellows];
      for (int f=0; f<nFellows; f++) {
        aFellows[f] = new Fellow();
      aFellows[f].putAll(oFellows.getRowAsMap(f));
      } // next
    } // fi (nFellows)


    if (DebugFile.trace) {
      DebugFile.decIdent();

View Full Code Here


    // ------------------------------------------------------------------------


  public Room[] getDistinctRooms(JDCConnection oConn)
    throws SQLException {
    DBSubset oRooms;
    Timestamp dtFirst = new Timestamp(dtFrom.getYear(),dtFrom.getMonth(),dtFrom.getDate(),0,0,0,0);
    Timestamp dtLast = new Timestamp(dtFirst.getTime()+WeekMilis);
    int nRooms = 0;
    Room[] aRooms;
    if (null==sWorkAreaGuid) {
      oRooms = new DBSubset (
        DB.k_rooms+" r",
        new Room().getTable(oConn).getColumnsStr(),
        "r."+DB.id_domain+"=? AND "+
        "EXISTS (SELECT x."+DB.nm_room+" FROM "+DB.k_x_meeting_room+" x WHERE x."+DB.nm_room+"=r."+DB.nm_room+" AND x."+DB.gu_meeting+" IN (SELECT "+DB.gu_meeting+" FROM "+DB.k_meetings+" WHERE "+DB.id_domain+"=? AND "+DB.dt_start+" BETWEEN ? AND ?))"+
        " ORDER BY "+DB.nm_room, 10);
      nRooms = oRooms.load(oConn, new Object[]{oDomainId,oDomainId,dtFirst,dtLast});
    } else {
      oRooms = new DBSubset (
        DB.k_rooms+" r",
        new Room().getTable(oConn).getColumnsStr(),
        "r."+DB.id_domain+"=? AND r."+DB.gu_workarea+"=? AND "+
        "EXISTS (SELECT x."+DB.nm_room+" FROM "+DB.k_x_meeting_room+" x WHERE x."+DB.nm_room+"=r."+DB.nm_room+" AND x."+DB.gu_meeting+" IN (SELECT "+DB.gu_meeting+" FROM "+DB.k_meetings+" WHERE "+DB.id_domain+"=? AND "+DB.gu_workarea+"=? AND "+DB.dt_start+" BETWEEN ? AND ?))"+
        " ORDER BY "+DB.nm_room, 10);
      nRooms = oRooms.load(oConn, new Object[]{oDomainId,sWorkAreaGuid,oDomainId,sWorkAreaGuid,dtFirst,dtLast});
    } // fi
    if (0==nRooms) {
      aRooms = null;
    } else {
      aRooms = new Room[nRooms];
      for (int r=0; r<nRooms; r++) {
        aRooms[r] = new Room();
      aRooms[r].putAll(oRooms.getRowAsMap(r));
      } // next
    }
    return aRooms;
  } // getDistinctRooms

View Full Code Here


    // ------------------------------------------------------------------------


  public Address[] getDistinctAddresses(JDCConnection oConn)
    throws SQLException {
    DBSubset oAddresses;
    Timestamp dtFirst = new Timestamp(dtFrom.getYear(),dtFrom.getMonth(),dtFrom.getDate(),0,0,0,0);
    Timestamp dtLast = new Timestamp(dtFirst.getTime()+WeekMilis);
    int nAddresses = 0;
    Address[] aAddresses;
    if (null==sWorkAreaGuid) {
      oAddresses = new DBSubset (
        DB.k_addresses+" a",
        new Address().getTable(oConn).getColumnsStr(),
        "EXISTS (SELECT m."+DB.gu_address+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_address+"=a."+DB.gu_address+" AND m."+DB.id_domain+"=? AND m."+DB.dt_start+" BETWEEN ? AND ?)",
        10);
      nAddresses = oAddresses.load(oConn, new Object[]{oDomainId,dtFirst,dtLast});
    } else {
      oAddresses = new DBSubset (
        DB.k_addresses+" a",
        new Address().getTable(oConn).getColumnsStr(),
        "EXISTS (SELECT m."+DB.gu_address+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_address+"=a."+DB.gu_address+" AND m."+DB.id_domain+"=? AND m."+DB.gu_workarea+"=? AND m."+DB.dt_start+" BETWEEN ? AND ?)",
        10);
      nAddresses = oAddresses.load(oConn, new Object[]{oDomainId,sWorkAreaGuid,dtFirst,dtLast});
    } // fi
    if (0==nAddresses) {
      aAddresses = null;
    } else {
      aAddresses = new Address[nAddresses];
      for (int a=0; a<nAddresses; a++) {
        aAddresses[a] = new Address();
      aAddresses[a].putAll(oAddresses.getRowAsMap(a));
      } // next
    }
    return aAddresses;
  } // getDistinctAddresses

View Full Code Here

   * @throws SQLException
   * @since 4.0
   */
  public DBSubset getGroups(JDCConnection oConn) throws SQLException {
    Object aContact[] = { get(DB.gu_contact) };
    DBSubset oGroups = new DBSubset(DB.k_x_group_contact,DB.gu_acl_group,DB.gu_contact + "=?",10);


    oGroups.load (oConn, aContact);
    return oGroups;
  } // getGroups

View Full Code Here


    if (isNull(DB.gu_contact)) throw new NullPointerException ("gu_contact not set");


    Address oAddr = new Address();


    DBSubset oAddrs = new DBSubset (DB.k_addresses,
                                    oAddr.getTable(oConn).getColumnsStr(),
                                    DB.gu_address + " IN (SELECT " + DB.gu_address +  " FROM " + DB.k_x_contact_addr + " WHERE " + DB.gu_contact + "='" + getString(DB.gu_contact) + "')", 10);
    int iAddrs = oAddrs.load (oConn);


    oAddr = null;


    if (DebugFile.trace) {
      DebugFile.decIdent();

View Full Code Here

    if (isNull(DB.gu_contact))
      throw new IllegalStateException("Contact.getAllBankAccounts() gu_contact property is not set");
    if (isNull(DB.gu_workarea))
      throw new IllegalStateException("Contact.getAllBankAccounts() gu_workarea property is not set");


    DBSubset oAccs = new DBSubset (DB.k_bank_accounts,
                                   DB.nu_bank_acc+","+DB.dt_created+","+DB.bo_active+","+DB.tp_account+","+DB.nm_bank+","+DB.tx_addr+","+DB.nm_cardholder+","+DB.nu_card+","+DB.tp_card+","+DB.tx_expire+","+DB.nu_pin+","+DB.nu_cvv2+","+DB.im_credit_limit+","+DB.de_bank_acc,
                                   DB.gu_workarea+"=? AND "+DB.nu_bank_acc+" IN (SELECT "+DB.nu_bank_acc+" FROM "+DB.k_x_contact_bank+" WHERE "+DB.gu_workarea+"=? AND "+DB.gu_contact+"=?)",10);


    oAccs.load(oConn, new Object[]{get(DB.gu_workarea),get(DB.gu_workarea),get(DB.gu_contact)});
    return oAccs;
  } // getAllBankAccounts

View Full Code Here

    if (isNull(DB.gu_contact))
      throw new IllegalStateException("Contact.getActiveBankAccounts() gu_contact property is not set");
    if (isNull(DB.gu_workarea))
      throw new IllegalStateException("Contact.getActiveBankAccounts() gu_workarea property is not set");


    DBSubset oAccs = new DBSubset (DB.k_bank_accounts,
                                   DB.nu_bank_acc+","+DB.dt_created+","+DB.tp_account+","+DB.nm_bank+","+DB.tx_addr+","+DB.nm_cardholder+","+DB.nu_card+","+DB.tp_card+","+DB.tx_expire+","+DB.nu_pin+","+DB.nu_cvv2+","+DB.im_credit_limit+","+DB.de_bank_acc,
                                   DB.gu_workarea+"=? AND "+DB.bo_active+"<>0 AND "+DB.nu_bank_acc+" IN (SELECT "+DB.nu_bank_acc+" FROM "+DB.k_x_contact_bank+" WHERE "+DB.gu_workarea+"=? AND "+DB.gu_contact+"=?)",10);


    oAccs.load(oConn, new Object[]{get(DB.gu_workarea),get(DB.gu_workarea),get(DB.gu_contact)});
    return oAccs;
  } // getActiveBankAccounts

View Full Code Here

    if (isNull(DB.gu_company))
      throw new IllegalStateException("Contact.getUnactiveBankAccounts() gu_company property is not set");
    if (isNull(DB.gu_workarea))
      throw new IllegalStateException("Contact.getUnactiveBankAccounts() gu_contact property is not set");


    DBSubset oAccs = new DBSubset (DB.k_bank_accounts,
                                   DB.nu_bank_acc+","+DB.dt_created+","+DB.tp_account+","+DB.nm_bank+","+DB.tx_addr+","+DB.nm_cardholder+","+DB.nu_card+","+DB.tp_card+","+DB.tx_expire+","+DB.nu_pin+","+DB.nu_cvv2+","+DB.im_credit_limit+","+DB.de_bank_acc,
                                   DB.gu_workarea+"=? AND "+DB.bo_active+"=0 AND "+DB.nu_bank_acc+" IN (SELECT "+DB.nu_bank_acc+" FROM "+DB.k_x_contact_bank+" WHERE "+DB.gu_workarea+"=? AND "+DB.gu_company+"=?)",10);


    oAccs.load(oConn, new Object[]{get(DB.gu_workarea),get(DB.gu_workarea),get(DB.gu_contact)});
    return oAccs;
  } // getUnactiveBankAccounts

View Full Code Here

    if (isNull(DB.gu_contact))
      throw new NullPointerException("Contact.getAttachments() Contact not loaded");


    Attachment oAttach = new Attachment();
    Attachment[] aAttachs;
    DBSubset oAttachs = new DBSubset(DB.k_contact_attachs,
                                     oAttach.getTable(oConn).getColumnsStr(),
                                     DB.gu_contact+"=?", 10);
    int iAttachs = oAttachs.load(oConn, new Object[]{get(DB.gu_contact)});
    if (0==iAttachs) {
      aAttachs = null;
    } else {
      aAttachs = new Attachment[iAttachs];
      ListIterator oCols = oAttach.getTable(oConn).getColumns().listIterator();
      while (oCols.hasNext()) {
        String sKey = (String) oCols.next();
        if (!sKey.equalsIgnoreCase(DB.dt_created)) {
          for (int a=0; a<iAttachs; a++) {
            aAttachs[a].put(sKey, oAttachs.get(sKey,a));
          } // next (a)
        } // fi (sKey!="dt_created")
      } // wend
    } // fi (iAttachs)
    return aAttachs;

View Full Code Here

   * @since 4.0
   */
  public String toXML(JDCConnection oConn, String sIdent, String sDelim)
    throws IllegalStateException,SQLException {
    String sXml = toXML(sIdent, sDelim);
  DBSubset oAddrs = getAddresses(oConn);
  int nAddrs = oAddrs.getRowCount();
    StringBuffer oXml = new StringBuffer(sXml.length()+512*nAddrs);
  oXml.append(sXml.substring(0,sXml.indexOf(sIdent + "</" + sAuditCls + ">")));
  oXml.append(sIdent+"  <Addresses count=\""+String.valueOf(nAddrs)+"\">"+sDelim);
  Address oAddr = new Address();
  oAddr.getTable(oConn);
  for (int a=0; a<nAddrs; a++) {
    oAddr.putAll(oAddrs.getRowAsMap(a));
    oXml.append(oAddr.toXML(sIdent+"    ", sDelim));
    oXml.append(sDelim);
    oAddr.clear();
  } // next
  oXml.append(sIdent+"  </Addresses>"+sDelim);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.knowgate.dataobjs.DBSubset

com.knowgate.acl.ACLDomain

com.knowgate.acl.ACLGroup

com.knowgate.acl.ACLUser

com.knowgate.addrbook.DayPlan

com.knowgate.addrbook.jical.ICalendarFactory

com.knowgate.addrbook.Meeting

com.knowgate.addrbook.MonthPlan

com.knowgate.addrbook.WeekPlan

com.knowgate.addrbook.WorkingCalendar

com.knowgate.crm.Company

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.