package com.softwareag.tils;


import java.io.IOException;

import org.w3c.dom.Document;



import com.developer.xml.Xml;
import com.softwareag.tamino.db.api.accessor.TAccessLocation;
import com.softwareag.tamino.db.api.accessor.TAccessorException;
import com.softwareag.tamino.db.api.accessor.TXMLObjectAccessor;

import com.softwareag.tamino.db.api.connection.TConnection;
import com.softwareag.tamino.db.api.connection.TConnectionCloseException;
import com.softwareag.tamino.db.api.connection.TConnectionFactory;
import com.softwareag.tamino.db.api.connection.TLocalTransaction;
import com.softwareag.tamino.db.api.connection.TServerNotAvailableException;
import com.softwareag.tamino.db.api.connection.TTransactionException;

import com.softwareag.tamino.db.api.objectModel.TXMLObject;
import com.softwareag.tamino.db.api.objectModel.dom.TDOMObjectModel;




public class TestTamino {

	/**
	 * @param args
	 * @throws TTransactionException 
	 */
	public static final String DATABASE_URL = "http://localhost/tamino/workshop" ;
    public static final String COLLECTION   = "miscela" ;
    public static final String DOCTYPE      = "fagioli" ;
    public static final String USERNAME     = "" ;
    public static final String PASSWORD     = "" ;
    private static TConnection conn;
    private static TLocalTransaction transaction = null;
    
	public static void main(String[] args) throws TTransactionException {
		// TODO Auto-generated method stub
		
		
		
		String xmlString="<fagioli><codice>3</codice><descrizione>descr fagioli 3</descrizione></fagioli>";
		
        
		try{
			
			conn = TConnectionFactory.getInstance().newConnection(DATABASE_URL + "/" + COLLECTION,DOCTYPE,USERNAME,PASSWORD );
			
			
			}
			catch(TServerNotAvailableException e){
				e.printStackTrace();
				
			}
		transaction = conn.useLocalTransactionMode();
		
		
		//	Obtain a TXMLObjectAccessor with a DOM object model
	
		
		
		TXMLObjectAccessor xmlObjectAccessor = conn.newXMLObjectAccessor(
				   TAccessLocation.newInstance(COLLECTION),
				   TDOMObjectModel.getInstance() );

		
		
		Xml x = new Xml();
		
		
		Document mydoc = x.StringToDom(xmlString); // w3c Document
		TXMLObject tobj = TXMLObject.newInstance( mydoc);
		
		try{		
		
		
		 xmlObjectAccessor.insert( tobj ); //eseguo la insert
		 transaction.commit(); //faccio la commit
		 
		}catch (TAccessorException accessorException)  {
			  
	  		transaction.rollback();
			
		
			accessorException.printStackTrace();
	}finally{

		conn.useAutoCommitMode(); 									 
		try {
			conn.close();
		} catch (TConnectionCloseException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} //chiudo la connessione
		
	}

	
	
	}	
	
	
			
		}