Package com.openindex.openestate.tool.news.db.hsql

Class HSqlDbNewsHandler

java.lang.Object

com.openindex.openestate.tool.news.db.DbNewsHandlerImpl

com.openindex.openestate.tool.news.db.hsql.HSqlDbNewsHandler

All Implemented Interfaces:

DbNewsHandler

public class HSqlDbNewsHandler
extends DbNewsHandlerImpl

HSqlDbNewsHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field	Description
static String	FIELD_ENTRY_AUTHOR
static String	FIELD_ENTRY_CONTENT
static String	FIELD_ENTRY_ID
static String	FIELD_ENTRY_LINK
static String	FIELD_ENTRY_NEW
static String	FIELD_ENTRY_STICKY
static String	FIELD_ENTRY_TIME
static String	FIELD_ENTRY_TITLE
static String	FIELD_ENTRY_URI
static String	FIELD_FEED_ARCHIVED
static String	FIELD_FEED_AUTH_METHOD
static String	FIELD_FEED_AUTH_PASS
static String	FIELD_FEED_AUTH_USER
static String	FIELD_FEED_DOWNLOADED_AT
static String	FIELD_FEED_ID
static String	FIELD_FEED_NAME
static String	FIELD_FEED_NOTES
static String	FIELD_FEED_PUBLISHED_AT
static String	FIELD_FEED_UPDATE_ENABLED
static String	FIELD_FEED_UPDATE_INTERVAL
static String	FIELD_FEED_URL
static String	PROC_REMOVE_ENTRIES
static String	PROC_REMOVE_FEEDS
static String	PROC_SAVE_ENTRIES
static String	PROC_SAVE_FEEDS
static String	TABLE_NEWS_ENTRIES
static String	TABLE_NEWS_FEEDS
static String	VIEW_ENTRIES
static String	VIEW_FEEDS

Constructor Summary

Constructors

Constructor	Description
HSqlDbNewsHandler()

Method Summary

Modifier and Type	Method	Description
DbNewsEntry[]	getEntries(Connection c, long[] feedIds)
DbNewsEntry	getEntry(Connection c, long feedId, String uri)
long[]	getEntryIds(Connection c, long[] feedIds)
long[]	getFeedIds(Connection c, Boolean enabled)
DbNewsFeed[]	getFeeds(Connection c, long[] ids)
DbNewsFeed[]	getFeeds(Connection c, Boolean updateEnabled)
void	removeEntries(Connection c, long[] ids)
void	removeFeeds(Connection c, long[] ids)
void	saveEntry(Connection c, DbNewsEntry entry)
void	saveFeed(Connection c, DbNewsFeed feed)

Methods inherited from class com.openindex.openestate.tool.news.db.DbNewsHandlerImpl

getEntries, getEntries, getEntryIds, getEntryIds, getFeed, getFeedIds, getFeeds, removeEntry, removeFeed, removeFeedEntries, removeFeedEntries

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

PROC_REMOVE_FEEDS

public static final String PROC_REMOVE_FEEDS

See Also:

Constant Field Values

PROC_REMOVE_ENTRIES

public static final String PROC_REMOVE_ENTRIES

See Also:

Constant Field Values

PROC_SAVE_FEEDS

public static final String PROC_SAVE_FEEDS

See Also:

Constant Field Values

PROC_SAVE_ENTRIES

public static final String PROC_SAVE_ENTRIES

See Also:

Constant Field Values

VIEW_FEEDS

public static final String VIEW_FEEDS

See Also:

Constant Field Values

VIEW_ENTRIES

public static final String VIEW_ENTRIES

See Also:

Constant Field Values

TABLE_NEWS_FEEDS

public static final String TABLE_NEWS_FEEDS

See Also:

Constant Field Values

FIELD_FEED_ID

public static final String FIELD_FEED_ID

See Also:

Constant Field Values

FIELD_FEED_NAME

public static final String FIELD_FEED_NAME

See Also:

Constant Field Values

FIELD_FEED_URL

public static final String FIELD_FEED_URL

See Also:

Constant Field Values

FIELD_FEED_AUTH_METHOD

public static final String FIELD_FEED_AUTH_METHOD

See Also:

Constant Field Values

FIELD_FEED_AUTH_USER

public static final String FIELD_FEED_AUTH_USER

See Also:

Constant Field Values

FIELD_FEED_AUTH_PASS

public static final String FIELD_FEED_AUTH_PASS

See Also:

Constant Field Values

FIELD_FEED_NOTES

public static final String FIELD_FEED_NOTES

See Also:

Constant Field Values

FIELD_FEED_ARCHIVED

