java.lang.Object
- java.lang.Enum<LogicMetadataSQLStatements.SqlStatements>
- - es.bsc.dataclay.logic.logicmetadata.LogicMetadataSQLStatements.SqlStatements

All Implemented Interfaces:

Serializable, Comparable<LogicMetadataSQLStatements.SqlStatements>

Enclosing class:

LogicMetadataSQLStatements
```
public static enum LogicMetadataSQLStatements.SqlStatements
extends Enum<LogicMetadataSQLStatements.SqlStatements>
```
This enumeration represent all possible SQL statements.

Enum Constant Summary

Enum Constants
Enum Constant	Description
`CREATE_TABLE_DATACLAYS`	Table of external dataClay info.
`CREATE_TABLE_EXECUTION_ENVIRONMENTS`	Create execution environments table.
`CREATE_TABLE_LOGICMODULE`	Create table.
`CREATE_TABLE_STORAGE_LOCATIONS`	Create storage locations table.
`DELETE_DATACLAY`	Delete dataClay instance.
`DELETE_EXECUTION_ENVIRONMENT`	Delete execution environment.
`DELETE_STORAGE_LOCATION`	Delete storage location.
`DROP_TABLE_EXECUTION_ENVIRONMENTS`	Drop execution environments table.
`DROP_TABLE_LOGICMODULE`	Drop table.
`DROP_TABLE_STORAGE_LOCATIONS`	Drop storage locations table.
`EXISTS_EXECUTION_ENVIRONMENT_BY_HOSTPORT`	Exists execution environment by host and port.
`EXISTS_EXECUTION_ENVIRONMENT_BY_ID`	Exists execution environment by id.
`EXISTS_LOGICMODULE_BY_ID`	Exists.
`EXISTS_STORAGE_LOCATION_BY_HOSTPORT`	Exists storage location by host and port.
`EXISTS_STORAGE_LOCATION_BY_ID`	Exists storage location by id.
`INSERT_DATACLAY_INFO`	Insert dataclay external info.
`INSERT_EXECUTION_ENVIRONMENT`	Insert execution environment.
`INSERT_LOGICMODULE`	Insert.
`INSERT_STORAGE_LOCATION`	Insert storage location.
`SELECT_ALL_DATACLAYS`	Select all dataclays.
`SELECT_ALL_EXECENV_BY_HOSTNAME_AND_LANG`	Select all execution environments in host name.
`SELECT_ALL_EXECENVS`	Select all execution environments.
`SELECT_ALL_EXECENVS_BY_LANG`	Select all execution environments.
`SELECT_ALL_LOCS`	Select all storage locations.
`SELECT_DATACLAY_ID_FROM_HOST_PORT`	Select dataclay id from host and port.
`SELECT_DATACLAY_INFO_BY_ID`	Select dataclay external info by id.
`SELECT_EXECENV_BY_HOSTNAME_AND_PORT`	Select exec environment by hostname and port.
`SELECT_EXECENV_BY_NAME_LANG`	Select exec environment by name and language.
`SELECT_EXECUTION_ENVIRONMENT`	Select execution environment.
`SELECT_LOGICMODULE`	Select.
`SELECT_STLOC_BY_NAME`	Select storage location by name.
`SELECT_STORAGE_LOCATION`	Select storage location.
`UPDATE_EXECUTION_ENVIRONMENT`	Update execution environment.
`UPDATE_STORAGE_LOCATION`	Update storage location.
`VACUUM`	Vacuum db.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`String`	`getSqlStatement()`	Get the sqlStatement
`static void`	`loadStatements()`	Init properties of the properties file
`void`	`setSqlStatement(String newsqlStatement)`	Set the sqlStatement
`static void`	`unloadStatements()`	Unload statements.
`static LogicMetadataSQLStatements.SqlStatements`	`valueOf(String name)`	Returns the enum constant of this type with the specified name.
`static LogicMetadataSQLStatements.SqlStatements[]`	`values()`	Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

