services

Creates, updates, deletes, gets or lists a services resource.

Overview

Name	services
Type	Resource
Id	azure.service_fabric.services

Fields

vw_services

Name	Datatype	Description
id	text	Azure resource identifier.
name	text	Azure resource name.
applicationName	text	field from the properties object
clusterName	text	field from the properties object
correlation_scheme	text	field from the properties object
default_move_cost	text	field from the properties object
etag	text	Azure resource etag.
location	text	It will be deprecated in New API, resource location depends on the parent resource.
partition_description	text	field from the properties object
placement_constraints	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
serviceName	text	field from the properties object
service_dns_name	text	field from the properties object
service_kind	text	field from the properties object
service_load_metrics	text	field from the properties object
service_package_activation_mode	text	field from the properties object
service_placement_policies	text	field from the properties object
service_type_name	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Azure resource tags.
type	text	Azure resource type.

services

Name	Datatype	Description
id	string	Azure resource identifier.
name	string	Azure resource name.
etag	string	Azure resource etag.
location	string	It will be deprecated in New API, resource location depends on the parent resource.
properties	object	The service resource properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Azure resource tags.
type	string	Azure resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	applicationName, clusterName, resourceGroupName, serviceName, subscriptionId	Get a Service Fabric service resource created or in the process of being created in the Service Fabric application resource.
list	SELECT	applicationName, clusterName, resourceGroupName, subscriptionId	Gets all service resources created or in the process of being created in the Service Fabric application resource.
create_or_update	INSERT	applicationName, clusterName, resourceGroupName, serviceName, subscriptionId	Create or update a Service Fabric service resource with the specified name.
delete	DELETE	applicationName, clusterName, resourceGroupName, serviceName, subscriptionId	Delete a Service Fabric service resource with the specified name.
update	UPDATE	applicationName, clusterName, resourceGroupName, serviceName, subscriptionId	Update a Service Fabric service resource with the specified name.

SELECT examples

Gets all service resources created or in the process of being created in the Service Fabric application resource.

vw_services

SELECT
id,
name,
applicationName,
clusterName,
correlation_scheme,
default_move_cost,
etag,
location,
partition_description,
placement_constraints,
provisioning_state,
resourceGroupName,
serviceName,
service_dns_name,
service_kind,
service_load_metrics,
service_package_activation_mode,
service_placement_policies,
service_type_name,
subscriptionId,
system_data,
tags,
type
FROM azure.service_fabric.vw_services
WHERE applicationName = '{{ applicationName }}'
AND clusterName = '{{ clusterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

services

SELECT
id,
name,
etag,
location,
properties,
systemData,
tags,
type
FROM azure.service_fabric.services
WHERE applicationName = '{{ applicationName }}'
AND clusterName = '{{ clusterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new services resource.

All Properties

/*+ create */
INSERT INTO azure.service_fabric.services (
applicationName,
clusterName,
resourceGroupName,
serviceName,
subscriptionId,
properties,
location,
tags,
systemData
)
SELECT 
'{{ applicationName }}',
'{{ clusterName }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ location }}',
'{{ tags }}',
'{{ systemData }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: placementConstraints
          value: string
        - name: correlationScheme
          value: []
        - name: serviceLoadMetrics
          value: []
        - name: servicePlacementPolicies
          value: []
        - name: defaultMoveCost
          value: []
        - name: provisioningState
          value: string
        - name: serviceKind
          value: []
        - name: serviceTypeName
          value: string
        - name: partitionDescription
          value:
            - name: partitionScheme
              value: []
        - name: servicePackageActivationMode
          value: string
        - name: serviceDnsName
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: etag
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a services resource.

/*+ update */
UPDATE azure.service_fabric.services
SET 
properties = '{{ properties }}',
location = '{{ location }}',
tags = '{{ tags }}',
systemData = '{{ systemData }}'
WHERE 
applicationName = '{{ applicationName }}'
AND clusterName = '{{ clusterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified services resource.

/*+ delete */
DELETE FROM azure.service_fabric.services
WHERE applicationName = '{{ applicationName }}'
AND clusterName = '{{ clusterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';