planting_data

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

Overview

Name	planting_data
Type	Resource
Id	azure_extras.agrifood_farming.planting_data

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
create_or_update	insert	party_id, planting_data_id, endpoint		Creates or updates an planting data resource under a particular party.
create_or_update	replace	party_id, planting_data_id, endpoint		Creates or updates an planting data resource under a particular party.
delete	delete	party_id, planting_data_id, endpoint		Deletes a specified planting data resource under a particular party.
get_raw	exec	party_id, planting_data_id, endpoint		Get a specified planting data resource under a particular party.
list_raw	exec	endpoint	minAvgPlantingRate, maxAvgPlantingRate, minTotalMaterial, maxTotalMaterial, minAvgMaterial, maxAvgMaterial, minOperationStartDateTime, maxOperationStartDateTime, minOperationEndDateTime, maxOperationEndDateTime, minOperationModifiedDateTime, maxOperationModifiedDateTime, minArea, maxArea, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of planting data resources across all parties.
list_by_party_id	exec	party_id, endpoint	minAvgPlantingRate, maxAvgPlantingRate, minTotalMaterial, maxTotalMaterial, minAvgMaterial, maxAvgMaterial, minOperationStartDateTime, maxOperationStartDateTime, minOperationEndDateTime, maxOperationEndDateTime, minOperationModifiedDateTime, maxOperationModifiedDateTime, minArea, maxArea, minCreatedDateTime, maxCreatedDateTime, minLastModifiedDateTime, maxLastModifiedDateTime, skipToken	Returns a paginated list of planting data resources under a particular party.
get_cascade_delete_job_details	exec	job_id, endpoint		Get cascade delete job for planting data resource.
create_cascade_delete_job	exec	job_id, partyId, plantingDataId, endpoint		Create cascade delete job for planting data resource.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
endpoint	string	The service endpoint host (no scheme). (default: )
job_id	string	Job Id supplied by end user. Required.
partyId	string	Id of the party. Required.
party_id	string	ID of the associated party. Required.
plantingDataId	string	Id of the planting data. Required.
planting_data_id	string	ID of the planting data resource. Required.
maxArea	number	Maximum area for which operation was applied (inclusive). Default value is None.
maxAvgMaterial	number	Maximum AvgMaterial value (inclusive). Default value is None.
maxAvgPlantingRate	number	Maximum AvgPlantingRate value (inclusive). Default value is None.
maxCreatedDateTime	string (date-time)	Maximum creation date of resource (inclusive). Default value is None.
maxLastModifiedDateTime	string (date-time)	Maximum last modified date of resource (inclusive). Default value is None.
maxOperationEndDateTime	string (date-time)	Maximum end date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
maxOperationModifiedDateTime	string (date-time)	Maximum modified date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
maxOperationStartDateTime	string (date-time)	Maximum start date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
maxTotalMaterial	number	Maximum TotalMaterial value (inclusive). Default value is None.
minArea	number	Minimum area for which operation was applied (inclusive). Default value is None.
minAvgMaterial	number	Minimum AvgMaterial value(inclusive). Default value is None.
minAvgPlantingRate	number	Minimum AvgPlantingRate value(inclusive). Default value is None.
minCreatedDateTime	string (date-time)	Minimum creation date of resource (inclusive). Default value is None.
minLastModifiedDateTime	string (date-time)	Minimum last modified date of resource (inclusive). Default value is None.
minOperationEndDateTime	string (date-time)	Minimum end date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
minOperationModifiedDateTime	string (date-time)	Minimum modified date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
minOperationStartDateTime	string (date-time)	Minimum start date-time of the operation data, sample format: yyyy-MM-ddTHH:mm:ssZ (inclusive). Default value is None.
minTotalMaterial	number	Minimum TotalMaterial value(inclusive). Default value is None.
skipToken	string	Skip token for getting next set of results. Default value is None.

INSERT examples

create_or_update

Creates or updates an planting data resource under a particular party.

INSERT INTO azure_extras.agrifood_farming.planting_data (
party_id,
planting_data_id,
endpoint
)
SELECT 
'{{ party_id }}',
'{{ planting_data_id }}',
'{{ endpoint }}'
;

Manifest

# Description fields are for documentation purposes
- name: planting_data
props:
  - name: party_id
    value: "{{ party_id }}"
    description: Required parameter for the planting_data resource.
  - name: planting_data_id
    value: "{{ planting_data_id }}"
    description: Required parameter for the planting_data resource.
  - name: endpoint
    value: "{{ endpoint }}"
    description: Required parameter for the planting_data resource.

REPLACE examples

create_or_update

