/**
* For storing a web agency in the web database
*
* @param args agencyId = args[0]; hostName = args[1]; dbName = args[2]; dbType = args[3]; dbHost
* = args[4]; dbUserName = args[5]; dbPassword = args[6];
*/
public static void main(String args[]) {
// Determine all the params
if (args.length <= 5) {
System.err.println(
"Specify params for the WebAgency: agencyId = args[0]; hostName = args[1]; dbType = args[2]; dbHost = args[3]; dbUserName = args[4]; dbPassword = args[5];");
System.exit(-1);
}
String agencyId = args[0];
String hostName = args[1];
boolean active = true;
String dbName = args[2];
String dbType = args[3];
String dbHost = args[4];
String dbUserName = args[5];
String dbPassword = args[6];
// Name of database where to store the WebAgency object
String webAgencyDbName = "web";
// Create the WebAgency object
WebAgency webAgency =
new WebAgency(agencyId, hostName, active, dbName, dbType, dbHost, dbUserName, dbPassword);
System.out.println("Storing " + webAgency);
// Store the WebAgency
webAgency.store(webAgencyDbName);
}
/**
* Reads in WebAgency objects from the database and returns them as a map keyed on agencyId.
*
* @return
* @throws HibernateException
*/
private static Map<String, WebAgency> getMapFromDb() throws HibernateException {
String webAgencyDbName = getWebAgencyDbName();
logger.info("Reading WebAgencies data from database \"{}\"...", webAgencyDbName);
IntervalTimer timer = new IntervalTimer();
Session session = HibernateUtils.getSession(webAgencyDbName);
try {
String hql = "FROM WebAgency";
Query query = session.createQuery(hql);
@SuppressWarnings("unchecked")
List<WebAgency> list = query.list();
Map<String, WebAgency> map = new HashMap<String, WebAgency>();
for (WebAgency webAgency : list) {
map.put(webAgency.getAgencyId(), webAgency);
}
logger.info(
"Done reading WebAgencies from database. Took {} msec. " + "They are {}",
timer.elapsedMsec(),
map.values());
return map;
} catch (Exception e) {
throw e;
} finally {
// Make sure that the session always gets closed, even if
// exception occurs
session.close();
}
}