import java.util.Arrays;
import java.util.Iterator;
import java.util.List;
-import java.util.Vector;
import mir.entity.EntityList;
import mir.log.LoggerWrapper;
import mir.storage.Database;
-import mir.storage.StorageObject;
import mir.storage.StorageObjectFailure;
import mircoders.entity.EntityContent;
import mircoders.entity.EntityTopics;
*
*/
-public class DatabaseContentToTopics extends Database implements StorageObject{
+public class DatabaseContentToTopics extends Database {
private static DatabaseContentToTopics instance;
super();
logger = new LoggerWrapper("Database.ContentToTopics");
-
- hasTimestamp = false;
- theTable="content_x_topic";
- theEntityClass = mir.entity.GenericEntity.class;
+ mainTable="content_x_topic";
+ entityClass = mir.entity.GenericEntity.class;
}
/**
* This class return an EntityList of Topics
- * @param EntityContent content
- * @returns EntityList
*/
public EntityList getTopics(EntityContent content) {
EntityList returnList=null;
if (content != null) {
- // get all to_topic from content_x_topic
- // TODO rewrite with getByWhereClauseWithExtraTables
- // select t.* from topics t, content_x_topic cxt where t.id=cxt.topic_id
- // and cxt.content_id=<id>
-
- String id = content.getId();
- //String subselect = "id in (select topic_id from " + theTable + " where content_id=" + id+")";
+ String id = content.getId();
try {
- Vector extraTables = new Vector();
- extraTables.add(theTable+" cxt");
+ ArrayList extraTables = new ArrayList();
+ extraTables.add(mainTable+" cxt");
returnList = DatabaseTopics.getInstance()
- .selectByWhereClauseWithExtraTables("t",extraTables,
+ .selectByWhereClauseWithExtraTables("t",extraTables,
"t.id=cxt.topic_id and cxt.content_id="+id );
- // .selectByWhereClause(subselect,-1);
}
catch (Exception e) {
logger.error("-- get topics failed " + e.toString());
}
/**
- * Returns a ArrayList of Integer-Objects from a content-id.
- * @returns ArrayList
+ * Returns a List of String-Objects from a content-id.
*/
public List getTopicsOfContent(String contentId)
throws StorageObjectFailure {
ArrayList returnList = new ArrayList();
if (contentId != null) {
- String sql = "select topic_id from " + theTable + " where content_id=" + contentId;
+ String sql = "select topic_id from " + mainTable + " where content_id=" + contentId;
Connection con=null;Statement stmt=null;
try {
- con = getPooledCon();
+ con = obtainConnection();
+
// should be a preparedStatement because is faster
stmt = con.createStatement();
ResultSet rs = executeSql(stmt,sql);
if(rs!=null){
while(rs.next()){
- returnList.add(new Integer(rs.getInt("topic_id")));
+ returnList.add(Integer.toString(rs.getInt("topic_id")));
}
}
}
}
public void setTopics(String anArticleId, List aTopics) throws StorageObjectFailure {
- List newTopics = new Vector();
+ List newTopics = new ArrayList();
if (aTopics!=null) {
Iterator i = aTopics.iterator();
List currentTopics = getTopicsOfContent(anArticleId);
logger.debug("New topics = " + newTopics.toString());
logger.debug("Current topics = " + currentTopics.toString());
- List topicsToDelete = new Vector(currentTopics);
+ List topicsToDelete = new ArrayList(currentTopics);
topicsToDelete.removeAll(newTopics);
- List topicsToAdd = new Vector(newTopics);
+ List topicsToAdd = new ArrayList(newTopics);
topicsToAdd.removeAll(currentTopics);
logger.debug("to delete = " + topicsToDelete.toString());
logger.debug("to add = " + topicsToAdd.toString());
- if (!topicsToDelete.isEmpty()) {
+ if (!topicsToDelete.isEmpty()) {
String sql =
- "delete from " + theTable + " " +
+ "delete from " + mainTable + " " +
"where content_id=" + anArticleId +
" and topic_id in (" + getIdListExpression(topicsToDelete) + ")";
Connection connection=null;
Statement statement=null;
try {
- connection = getPooledCon();
+ connection = obtainConnection();
statement = connection.createStatement();
- int rs = executeUpdate(statement, sql);
+ executeUpdate(statement, sql);
}
catch (Exception e) {
logger.error("-- deleting topics failed");
while (i.hasNext()) {
Integer topicId = (Integer) i.next();
String sql =
- "insert into " + theTable + " (content_id, topic_id) "+
+ "insert into " + mainTable + " (content_id, topic_id) "+
"values (" + anArticleId + "," + topicId + ")";
Connection connection=null;
Statement statement=null;
try {
- connection = getPooledCon();
+ connection = obtainConnection();
// should be a preparedStatement because is faster
statement = connection.createStatement();
- int rs = executeUpdate(statement, sql);
+ executeUpdate(statement, sql);
}
catch (Exception e) {
logger.error("-- adding topics failed");
return;
}
//delete all row with content_id=contentId
- String sql = "delete from "+ theTable +" where content_id=" + contentId;
+ String sql = "delete from "+ mainTable +" where content_id=" + contentId;
Connection con=null;Statement stmt=null;
try {
- con = getPooledCon();
+ con = obtainConnection();
// should be a preparedStatement because is faster
stmt = con.createStatement();
- ResultSet rs = executeSql(stmt,sql);
+ executeSql(stmt,sql);
} catch (Exception e) {
//theLog.printDebugInfo("-- delete topics failed ");
} finally {
return;
}
//delete all row with content_id=contentId
- String sql = "delete from "+ theTable +" where topic_id=" + topicId;
+ String sql = "delete from "+ mainTable +" where topic_id=" + topicId;
Connection con=null;Statement stmt=null;
try {
- con = getPooledCon();
+ con = obtainConnection();
// should be a preparedStatement because is faster
stmt = con.createStatement();
- ResultSet rs = executeSql(stmt,sql);
+ executeSql(stmt,sql);
}
catch (Exception e) {
logger.error("-- delete topics failed ");
}
}
-
+/**
+ * Returns list of Content for a specific topic
+ * @param topic
+ * @return EntityList
+ * @throws StorageObjectFailure
+ */
public EntityList getContent(EntityTopics topic)
throws StorageObjectFailure {
EntityList returnList=null;
if (topic != null) {
- // TODO rewrite with getByWhereClauseWithExtraTables
- //
-
String id = topic.getId();
- String select = "select content_id from " + theTable + " where topic_id=" + id;
-
- // execute select statement
- Connection con=null;Statement stmt=null;
try {
- con = getPooledCon();
- // should be a preparedStatement because is faster
- stmt = con.createStatement();
- ResultSet rs = executeSql(stmt,select);
- if (rs!=null) {
- String topicSelect= "id IN (";
- boolean first=true;
- while (rs.next()) {
- if (first==false) topicSelect+=",";
- topicSelect += rs.getString(1);
- first=false;
- }
- topicSelect+=")";
- if (first==false)
- returnList = DatabaseContent.getInstance().selectByWhereClause(topicSelect,-1);
- }
+ ArrayList extraTables = new ArrayList();
+ extraTables.add(mainTable+" cxt");
+ returnList = DatabaseContent.getInstance()
+ .selectByWhereClauseWithExtraTables("c",extraTables,
+ "c.id=cxt.content_id and cxt.topic_id="+id );
}
catch (Exception e) {
logger.error("-- get content failed");
}
- finally { freeConnection(con,stmt);}
}
return returnList;
}