access_group_projects

Creates, updates, deletes, gets or lists an access_group_projects resource.

Overview

Name	access_group_projects
Type	Resource
Id	railway.workspaces.access_group_projects

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
attach	insert	access_group_id, project_id		Attach a project to an access group. Backed by the Railway GraphQL mutation accessGroupProjectAttach.
detach	delete	access_group_id, project_id		Detach a project from an access group. Backed by the Railway GraphQL mutation accessGroupProjectDetach.

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
access_group_id	string
project_id	string

INSERT examples

attach

Attach a project to an access group. Backed by the Railway GraphQL mutation accessGroupProjectAttach.

INSERT INTO railway.workspaces.access_group_projects (
access_group_id,
project_id
)
SELECT 
'{{ access_group_id }}' /* required */,
'{{ project_id }}' /* required */
RETURNING
id,
access_group_id,
project_id,
access_group,
created_at,
project,
updated_at
;

Manifest

# Description fields are for documentation purposes
- name: access_group_projects
props:
  - name: access_group_id
    value: "{{ access_group_id }}"
  - name: project_id
    value: "{{ project_id }}"

DELETE examples

detach

Detach a project from an access group. Backed by the Railway GraphQL mutation accessGroupProjectDetach.

DELETE FROM railway.workspaces.access_group_projects
WHERE 
access_group_id = '{{ access_group_id }}' --required
AND project_id = '{{ project_id }}' --required
;