Index: lams_tool_deploy/test/java/org/lamsfoundation/lams/tool/deploy/ToolDBTest.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_deploy/test/java/org/lamsfoundation/lams/tool/deploy/Attic/ToolDBTest.java,v diff -u -r1.2 -r1.3 --- lams_tool_deploy/test/java/org/lamsfoundation/lams/tool/deploy/ToolDBTest.java 13 Apr 2005 03:03:11 -0000 1.2 +++ lams_tool_deploy/test/java/org/lamsfoundation/lams/tool/deploy/ToolDBTest.java 1 Dec 2005 23:50:36 -0000 1.3 @@ -66,6 +66,7 @@ DBConnector connector = new DBConnector(propsFilePath); conn = connector.connect(); conn.setAutoCommit(false); + File createLamsTables = new File("test/file/sql/lams_common/create_lams_11_tables.sql"); File insertTypesData = new File("test/file/sql/lams_common/insert_types_data.sql"); @@ -135,4 +136,52 @@ } } + protected void insertTestRecordsForLibraryDeploy(String propsFilePath) throws Exception + { + Connection conn = null; + try + { + DBConnector connector = new DBConnector(propsFilePath); + conn = connector.connect(); + conn.setAutoCommit(false); + File insertTestRecords = new File("test/file/sql/insert_library_test_data.sql"); + ScriptRunner insertRunner = new ScriptRunner(FileUtils.readFileToString(insertTestRecords , "UTF8"),conn); + insertRunner.run(); + conn.commit(); + } + catch (Exception ex) + { + conn.rollback(); + throw ex; + } + finally + { + DbUtils.closeQuietly(conn); + } + } + + protected void dropTestToolTable(String propsFilePath) throws Exception + { + Connection conn = null; + try + { + DBConnector connector = new DBConnector(propsFilePath); + conn = connector.connect(); + conn.setAutoCommit(false); + File deleteToolTables = new File("test/file/sql/drop_tool_tables.sql"); + ScriptRunner insertRunner = new ScriptRunner(FileUtils.readFileToString(deleteToolTables , "UTF8"),conn); + insertRunner.run(); + conn.commit(); + } + catch (Exception ex) + { + conn.rollback(); + throw ex; + } + finally + { + DbUtils.closeQuietly(conn); + } + } + }