package com.apag.p2plus.p2objects;

import java.util.Date;
import java.io.*;
import java.net.*;

import com.apag.p2plus.p2masterdata.*;
import com.apag.p2plus.p2system.*;
import com.apag.p2plus.p2core.*;
import com.apag.p2plus.p2core.p2exceptions.*;
import com.apag.p2plus.p2xml.*;
import com.apag.p2plus.p2wp.*;
import com.apag.p2plus.p2stock.*;
import com.apag.p2plus.p2sales.*;
import com.apag.p2plus.p2script.*;
import com.apag.p2plus.p2test.*;
import com.apag.p2plus.p2tools.*;
import com.apag.p2plus.p2vis.*;
import java.util.*;
import java.util.regex.*;
import javax.swing.*;


public class Test
{
  public static void main(String[] args) throws Exception {
    ObjectManager manager, manager2, manager3;
    ObjectCollection coll;
//    ObjectCollection<ArtikelObject> gColl;
    ArtikelObject artikelObj, artikelObj2, artikelObj3;
    AuftragObject auftragObj;
    AdresseObject adresseObj;
    RechnungObject rechnungObj;
    WarenAusgangPosObject waPosObj;
    SysConfObject sysConfObj;
    AufstueliPosObject aufStueliPosObj;
    ArtikelGruppeObject artikelGruppeObject;
    LagerBewegungObject lagerBewegungObject;
    AktivitaetObject aktObj;
    SpecialObject specialObj;
    Debug debug;
    XMLDocument xmlDoc;
    XMLTag rootTag;
    StringBuffer sql, xml;
    Date abc, d2, d123, d1;
    int count, i, enum;
    
    xmlDoc = new XMLDocument(new File("C:\\useXML_StueliPos_replicate.xml"));
    new XML().useXML(xmlDoc.toString());
    System.exit(0);
    
    manager = new ObjectManager();
    ArtikelDispoObject ado;
    P2Time termin = new P2Time("30.09.2004 12:56:00");
    
    ado = ArtikelDispoFactory.create(manager, "aaa", "bbb", "ZA", new Short((short)1), null, termin, 11.0);
    ado.updateDirect();
    
    Transaction.complete();
    
    Transaction.spawn();
    manager = new ObjectManager();
    ado = ArtikelDispoFactory.search(manager, "bbb", new Short((short)1), "ZA", null, null, null, null, 0, true);
    System.out.println(ado.getTermin());
    
    ado.deleteDirect();
    Transaction.complete();

    System.exit(0);
    
//    Debug.setLevel(8);
//    Debug.setDebugOn(true);
//    TestTabelleObject testObj;
//    manager = new ObjectManager();
//    testObj = TestTabelleFactory.create(manager, true);
//    testObj.setWert1(true);
//    testObj.setWert2((short)1);
//    testObj.update();
//    Transaction.complete();
//    System.exit(0);

    
    
//    manager = new ObjectManager();
//    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
//    System.out.println(artikelObj.getTimestamp());
//    
//    Transaction.spawn();
//    manager2 = new ObjectManager();
//    artikelObj2 = ArtikelFactory.search(manager2, "V-10000", 0, true);
//    System.out.println(artikelObj2.getTimestamp());
//    
//    Transaction.spawn();
//    manager3 = new ObjectManager();
//    artikelObj3 = ArtikelFactory.search(manager3, "V-10000", 0, true);
//    System.out.println(artikelObj3.getTimestamp());
//    artikelObj3.setName(artikelObj3.getName());
//    artikelObj3.update();
//    System.out.println(artikelObj3.getTimestamp());
//    Transaction.complete();
//    
//    artikelObj2 = ArtikelFactory.search(manager2, "V-10000", 0, true);
//    System.out.println(artikelObj2.getTimestamp());
//    Transaction.complete();
//    
//    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
//    System.out.println(artikelObj.getTimestamp());
//    Transaction.complete();
//    
//    System.exit(0);
    
    
//    XMLNode xmlNode;
//    TestTabelleObject testTabelleObj;
//    manager = new ObjectManager();
//    
//    specialObj = SpecialFactory.search(manager, "testtabelle", "select * from testtabelle", true);
//    System.out.println(specialObj.getShort("SCHLUESSEL"));
//    System.out.println(specialObj.getBoolean("SCHLUESSEL"));
//    
//    testTabelleObj = TestTabelleFactory.search(manager, true, 0, true);
////    System.out.println(testTabelleObj.getShort("SCHLUESSEL"));
//    System.out.println(testTabelleObj.getBoolean("SCHLUESSEL"));
//    
//    xmlDoc = new XMLDocument();
//    xmlNode = xmlDoc.addTag("root");
//    testTabelleObj.toXML(xmlNode, null);
//    System.out.println(xmlDoc);
//    
//    xmlDoc = new XMLDocument();
//    xmlNode = xmlDoc.addTag("root");
//    testTabelleObj.exportXML(xmlNode);
//    System.out.println(xmlDoc);
//    
//    testTabelleObj.setSchluessel(false);
//    System.out.println(testTabelleObj);
//    testTabelleObj.importXML(xmlNode);
//    System.out.println(testTabelleObj);
//    
//    testTabelleObj.setSchluessel(false);
//    System.out.println(testTabelleObj);
//    xmlDoc = new XMLDocument("<root><ID>1</ID><TIMESTAMP>000000000029097b</TIMESTAMP><SCHLUESSEL>1</SCHLUESSEL><WERT1>1</WERT1></root>");
//    xmlNode = xmlDoc.getRoot();
//    testTabelleObj.importXML(xmlNode);
//    System.out.println(testTabelleObj);
//    
//    System.exit(0);
    
//    Class.forName("com.sun.java.swing.plaf.gtk.GTKLookAndFeel");
//    UIManager.setLookAndFeel("com.sun.java.swing.plaf.gtk.GTKLookAndFeel");
    

//    ByteArrayOutputStream baos;
//    ObjectOutputStream oos;
//    FileOutputStream fos;
//    
//    fos = new FileOutputStream("C:\\oos.bin");
//    
//    manager = new ObjectManager();
//    count = 0;
//    coll = new ObjectCollection(manager, "Artikel", null, 0);
//    while(! coll.endOfObjects()) {
//      count++;
//      artikelObj = (ArtikelObject)coll.getObject();
//      baos = new ByteArrayOutputStream();
//      oos = new ObjectOutputStream(baos);
//      oos.writeUnshared(((BusinessObject)artikelObj).fields);
//      oos.close();
//      baos.close();
//      fos.write(baos.toByteArray());
//      ((BusinessObject)artikelObj).fields = null;
////      System.out.println(count + " / " + baos.size());
//      System.out.println(count);
//      coll.nextObject();
//    }
//    System.out.println(Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory());
////    oos.close();
//    fos.close();
//    System.exit(0);
    
    
    manager = new ObjectManager();
    artikelObj = ArtikelFactory.search(manager, "ANZAHLUNG", 0, true);
    
////    ObjectOutputStream oos;
////    ByteArrayOutputStream baos;
//    baos = new ByteArrayOutputStream();
////    oos = new ObjectOutputStream(new FileOutputStream("C:\\oos.bin"));
//    oos = new ObjectOutputStream(baos);
////    oos.writeObject(new P2Time());
//    oos.writeObject(((BusinessObject)artikelObj).fields);
//    oos.close();
//    baos.close();
//    System.out.println(new String(baos.toByteArray()));
//    System.exit(0);

    
    manager = new ObjectManager();
    sysConfObj = SysConfFactory.search(manager, "params", "EMailSender", 0, true);
    sysConfObj.setBereich("x");
    System.exit(0);
    
    
    manager = new ObjectManager();
    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
    Transaction.complete();
    
    manager = new ObjectManager();
    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
    System.out.println(artikelObj.getString("NAME"));
    
    Transaction.spawn();
    manager2 = new ObjectManager();
    artikelObj = ArtikelFactory.search(manager2, "V-10000", 0, true);
    artikelObj.setString("NAME", artikelObj.getString("NAME") + "X");
    artikelObj.update();
    Transaction.complete();
    
    Transaction.complete();
    
    manager = new ObjectManager();
    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
    System.out.println(artikelObj.getString("NAME"));
    System.exit(0);
    
    manager = new ObjectManager();
    coll = new ObjectCollection(manager, "LagerBewegung", "id > 60000 and id < 270000 and elemente is not null and bemerkung is not null", 0);
//    lagerBewegungObject = (LagerBewegungObject)coll.getObject();
    coll.release();
    manager.flushTransactionCache("LagerBewegung");
    System.exit(0);
    
    d1 = new Date();
    coll = new ObjectCollection(manager, "LagerBewegung", "id > 60000 and id < 270000 and elemente is not null and bemerkung is not null", 0);
    d2 = new Date();
    System.out.println("Zeit fuer SELECT: " + (d2.getTime() - d1.getTime()));
    
    count = 0;
    d1 = new Date();
    while(! coll.endOfObjects()) {
      lagerBewegungObject = (LagerBewegungObject)coll.getObject();
      count++;
      coll.nextObject();
    }
    d2 = new Date();
    System.out.println("Zeit fuer Lesen von " + count + " Saetzen: " + (d2.getTime() - d1.getTime()));
    coll.release();
    manager.flushTransactionCache("LagerBewegung");
    
    coll = new ObjectCollection(manager, "LagerBewegung", "id > 60000 and id < 270000 and elemente is not null and bemerkung is not null", 0);
    count = 0;
    d1 = new Date();
    while(! coll.endOfObjects()) {
      lagerBewegungObject = (LagerBewegungObject)coll.getObject();
      lagerBewegungObject.setString("BEMERKUNG", lagerBewegungObject.getString("BEMERKUNG"));
      lagerBewegungObject.update();
      count++;
      coll.nextObject();
    }
    d2 = new Date();
    System.out.println("Zeit fuer Updaten von " + count + " mal VARCHAR: " + (d2.getTime() - d1.getTime()));
    coll.release();
    manager.flushTransactionCache("LagerBewegung");
    
    coll = new ObjectCollection(manager, "LagerBewegung", "id > 60000 and id < 270000 and elemente is not null and bemerkung is not null", 0);
    count = 0;
    d1 = new Date();
    while(! coll.endOfObjects()) {
      lagerBewegungObject = (LagerBewegungObject)coll.getObject();
      lagerBewegungObject.setString("ELEMENTE", lagerBewegungObject.getString("ELEMENTE"));
      lagerBewegungObject.update();
      count++;
      coll.nextObject();
    }
    d2 = new Date();
    System.out.println("Zeit fuer Updaten von " + count + " mal TEXT: " + (d2.getTime() - d1.getTime()));
    coll.release();
    manager.flushTransactionCache("LagerBewegung");
    
    System.exit(0);
    

//    P2plusServer.COMPANY = "TestCompany";
//    P2plusServer.COMPANY_PATH = "\\TestCompany";
////    Tool.setConfigString("TestParameter", "Lall");
//    System.out.println(Tool.getConfigString("TestParameter"));
    
//    System.exit(0);
    

//    StringBuffer text;
//    BufferedReader br;
//    
//    br = new BufferedReader(new FileReader("c:\\193"));
//    text = new StringBuffer();
//    while(br.ready()) {
//      text.append(br.readLine());
//    }
//    System.out.println(text.toString());
//    System.out.println(Text.unzip(Base64.decode(text.toString().toCharArray())));
//    System.exit(0);
//    
//    SpecialCollection sColl;
//    manager = new ObjectManager();
//    sColl = new SpecialCollection(manager, "artikel", "if exists(select * from artikel where artikel='asdfsdf') select * from artikel");
//    System.out.println(sColl.endOfObjects());
//    
//    System.exit(0);
    
    
    manager = new ObjectManager();
    aufStueliPosObj = AufstueliPosFactory.search(manager, null, null, 0, false);
    coll = new ObjectCollection(manager, "AufStueliPos", null, 0);
    count = 0;
    while(! coll.endOfObjects()) {
      count++;
      aufStueliPosObj = (AufstueliPosObject)coll.getObject();
      aufStueliPosObj.setString("NAME", aufStueliPosObj.getString("NAME"));
      aufStueliPosObj.update();
      if(count == 10) {
        break;
      }
      coll.nextObject();
    }
    coll.release();
    coll = new ObjectCollection(manager, "AufStueliPos", null, 0);
    count = 0;
    System.out.println("Start!");
    d1 = new Date();
    while(! coll.endOfObjects()) {
      count++;
      aufStueliPosObj = (AufstueliPosObject)coll.getObject();
      aufStueliPosObj.setString("NAME", aufStueliPosObj.getString("NAME"));
      aufStueliPosObj.update();
      if(count == 1000) {
        break;
      }
      coll.nextObject();
    }
    d2 = new Date();
    System.out.println("Fertig: " + count);
    System.out.println(d2.getTime() - d1.getTime());
    System.exit(0);
    
    
//    manager = new ObjectManager();
//    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
//    artikelObj.setString("NAME", artikelObj.getString("NAME"));
//    artikelObj.update();
    
//    manager = new ObjectManager();
//    sysConfObj = SysConfFactory.search(manager, "params", "EMailSender", 0, false);
//    
//    coll = new ObjectCollection(manager, "SysConf", null, 0);
//    count = 0;
//    d1 = new Date();
//    while(! coll.endOfObjects()) {
//      count++;
//      sysConfObj = (SysConfObject)coll.getObject();
//      coll.nextObject();
//    }
//    d2 = new Date();
//    System.out.println(count + ": " + (d2.getTime() - d1.getTime()));

//    coll = new ObjectCollection(manager, "SysConf", null, 0);
//    count = 0;
//    d1 = new Date();
//    while(! coll.endOfObjects()) {
//      count++;
//      sysConfObj = (SysConfObject)coll.getObject();
//      sysConfObj.setString("BEREICH", sysConfObj.getString("BEREICH"));
//      sysConfObj.update();
//      coll.nextObject();
//    }
//    d2 = new Date();
//    System.out.println(count + ": " + (d2.getTime() - d1.getTime()));

//    coll = new ObjectCollection(manager, "Artikel", "VERKAUF=1", 0);
//    count = 0;
//    d1 = new Date();
//    while(! coll.endOfObjects()) {
//      count++;
//      artikelObj = (ArtikelObject)coll.getObject();
//      artikelObj.setString("NAME", artikelObj.getString("NAME"));
//      artikelObj.update();
//      coll.nextObject();
//    }
//    d2 = new Date();
//    System.out.println(count + ": " + (d2.getTime() - d1.getTime()));
    
//    Transaction.complete();
    
//    manager = new ObjectManager();
//    manager.flushTableCache("NT2000|P2plus|artikel");
//    coll = new ObjectCollection(manager, "Artikel", "VERKAUF=1", 0);
//    count = 0;
//    d1 = new Date();
//    while(! coll.endOfObjects()) {
//      count++;
//      artikelObj = (ArtikelObject)coll.getObject();
//      artikelObj.setString("NAME", artikelObj.getString("NAME"));
//      artikelObj.update();
//      coll.nextObject();
//    }
//    d2 = new Date();
//    System.out.println(count + ": " + (d2.getTime() - d1.getTime()));
    
    manager = new ObjectManager();
    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
    Transaction.spawn();
    manager2 = new ObjectManager();
    artikelObj2 = ArtikelFactory.search(manager2, "V-10000", 0, true);
//    System.out.println(artikelObj.equals(artikelObj2));
    manager2.executeUpdate("Artikel", "update artikel set verkauf=1 where artikel='V-10000'");
//    manager2.flushTableCache("NT2000|P2plus", artikelObj2);
    Transaction.complete();
    Transaction.complete();
    
    manager = new ObjectManager();
    artikelObj2 = ArtikelFactory.search(manager, "V-10000", 0, true);
//    System.out.println(artikelObj.equals(artikelObj2));
    artikelObj2.setShort("VERKAUF", (short)1);
    artikelObj2.update();
    Transaction.complete();
    
    
//    manager = new ObjectManager();
//    gColl = new ObjectCollection<ArtikelObject>(manager, "Artikel", "VERKAUF=1", 0);
//    while(! gColl.endOfObjects()) {
//      artikelObj = gColl.getObject();
//      System.out.println(artikelObj);
//      gColl.nextObject();
//    }
    
    
//    xml = new StringBuffer();
//    br = new BufferedReader(new FileReader("c:\\exportRechnung.xml"));
//    while(br.ready()) {
//      xml.append(br.readLine() + "\n");
//    }
    
//    xmlDoc = new XMLDocument();
//    xmlDoc.load("c:\\instanz_Test2.xml");
//    new Auftrag().importXML(xmlDoc.toString());
//    Transaction.cleanup("com.apag.p2plus.p2objects.Test", "main");
    
//    sql = new StringBuffer();
//    br = new BufferedReader(new FileReader("c:\\test.sql"));
//    while(br.ready()) {
//      sql.append(br.readLine() + "\n");
//    }
//    manager.executeSQL("artikel", sql.toString());
    
//    xmlDoc = new XMLDocument();
//    xmlDoc.fromString(new Auftrag().exportXML("<root><AUFTRAG>200275</AUFTRAG></root>"));
//    xmlDoc.save("c:\\exportAuftrag.xml");

//    xmlDoc = new XMLDocument();
//    xmlDoc.fromString(new Rechnung().exportXML("<root><RECHNUNG>300208</RECHNUNG></root>"));
//    xmlDoc.save("c:\\exportRechnung.xml");
    
//    xmlDoc = new XMLDocument();
//    rootTag = xmlDoc.addTag("root");
//    rechnungObj = RechnungFactory.search(manager, "300083", 0, true);
//    rechnungObj.exportXML(rootTag);
//    xmlDoc.save("c:\\exportRechnung.xml");
    
//    xmlDoc = new XMLDocument();
//    xmlDoc.fromString(new Artikel().exportXML("<root><ARTIKEL>V-10000</ARTIKEL></root>"));
//    xmlDoc.save("c:\\exportArtikel.xml");
    
//    xmlDoc = new XMLDocument();
//    rootTag = xmlDoc.addTag("root");
//    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
//    artikelObj.exportXML(rootTag);
//    xmlDoc.save("c:\\exportArtikel.xml");
//    
//    xmlDoc = new XMLDocument();
//    rootTag = xmlDoc.addTag("root");
//    auftragObj = AuftragFactory.search(manager, "200275", 0, true);
//    auftragObj.exportXML(rootTag);
//    xmlDoc.save("c:\\exportAuftrag.xml");
//    
//    xmlDoc = new XMLDocument();
//    rootTag = xmlDoc.addTag("root");
//    waPosObj = WarenAusgangPosFactory.search(manager, "705193", (short)1, 0, true);
//    waPosObj.exportXML(rootTag);
//    xmlDoc.save("c:\\exportWarenAusgang.xml");
    
//    manager.setIgnoreClients(true);
//    artikelObj = ArtikelFactory.search(manager, "V-10000", 0, true);
//    coll = new ObjectCollection(manager, "Artikel", null, 0);
//    coll = new ObjectCollection(manager, "Artikel", "VERKAUF = 1", 0);
    
    Transaction.complete();
  }
}