solutions

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

Overview

Name	solutions
Type	Resource
Id	azure_extras.ag_food_platform.solutions

Fields

vw_solutions

Name	Datatype	Description
dataManagerForAgricultureResourceName	text	field from the properties object
e_tag	text	field from the properties object
marketplace_publisher_id	text	field from the properties object
offer_id	text	field from the properties object
partner_id	text	field from the properties object
plan_id	text	field from the properties object
resourceGroupName	text	field from the properties object
role_assignment_id	text	field from the properties object
saas_subscription_id	text	field from the properties object
saas_subscription_name	text	field from the properties object
solutionId	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
term_id	text	field from the properties object

solutions

Name	Datatype	Description
eTag	string	The ETag value to implement optimistic concurrency.
properties	object	Solution resource properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataManagerForAgricultureResourceName, resourceGroupName, solutionId, subscriptionId	Get installed Solution details by Solution id.
list	SELECT	dataManagerForAgricultureResourceName, resourceGroupName, subscriptionId	Get installed Solutions details.
create_or_update	INSERT	dataManagerForAgricultureResourceName, resourceGroupName, solutionId, subscriptionId	Install Or Update Solution.
delete	DELETE	dataManagerForAgricultureResourceName, resourceGroupName, solutionId, subscriptionId	Uninstall Solution.

SELECT examples

Get installed Solutions details.

vw_solutions

SELECT
dataManagerForAgricultureResourceName,
e_tag,
marketplace_publisher_id,
offer_id,
partner_id,
plan_id,
resourceGroupName,
role_assignment_id,
saas_subscription_id,
saas_subscription_name,
solutionId,
subscriptionId,
system_data,
term_id
FROM azure_extras.ag_food_platform.vw_solutions
WHERE dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

solutions

SELECT
eTag,
properties,
systemData
FROM azure_extras.ag_food_platform.solutions
WHERE dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.ag_food_platform.solutions (
dataManagerForAgricultureResourceName,
resourceGroupName,
solutionId,
subscriptionId,
systemData,
properties
)
SELECT 
'{{ dataManagerForAgricultureResourceName }}',
'{{ resourceGroupName }}',
'{{ solutionId }}',
'{{ subscriptionId }}',
'{{ systemData }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - 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
    - name: properties
      value:
        - name: partnerId
          value: string
        - name: saasSubscriptionId
          value: string
        - name: saasSubscriptionName
          value: string
        - name: marketplacePublisherId
          value: string
        - name: planId
          value: string
        - name: roleAssignmentId
          value: string
        - name: offerId
          value: string
        - name: termId
          value: string
    - name: eTag
      value: string

DELETE example

Deletes the specified solutions resource.

/*+ delete */
DELETE FROM azure_extras.ag_food_platform.solutions
WHERE dataManagerForAgricultureResourceName = '{{ dataManagerForAgricultureResourceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND solutionId = '{{ solutionId }}'
AND subscriptionId = '{{ subscriptionId }}';