Index: lams_tool_deploy/test/java/org/lamsfoundation/lams/tool/deploy/ToolDBTest.java
===================================================================
diff -u -rb9682e51114d632fd77ff0feabf3f2de634744bd -r728977be6095e0aa7ec2a16a4b52009d71b60e1c
--- lams_tool_deploy/test/java/org/lamsfoundation/lams/tool/deploy/ToolDBTest.java	(.../ToolDBTest.java)	(revision b9682e51114d632fd77ff0feabf3f2de634744bd)
+++ lams_tool_deploy/test/java/org/lamsfoundation/lams/tool/deploy/ToolDBTest.java	(.../ToolDBTest.java)	(revision 728977be6095e0aa7ec2a16a4b52009d71b60e1c)
@@ -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);
+        }
+    }
+    
 }