org.openimaj.picslurper

Class DatabaseStatusFeeder

java.lang.Object

org.openimaj.picslurper.DatabaseStatusFeeder

All Implemented Interfaces:

StatusFeeder

public class DatabaseStatusFeeder
extends Object
implements StatusFeeder

This class is a status feeder for picslurper that takes statuses from a database. The default database driver is the MySQL driver and expects a mysql URL in the constructor; e.g. jdbc:mysql://localhost/database

The class connects to the database lazily (that is, only when the feed is started), so the driver can be changed after construction using setDriver(String).

The schema of the table must include at least two columns: one that contains the tweet text and one that contains the created time. The default column names are expected to be text and created_at respectively. These can be changed by passing in a map, where the key is the expected column name and the value is the actual column name; e.g. text -> tweet_text

The results are paged through in steps of 25 by default, so the database must support the LIMIT command.

Author:

David Dupplaw (dpd@ecs.soton.ac.uk)

Created:

18 Sep 2013

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	DatabaseStatusFeeder.DatabaseFeederStatus

Constructor Summary

Constructors

Constructor and Description
DatabaseStatusFeeder(String databaseURL, String table, String username, String password) Create a database status feeder using the database, table, username and password provided.
DatabaseStatusFeeder(String databaseURL, String table, String username, String password, Map<String,String> columnNames) Create a database status feeder using the database, table, username and password provided with the given column mapping

Method Summary

Modifier and Type	Method and Description
void	feedStatus(PicSlurper slurper) Start feeding statuses to the provided picslurper.
static void	main(String[] args)
void	setDriver(String driverName) Set the database driver to use.

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseStatusFeeder

public DatabaseStatusFeeder(String databaseURL,
                            String table,
                            String username,
                            String password)

Create a database status feeder using the database, table, username and password provided.

Parameters:

databaseURL - The URL to the database

table - The table to use

username - The user name

password - The password

DatabaseStatusFeeder

public DatabaseStatusFeeder(String databaseURL,
                            String table,
                            String username,
                            String password,
                            Map<String,String> columnNames)

Create a database status feeder using the database, table, username and password provided with the given column mapping

Parameters:

databaseURL - The URL to the database

table - The table to use

username - The user name

password - The password

columnNames - The column mapping

Method Detail

feedStatus

public void feedStatus(PicSlurper slurper)
                throws IOException

Start feeding statuses to the provided picslurper. This method should not block

Specified by:

feedStatus in interface StatusFeeder

Throws:

IOException

See Also:

StatusFeeder.feedStatus(org.openimaj.picslurper.PicSlurper)

setDriver

public void setDriver(String driverName)

Set the database driver to use.

Parameters:

driverName - The driver name.

main

public static void main(String[] args)

Parameters:

args -