CREATE_TABLE_LOGICMODULE

public static final LogicMetadataSQLStatements.SqlStatements CREATE_TABLE_LOGICMODULE

Create table.

CREATE_TABLE_STORAGE_LOCATIONS

public static final LogicMetadataSQLStatements.SqlStatements CREATE_TABLE_STORAGE_LOCATIONS

Create storage locations table.

CREATE_TABLE_EXECUTION_ENVIRONMENTS

public static final LogicMetadataSQLStatements.SqlStatements CREATE_TABLE_EXECUTION_ENVIRONMENTS

Create execution environments table.

DROP_TABLE_LOGICMODULE

public static final LogicMetadataSQLStatements.SqlStatements DROP_TABLE_LOGICMODULE

Drop table.

DROP_TABLE_STORAGE_LOCATIONS

public static final LogicMetadataSQLStatements.SqlStatements DROP_TABLE_STORAGE_LOCATIONS

Drop storage locations table.

DROP_TABLE_EXECUTION_ENVIRONMENTS

public static final LogicMetadataSQLStatements.SqlStatements DROP_TABLE_EXECUTION_ENVIRONMENTS

Drop execution environments table.

INSERT_LOGICMODULE

public static final LogicMetadataSQLStatements.SqlStatements INSERT_LOGICMODULE

Insert.

INSERT_STORAGE_LOCATION

public static final LogicMetadataSQLStatements.SqlStatements INSERT_STORAGE_LOCATION

Insert storage location.

INSERT_EXECUTION_ENVIRONMENT

public static final LogicMetadataSQLStatements.SqlStatements INSERT_EXECUTION_ENVIRONMENT

Insert execution environment.

EXISTS_LOGICMODULE_BY_ID

public static final LogicMetadataSQLStatements.SqlStatements EXISTS_LOGICMODULE_BY_ID

Exists.

EXISTS_STORAGE_LOCATION_BY_ID

public static final LogicMetadataSQLStatements.SqlStatements EXISTS_STORAGE_LOCATION_BY_ID

Exists storage location by id.

EXISTS_EXECUTION_ENVIRONMENT_BY_ID

public static final LogicMetadataSQLStatements.SqlStatements EXISTS_EXECUTION_ENVIRONMENT_BY_ID

Exists execution environment by id.

EXISTS_EXECUTION_ENVIRONMENT_BY_HOSTPORT

public static final LogicMetadataSQLStatements.SqlStatements EXISTS_EXECUTION_ENVIRONMENT_BY_HOSTPORT

Exists execution environment by host and port.

EXISTS_STORAGE_LOCATION_BY_HOSTPORT

public static final LogicMetadataSQLStatements.SqlStatements EXISTS_STORAGE_LOCATION_BY_HOSTPORT

Exists storage location by host and port.

DELETE_STORAGE_LOCATION

public static final LogicMetadataSQLStatements.SqlStatements DELETE_STORAGE_LOCATION

Delete storage location.

DELETE_EXECUTION_ENVIRONMENT

public static final LogicMetadataSQLStatements.SqlStatements DELETE_EXECUTION_ENVIRONMENT

Delete execution environment.

SELECT_ALL_LOCS

public static final LogicMetadataSQLStatements.SqlStatements SELECT_ALL_LOCS

Select all storage locations.

SELECT_ALL_EXECENVS

public static final LogicMetadataSQLStatements.SqlStatements SELECT_ALL_EXECENVS

Select all execution environments.

SELECT_ALL_EXECENVS_BY_LANG

public static final LogicMetadataSQLStatements.SqlStatements SELECT_ALL_EXECENVS_BY_LANG

Select all execution environments.

SELECT_STLOC_BY_NAME

public static final LogicMetadataSQLStatements.SqlStatements SELECT_STLOC_BY_NAME

Select storage location by name.

SELECT_EXECENV_BY_NAME_LANG

