Coverage Report

Coverage Report - org.kuali.db.jdbc.DatabaseManager

Classes in this File

Line Coverage

Branch Coverage

Complexity

DatabaseManager

0/46

0/2

1.062

 package org.kuali.db.jdbc;
 
 import java.sql.Connection;
 import java.sql.SQLException;
 
 import org.apache.commons.logging.Log;
 import org.apache.commons.logging.LogFactory;
 
 public class DatabaseManager {
     private static final Log log = LogFactory.getLog(DatabaseManager.class);
     Credentials credentials;
     Credentials dbaCredentials;
     DatabaseManagerMode mode;
     String url;
     String dbaUrl;
     JDBCUtils jdbcUtils;
 
     public void execute() throws SQLException {
         if (mode.equals(DatabaseManagerMode.DROP_CREATE)) {
             dropDatabase();
             createDatabase();
         } else {
 
         }
     }
 
     protected void executeDbaSql(final JDBCConfiguration config, final String sql) throws SQLException {
         ConnectionHandler connectionHandler = new ConnectionHandler();
         connectionHandler.setCredentials(getDbaCredentials());
         connectionHandler.setUrl(getUrl());
         connectionHandler.setDriver(config.getDriver());
         Connection conn = null;
         try {
             conn = connectionHandler.getConnection();
             SQLExecutor executor = new SQLExecutor();
             executor.setConn(conn);
             executor.executeSql(sql);
         } finally {
             JDBCUtils.closeQuietly(conn);
         }
     }
 
     public void dropDatabase() throws SQLException {
         JDBCConfiguration config = getJdbcUtils().getDatabaseConfiguration(getDbaUrl());
         String sql = config.getDbaSql().getDropSql();
         log.info("-- Dropping database --");
         executeDbaSql(config, sql);
     }
 
     public void createDatabase() throws SQLException {
         JDBCConfiguration config = getJdbcUtils().getDatabaseConfiguration(getDbaUrl());
         String sql = config.getDbaSql().getCreateSql();
         log.info("-- Creating database --");
         executeDbaSql(config, sql);
     }
 
     /**
      * @return the credentials
      */
     public Credentials getCredentials() {
         return credentials;
     }
 
     /**
      * @param credentials
      * the credentials to set
      */
     public void setCredentials(final Credentials credentials) {
         this.credentials = credentials;
     }
 
     /**
      * @return the dbaCredentials
      */
     public Credentials getDbaCredentials() {
         return dbaCredentials;
     }
 
     /**
      * @param dbaCredentials
      * the dbaCredentials to set
      */
     public void setDbaCredentials(final Credentials dbaCredentials) {
         this.dbaCredentials = dbaCredentials;
     }
 
     /**
      * @return the mode
      */
     public DatabaseManagerMode getMode() {
         return mode;
     }
 
     /**
      * @param mode
      * the mode to set
      */
     public void setMode(final DatabaseManagerMode mode) {
         this.mode = mode;
     }
 
     /**
      * @return the url
      */
     public String getUrl() {
         return url;
     }
 
     /**
      * @param url
      * the url to set
      */
     public void setUrl(final String url) {
         this.url = url;
     }
 
     /**
      * @return the jdbcUtils
      */
     public JDBCUtils getJdbcUtils() {
         return jdbcUtils;
     }
 
     /**
      * @param jdbcUtils
      * the jdbcUtils to set
      */
     public void setJdbcUtils(final JDBCUtils jdbcUtils) {
         this.jdbcUtils = jdbcUtils;
     }
 
     /**
      * @return the dbaUrl
      */
     public String getDbaUrl() {
         return dbaUrl;
     }
 
     /**
      * @param dbaUrl
      * the dbaUrl to set
      */
     public void setDbaUrl(final String dbaUrl) {
         this.dbaUrl = dbaUrl;
     }
 
 }

