Package es.bsc.dataclay.metadataservice

Enum MetaDataServiceSQLStatements.SqlStatements

java.lang.Object

java.lang.Enum<MetaDataServiceSQLStatements.SqlStatements>

es.bsc.dataclay.metadataservice.MetaDataServiceSQLStatements.SqlStatements

All Implemented Interfaces:

Serializable, Comparable<MetaDataServiceSQLStatements.SqlStatements>

Enclosing class:

MetaDataServiceSQLStatements

public static enum MetaDataServiceSQLStatements.SqlStatements
extends Enum<MetaDataServiceSQLStatements.SqlStatements>

This enumeration represent all possible SQL statements.

Enum Constant Summary

Enum Constants

Enum Constant	Description
CREATE_TABLE_EXTERNAL_OBJECTS	Table of external objects federated from an external dataClay instance.
CREATE_TABLE_FEDERATED_OBJECTS	Table of objects federated with external dataClay instances.
CREATE_TABLE_METADATA	Create metadata table.
DELETE_EXTERNAL_OBJECT	Delete an object federated from an external dataClay instance.
DELETE_FEDERATED_OBJECT	Delete a federated object with an external dataClay instance.
DELETE_METADATA	Delete metadata.
DROP_TABLE_METADATA	Drop metadata table.
EXISTS_EXTERNAL_OBJECT	Check if an object is federated from an external dataClay instance.
EXISTS_FEDERATED_OBJECT	Check if an object is federated.
EXISTS_FEDERATED_OBJECT_WITH_DC	Check if an object is already federated with a dataClay instance.
EXISTS_METADATA_BY_DATASETID	Exists metadata by dataset id.
EXISTS_METADATA_BY_ID	Exists metadata by id.
INSERT_EXTERNAL_OBJECT	Insert an object federated from an external dataClay instance.
INSERT_FEDERATED_OBJECT	Insert a federated object with an external dataClay instance.
INSERT_METADATA	Insert metadata.
SELECT_ALL_OIDS	Get all object ids in system.
SELECT_METADATA	Select metadata.
SELECT_METADATA_BY_ALIAS	Select metadata by alias (and class)
SELECT_METADATA_FOR_CLASS	Select all metadata from class.
SELECT_OBJECTS_FEDERATED_WITH_DATACLAY	Select objects federated/belonging to external dataClay.
SELECT_SOURCE_DATACLAY_EXTERNAL_OBJECT	Select id of external dataClay federating an object with current dataClay instance.
SELECT_TARGET_DATACLAYS_FEDERATED_OBJECT	Select dataClay ids for which an object has been federated.
SELECT_UNREGISTERED_EXTERNAL_OBJECTS	Select all unregistered external objects.
UPDATE_ALIAS_METADATA	Update aliases.
UPDATE_DATASETID_METADATA	Update dataset id.
UPDATE_FOR_REPLICA_METADATA	Update for replica.
UPDATE_LOCS_METADATA	Update st.
UPDATE_READONLY_METADATA	Update read only metadata.
UPDATE_UNREGISTER_EXTERNAL_OBJECT	Update external object to be unregistered.
VACUUM	Vacuum db.

Method Summary

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 MetaDataServiceSQLStatements.SqlStatements	valueOf(String name)	Returns the enum constant of this type with the specified name.
static MetaDataServiceSQLStatements.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_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements CREATE_TABLE_METADATA

Create metadata table.

DROP_TABLE_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements DROP_TABLE_METADATA

Drop metadata table.

INSERT_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements INSERT_METADATA

Insert metadata.

SELECT_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements SELECT_METADATA

Select metadata.

SELECT_ALL_OIDS

public static final MetaDataServiceSQLStatements.SqlStatements SELECT_ALL_OIDS

Get all object ids in system.

EXISTS_METADATA_BY_ID

public static final MetaDataServiceSQLStatements.SqlStatements EXISTS_METADATA_BY_ID

Exists metadata by id.

EXISTS_METADATA_BY_DATASETID

