Constant Field Values


Contents
org.glite.*

org.glite.rgma.discovery.RGMAServiceDiscoverySQL
public static final java.lang.String GET_SERVICE_DATA_SELECT "SELECT DataKey, DataValue FROM GlueServiceData WHERE GlueService_UniqueId = \'@servicename@\';"
public static final java.lang.String GET_SERVICE_DETAILS_SELECT_ADMIN "SELECT SysAdminContact FROM GlueSite, GlueService WHERE GlueSite.UniqueId = GlueService.GlueSite_UniqueId AND GlueService.UniqueId = \'@servicename@\';"
public static final java.lang.String GET_SERVICE_DETAILS_SELECT_ASSOC "SELECT UniqueId, Type, Endpoint, Version FROM GlueService, GlueServiceStatus, GlueServiceAssociation WHERE GlueServiceAssociation.GlueService_UniqueId_1 = \'@servicename@\' AND GlueService.UniqueId = GlueServiceAssociation.GlueService_UniqueId_2 AND GlueServiceStatus.GlueService_UniqueId = GlueServiceAssociation.GlueService_UniqueId_2;"
public static final java.lang.String GET_SERVICE_DETAILS_SELECT_SERVICE "SELECT UniqueId, Type, Version, GlueSite_UniqueId, Endpoint, WSDL FROM GlueService, GlueServiceStatus WHERE UniqueId = \'@servicename@\' AND GlueServiceStatus.GlueService_UniqueId = \'@servicename@\';"
public static final java.lang.String GET_SERVICE_DETAILS_SELECT_VOS "SELECT Owner FROM GlueServiceOwner WHERE GlueService_UniqueId = \'@servicename@\';"
public static final java.lang.String GET_SERVICE_PARAMETER_SELECT "SELECT DataValue FROM GlueServiceData WHERE GlueService_UniqueId = \'@servicename@\' AND DataKey = \'@key@\';"
public static final java.lang.String GET_SERVICE_SELECT "SELECT UniqueId, Type, Endpoint, Version FROM GlueService, GlueServiceStatus WHERE UniqueId = \'@servicename@\' AND GlueServiceStatus.GlueService_UniqueId = \'@servicename@\';"
public static final java.lang.String GET_SERVICE_SITE_SELECT "SELECT GlueSite_UniqueId FROM GlueService WHERE UniqueId = \'@servicename@\';"
public static final java.lang.String GET_SERVICE_WSDL_SELECT "SELECT WSDL FROM GlueService WHERE UniqueId = \'@servicename@\';"
public static final java.lang.String LIST_ASSOCIATED_SERVICES_SELECT "SELECT DISTINCT UniqueId, Type, Endpoint, Version FROM GlueService, GlueServiceAssociation, GlueServiceStatus WHERE GlueService.UniqueId = GlueServiceAssociation.GlueService_UniqueId_2 AND GlueService.UniqueId = GlueServiceStatus.GlueService_UniqueId AND GlueServiceAssociation.GlueService_UniqueId_1 = \'@servicename@\' @WHERE_TYPE@ @WHERE_SITE@ @WHERE_STATUS_AVAILABLE@;"
public static final java.lang.String LIST_ASSOCIATED_SERVICES_SELECT_WITH_VO "SELECT DISTINCT UniqueId, Type, Endpoint, Version FROM GlueService, GlueServiceAssociation, GlueServiceStatus LEFT JOIN GlueServiceOwner ON GlueService.UniqueId = GlueServiceOwner.GlueService_UniqueId WHERE GlueService.UniqueId = GlueServiceAssociation.GlueService_UniqueId_2 AND GlueService.UniqueId = GlueServiceStatus.GlueService_UniqueId AND GlueServiceAssociation.GlueService_UniqueId_1 = \'@servicename@\' @WHERE_TYPE@ @WHERE_SITE@ @WHERE_STATUS_AVAILABLE@ AND (Owner IS NULL OR Owner IN (@volist@));"
public static final java.lang.String LIST_SERVICES_BY_DATA_SELECT "SELECT GlueService_UniqueId, COUNT(GlueService_UniqueId) FROM GlueServiceData WHERE GlueService_UniqueId IN (@servicelist@) AND (@WHERE_KEY@) GROUP BY GlueService_UniqueId;"
public static final java.lang.String LIST_SERVICES_SELECT "SELECT DISTINCT UniqueId, Type, Endpoint, Version FROM GlueService, GlueServiceStatus WHERE GlueServiceStatus.GlueService_UniqueId = GlueService.UniqueId @WHERE_TYPE@ @WHERE_SITE@ @WHERE_STATUS_AVAILABLE@;"
public static final java.lang.String LIST_SERVICES_SELECT_WITH_VO "SELECT DISTINCT UniqueId, Type, Endpoint, Version FROM GlueService, GlueServiceStatus LEFT JOIN GlueServiceOwner ON GlueService.UniqueId = GlueServiceOwner.GlueService_UniqueId WHERE GlueServiceStatus.GlueService_UniqueId = GlueService.UniqueId @WHERE_TYPE@ @WHERE_SITE@ @WHERE_STATUS_AVAILABLE@ AND (Owner IS NULL OR Owner IN (@volist@));"
public static final java.lang.String WHERE_SITE "AND GlueSite_UniqueId = \'@site@\'"
public static final java.lang.String WHERE_STATUS_AVAILABLE "AND GlueServiceStatus.Status = \'OK\'"
public static final java.lang.String WHERE_TYPE "AND Type = \'@type@\'"