org.encog.bot.spider.workload.sql
Class SQLHolder

java.lang.Object
  org.encog.bot.spider.workload.sql.SQLHolder

Direct Known Subclasses:

OracleHolder

public class SQLHolder
extends java.lang.Object

SQLHolder: This class holds the SQL statements used by the Heaton Research Spider. This is the generic set that should work with most DBMS systems. However you will also find customized versions of this class to support specific DBMS systems, when it is needed.

Constructor Summary

SQLHolder()

Method Summary

java.lang.String	getSQLAdd() Add to the workload.
java.lang.String	getSQLAdd2() Add to the hosts list.
java.lang.String	getSQLClear() Clear the workload.
java.lang.String	getSQLClear2() Clear the host table.
java.lang.String	getSQLGetDepth() Get the depth of a URL.
java.lang.String	getSQLGetHost() Find a host.
java.lang.String	getSQLGetHostID() Find a host ID.
java.lang.String	getSQLGetNextHost() Get the next host to process.
java.lang.String	getSQLGetSource() Get the source for a URL.
java.lang.String	getSQLGetWork() Get a URL from the workload.
java.lang.String	getSQLGetWork2() Set the status of a workload element.
java.lang.String	getSQLGetWorkloadID() Get the workload id for a url.
java.lang.String	getSQLResume() Resume an aborted spider run.
java.lang.String	getSQLResume2() Resume an aborted spider run.
java.lang.String	getSQLSetHostStatus() Update the status of a host.
java.lang.String	getSQLSetWorkloadStatus() Update the status of a workload.
java.lang.String	getSQLSetWorkloadStatus2() Get a workload status.
java.lang.String	getSQLWorkloadEmpty() Determine if the workload is empty.

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLHolder

public SQLHolder()

Method Detail

getSQLAdd

public java.lang.String getSQLAdd()

Add to the workload.

Returns:

A SQL command.

getSQLAdd2

public java.lang.String getSQLAdd2()

Add to the hosts list.

Returns:

A SQL command.

getSQLClear

public java.lang.String getSQLClear()

Clear the workload.

Returns:

A SQL command.

getSQLClear2

public java.lang.String getSQLClear2()

Clear the host table.

Returns:

A SQL command.

getSQLGetDepth

public java.lang.String getSQLGetDepth()

Get the depth of a URL.

Returns:

A SQL command.

getSQLGetHost

public java.lang.String getSQLGetHost()

Find a host.

Returns:

A SQL command.

getSQLGetHostID

public java.lang.String getSQLGetHostID()

Find a host ID.

Returns:

A SQL command.

getSQLGetNextHost

public java.lang.String getSQLGetNextHost()

Get the next host to process.

Returns:

A SQL command.

getSQLGetSource

public java.lang.String getSQLGetSource()

Get the source for a URL.

Returns:

A SQL command.

getSQLGetWork

public java.lang.String getSQLGetWork()

Get a URL from the workload.

Returns:

A SQL command.

getSQLGetWork2

public java.lang.String getSQLGetWork2()

Set the status of a workload element.

Returns:

A SQL command.

getSQLGetWorkloadID

public java.lang.String getSQLGetWorkloadID()

Get the workload id for a url.

Returns:

A SQL command.

getSQLResume

public java.lang.String getSQLResume()

Resume an aborted spider run.

Returns:

A SQL command.

getSQLResume2

public java.lang.String getSQLResume2()

Resume an aborted spider run.

Returns:

A SQL command.

getSQLSetHostStatus

public java.lang.String getSQLSetHostStatus()

Update the status of a host.

Returns:

A SQL command.

getSQLSetWorkloadStatus

public java.lang.String getSQLSetWorkloadStatus()

Update the status of a workload.

Returns:

A SQL command.

getSQLSetWorkloadStatus2

public java.lang.String getSQLSetWorkloadStatus2()

Get a workload status.

Returns:

A SQL command.

getSQLWorkloadEmpty

public java.lang.String getSQLWorkloadEmpty()

Determine if the workload is empty.

Returns:

A SQL command.