1		package org.kuali.db.jdbc;
2
3		import java.sql.Connection;
4		import java.sql.SQLException;
5
6		import org.apache.commons.logging.Log;
7		import org.apache.commons.logging.LogFactory;
8
9	0	public class DatabaseManager {
10	0	private static final Log log = LogFactory.getLog(DatabaseManager.class);
11		Credentials credentials;
12		Credentials dbaCredentials;
13		DatabaseManagerMode mode;
14		String url;
15		String dbaUrl;
16		JDBCUtils jdbcUtils;
17
18		public void execute() throws SQLException {
19	0	if (mode.equals(DatabaseManagerMode.DROP_CREATE)) {
20	0	dropDatabase();
21	0	createDatabase();
22		} else {
23
24		}
25	0	}
26
27		protected void executeDbaSql(final JDBCConfiguration config, final String sql) throws SQLException {
28	0	ConnectionHandler connectionHandler = new ConnectionHandler();
29	0	connectionHandler.setCredentials(getDbaCredentials());
30	0	connectionHandler.setUrl(getUrl());
31	0	connectionHandler.setDriver(config.getDriver());
32	0	Connection conn = null;
33		try {
34	0	conn = connectionHandler.getConnection();
35	0	SQLExecutor executor = new SQLExecutor();
36	0	executor.setConn(conn);
37	0	executor.executeSql(sql);
38		} finally {
39	0	JDBCUtils.closeQuietly(conn);
40	0	}
41	0	}
42
43		public void dropDatabase() throws SQLException {
44	0	JDBCConfiguration config = getJdbcUtils().getDatabaseConfiguration(getDbaUrl());
45	0	String sql = config.getDbaSql().getDropSql();
46	0	log.info("-- Dropping database --");
47	0	executeDbaSql(config, sql);
48	0	}
49
50		public void createDatabase() throws SQLException {
51	0	JDBCConfiguration config = getJdbcUtils().getDatabaseConfiguration(getDbaUrl());
52	0	String sql = config.getDbaSql().getCreateSql();
53	0	log.info("-- Creating database --");
54	0	executeDbaSql(config, sql);
55	0	}
56
57		/**
58		* @return the credentials
59		*/
60		public Credentials getCredentials() {
61	0	return credentials;
62		}
63
64		/**
65		* @param credentials
66		* the credentials to set
67		*/
68		public void setCredentials(final Credentials credentials) {
69	0	this.credentials = credentials;
70	0	}
71
72		/**
73		* @return the dbaCredentials
74		*/
75		public Credentials getDbaCredentials() {
76	0	return dbaCredentials;
77		}
78
79		/**
80		* @param dbaCredentials
81		* the dbaCredentials to set
82		*/
83		public void setDbaCredentials(final Credentials dbaCredentials) {
84	0	this.dbaCredentials = dbaCredentials;
85	0	}
86
87		/**
88		* @return the mode
89		*/
90		public DatabaseManagerMode getMode() {
91	0	return mode;
92		}
93
94		/**
95		* @param mode
96		* the mode to set
97		*/
98		public void setMode(final DatabaseManagerMode mode) {
99	0	this.mode = mode;
100	0	}
101
102		/**
103		* @return the url
104		*/
105		public String getUrl() {
106	0	return url;
107		}
108
109		/**
110		* @param url
111		* the url to set
112		*/
113		public void setUrl(final String url) {
114	0	this.url = url;
115	0	}
116
117		/**
118		* @return the jdbcUtils
119		*/
120		public JDBCUtils getJdbcUtils() {
121	0	return jdbcUtils;
122		}
123
124		/**
125		* @param jdbcUtils
126		* the jdbcUtils to set
127		*/
128		public void setJdbcUtils(final JDBCUtils jdbcUtils) {
129	0	this.jdbcUtils = jdbcUtils;
130	0	}
131
132		/**
133		* @return the dbaUrl
134		*/
135		public String getDbaUrl() {
136	0	return dbaUrl;
137		}
138
139		/**
140		* @param dbaUrl
141		* the dbaUrl to set
142		*/
143		public void setDbaUrl(final String dbaUrl) {
144	0	this.dbaUrl = dbaUrl;
145	0	}
146
147		}