org.wandora.application.tools.exporters

Class SQLDumpExport

java.lang.Object

org.wandora.application.tools.AbstractWandoraTool

org.wandora.application.tools.exporters.AbstractExportTool

org.wandora.application.tools.exporters.SQLDumpExport

All Implemented Interfaces:

java.io.Serializable, java.lang.Runnable, WandoraTool, WandoraToolLogger, TopicMapLogger

public class SQLDumpExport
extends AbstractExportTool

Author:

olli

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	SQLDumpExport.XTM2toSQL

Field Summary

Fields

Modifier and Type	Field and Description
protected int	associationCount
protected int	dataCount
static int	I_ASSOCIATION
static int	I_DATA
static int	I_MEMBER
static int	I_SUBJECTIDENTIFIER
static int	I_TOPIC
static int	I_TOPICTYPE
static int	I_VARIANT
static int	I_VARIANTSCOPE
private static int	idcounter
protected int	memberCount
protected int	subjectIdentifierCount
protected int	topicCount
protected int	topicTypeCount
protected int	variantCount
protected int	variantScopeCount
protected int	writeLimit

Fields inherited from interface org.wandora.application.WandoraToolLogger

CLOSE, EXECUTE, INVISIBLE, VISIBLE, WAIT

Constructor Summary

Constructors

Constructor and Description
SQLDumpExport()

Method Summary

Modifier and Type	Method and Description
void	appendFile(java.io.OutputStream out, java.io.File in)
void	appendFile(java.io.OutputStream out, java.io.InputStream in)
void	closeStream(int count, java.io.PrintStream out)
void	closeStreams(java.io.PrintStream[] out)
void	convertXTM2ToSQL(java.io.InputStream in, java.io.PrintStream outs, TopicMapLogger logger)
void	disableForeignKeys(java.io.PrintStream out)
void	enableForeignKeys(java.io.PrintStream out)
void	execute(Wandora admin, Context context) Runs the tool.
java.lang.String	getDescription() AdminToolManager views tool descriptions while user browses available tools and build user customizable GUI elements such as Tools menu.
java.lang.String	getName() Tools name represent the tool in UI unless the tool has been given explicitly another GUI name.
static void	main(java.lang.String[] args)
protected static java.lang.String	makeID(java.lang.String prefix)
boolean	requiresRefresh() If any visible topic has been changed during tool execution GUI is automatically refreshed.
java.lang.String	sqlEscape(java.lang.String s)
void	writeAssociation(java.lang.String associationid, java.lang.String typeid, java.io.PrintStream out)
void	writeAssociation(java.lang.String associationid, java.lang.String typeid, java.io.PrintStream[] out)
void	writeData(java.lang.String topicid, java.lang.String typeid, java.lang.String versionid, java.lang.String data, java.io.PrintStream out)
void	writeData(java.lang.String topicid, java.lang.String typeid, java.lang.String versionid, java.lang.String data, java.io.PrintStream[] out)
void	writeMember(java.lang.String associationid, java.lang.String playerid, java.lang.String roleid, java.io.PrintStream out)
void	writeMember(java.lang.String associationid, java.lang.String playerid, java.lang.String roleid, java.io.PrintStream[] out)
void	writeSubjectIdentifier(java.lang.String topicid, java.lang.String si, java.io.PrintStream out)
void	writeSubjectIdentifier(java.lang.String topicid, java.lang.String si, java.io.PrintStream[] out)
void	writeTopic(java.lang.String topicid, java.lang.String baseName, Locator subjectLocator, java.io.PrintStream out)
void	writeTopic(java.lang.String topicid, java.lang.String baseName, Locator subjectLocator, java.io.PrintStream[] out)
void	writeTopic(java.lang.String topicid, java.lang.String baseName, java.lang.String subjectLocator, java.io.PrintStream out)
void	writeTopic(java.lang.String topicid, java.lang.String baseName, java.lang.String subjectLocator, java.io.PrintStream[] out)
void	writeTopicType(java.lang.String topicid, java.lang.String typeid, java.io.PrintStream out)
void	writeTopicType(java.lang.String topicid, java.lang.String typeid, java.io.PrintStream[] out)
void	writeVariant(java.lang.String variantid, java.lang.String topicid, java.lang.String value, java.io.PrintStream out)
void	writeVariant(java.lang.String variantid, java.lang.String topicid, java.lang.String value, java.io.PrintStream[] out)
void	writeVariantScope(java.lang.String variantid, java.lang.String topicid, java.io.PrintStream out)
void	writeVariantScope(java.lang.String variantid, java.lang.String topicid, java.io.PrintStream[] out)