public static final MetaDataServiceSQLStatements.SqlStatements EXISTS_METADATA_BY_DATASETID

Exists metadata by dataset id.

DELETE_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements DELETE_METADATA

Delete metadata.

UPDATE_ALIAS_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements UPDATE_ALIAS_METADATA

Update aliases.

UPDATE_DATASETID_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements UPDATE_DATASETID_METADATA

Update dataset id.

UPDATE_READONLY_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements UPDATE_READONLY_METADATA

Update read only metadata.

UPDATE_LOCS_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements UPDATE_LOCS_METADATA

Update st. locs metadata.

UPDATE_FOR_REPLICA_METADATA

public static final MetaDataServiceSQLStatements.SqlStatements UPDATE_FOR_REPLICA_METADATA

Update for replica.

SELECT_METADATA_FOR_CLASS

public static final MetaDataServiceSQLStatements.SqlStatements SELECT_METADATA_FOR_CLASS

Select all metadata from class.

SELECT_METADATA_BY_ALIAS

public static final MetaDataServiceSQLStatements.SqlStatements SELECT_METADATA_BY_ALIAS

Select metadata by alias (and class)

CREATE_TABLE_FEDERATED_OBJECTS

public static final MetaDataServiceSQLStatements.SqlStatements CREATE_TABLE_FEDERATED_OBJECTS

Table of objects federated with external dataClay instances.

CREATE_TABLE_EXTERNAL_OBJECTS

public static final MetaDataServiceSQLStatements.SqlStatements CREATE_TABLE_EXTERNAL_OBJECTS

Table of external objects federated from an external dataClay instance.

INSERT_FEDERATED_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements INSERT_FEDERATED_OBJECT

Insert a federated object with an external dataClay instance.

DELETE_FEDERATED_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements DELETE_FEDERATED_OBJECT

Delete a federated object with an external dataClay instance.

EXISTS_FEDERATED_OBJECT_WITH_DC

public static final MetaDataServiceSQLStatements.SqlStatements EXISTS_FEDERATED_OBJECT_WITH_DC

Check if an object is already federated with a dataClay instance.

EXISTS_FEDERATED_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements EXISTS_FEDERATED_OBJECT

Check if an object is federated.

SELECT_TARGET_DATACLAYS_FEDERATED_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements SELECT_TARGET_DATACLAYS_FEDERATED_OBJECT

Select dataClay ids for which an object has been federated.

INSERT_EXTERNAL_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements INSERT_EXTERNAL_OBJECT

Insert an object federated from an external dataClay instance.

DELETE_EXTERNAL_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements DELETE_EXTERNAL_OBJECT

Delete an object federated from an external dataClay instance.

EXISTS_EXTERNAL_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements EXISTS_EXTERNAL_OBJECT

Check if an object is federated from an external dataClay instance.

SELECT_SOURCE_DATACLAY_EXTERNAL_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements SELECT_SOURCE_DATACLAY_EXTERNAL_OBJECT

Select id of external dataClay federating an object with current dataClay instance.

SELECT_UNREGISTERED_EXTERNAL_OBJECTS

public static final MetaDataServiceSQLStatements.SqlStatements SELECT_UNREGISTERED_EXTERNAL_OBJECTS

Select all unregistered external objects.

UPDATE_UNREGISTER_EXTERNAL_OBJECT

public static final MetaDataServiceSQLStatements.SqlStatements UPDATE_UNREGISTER_EXTERNAL_OBJECT

Update external object to be unregistered.

SELECT_OBJECTS_FEDERATED_WITH_DATACLAY

public static final MetaDataServiceSQLStatements.SqlStatements SELECT_OBJECTS_FEDERATED_WITH_DATACLAY

Select objects federated/belonging to external dataClay.

VACUUM

public static final MetaDataServiceSQLStatements.SqlStatements VACUUM

Vacuum db.

Method Detail

values

public static MetaDataServiceSQLStatements.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 (MetaDataServiceSQLStatements.SqlStatements c : MetaDataServiceSQLStatements.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 MetaDataServiceSQLStatements.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