public class DatabaseSaver extends AbstractSaver implements BatchConverter, IncrementalConverter, DatabaseConverter, OptionHandler
-url <JDBC URL> The JDBC URL to connect to. (default: from DatabaseUtils.props file)
-user <name> The user to connect with to the database. (default: none)
-password <password> The password to connect with to the database. (default: none)
-T <table name> The name of the table. (default: the relation name)
-P Add an ID column as primary key. The name is specified in the DatabaseUtils file ('idColumn'). The DatabaseLoader won't load this column.
-i <input file name> Input file in arff format that should be saved in database.
BATCH, INCREMENTAL, NONE
Constructor and Description |
---|
DatabaseSaver()
Constructor.
|
Modifier and Type | Method and Description |
---|---|
java.lang.String |
autoKeyGenerationTipText()
Returns the tip text for this property.
|
void |
cancel()
Cancels the incremental saving process and tries to drop the table if
the write mode is CANCEL.
|
void |
connectToDatabase()
Opens a connection to the database.
|
boolean |
getAutoKeyGeneration()
Gets whether or not a primary key will be generated automatically.
|
Capabilities |
getCapabilities()
Returns the Capabilities of this saver.
|
java.lang.String[] |
getOptions()
Gets the setting.
|
java.lang.String |
getPassword()
Returns the database password.
|
boolean |
getRelationForTableName()
Gets whether or not the relation name is used as name of the table.
|
java.lang.String |
getRevision()
Returns the revision string.
|
java.lang.String |
getTableName()
Gets the table's name.
|
java.lang.String |
getUrl()
Gets the database URL.
|
java.lang.String |
getUser()
Gets the database user.
|
java.lang.String |
globalInfo()
Returns a string describing this Saver.
|
java.util.Enumeration |
listOptions()
Lists the available options.
|
static void |
main(java.lang.String[] options)
Main method.
|
java.lang.String |
passwordTipText()
Returns the tip text for this property.
|
java.lang.String |
relationForTableNameTipText()
Returns the tip text fo this property.
|
void |
resetOptions()
Resets the Saver ready to save a new data set.
|
void |
setAutoKeyGeneration(boolean flag)
En/Dis-ables the automatic generation of a primary key.
|
void |
setDestination()
Sets the database url using the DatabaseUtils file.
|
void |
setDestination(java.lang.String url)
Sets the database url.
|
void |
setDestination(java.lang.String url,
java.lang.String userName,
java.lang.String password)
Sets the database url.
|
void |
setOptions(java.lang.String[] options)
Sets the options.
|
void |
setPassword(java.lang.String password)
Sets the database password.
|
void |
setRelationForTableName(boolean flag)
En/Dis-ables that the relation name is used for the name of the table (default enabled).
|
void |
setTableName(java.lang.String tn)
Sets the table's name.
|
void |
setUrl(java.lang.String url)
Sets the database URL.
|
void |
setUser(java.lang.String user)
Sets the database user.
|
java.lang.String |
tableNameTipText()
Returns the tip text for this property.
|
java.lang.String |
urlTipText()
Returns the tip text for this property.
|
java.lang.String |
userTipText()
Returns the tip text for this property.
|
void |
writeBatch()
Writes a Batch of instances.
|
void |
writeIncremental(Instance inst)
Saves an instances incrementally.
|
filePrefix, getFileExtension, getInstances, getWriteMode, resetStructure, retrieveDir, setDestination, setDestination, setDir, setDirAndPrefix, setFile, setFilePrefix, setInstances, setRetrieval, setStructure
public DatabaseSaver() throws java.lang.Exception
java.lang.Exception
- throws Exception if property file cannot be readpublic void resetOptions()
resetOptions
in class AbstractSaver
public void cancel()
cancel
in class AbstractSaver
public java.lang.String globalInfo()
public void setTableName(java.lang.String tn)
tn
- the name of the tablepublic java.lang.String getTableName()
public java.lang.String tableNameTipText()
public void setAutoKeyGeneration(boolean flag)
flag
- flag for automatic key-genererationpublic boolean getAutoKeyGeneration()
public java.lang.String autoKeyGenerationTipText()
public void setRelationForTableName(boolean flag)
flag
- if true the relation name is used as table namepublic boolean getRelationForTableName()
public java.lang.String relationForTableNameTipText()
public void setUrl(java.lang.String url)
setUrl
in interface DatabaseConverter
url
- the URLpublic java.lang.String getUrl()
getUrl
in interface DatabaseConverter
public java.lang.String urlTipText()
public void setUser(java.lang.String user)
setUser
in interface DatabaseConverter
user
- the user namepublic java.lang.String getUser()
getUser
in interface DatabaseConverter
public java.lang.String userTipText()
public void setPassword(java.lang.String password)
setPassword
in interface DatabaseConverter
password
- the passwordpublic java.lang.String getPassword()
public java.lang.String passwordTipText()
public void setDestination(java.lang.String url, java.lang.String userName, java.lang.String password)
url
- the database urluserName
- the user namepassword
- the passwordpublic void setDestination(java.lang.String url)
url
- the database urlpublic void setDestination()
public Capabilities getCapabilities()
getCapabilities
in interface CapabilitiesHandler
getCapabilities
in class AbstractSaver
Capabilities
public void connectToDatabase()
public void writeIncremental(Instance inst) throws java.io.IOException
writeIncremental
in interface Saver
writeIncremental
in class AbstractSaver
inst
- the instance to savejava.io.IOException
- throws IOEXception.public void writeBatch() throws java.io.IOException
writeBatch
in interface Saver
writeBatch
in class AbstractSaver
java.io.IOException
- throws IOExceptionpublic java.lang.String[] getOptions()
getOptions
in interface OptionHandler
public java.util.Enumeration listOptions()
listOptions
in interface OptionHandler
public void setOptions(java.lang.String[] options) throws java.lang.Exception
-url <JDBC URL> The JDBC URL to connect to. (default: from DatabaseUtils.props file)
-user <name> The user to connect with to the database. (default: none)
-password <password> The password to connect with to the database. (default: none)
-T <table name> The name of the table. (default: the relation name)
-P Add an ID column as primary key. The name is specified in the DatabaseUtils file ('idColumn'). The DatabaseLoader won't load this column.
-i <input file name> Input file in arff format that should be saved in database.
setOptions
in interface OptionHandler
options
- the optionsjava.lang.Exception
- if options cannot be setpublic java.lang.String getRevision()
getRevision
in interface RevisionHandler
public static void main(java.lang.String[] options)
options
- should contain the options of a Saver.