Skip to content

Instantly share code, notes, and snippets.

View vinijmoura's full-sized avatar

Vinicius Moura vinijmoura

323 followers · 18 following
View GitHub Profile
@vinijmoura
vinijmoura / CreateIteration.ps1
Created May 5, 2020 01:48
Create Iteration
Param
(
[string]$PAT,
[string]$Organization,
[string]$Project,
[string]$TeamName,
[DateTime]$StartDate,
[int]$NumberOfSprints
)
@vinijmoura
vinijmoura / CreateRepo.ps1
Created May 10, 2020 19:49
Create Repo
Param
(
[string]$PAT,
[string]$Organization,
[string]$Project,
[string]$RepoName,
[string]$Reviewers
)
Function Set-BranchPolicy
@vinijmoura
vinijmoura / ListRepos_GitHub_ProtectedBranch.ps1
Created May 21, 2020 17:40
$token = '[Personal Acces Token]'
$base64Token = [System.Convert]::ToBase64String([char[]]$token)
$headers = @{
Authorization = 'Basic {0}' -f $base64Token
};
$response = Invoke-RestMethod -Headers $headers -Uri https://api.github.com/user/repos
foreach ($obj in $response)
{
@vinijmoura
vinijmoura / InsertUserAndPermissions.ps1
Created May 31, 2020 22:04
Param
(
[string]$PAT,
[string]$Organization,
[string]$newUser,
[string]$newUserLicenseType,
[string]$activeUser
)
echo $PAT | az devops login --org $Organization
@vinijmoura
vinijmoura / ListProcessAndFields.ps1
Created June 17, 2020 14:24
Param
(
[string]$PAT,
[string]$Organization
)
$AzureDevOpsAuthenicationHeader = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(":$($PAT)")) }
$UriOrganization = "https://dev.azure.com/$($Organization)/"
$uriProcess = $UriOrganization + "_apis/work/processes/"
@vinijmoura
vinijmoura / ssdt.yml
Created January 15, 2021 04:26
name: SQL Server Database Project
on:
push:
branches: [ master ]
pull_request:
branches: [ master ]
workflow_dispatch:
jobs:
@vinijmoura
vinijmoura / JMeter.yml
Created January 18, 2021 19:33
name: SELENIUM and JMETER
on:
push:
branches: [ master ]
pull_request:
branches: [ master ]
workflow_dispatch:
env:
@vinijmoura
vinijmoura / SelfHostedAgentCapabilities.ps1
Created March 18, 2021 19:30
Param
(
[string]$PAT,
[string]$Organization
)
$SelfHostedAgentCapabilities = @()
$AzureDevOpsAuthenicationHeader = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(":$($PAT)")) }
$UriOrganization = "https://dev.azure.com/$($Organization)/"
@vinijmoura
vinijmoura / ReleaseDefinitions_Stages_Approvers.ps1
Created April 7, 2021 17:59
Param
(
[string]$PAT,
[string]$Organization,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE ReleaseDefinitionsClassic"
Invoke-Sqlcmd -query $SQLQuery -ConnectionString $Connstr
@vinijmoura
vinijmoura / ReleaseDefinitonsClassic.sql
Created April 7, 2021 18:56
CREATE TABLE [dbo].[ReleaseDefinitionsClassic](
[TeamProjectId] [varchar](50) NULL,
[TeamProjectName] [varchar](100) NULL,
[ReleaseDefinitionId] [int] NULL,
[ReleaseDefintionName] [varchar](50) NULL,
[ReleaseDefinitionURL] [varchar](300) NULL,
[ReleaseDefintionEnvironmentName] VARCHAR(50) NULL,
[ReleaseDefinitionEnvironmentRank] TINYINT NULL,
[ReleaseDefinitionEnvironmentPreDeployApprovalsName] VARCHAR (200) NULL,
[ReleaseDefinitionEnvironmentPostDeployApprovalsName] VARCHAR (200) NULL