package net.eyde.personalblog.service;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.List;
import java.util.Locale;
import java.util.Properties;
import net.eyde.personalblog.beans.BlogProperty;
import net.eyde.personalblog.beans.Comment;
import net.eyde.personalblog.beans.Post;
import net.eyde.personalblog.beans.Referrer;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.checkerframework.checker.tainting.qual.Untainted;
/**
* @author NEyde
* <p>When the user selects a date, they will get the previous 25 posts from the date selected.
* <p>When a user selects a specific post, they will see that post only.
* <p>When a user selects a month, they will get all the posts for the month.
*/
public class PersonalBlogService {
// Installation State
public static final String INSTALLATION_STATE = "installation_state";
public static final String STATE_UNDEFINED = "undefined";
public static final String STATE_NO_HIBERNATE_FILE = "no_hibernate_file";
public static final String STATE_DATABASE_OFF = "database_off";
public static final String STATE_HIBERNATE_FILE_INVALID = "hibernate_file_invalid";
public static final String STATE_TABLES_NOT_CREATED = "tables_not_created_yet";
public static final String STATE_MISSING_PROPERTIES = "missing_properties";
public static final String STATE_OK = "ok";
private static Log log = LogFactory.getLog(PersonalBlogService.class);
private static PersonalBlogService service = null;
// Property Name Constants
public static final String WEBLOG_TITLE = "weblog.title";
public static final String WEBLOG_DESCRIPTION = "weblog.description";
public static final String WEBLOG_PICTURE = "weblog.ownerpicture";
public static final String WEBLOG_OWNER_NICK_NAME = "weblog.ownernickname";
public static final String WEBLOG_URL = "weblog.url";
public static final String WEBLOG_OWNER = "weblog.owner";
public static final String WEBLOG_EMAIL = "weblog.email";
public static final String LINK_POST = "links.post";
public static final String EMOTICON_VALUES = "emoticon.values";
public static final String EMOTICON_IMAGES = "emoticon.images";
public static final String LOGON_ID = "logon.id";
public static final String LOGON_PASSWORD = "logon.password";
public static final String EDITOR = "weblog.editor";
public static final String EMAIL_HOST = "mail.smtp.host";
public static final String EMAIL_TRANSPORT = "mail.transport";
public static final String EMAIL_USERNAME = "mail.username";
public static final String EMAIL_PASSWORD = "mail.password";
public static final String CATEGORY_TITLES = "category.titles";
public static final String CATEGORY_VALUES = "category.values";
public static final String CATEGORY_IMAGES = "category.images";
Configuration cfg;
SessionFactory sf;
int adjustHours;
PropertyManager pm;
CacheManager cache;
// is really necessary when you are going to format it?
Locale myLocale = Locale.US;
String dburl;
String dbuser;
String dbpassword;
SimpleDateFormat qf = new SimpleDateFormat("yyyy-MM-dd", myLocale);
SimpleDateFormat monthNav = new SimpleDateFormat("yyyyMM", myLocale);
/** Constructor for PersonalBlogService. */
protected PersonalBlogService(Properties conn) throws InitializationException {
log.debug("initialization - constructor");
try {
cfg =
new Configuration()
.addClass(Post.class)
.addClass(Comment.class)
.addClass(Referrer.class)
.addClass(BlogProperty.class);
if (conn != null) {
cfg.setProperties(conn);
pm = new PropertyManager(conn);
} else {
pm = new PropertyManager();
}
// I want to take it out of here, for these
sf = cfg.buildSessionFactory();
} catch (Exception e) {
log.error("Error initializing PersonalBlog Service", e);
throw new InitializationException(e);
}
}
/** Singleton getInstance method */
public static PersonalBlogService getInstance() throws ServiceException {
if (service == null) {
try {
log.debug("Initializing PersonalBlog Service (WITHOUT CONNECTION PARMS)");
service = new PersonalBlogService(null);
} catch (ServiceException e) {
log.error("Error getting instance of PersonalBlog Service", e);
throw e;
}
}
return service;
}
public static PersonalBlogService getInstance(Properties conn) throws ServiceException {
if (service == null) {
try {
log.debug("Initializing PersonalBlog Service (WITH CONNECTION PARMS)");
service = new PersonalBlogService(conn);
} catch (Exception e) {
log.error("Error getting instance of PersonalBlog Service", e);
}
}
return service;
}
/*
* This method will return the most recent posts for today's date. This method
* will return a maximum of 25 total posts or three days worth of posts.
*
*/
public List<?> getPosts() throws ServiceException {
List<?> posts = null;
Calendar cal = Calendar.getInstance();
cal.add(Calendar.MONTH, -1);
/*@SuppressWarnings("tainting")*/
String startdate = (/*@Untainted*/ String) qf.format(cal.getTime());
posts =
executeQuery(
"from post in class net.eyde.personalblog.beans.Post "
+ "where post.created > '"
+ startdate
+ "' order by post.created desc");
return posts;
}
public List<?> getPostsByCategory(String category) throws ServiceException {
List<?> posts = null;
posts =
executeQuery(
"from post in class net.eyde.personalblog.beans.Post "
+ "where post.category like '%"
+ category
+ "%' order by post.created desc");
return posts;
}
private <T> List<T> executeQuery(@Untainted String query) {
try {
Session session = sf.openSession();
@SuppressWarnings({"unchecked"})
List<T> lst = (List<T>) session.find(query);
session.close();
return lst;
} catch (Exception e) {
log.error("Error while importing data", e);
return null;
}
}
}