/*
    * Created on 2005-9-10
    *
    * TODO To change the template for this generated file go to
    * Window - Preferences - Java - Code Style - Code Templates
    */
   package org.huihoo.jfox.soaf.services.persistence;
   
   import junit.framework.TestCase;
  
  import org.huihoo.jfox.soaf.container.ServiceFactory;
  import org.huihoo.jfox.soaf.container.ServiceLoader;
  import org.huihoo.jfox.soaf.exception.DAOException;
  import org.huihoo.jfox.soaf.services.jdbc.DataSourceService;
  
  import com.jenkov.mrpersister.itf.PersistenceException;
  
  /***
   * @author peter.cheng
   * 
   * TODO To change the template for this generated type comment go to Window -
   * Preferences - Java - Code Style - Code Templates
   */
  public class MrPersisterServiceImplTest extends TestCase {
  
  	private MrPersisterService mrPersisterService;
  	
  	private DataSourceService dsService;
  
  	private ServiceLoader sl = ServiceLoader.getInstance();
  
  	private ServiceFactory sf = ServiceFactory.getInstance();
  
  	private final static String SQL = "CREATE TABLE employees (employee_id varchar(255) NOT NULL,"
  		                              + "name varchar(255) NOT NULL, job_title varchar(255) NOT NULL,"
  									  + "job_description varchar(255) default NULL, employed_since"
  									  + " datetime, monthly_salary int(4), PRIMARY KEY  (employee_id))";
  	
  	private final static String DROP_TABLE_SQL = "drop table employees";
  	
  	/*
  	 * @see TestCase#setUp()
  	 */
  	protected void setUp() throws Exception {
  		super.setUp();
  		if (!sl.isServiceLoaded()) {
  			sl.initService("jfoxsoaf-config.xml");
  		}
  		mrPersisterService = (MrPersisterService) sf
  				.getService(MrPersisterService.class);
  		dsService = (DataSourceService) sf.getService(DataSourceService.class);
  		//super.assertNotNull(dsService.getDataSource(null));
  		mrPersisterService.setDataSource(dsService.getDataSource(null));
  	}
  
  	/*
  	 * @see TestCase#tearDown()
  	 */
  	protected void tearDown() throws Exception {
  		super.tearDown();
  	}
  
  	public void testSetDataSource() {
  	}
  
  	/*
  	 * Class under test for int delete(Connection, Object)
  	 */
  	public void testDeleteConnectionObject() {
  	}
  
  	/*
  	 * Class under test for int delete(Object)
  	 */
  	public void testDeleteObject() {
  	}
  
  	/*
  	 * Class under test for int delete(Object, Object)
  	 */
  	public void testDeleteObjectObject() {
  	}
  
  	/*
  	 * Class under test for int delete(Connection, Object, Object)
  	 */
  	public void testDeleteConnectionObjectObject() {
  	}
  
  	/*
  	 * Class under test for int[] deleteBatch(Collection)
  	 */
  	public void testDeleteBatchCollection() {
  	}
  
  	/*
  	 * Class under test for int[] deleteBatch(Connection, Collection)
  	 */
  	public void testDeleteBatchConnectionCollection() {
 	}
 
 	/*
 	 * Class under test for int[] deleteBatch(Connection, Object, Collection)
 	 */
 	public void testDeleteBatchConnectionObjectCollection() {
 	}
 
 	/*
 	 * Class under test for int[] deleteBatch(Object, Collection)
 	 */
 	public void testDeleteBatchObjectCollection() {
 	}
 
 	/*
 	 * Class under test for int deleteByPrimaryKey(Connection, Object, Object)
 	 */
 	public void testDeleteByPrimaryKeyConnectionObjectObject() {
 	}
 
 	/*
 	 * Class under test for int deleteByPrimaryKey(Object, Object)
 	 */
 	public void testDeleteByPrimaryKeyObjectObject() {
 	}
 
 	/*
 	 * Class under test for int[] deleteBatchByPrimaryKeys(Object, Collection)
 	 */
 	public void testDeleteBatchByPrimaryKeysObjectCollection() {
 	}
 
 	/*
 	 * Class under test for int[] deleteBatchByPrimaryKeys(Connection, Object,
 	 * Collection)
 	 */
 	public void testDeleteBatchByPrimaryKeysConnectionObjectCollection() {
 	}
 
 	/*
 	 * Class under test for int executeUpdate(String, Collection)
 	 */
 	public void testExecuteUpdateStringCollection() {
 	}
 
 	/*
 	 * Class under test for int executeUpdate(Connection, String, Collection)
 	 */
 	public void testExecuteUpdateConnectionStringCollection() {
 	}
 
 	/*
 	 * Class under test for int executeUpdate(String, Object[])
 	 */
 	public void testExecuteUpdateStringObjectArray() {
 	}
 
 	/*
 	 * Class under test for int executeUpdate(Connection, String, Object[])
 	 */
 	public void testExecuteUpdateConnectionStringObjectArray() {
 	}
 
 	/*
 	 * Class under test for int executeUpdate(String)
 	 */
 	public void testExecuteUpdateString() {
 		
 		try {
 			mrPersisterService.executeUpdate(DROP_TABLE_SQL);
 		} catch (DAOException e1) {
 			e1.printStackTrace();
 		} catch (PersistenceException e1) {
 			e1.printStackTrace();
 		}
 		
 		try {
 			mrPersisterService.executeUpdate(SQL);
 		} catch (DAOException e) {			
 			e.printStackTrace();
 		} catch (PersistenceException e) {
 			e.printStackTrace();
 		}
 		
 		
 	}
 
 	/*
 	 * Class under test for int executeUpdate(Connection, String)
 	 */
 	public void testExecuteUpdateConnectionString() {
 	}
 
 	/*
 	 * Class under test for int insert(Object, Object)
 	 */
 	public void testInsertObjectObject() {
 	}
 
 	/*
 	 * Class under test for int insert(Connection, Object, Object)
 	 */
 	public void testInsertConnectionObjectObject() {
 	}
 
 	/*
 	 * Class under test for int insert(Object)
 	 */
 	public void testInsertObject() {
 	}
 
 	/*
 	 * Class under test for int insert(Connection, Object)
 	 */
 	public void testInsertConnectionObject() {
 	}
 
 	/*
 	 * Class under test for int[] insertBatch(Collection)
 	 */
 	public void testInsertBatchCollection() {
 	}
 
 	/*
 	 * Class under test for int[] insertBatch(Object, Collection)
 	 */
 	public void testInsertBatchObjectCollection() {
 	}
 
 	/*
 	 * Class under test for int[] insertBatch(Connection, Collection)
 	 */
 	public void testInsertBatchConnectionCollection() {
 	}
 
 	/*
 	 * Class under test for Object read(Object, PreparedStatement)
 	 */
 	public void testReadObjectPreparedStatement() {
 	}
 
 	/*
 	 * Class under test for Object read(Connection, Object, PreparedStatement)
 	 */
 	public void testReadConnectionObjectPreparedStatement() {
 	}
 
 	/*
 	 * Class under test for Object read(Object, ResultSet)
 	 */
 	public void testReadObjectResultSet() {
 	}
 
 	/*
 	 * Class under test for Object read(Connection, Object, ResultSet)
 	 */
 	public void testReadConnectionObjectResultSet() {
 	}
 
 	/*
 	 * Class under test for Object read(Object, Statement, String)
 	 */
 	public void testReadObjectStatementString() {
 	}
 
 	/*
 	 * Class under test for Object read(Connection, Object, Statement, String)
 	 */
 	public void testReadConnectionObjectStatementString() {
 	}
 
 	/*
 	 * Class under test for Object read(Object, String, Collection)
 	 */
 	public void testReadObjectStringCollection() {
 	}
 
 	/*
 	 * Class under test for Object read(Connection, Object, String, Collection)
 	 */
 	public void testReadConnectionObjectStringCollection() {
 	}
 
 	/*
 	 * Class under test for Object read(Object, String, Object[])
 	 */
 	public void testReadObjectStringObjectArray() {
 	}
 
 	/*
 	 * Class under test for Object read(Connection, Object, String, Object[])
 	 */
 	public void testReadConnectionObjectStringObjectArray() {
 	}
 
 	/*
 	 * Class under test for Object read(Object, String)
 	 */
 	public void testReadObjectString() {
 	}
 
 	/*
 	 * Class under test for Object read(Connection, Object, String)
 	 */
 	public void testReadConnectionObjectString() {
 	}
 
 	/*
 	 * Class under test for Object readByPrimaryKey(Object, Object)
 	 */
 	public void testReadByPrimaryKeyObjectObject() {
 	}
 
 	/*
 	 * Class under test for Object readByPrimaryKey(Connection, Object, Object)
 	 */
 	public void testReadByPrimaryKeyConnectionObjectObject() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, PreparedStatement,
 	 * IReadFilter)
 	 */
 	public void testReadListObjectPreparedStatementIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, PreparedStatement,
 	 * IReadFilter)
 	 */
 	public void testReadListConnectionObjectPreparedStatementIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, PreparedStatement)
 	 */
 	public void testReadListObjectPreparedStatement() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, PreparedStatement)
 	 */
 	public void testReadListConnectionObjectPreparedStatement() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, ResultSet, IReadFilter)
 	 */
 	public void testReadListObjectResultSetIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, ResultSet,
 	 * IReadFilter)
 	 */
 	public void testReadListConnectionObjectResultSetIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, ResultSet)
 	 */
 	public void testReadListObjectResultSet() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, ResultSet)
 	 */
 	public void testReadListConnectionObjectResultSet() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, Statement, String)
 	 */
 	public void testReadListObjectStatementString() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, Statement, String)
 	 */
 	public void testReadListConnectionObjectStatementString() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, String, Collection,
 	 * IReadFilter)
 	 */
 	public void testReadListObjectStringCollectionIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, String,
 	 * Collection, IReadFilter)
 	 */
 	public void testReadListConnectionObjectStringCollectionIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, Statement, String,
 	 * IReadFilter)
 	 */
 	public void testReadListObjectStatementStringIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, Statement, String,
 	 * IReadFilter)
 	 */
 	public void testReadListConnectionObjectStatementStringIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, String, Collection)
 	 */
 	public void testReadListObjectStringCollection() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, String,
 	 * Collection)
 	 */
 	public void testReadListConnectionObjectStringCollection() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, String, IReadFilter)
 	 */
 	public void testReadListObjectStringIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, String,
 	 * IReadFilter)
 	 */
 	public void testReadListConnectionObjectStringIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, String, Object[], IReadFilter)
 	 */
 	public void testReadListObjectStringObjectArrayIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, String, Object[],
 	 * IReadFilter)
 	 */
 	public void testReadListConnectionObjectStringObjectArrayIReadFilter() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, String, Object[])
 	 */
 	public void testReadListObjectStringObjectArray() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, String, Object[])
 	 */
 	public void testReadListConnectionObjectStringObjectArray() {
 	}
 
 	/*
 	 * Class under test for List readList(Object, String)
 	 */
 	public void testReadListObjectString() {
 	}
 
 	/*
 	 * Class under test for List readList(Connection, Object, String)
 	 */
 	public void testReadListConnectionObjectString() {
 	}
 
 	/*
 	 * Class under test for List readListByPrimaryKeys(Object, Collection)
 	 */
 	public void testReadListByPrimaryKeysObjectCollection() {
 	}
 
 	/*
 	 * Class under test for List readListByPrimaryKeys(Connection, Object,
 	 * Collection)
 	 */
 	public void testReadListByPrimaryKeysConnectionObjectCollection() {
 	}
 
 	/*
 	 * Class under test for int update(Object, Object)
 	 */
 	public void testUpdateObjectObject() {
 	}
 
 	/*
 	 * Class under test for int update(Connection, Object, Object)
 	 */
 	public void testUpdateConnectionObjectObject() {
 	}
 
 	/*
 	 * Class under test for int update(Object)
 	 */
 	public void testUpdateObject() {
 	}
 
 	/*
 	 * Class under test for int update(Connection, Object)
 	 */
 	public void testUpdateConnectionObject() {
 	}
 
 	/*
 	 * Class under test for int[] updateBatch(Collection)
 	 */
 	public void testUpdateBatchCollection() {
 	}
 
 	/*
 	 * Class under test for int[] updateBatch(Connection, Collection)
 	 */
 	public void testUpdateBatchConnectionCollection() {
 	}
 
 	/*
 	 * Class under test for int[] updateBatch(Object, Collection)
 	 */
 	public void testUpdateBatchObjectCollection() {
 	}
 
 	/*
 	 * Class under test for int[] updateBatch(Connection, Object, Collection)
 	 */
 	public void testUpdateBatchConnectionObjectCollection() {
 	}
 
 	/*
 	 * Class under test for int[] updateBatchByPrimaryKeys(Collection,
 	 * Collection)
 	 */
 	public void testUpdateBatchByPrimaryKeysCollectionCollection() {
 	}
 
 	/*
 	 * Class under test for int[] updateBatchByPrimaryKeys(Connection,
 	 * Collection, Collection)
 	 */
 	public void testUpdateBatchByPrimaryKeysConnectionCollectionCollection() {
 	}
 
 	/*
 	 * Class under test for int[] updateBatchByPrimaryKeys(Object, Collection,
 	 * Collection)
 	 */
 	public void testUpdateBatchByPrimaryKeysObjectCollectionCollection() {
 	}
 
 	/*
 	 * Class under test for int[] updateBatchByPrimaryKeys(Connection, Object,
 	 * Collection, Collection)
 	 */
 	public void testUpdateBatchByPrimaryKeysConnectionObjectCollectionCollection() {
 	}
 
 	/*
 	 * Class under test for int updateByPrimaryKey(Object, Object, Object)
 	 */
 	public void testUpdateByPrimaryKeyObjectObjectObject() {
 	}
 
 	/*
 	 * Class under test for int updateByPrimaryKey(Connection, Object, Object,
 	 * Object)
 	 */
 	public void testUpdateByPrimaryKeyConnectionObjectObjectObject() {
 	}
 
 	/*
 	 * Class under test for int updateByPrimaryKey(Object, Object)
 	 */
 	public void testUpdateByPrimaryKeyObjectObject() {
 	}
 
 	/*
 	 * Class under test for int updateByPrimaryKey(Connection, Object, Object)
 	 */
 	public void testUpdateByPrimaryKeyConnectionObjectObject() {
 	}
 
 }