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@\'" |