Creates or updates an planting data resource under a particular party.

REPLACE azure_extras.agrifood_farming.planting_data
SET 
-- No updatable properties
WHERE 
party_id = '{{ party_id }}' --required
AND planting_data_id = '{{ planting_data_id }}' --required
AND endpoint = '{{ endpoint }}' --required;

DELETE examples

delete

Deletes a specified planting data resource under a particular party.

DELETE FROM azure_extras.agrifood_farming.planting_data
WHERE party_id = '{{ party_id }}' --required
AND planting_data_id = '{{ planting_data_id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

get_raw

Get a specified planting data resource under a particular party.

EXEC azure_extras.agrifood_farming.planting_data.get_raw 
@party_id='{{ party_id }}' --required, 
@planting_data_id='{{ planting_data_id }}' --required, 
@endpoint='{{ endpoint }}' --required
;

list_raw

Returns a paginated list of planting data resources across all parties.

EXEC azure_extras.agrifood_farming.planting_data.list_raw 
@endpoint='{{ endpoint }}' --required, 
@minAvgPlantingRate='{{ minAvgPlantingRate }}', 
@maxAvgPlantingRate='{{ maxAvgPlantingRate }}', 
@minTotalMaterial='{{ minTotalMaterial }}', 
@maxTotalMaterial='{{ maxTotalMaterial }}', 
@minAvgMaterial='{{ minAvgMaterial }}', 
@maxAvgMaterial='{{ maxAvgMaterial }}', 
@minOperationStartDateTime='{{ minOperationStartDateTime }}', 
@maxOperationStartDateTime='{{ maxOperationStartDateTime }}', 
@minOperationEndDateTime='{{ minOperationEndDateTime }}', 
@maxOperationEndDateTime='{{ maxOperationEndDateTime }}', 
@minOperationModifiedDateTime='{{ minOperationModifiedDateTime }}', 
@maxOperationModifiedDateTime='{{ maxOperationModifiedDateTime }}', 
@minArea='{{ minArea }}', 
@maxArea='{{ maxArea }}', 
@minCreatedDateTime='{{ minCreatedDateTime }}', 
@maxCreatedDateTime='{{ maxCreatedDateTime }}', 
@minLastModifiedDateTime='{{ minLastModifiedDateTime }}', 
@maxLastModifiedDateTime='{{ maxLastModifiedDateTime }}', 
@skipToken='{{ skipToken }}'
;

list_by_party_id

Returns a paginated list of planting data resources under a particular party.

EXEC azure_extras.agrifood_farming.planting_data.list_by_party_id 
@party_id='{{ party_id }}' --required, 
@endpoint='{{ endpoint }}' --required, 
@minAvgPlantingRate='{{ minAvgPlantingRate }}', 
@maxAvgPlantingRate='{{ maxAvgPlantingRate }}', 
@minTotalMaterial='{{ minTotalMaterial }}', 
@maxTotalMaterial='{{ maxTotalMaterial }}', 
@minAvgMaterial='{{ minAvgMaterial }}', 
@maxAvgMaterial='{{ maxAvgMaterial }}', 
@minOperationStartDateTime='{{ minOperationStartDateTime }}', 
@maxOperationStartDateTime='{{ maxOperationStartDateTime }}', 
@minOperationEndDateTime='{{ minOperationEndDateTime }}', 
@maxOperationEndDateTime='{{ maxOperationEndDateTime }}', 
@minOperationModifiedDateTime='{{ minOperationModifiedDateTime }}', 
@maxOperationModifiedDateTime='{{ maxOperationModifiedDateTime }}', 
@minArea='{{ minArea }}', 
@maxArea='{{ maxArea }}', 
@minCreatedDateTime='{{ minCreatedDateTime }}', 
@maxCreatedDateTime='{{ maxCreatedDateTime }}', 
@minLastModifiedDateTime='{{ minLastModifiedDateTime }}', 
@maxLastModifiedDateTime='{{ maxLastModifiedDateTime }}', 
@skipToken='{{ skipToken }}'
;

get_cascade_delete_job_details

Get cascade delete job for planting data resource.

EXEC azure_extras.agrifood_farming.planting_data.get_cascade_delete_job_details 
@job_id='{{ job_id }}' --required, 
@endpoint='{{ endpoint }}' --required
;

create_cascade_delete_job

Create cascade delete job for planting data resource.

EXEC azure_extras.agrifood_farming.planting_data.create_cascade_delete_job 
@job_id='{{ job_id }}' --required, 
@partyId='{{ partyId }}' --required, 
@plantingDataId='{{ plantingDataId }}' --required, 
@endpoint='{{ endpoint }}' --required
;