dennisroche’s gists

dennisroche / atmos.json

Last active July 10, 2024 08:10

Scoop Manifest for Atmos

	{
	"version": "1.83.1",
	"description": "Terraform Orchestration Tool for DevOps. Keep environment configuration DRY with hierarchical imports of configurations, inheritance, and WAY more. Native support for Terraform and Helmfile.",
	"homepage": "https://github.com/cloudposse/atmos/",
	"license": "Apache-2.0",
	"architecture": {
	"64bit": {
	"url": "https://github.com/cloudposse/atmos/releases/download/v1.83.1/atmos_1.83.1_windows_amd64.exe",
	"hash": "6008ada9a269e24d47055ec574a58c9cc401113fa6e1e3d1fdbc45a8a8fa9d36"
	},

dennisroche / cfn-http2-target-group.py

Last active February 12, 2021 01:53

CloudFormation custom resource to create HTTP2 Target Group

	'''
	Uses crhelper https://github.com/aws-cloudformation/custom-resource-helper

	Requires
	- 'elasticloadbalancing:*'
	- 'ec2:DescribeInternetGateways'
	- 'ec2:DescribeVpcs'
	'''

	from crhelper import CfnResource

dennisroche / Paradox.psm1

Last active February 7, 2020 02:34

Custom https://github.com/JanDeDobbeleer/oh-my-posh with https://github.com/jonscheiding/posh-awsp

	#requires -Version 2 -Modules posh-git

	function Write-Theme {
	param(
	[bool]
	$lastCommandFailed,
	[string]
	$with
	)

dennisroche / PromoteAll.ps1

Created April 5, 2018 05:01

Octopus Deploy script to shift a range of projects to the right (dev to staging) as a set

	$octo = Get-OctopusTools

	Write-Heading 'Projects'

	function GetProjectsInGroup([string]$projectGroupName, [string]$ignoreProjectNames) {
	$projectGroup = Invoke-OctopusApi '/api/projectgroups/all' \| Where-Object { $_.Name -eq $projectGroupName }
	if ($null -eq $projectGroup) {
	Write-Fatal "Project $projectGroupName not found"
	}

dennisroche / ValidateAzureTemplate.ps1

Created April 5, 2018 04:59

Validate Azure ARM template

	function Format-ValidationOutput {
	Param (
	[Parameter(ValueFromPipeline=$true)] $ValidationOutput,
	[int] $Depth = 0
	)

	return @($ValidationOutput \| Where-Object { $_ -ne $null } \| ForEach-Object { @(' ' * $Depth + ': ' + $_.Message) + @(Format-ValidationOutput @($_.Details) ($Depth + 1)) })
	}

	# Template

dennisroche / PostDeploySql.ps1

Created April 5, 2018 04:58

PostDeploy script for Octopus that executes SQL

	trap {
	Write-Error "$_"
	Exit 1
	}

	# Injected by Octopus Deploy Step Template
	$connectionString = $DeploySqlConnectionString
	$filter = $Filter

	Write-Host "Executing scripts in folder '$($PSScriptRoot)'"

dennisroche / LoadAzureCertificate.ps1

Created April 5, 2018 04:56

Loading a Certificate to Azure (useful for IdentityServer)

	$pfx = $OctopusParameters["PrimarySigningCertificate.Pfx"]
	$thumbprint = $OctopusParameters["PrimarySigningCertificate.Thumbprint"]
	$appName = "auth-api-$AzureEnvironment"

	function Set-AzureRmCertificate($ResourceGroupName, $Location, $Pfx, $Thumbprint) {
	$ResourceLocation = $Location
	$ResourceName = $Thumbprint
	$PropertiesObject = @{
	pfxBlob = $Pfx;
	password = ""

dennisroche / README.md

Last active October 21, 2022 04:17

Pretty log header using ASCII

  ╔═══════════════════════════════════════════════════════════════════════════════╗
  ║                                    Example                                    ║
  ╚═══════════════════════════════════════════════════════════════════════════════╝

Useful for breaking up large log files

dennisroche / LogHelper.cs

Last active March 11, 2018 06:20

xUnit2 and BDDfy logging with Serilog

	internal static class LogHelper
	{
	private static readonly AsyncLocal<Guid> TestCorrelationId = new AsyncLocal<Guid>();
	private static readonly ConcurrentDictionary<Guid, XUnitBddfyTextReporter> BddfyTextReporterLookup = new ConcurrentDictionary<Guid, XUnitBddfyTextReporter>();
	private static readonly ConcurrentDictionary<Guid, ITestOutputHelper> LoggerLookup = new ConcurrentDictionary<Guid, ITestOutputHelper>();
	private static readonly ConcurrentDictionary<Guid, ILogger> SerilogLookup = new ConcurrentDictionary<Guid, ILogger>();

	public static IDisposable Capture(ITestOutputHelper outputHelper)
	{
	if (outputHelper == null)

dennisroche / DropSchema.sql

Created February 2, 2018 16:43

Drop entire SQL Server schema

	DECLARE @schema VARCHAR(128)
	SET @schema = 'dbo' --< change this

	/* Drop all Foreign Key constraints */
	DECLARE @name VARCHAR(128)
	DECLARE @constraint VARCHAR(254)
	DECLARE @SQL VARCHAR(254)

	SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA=@schema AND CONSTRAINT_CATALOG=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)

Dennis Roche dennisroche