public static final String FIELD_FEED_ARCHIVED

See Also:

Constant Field Values

FIELD_FEED_UPDATE_ENABLED

public static final String FIELD_FEED_UPDATE_ENABLED

See Also:

Constant Field Values

FIELD_FEED_UPDATE_INTERVAL

public static final String FIELD_FEED_UPDATE_INTERVAL

See Also:

Constant Field Values

FIELD_FEED_DOWNLOADED_AT

public static final String FIELD_FEED_DOWNLOADED_AT

See Also:

Constant Field Values

FIELD_FEED_PUBLISHED_AT

public static final String FIELD_FEED_PUBLISHED_AT

See Also:

Constant Field Values

TABLE_NEWS_ENTRIES

public static final String TABLE_NEWS_ENTRIES

See Also:

Constant Field Values

FIELD_ENTRY_ID

public static final String FIELD_ENTRY_ID

See Also:

Constant Field Values

FIELD_ENTRY_URI

public static final String FIELD_ENTRY_URI

See Also:

Constant Field Values

FIELD_ENTRY_TITLE

public static final String FIELD_ENTRY_TITLE

See Also:

Constant Field Values

FIELD_ENTRY_AUTHOR

public static final String FIELD_ENTRY_AUTHOR

See Also:

Constant Field Values

FIELD_ENTRY_CONTENT

public static final String FIELD_ENTRY_CONTENT

See Also:

Constant Field Values

FIELD_ENTRY_LINK

public static final String FIELD_ENTRY_LINK

See Also:

Constant Field Values

FIELD_ENTRY_TIME

public static final String FIELD_ENTRY_TIME

See Also:

Constant Field Values

FIELD_ENTRY_NEW

public static final String FIELD_ENTRY_NEW

See Also:

Constant Field Values

FIELD_ENTRY_STICKY

public static final String FIELD_ENTRY_STICKY

See Also:

Constant Field Values

Constructor Detail

HSqlDbNewsHandler

public HSqlDbNewsHandler()

Method Detail

getEntries

public DbNewsEntry[] getEntries(Connection c,
                                long[] feedIds)
                         throws SQLException

Specified by:

getEntries in interface DbNewsHandler

Specified by:

getEntries in class DbNewsHandlerImpl

Throws:

SQLException

getEntry

public DbNewsEntry getEntry(Connection c,
                            long feedId,
                            String uri)
                     throws SQLException

Specified by:

getEntry in interface DbNewsHandler

Specified by:

getEntry in class DbNewsHandlerImpl

Throws:

SQLException

getEntryIds

public long[] getEntryIds(Connection c,
                          long[] feedIds)
                   throws SQLException

Specified by:

getEntryIds in interface DbNewsHandler

Specified by:

getEntryIds in class DbNewsHandlerImpl

Throws:

SQLException

getFeeds

public DbNewsFeed[] getFeeds(Connection c,
                             long[] ids)
                      throws SQLException

Specified by:

getFeeds in interface DbNewsHandler

Specified by:

getFeeds in class DbNewsHandlerImpl

Throws:

SQLException

getFeeds

public DbNewsFeed[] getFeeds(Connection c,
                             Boolean updateEnabled)
                      throws SQLException

Specified by:

getFeeds in interface DbNewsHandler

Specified by:

getFeeds in class DbNewsHandlerImpl

Throws:

SQLException

getFeedIds

public long[] getFeedIds(Connection c,
                         Boolean enabled)
                  throws SQLException

Specified by:

getFeedIds in interface DbNewsHandler

Specified by:

getFeedIds in class DbNewsHandlerImpl

Throws:

SQLException

removeEntries

public void removeEntries(Connection c,
                          long[] ids)
                   throws SQLException

Specified by:

removeEntries in interface DbNewsHandler

Specified by:

removeEntries in class DbNewsHandlerImpl

Throws:

SQLException

removeFeeds

public void removeFeeds(Connection c,
                        long[] ids)
                 throws SQLException

Specified by:

removeFeeds in interface DbNewsHandler

Specified by:

removeFeeds in class DbNewsHandlerImpl

Throws:

SQLException

saveEntry

public void saveEntry(Connection c,
                      DbNewsEntry entry)
               throws SQLException

Specified by:

saveEntry in interface DbNewsHandler

Specified by:

saveEntry in class DbNewsHandlerImpl

Throws:

SQLException

saveFeed

public void saveFeed(Connection c,
                     DbNewsFeed feed)
              throws SQLException

Specified by:

saveFeed in interface DbNewsHandler

Specified by:

saveFeed in class DbNewsHandlerImpl

Throws:

SQLException