org.syrup.sql.mysql
Class MySQLStatements

java.lang.Object
  org.syrup.sql.Functions
      org.syrup.sql.SQLStatements
          org.syrup.sql.mysql.MySQLStatements

public class MySQLStatements

extends SQLStatements

Utility class that provides all the MySQL statements needed for the creation, updating and deletion of Syrup objects.

Author:

Robbert van Dalen

Constructor Summary

MySQLStatements(SQLImpl impl)
Constructor for the MySQLStatements object

Method Summary

java.lang.String	createLinkTableStatement() Returns create table link(from_task varchar(255), from_port SMALLINT, to_task varchar(255), to_port SMALLINT, data BLOB, index(from_task), index(to_task), index(from_task, from_port), index(to_task, to_port)) ENGINE=InnoDB
java.lang.String	createLogTableStatement() Returns create table syrup_log(creation_time BIGINT not null, key_ varchar(255) not null, event INT not null, worker varchar(255) not null, index(creation_time), index(key_), index(event), index(worker)) ENGINE=InnoDB
java.lang.String	createTaskTableStatement() Returns create table task(key_ varchar(255) not null, parent_key varchar(255) not null, function_class varchar(255) not null, name varchar(255), description varchar(255), parameter varchar(255), environment varchar(255), or_type SMALLINT not null, worker varchar(255) not null, executable SMALLINT not null, done SMALLINT not null, creation_time BIGINT not null, modification_time BIGINT not null, modifications BIGINT not null, is_parent SMALLINT not null, index(key_), index(parent_key), index(function_class), index(name), index(description), index(environment), index(or_type), index(worker), index(executable), index(done), index(creation_time), index(modification_time), index(modifications), index(is_parent), index(executable, worker, creation_time, modification_time, modifications)) ENGINE=InnoDB

Methods inherited from class org.syrup.sql.SQLStatements

checkInLinkFullStatement, checkIsExecutableTaskStatement, checkOutLinkFullStatement, checkWorkerStatement, clearLinkTableStatement, clearTaskTableStatement, createExternalStatement, createLauncherStatement, createLink1Statement, createLink2Statement, createLink3Statement, createLink4Statement, createNewLinkStatement, createNewLogEntryStatement, createNewTaskStatement, dropLinkTableStatement, dropTaskTableStatement, resetWorkerStatement, rewireInLinkStatement, rewireOutLinkStatement, selectDoneStatement, selectFromTaskStatement, selectInLinkStatement, selectInLinkTaskStatement, selectLogEntriesStatement, selectOutLinkStatement, selectOutLinkTaskStatement, selectTaskKeyStatement, selectTasksStatement, selectTaskStatement, selectToTaskStatement, selectTypeStatement, updateDoneTaskStatement, updateExecutableTaskStatement, updateInLinkStatement, updateOutLinkStatement, updateTaskModificationStatement, updateWorkerStatement

Methods inherited from class org.syrup.sql.Functions

sqlImpl

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLStatements

public MySQLStatements(SQLImpl impl)

Constructor for the MySQLStatements object

Parameters:

impl - Description of the Parameter

Method Detail

createLogTableStatement

public java.lang.String createLogTableStatement()

Returns create table syrup_log(creation_time BIGINT not null, key_ varchar(255) not null, event INT not null, worker varchar(255) not null, index(creation_time), index(key_), index(event), index(worker)) ENGINE=InnoDB

Overrides:

createLogTableStatement in class SQLStatements

createTaskTableStatement

public java.lang.String createTaskTableStatement()

Returns create table task(key_ varchar(255) not null, parent_key varchar(255) not null, function_class varchar(255) not null, name varchar(255), description varchar(255), parameter varchar(255), environment varchar(255), or_type SMALLINT not null, worker varchar(255) not null, executable SMALLINT not null, done SMALLINT not null, creation_time BIGINT not null, modification_time BIGINT not null, modifications BIGINT not null, is_parent SMALLINT not null, index(key_), index(parent_key), index(function_class), index(name), index(description), index(environment), index(or_type), index(worker), index(executable), index(done), index(creation_time), index(modification_time), index(modifications), index(is_parent), index(executable, worker, creation_time, modification_time, modifications)) ENGINE=InnoDB

Overrides:

createTaskTableStatement in class SQLStatements

createLinkTableStatement

public java.lang.String createLinkTableStatement()

Returns create table link(from_task varchar(255), from_port SMALLINT, to_task varchar(255), to_port SMALLINT, data BLOB, index(from_task), index(to_task), index(from_task, from_port), index(to_task, to_port)) ENGINE=InnoDB

Overrides:

createLinkTableStatement in class SQLStatements