public static final LogicMetadataSQLStatements.SqlStatements SELECT_EXECENV_BY_NAME_LANG

Select exec environment by name and language.

SELECT_EXECENV_BY_HOSTNAME_AND_PORT

public static final LogicMetadataSQLStatements.SqlStatements SELECT_EXECENV_BY_HOSTNAME_AND_PORT

Select exec environment by hostname and port.

UPDATE_STORAGE_LOCATION

public static final LogicMetadataSQLStatements.SqlStatements UPDATE_STORAGE_LOCATION

Update storage location.

UPDATE_EXECUTION_ENVIRONMENT

public static final LogicMetadataSQLStatements.SqlStatements UPDATE_EXECUTION_ENVIRONMENT

Update execution environment.

CREATE_TABLE_DATACLAYS

public static final LogicMetadataSQLStatements.SqlStatements CREATE_TABLE_DATACLAYS

Table of external dataClay info.

INSERT_DATACLAY_INFO

public static final LogicMetadataSQLStatements.SqlStatements INSERT_DATACLAY_INFO

Insert dataclay external info.

SELECT_DATACLAY_INFO_BY_ID

public static final LogicMetadataSQLStatements.SqlStatements SELECT_DATACLAY_INFO_BY_ID

Select dataclay external info by id.

SELECT_DATACLAY_ID_FROM_HOST_PORT

public static final LogicMetadataSQLStatements.SqlStatements SELECT_DATACLAY_ID_FROM_HOST_PORT

Select dataclay id from host and port.

DELETE_DATACLAY

public static final LogicMetadataSQLStatements.SqlStatements DELETE_DATACLAY

Delete dataClay instance.

SELECT_ALL_DATACLAYS

public static final LogicMetadataSQLStatements.SqlStatements SELECT_ALL_DATACLAYS

Select all dataclays.

SELECT_LOGICMODULE

public static final LogicMetadataSQLStatements.SqlStatements SELECT_LOGICMODULE

Select.

SELECT_STORAGE_LOCATION

public static final LogicMetadataSQLStatements.SqlStatements SELECT_STORAGE_LOCATION

Select storage location.

SELECT_EXECUTION_ENVIRONMENT

public static final LogicMetadataSQLStatements.SqlStatements SELECT_EXECUTION_ENVIRONMENT

Select execution environment.

SELECT_ALL_EXECENV_BY_HOSTNAME_AND_LANG

public static final LogicMetadataSQLStatements.SqlStatements SELECT_ALL_EXECENV_BY_HOSTNAME_AND_LANG

Select all execution environments in host name.

VACUUM

public static final LogicMetadataSQLStatements.SqlStatements VACUUM

Vacuum db.

Method Detail
- values
```
public static LogicMetadataSQLStatements.SqlStatements[] values()
```
  Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (LogicMetadataSQLStatements.SqlStatements c : LogicMetadataSQLStatements.SqlStatements.values())
    System.out.println(c);
```
  Returns:
  
  an array containing the constants of this enum type, in the order they are declared
- valueOf
```
public static LogicMetadataSQLStatements.SqlStatements valueOf(String name)
```
  Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
  
  Parameters:
  
  name - the name of the enum constant to be returned.
  
  Returns:
  
  the enum constant with the specified name
  
  Throws:
  
  IllegalArgumentException - if this enum type has no constant with the specified name
  
  NullPointerException - if the argument is null
- unloadStatements
```
public static void unloadStatements()
```
  Unload statements.
- loadStatements
```
public static void loadStatements()
```
  Init properties of the properties file
- getSqlStatement
```
public String getSqlStatement()
```
  Get the sqlStatement
  
  Returns:
  
  the sqlStatement
- setSqlStatement
```
public void setSqlStatement(String newsqlStatement)
```
  Set the sqlStatement
  
  Parameters:
  
  newsqlStatement - the sqlStatement

Enum LogicMetadataSQLStatements.SqlStatements