petervandivier

#!/usr/bin/env bash

wd="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"
pushd "$wd" > /dev/null

pattern=$1

suites=$(kitchen list --bare $pattern) || exit 1

kitchen verify $pattern

petervandivier

$urllist = Import-Csv QueryResults.csv

$urllist | ForEach-Object {
    $url = $_.url
    $network,[int]$id=($url.Substring(30) -split '/')[0,3]

    $wayback = Invoke-WebRequest "http://archive.org/wayback/available?url=$($url)"
    $wayback_url = ($wayback.Content | ConvertFrom-Json).archived_snapshots.closest.url

petervandivier

function ConvertFrom-CkList {
    [CmdletBinding()]
    param (
        [Parameter(ValueFromPipeline)]
        [string]
        $InputObject
    )

    $NewLine = [Environment]::NewLine

petervandivier

function Import-ConfigFile {
    [CmdletBinding()]
    param (
        [Parameter(Mandatory)]
        [ValidateScript({Test-Path $_ -PathType Leaf})]
        [string]
        $Path,

        [string]

petervandivier

#!/usr/bin/env bash
# 
# this script deploys the sql scripts in the colocated subdirectories
# it supports 3 usages
#   1. docker@docker - when running `docker-compose up -d postgres`, 
#      the docker/config/postgres directory is mounted inside the image
#      and ./deploy.sh runs locally inside the image
#   2. local@docker (debug mode) - you may make edits to the files in
#      docker/config/postgres and re-run deploy.sh from your workstation.
#      it will determine that there is a postgres docker instance running 

petervandivier

$args = @(
    "ARTHUR\vagrant"
    "login"
)

$query = "exec sp_whoisactive "
$params = @{}
$i = 0

$args | % {

petervandivier

#!/usr/bin/env pwsh

[CmdletBinding()]
param (
    [Parameter(Mandatory=$true)]
    $Database,
    
    [switch]
    $AllowClobber,

petervandivier

• https://www.postgresql.org/docs/current/datatype-binary.html

• https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-BYTEA-OUTPUT

• https://www.pgadmin.org/docs/pgadmin4/4.21/release_notes_4_3.html

  • https://redmine.postgresql.org/issues/3981

  (☝️ requires login)

$INSTALLDIR/web/pgadmin/utils/driver/psycopg2/connection.py

For me, $INSTALLDIR is /Applications/pgAdmin 4.app/Contents/Resources

petervandivier

#!/usr/bin/env bash

PG_URL=127.0.0.1
PG_PORT=54320
PG_DATABASE=postgres
PG_SERVICE_ACCOUNT=deploy
PG_CONN=" -h $PG_URL \
-d $PG_DATABASE \
-p $PG_PORT \
-U $PG_SERVICE_ACCOUNT "

petervandivier

-- To allow advanced options to be changed.  
EXEC sp_configure 'show advanced options', 1;  
GO  
-- To update the currently configured value for advanced options.  
RECONFIGURE;  
GO  
-- To enable the feature.  
EXEC sp_configure 'xp_cmdshell', 1;  
GO  
-- To update the currently configured value for this feature.