labs

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

Overview

Name	labs
Type	Resource
Id	azure_extras.education.labs

Fields

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	Lab detail result properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	billingAccountName, billingProfileName, invoiceSectionName	Get the details for a specific lab associated with the provided billing account name, billing profile name, and invoice section name.
list	SELECT	billingAccountName, billingProfileName, invoiceSectionName	Get the details for a specific lab associated with the provided billing account name, billing profile name, and invoice section name.
list_all	SELECT	billingAccountName, billingProfileName	Get a list of labs associated with the provided billing account name and billing profile name.
create_or_update	INSERT	billingAccountName, billingProfileName, invoiceSectionName	Create a new lab or update a previously created lab.
delete	DELETE	billingAccountName, billingProfileName, invoiceSectionName	Delete a specific lab associated with the provided billing account name, billing profile name, and invoice section name. Note all students must be removed from the lab in order to delete the lab.
generate_invite_code	EXEC	billingAccountName, billingProfileName, invoiceSectionName	Generate invite code for a lab

SELECT examples

Get a list of labs associated with the provided billing account name and billing profile name.

SELECT
id,
name,
properties,
systemData,
type
FROM azure_extras.education.labs
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.education.labs (
billingAccountName,
billingProfileName,
invoiceSectionName,
properties
)
SELECT 
'{{ billingAccountName }}',
'{{ billingProfileName }}',
'{{ invoiceSectionName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      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
    - name: properties
      value:
        - name: displayName
          value: string
        - name: budgetPerStudent
          value:
            - name: currency
              value: string
            - name: value
              value: number
        - name: description
          value: string
        - name: expirationDate
          value: string
        - name: effectiveDate
          value: string
        - name: status
          value: string
        - name: maxStudentCount
          value: number
        - name: invitationCode
          value: string

DELETE example

Deletes the specified labs resource.

/*+ delete */
DELETE FROM azure_extras.education.labs
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND invoiceSectionName = '{{ invoiceSectionName }}';