/** rss item 문자열 생성 */
private static String rssItemStr(RssItem item) {
StringBuilder buffer = new StringBuilder();
buffer.append(" "); // 들여쓰기용
buffer.append("<item>");
if (item.getTitle() != null && !"".equals(item.getTitle()))
buffer.append("<title>" + "<![CDATA[" + item.getTitle() + "]]>" + "</title>");
if (item.getLink() != null && !"".equals(item.getLink()))
buffer.append("<link>" + item.getLink() + "</link>");
if (item.getDescription() != null && !"".equals(item.getDescription()))
buffer.append(
"<description>"
+ "<![CDATA["
+ item.getDescription().replaceAll(BR, "")
+ "]]>"
+ "</description>");
if (item.getAuthor() != null && !"".equals(item.getAuthor()))
buffer.append("<author>" + item.getAuthor() + "</author>");
if (item.getCategory() != null && !"".equals(item.getCategory()))
buffer.append("<category>" + "<![CDATA[" + item.getCategory() + "]]>" + "</category>");
if (item.getLink() != null && !"".equals(item.getLink()))
buffer.append("<guid>" + item.getLink() + "</guid>");
if (item.getPubDate() != null)
buffer.append("<pubDate>" + toRfc822DateFormat(item.getPubDate()) + "</pubDate>");
buffer.append("</item>");
return buffer.toString();
}
public boolean insertToDB(RssItem item) {
// query if it already exit
Cursor cursor =
getContentResolver()
.query(
RSSApp.RssItems.CONTENT_URI,
PROJECTION,
RSSApp.RssItems.COLUMN_NAME_PUBDATE + "=" + "'" + item.getPubDate() + "'",
null,
null);
int count = 0;
if (cursor != null) {
count = cursor.getCount();
}
if (count == 0) {
ContentValues values = new ContentValues();
values.put(RSSApp.RssItems.COLUMN_NAME_TITLE, item.getTitle());
values.put(RSSApp.RssItems.COLUMN_NAME_DESCRIPTION, item.getDescription());
values.put(RSSApp.RssItems.COLUMN_NAME_PUBDATE, item.getPubDate());
Uri newUri = getContentResolver().insert(RSSApp.RssItems.CONTENT_URI, values);
if (newUri != null) {
log("insertToDB: " + newUri);
return true;
} else {
log("insertToDb: fail!");
}
} else {
mHandler.post(
new Runnable() {
@Override
public void run() {
Toast.makeText(getApplicationContext(), "no more update !", Toast.LENGTH_SHORT)
.show();
}
});
log("DB already has this record : title = " + item.getTitle());
}
return false;
}
