Examples of com.knowgate.datacopy.DataStruct

com.knowgate.datacopy.DataStruct

Copier for Complex Data Structures stored at database.
This is not a general purpose module, but a custom class tailored to the design constraints of hipergate standard datamodel. @author Sergio Montoro Ten @version 0.6 alpha

    if (DebugFile.trace) {
      DebugFile.writeln("Begin Contact.clone(" + sTargetWorkAreaId + "," + sNewOwnerId + ")");
      DebugFile.incIdent();
    }


  DataStruct oDS = null;
    Object[] oPKOr = new Object[] { getString(DB.gu_contact) };
  Object[] oPKTr = new Object[] { Gadgets.generateUUID() } ;
  String sContactXml = null;
  String sCompanyXml = null;
  
  FileSystemWorkArea oFsw = new FileSystemWorkArea(((DBBind)oConn.getPool().getDatabaseBinding()).getProperties());
    try {
        switch (oConn.getDataBaseProduct()) {
          case com.knowgate.jdc.JDCConnection.DBMS_MSSQL:
            sContactXml = oFsw.readstorfilestr("datacopy/mssql/contact_clon.xml", "UTF-8");
            sCompanyXml = oFsw.readstorfilestr("datacopy/mssql/company_clon.xml", "UTF-8");
            break;
          case com.knowgate.jdc.JDCConnection.DBMS_MYSQL:
            sContactXml = oFsw.readstorfilestr("datacopy//mysql/contact_clon.xml", "UTF-8");
            sCompanyXml = oFsw.readstorfilestr("datacopy//mysql/company_clon.xml", "UTF-8");
            break;
          case com.knowgate.jdc.JDCConnection.DBMS_ORACLE:
            sContactXml = oFsw.readstorfilestr("datacopy/oracle/contact_clon.xml", "UTF-8");
            sCompanyXml = oFsw.readstorfilestr("datacopy/oracle/company_clon.xml", "UTF-8");
            break;
          case com.knowgate.jdc.JDCConnection.DBMS_POSTGRESQL:
            sContactXml = oFsw.readstorfilestr("datacopy/postgresql/contact_clon.xml", "UTF-8");
            sCompanyXml = oFsw.readstorfilestr("datacopy/postgresql/company_clon.xml", "UTF-8");
            break;
          default:
            if (DebugFile.trace) {
              DebugFile.writeln("Unsupported database "+oConn.getMetaData().getDatabaseProductName());
              DebugFile.decIdent();
            }
            throw new SQLException ("Unsupported database "+oConn.getMetaData().getDatabaseProductName());
        }
    } catch (com.enterprisedt.net.ftp.FTPException neverthrown) { }
    catch (IOException ioe) { throw new SQLException (ioe.getMessage(), ioe); }


    Properties oParams = new Properties();
    oParams.put("WorkAreaId", sTargetWorkAreaId==null ? getString(DB.gu_workarea) : sTargetWorkAreaId);
    oParams.put("OwnerId", sNewOwnerId==null ? getStringNull(DB.gu_writer,null) : sNewOwnerId);


  try {
    String sCompanyGuid = null;


    if (!isNull(DB.gu_company) && !getString(DB.gu_workarea).equals(sTargetWorkAreaId)) {        
        String[] aCompanyInfo = DBCommand.queryStrs(oConn, "SELECT "+DB.nm_legal+","+DB.id_legal+" FROM "+DB.k_companies+" WHERE "+DB.gu_company+"='"+getString(DB.gu_company)+"'");
        
        PreparedStatement oStmt = oConn.prepareStatement("SELECT "+DB.gu_company+" FROM "+DB.k_companies+" WHERE "+DB.gu_workarea+"='"+sTargetWorkAreaId+"' AND ("+DB.nm_legal+"=? OR "+DB.id_legal+"=?)", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
    oStmt.setString(1, aCompanyInfo[0]);
    oStmt.setString(2, aCompanyInfo[1]);
    ResultSet oRSet = oStmt.executeQuery();
    if (oRSet.next())
      sCompanyGuid = oRSet.getString(1);
    else
      sCompanyGuid = Gadgets.generateUUID();
    oRSet.close();
    oStmt.close();


        oDS = new DataStruct();
        oDS.setOriginConnection(oConn);
        oDS.setTargetConnection(oConn);
        oDS.setAutoCommit(false);
        oDS.parse (sCompanyXml, oParams);
        oDS.insert(new Object[]{getString(DB.gu_company)}, new Object[]{sCompanyGuid}, 0);
      oDS.commit();
      oDS.clear();
      oDS = null;
    }
    
      oDS = new DataStruct();


      oDS.setOriginConnection(oConn);
      oDS.setTargetConnection(oConn);
      oDS.setAutoCommit(false);


      oDS.parse (sContactXml, oParams);
      oDS.insert(oPKOr, oPKTr, 0);
    oDS.commit();
    
    if (sCompanyGuid!=null)
      DBCommand.executeUpdate(oConn, "UPDATE "+DB.k_contacts+" SET "+DB.gu_company+"='"+sCompanyGuid+"' WHERE "+DB.gu_contact+"='"+oPKTr[0]+"'");


  } catch (SAXException se) {
    throw new SQLException (se.getMessage(), se);
  } catch (IOException io) {
    throw new SQLException (io.getMessage(), io);
  } catch (ClassNotFoundException ce) {
    throw new SQLException (ce.getMessage(), ce);
  } catch (IllegalAccessException ia) {
    throw new SQLException (ia.getMessage(), ia);
  } catch (InstantiationException ie) {
    throw new SQLException (ie.getMessage(), ie);
  } finally {
      if (oDS!=null) oDS.clear();
  }


    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End Contact.clone()");

View Full Code Here

  
    Properties oParams = new Properties();
    oParams.put("IdWorkArea", sTargetWorkArea);
    oParams.put("IdOwner", sNewOwnerId==null ? "null" : sNewOwnerId);


    DataStruct oCS = new DataStruct();
    DataStruct oDS = new DataStruct();


    oCS.setOriginConnection(oConn);
    oCS.setTargetConnection(oConn);
    oCS.setAutoCommit(false);


    oDS.setOriginConnection(oConn);
    oDS.setTargetConnection(oConn);
    oDS.setAutoCommit(false);


    oCS.parse (sCompanyXml, oParams);
    oDS.parse (sContactXml, oParams);


  try {


    LinkedList<String> oContacts = new LinkedList<String>();
    LinkedList<String> oCompanies = new LinkedList<String>();


    oStmt = oConn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
    oRSet = oStmt.executeQuery("SELECT gu_contact,gu_company,gu_workarea FROM k_contacts WHERE "+sContactsFilter);
    while (oRSet.next()) {
      oContacts.add(oRSet.getString(1));
      String sCompany = oRSet.getString(2);
      if (!oRSet.wasNull()) {
        if (!sTargetWorkArea.equals(oRSet.getString(3))) {
          oCompanies.add(sCompany);
        }
      }
    } // wend
    oRSet.close();
    oRSet=null;
    oStmt.close();
    oStmt=null;


    if (oCompanies.size()>0) {
      oIter = oCompanies.listIterator();
      while (oIter.hasNext()) {
        oPKOr[0] = oIter.next();
        oPKTr[0] = Gadgets.generateUUID();
          oCS.insert(oPKOr, oPKTr, 1);
        oCS.commit();
          if (null!=oStrLog) oStrLog.append("New Company "+oPKTr[0]+" created successfully\n");
      } // wend
    } // fi


    oIter = oContacts.listIterator();
    while (oIter.hasNext()) {
      oPKOr[0] = oIter.next();
      oPKTr[0] = Gadgets.generateUUID();
        oDS.insert(oPKOr, oPKTr, 1);
      oDS.commit();
        if (null!=oStrLog) oStrLog.append("New Contact "+oPKTr[0]+" created successfully\n");
    } // wend


  } catch (SQLException sqle) {
      if (null!=oStrLog) oStrLog.append("SQLException at ModelManager.cloneContacts() "+sqle.getMessage()+"\n");
    try { System.out.println(com.knowgate.debug.StackTraceUtil.getStackTrace(sqle));}
    catch (Exception ignore){}
  } finally {
    if (null!=oRSet) oRSet.close();
    if (null!=oStmt) oStmt.close();
      oDS.clear();
      oCS.clear();
  }


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

View Full Code Here

TOP

Related Classes of com.knowgate.datacopy.DataStruct

com.knowgate.crm.Contact

com.knowgate.hipergate.datamodel.ModelManager

java.sql.ResultSetMetaData

java.io.BufferedReader

java.io.FileReader

java.sql.CallableStatement

java.sql.Statement

java.math.BigDecimal

java.io.File

java.io.StringBufferInputStream

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.