Methods inherited from class org.wandora.application.tools.exporters.AbstractExportTool

getIcon, getType, makeTopicMapWith, makeTopicMapWith

Methods inherited from class org.wandora.application.tools.AbstractWandoraTool

addUndoMarker, addUndoMarker, allowMultipleInvocations, clearAllThreads, clearThreads, clearThreads, clearToolLock, clearToolLock, clearToolLocks, configure, execute, execute, forceStop, forceStop, getContext, getCurrentLogger, getDefaultLogger, getHistory, getLastLogger, getState, getThreads, getThreads, getToolMenuItem, getToolMenuItem, getTopicName, hlog, initialize, interruptAllThreads, interruptThreads, interruptThreads, isConfigurable, isRunning, isRunning, lockLog, log, log, log, log, run, runInOwnThread, setContext, setDefaultLogger, setLogTitle, setProgress, setProgressMax, setState, setToolLogger, singleLog, singleLog, singleLog, solveContextTopicMap, solveNameForTopicMap, writeOptions

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.wandora.application.WandoraTool

configure, execute, execute, getContext, getToolMenuItem, hlog, initialize, isConfigurable, isRunning, log, log, log, log, setContext, setToolLogger, writeOptions

Methods inherited from interface org.wandora.application.WandoraToolLogger

forceStop, getHistory, getState, lockLog, setLogTitle, setProgress, setProgressMax, setState

Field Detail

I_TOPIC

public static final int I_TOPIC

See Also:

Constant Field Values

I_ASSOCIATION

public static final int I_ASSOCIATION

See Also:

Constant Field Values

I_MEMBER

public static final int I_MEMBER

See Also:

Constant Field Values

I_SUBJECTIDENTIFIER

public static final int I_SUBJECTIDENTIFIER

See Also:

Constant Field Values

I_TOPICTYPE

public static final int I_TOPICTYPE

See Also:

Constant Field Values

I_DATA

public static final int I_DATA

See Also:

Constant Field Values

I_VARIANT

public static final int I_VARIANT

See Also:

Constant Field Values

I_VARIANTSCOPE

public static final int I_VARIANTSCOPE

See Also:

Constant Field Values

idcounter

private static int idcounter

writeLimit

protected int writeLimit

topicCount

protected int topicCount

topicTypeCount

protected int topicTypeCount

associationCount

protected int associationCount

memberCount

protected int memberCount

subjectIdentifierCount

protected int subjectIdentifierCount

dataCount

protected int dataCount

variantScopeCount

protected int variantScopeCount

variantCount

protected int variantCount

Constructor Detail

SQLDumpExport

public SQLDumpExport()

Method Detail

getName

public java.lang.String getName()

Description copied from class: AbstractWandoraTool

Tools name represent the tool in UI unless the tool has been given explicitly another GUI name. All tools should override this method and return a valid string representing name of the tool.

Specified by:

getName in interface WandoraTool

Overrides:

getName in class AbstractWandoraTool

Returns:

String representing tool's name.

getDescription

public java.lang.String getDescription()

Description copied from class: AbstractWandoraTool

AdminToolManager views tool descriptions while user browses available tools and build user customizable GUI elements such as Tools menu. By default description equals the tool name. All tools should override this method.

Specified by:

getDescription in interface WandoraTool

Overrides:

getDescription in class AbstractWandoraTool

Returns:

String representing tool's description.

requiresRefresh

public boolean requiresRefresh()

Description copied from class: AbstractWandoraTool

If any visible topic has been changed during tool execution GUI is automatically refreshed. If tool doesn't change topics but GUI still requires refresh, tool should override this method and return true.

For example tools that alter the GUI but change no topics should return true.

Specified by:

requiresRefresh in interface WandoraTool

Overrides:

requiresRefresh in class AbstractWandoraTool

Returns:

true if Wandora application should refresh user interface.

makeID

protected static java.lang.String makeID(java.lang.String prefix)

execute

public void execute(Wandora admin,
                    Context context)
             throws TopicMapException

Description copied from interface: WandoraTool

Runs the tool. This is the main entry to the tool. Here the context

Throws:

TopicMapException

appendFile

public void appendFile(java.io.OutputStream out,
                       java.io.File in)
                throws java.io.IOException

Throws:

java.io.IOException

appendFile

public void appendFile(java.io.OutputStream out,
                       java.io.InputStream in)
                throws java.io.IOException

Throws:

java.io.IOException

sqlEscape

public java.lang.String sqlEscape(java.lang.String s)

disableForeignKeys

public void disableForeignKeys(java.io.PrintStream out)
                        throws java.io.IOException

Throws:

