GustavoAmerico

/*
ATENÇÃO: Esse comando não verifica se as alterações forma mescladas com a branch principal!! O branch vai ser apagado
*/
param(
[Parameter(Mandatory=$true)]
[String]$branchNamePattern,
$remoteName = 'origin')
git branch --all --merged | Select-String -Pattern $branchNamePattern
                 | %{$_.ToString().Replace("remotes/$remoteName/",'').Trim()} 
                 | %{ git push origin :$_ }

GustavoAmerico

 $tagNameExpression = "target-*"
 
# Define the PR URI based in azure devops pipeline runtime variables
$prUri = "$(System.CollectionUri)/$(System.TeamProject)/_apis/git/repositories/$(Build.Repository.ID)/pullRequests/$(System.PullRequest.PullRequestId)/labels?api-version=6.0-preview.1";
$buildUri= "$(System.CollectionUri)/$(System.TeamProject)/_apis/build/builds/$(Build.BuildId)/tags";

# Get PullRequest Details 
$FoundTags = Invoke-WebRequest `
                -Uri $prUri   `
                -Authentication Bearer `

GustavoAmerico

param(
[Parameter(Mandatory=$true)][System.String] $namespace,
[Parameter(Mandatory=$true)][int]$numberOfReplicas 
)


kubectl get deployments -n $namespace --output jsonpath="{range .items[*]}{.metadata.name}{'\n'}{end}" |%{
kubectl scale deployment/$_ -n $namespace --replicas $numberOfReplicas;
}

GustavoAmerico

CREATE PROCEDURE dbo.PROC_AddOrUpdateTableAndColumnDescription 
    @fullName varchar(255),
   @description varchar(255)
AS
/*
Table exemple: <schema>.<table name> dbo.MyTable
Column Exemple: <schema>.<table name>.<column name> dbo.MyTable.Id
*/

/*Extrai o primeiro valor antes do ponto, representa o schema*/

GustavoAmerico

# This  script help you setting an azure storage account  as a network folder or windows disk 
# Is need Azure CLI installed
 
param(
[System.String]
$resourceGroupName = "<resource group>",
[System.String]
$storageAccountName = "<storage account name>",
[System.String]
$subscription = "<subscription name or id>",

GustavoAmerico

param(
[Parameter(Mandatory=$true)] $acrAccountName,
$takeLastImages = 5,
$likeRepositories = '',
$selectTagPattern = '^([0-9]+(\.)?){3,4}$'
)

#Get all repository where the name like with parameter $likeRepositories
$repositories = az acr repository list --name $acrAccountName --query ("[?contains(@, '" + $likeRepositories + "')]")  |  ConvertFrom-Json ;

GustavoAmerico

#Esse script pode ser utilizado em tarefa do AzureDevOps para executar o backup da base de dados dentro do processo de Build ou Release

param(
$BaseStorageUri = "https://<your-storage>.blob.core.windows.net/backup-database",
$StorageKey = "<Shared key>",
$DatabaseName = @( "db1","db2","db3"),
$ResourceGroupName = "<database-resource-group-name>",
$ServerName = "<database-server-name>",
$serverAdmin = "<database-user-with-permission-login>",
$serverPassword = "<database-user-with-permission-password>"