scalingo_addonscalingo_alertscalingo_appscalingo_app_eventscalingo_autoscalerscalingo_collaboratorscalingo_containerscalingo_container_typescalingo_cronscalingo_databasescalingo_database_backupscalingo_database_maintenancescalingo_database_type_versionscalingo_database_userscalingo_deploymentscalingo_domainscalingo_environmentscalingo_event_typescalingo_invoicescalingo_keyscalingo_log_drainscalingo_log_drain_addonscalingo_notification_platformscalingo_notifierscalingo_regionscalingo_scm_integrationscalingo_scm_repo_linkscalingo_stackscalingo_tokenscalingo_user_eventscalingo_user_scm_repo_link
Table: scalingo_user_scm_repo_link
List all the SCM repository link of your account.
Examples
List all scm repo links associated to your account
select scm_type owner, repo, branchfrom scalingo_scm_repo_link;
Get all scm repo link from your account with auto deploy enabled
select scm_type, owner, repo, branchfrom scalingo_scm_repo_linkwhere auto_deploy_enabled = true;
Schema for scalingo_user_scm_repo_link
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
app_id | text | The application ID. | |
auth_integration_uuid | text | ID of the scm integration linked for authentication. | |
auto_deploy_enabled | boolean | True if a new deployment is trigered when the linked branch is updated. | |
automatic_creation_from_forks_allowed | boolean | Create a review app from forks. | |
branch | text | The branch used for auto deployment. | |
created_at | timestamp with time zone | Creation date of the link. | |
delete_on_close_enabled | boolean | Delete the review app when the pull request is closed. | |
delete_stale_enabled | boolean | Delete the review app when there is no activity on the pull request. | |
deploy_review_apps_enabled | boolean | Activation of the review apps feature. | |
hours_before_delete_on_close | bigint | Time to wait before deleting a review app linked to a closed pull request (in hours). | |
hours_before_delete_stale | bigint | Time to wait for activity on the pull request before deleting the review app (in hours) | |
id | text | Unique ID identifying the link. | |
last_auto_deploy_at | timestamp with time zone | Date of the last deployment triggered by this link | |
linker_email | text | Email of the user that linked the repository. | |
linker_id | text | ID of the user that linked the repository. | |
linker_username | text | Username of the user that linked the repository. | |
owner | text | Repository owner name. | |
repo | text | Repository name. | |
scm_type | text | The integration type. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
updated_at | timestamp with time zone | Last time the link was updated. | |
url | text | URL of the scm type. |