java.io.IOException

enableForeignKeys

public void enableForeignKeys(java.io.PrintStream out)
                       throws java.io.IOException

Throws:

java.io.IOException

closeStream

public void closeStream(int count,
                        java.io.PrintStream out)
                 throws java.io.IOException

Throws:

java.io.IOException

closeStreams

public void closeStreams(java.io.PrintStream[] out)
                  throws java.io.IOException

Throws:

java.io.IOException

writeTopic

public void writeTopic(java.lang.String topicid,
                       java.lang.String baseName,
                       Locator subjectLocator,
                       java.io.PrintStream[] out)
                throws java.io.IOException

Throws:

java.io.IOException

writeTopic

public void writeTopic(java.lang.String topicid,
                       java.lang.String baseName,
                       java.lang.String subjectLocator,
                       java.io.PrintStream[] out)
                throws java.io.IOException

Throws:

java.io.IOException

writeTopic

public void writeTopic(java.lang.String topicid,
                       java.lang.String baseName,
                       Locator subjectLocator,
                       java.io.PrintStream out)
                throws java.io.IOException

Throws:

java.io.IOException

writeTopic

public void writeTopic(java.lang.String topicid,
                       java.lang.String baseName,
                       java.lang.String subjectLocator,
                       java.io.PrintStream out)
                throws java.io.IOException

Throws:

java.io.IOException

writeTopicType

public void writeTopicType(java.lang.String topicid,
                           java.lang.String typeid,
                           java.io.PrintStream[] out)
                    throws java.io.IOException

Throws:

java.io.IOException

writeTopicType

public void writeTopicType(java.lang.String topicid,
                           java.lang.String typeid,
                           java.io.PrintStream out)
                    throws java.io.IOException

Throws:

java.io.IOException

writeAssociation

public void writeAssociation(java.lang.String associationid,
                             java.lang.String typeid,
                             java.io.PrintStream[] out)
                      throws java.io.IOException

Throws:

java.io.IOException

writeAssociation

public void writeAssociation(java.lang.String associationid,
                             java.lang.String typeid,
                             java.io.PrintStream out)
                      throws java.io.IOException

Throws:

java.io.IOException

writeMember

public void writeMember(java.lang.String associationid,
                        java.lang.String playerid,
                        java.lang.String roleid,
                        java.io.PrintStream[] out)
                 throws java.io.IOException

Throws:

java.io.IOException

writeMember

public void writeMember(java.lang.String associationid,
                        java.lang.String playerid,
                        java.lang.String roleid,
                        java.io.PrintStream out)
                 throws java.io.IOException

Throws:

java.io.IOException

writeSubjectIdentifier

public void writeSubjectIdentifier(java.lang.String topicid,
                                   java.lang.String si,
                                   java.io.PrintStream[] out)
                            throws java.io.IOException

Throws:

java.io.IOException

writeSubjectIdentifier

public void writeSubjectIdentifier(java.lang.String topicid,
                                   java.lang.String si,
                                   java.io.PrintStream out)
                            throws java.io.IOException

Throws:

java.io.IOException

writeData

public void writeData(java.lang.String topicid,
                      java.lang.String typeid,
                      java.lang.String versionid,
                      java.lang.String data,
                      java.io.PrintStream[] out)
               throws java.io.IOException

Throws:

java.io.IOException

writeData

public void writeData(java.lang.String topicid,
                      java.lang.String typeid,
                      java.lang.String versionid,
                      java.lang.String data,
                      java.io.PrintStream out)
               throws java.io.IOException

Throws:

java.io.IOException

writeVariantScope

public void writeVariantScope(java.lang.String variantid,
                              java.lang.String topicid,
                              java.io.PrintStream[] out)
                       throws java.io.IOException

Throws:

java.io.IOException

writeVariantScope

public void writeVariantScope(java.lang.String variantid,
                              java.lang.String topicid,
                              java.io.PrintStream out)
                       throws java.io.IOException

Throws:

java.io.IOException

writeVariant

public void writeVariant(java.lang.String variantid,
                         java.lang.String topicid,
                         java.lang.String value,
                         java.io.PrintStream[] out)
                  throws java.io.IOException

Throws:

java.io.IOException

writeVariant

public void writeVariant(java.lang.String variantid,
                         java.lang.String topicid,
                         java.lang.String value,
                         java.io.PrintStream out)
                  throws java.io.IOException

Throws:

java.io.IOException

convertXTM2ToSQL

public void convertXTM2ToSQL(java.io.InputStream in,
                             java.io.PrintStream outs,
                             TopicMapLogger logger)

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception

Throws:

java.lang.Exception