Andrew Pruski dbafromthecold

## mssql-cli-ubuntu-22.04
#######################################################################################################
#
# How to install the mssql-cli on Ubuntu 22.04 running python 3.10
#
# This is pretty hacky so please only do this on dev/test servers
#
# The first few steps here will also get the mssql-cli working on Ubuntu 20.04 (running python 3.8)
#
#######################################################################################################

## index.html
<!doctype html>
<html>
	<head>
		<meta charset="utf-8">
		<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

		<title>Test Presentation</title>

		<link rel="stylesheet" href="dist/reset.css">
		<link rel="stylesheet" href="dist/reveal.css">

## vimrc
"vim generic settings
set number
set nocompatible
set backspace=indent,eol,start
set nowrap
set nobackup
set noswapfile
set noundofile


## main.go
package main

import (
	"fmt"
	"io/ioutil"
	"os"
	"os/exec"
	"path/filepath"
	"strconv"
	"syscall"

## azure-sql-edge-persistent.yaml
apiVersion: apps/v1
kind: Deployment
metadata:
  name: sqledge-deployment
spec:
  replicas: 1
  selector:
    matchLabels:
      app: sqledge
  template:

## azure-sql-edge-pvc.yaml
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: sqlsystem-pvc
spec:
  volumeName: sqlsystem-pv
  accessModes:
    - ReadWriteOnce
  resources:
    requests:

## azure-sql-edge-pv.yaml
apiVersion: v1
kind: PersistentVolume
metadata:
  name: sqlsystem-pv
spec:
  capacity:
    storage: 1024Mi
  accessModes:
    - ReadWriteOnce
  nfs:

## azure-sql-edge.yaml
apiVersion: apps/v1
kind: Deployment
metadata:
  name: sqledge-deployment
spec:
  replicas: 1
  selector:
    matchLabels:
      app: sqledge
  template:

## testnginxingress.yaml
apiVersion: networking.k8s.io/v1
kind: Ingress
metadata:
  name: ingress-testwebsite
  annotations:
    kubernetes.io/ingress.class: "nginx"
spec:
  rules:
  - host: www.testwebaddress.com
    http:

## DecodeHelmSecrets.sh
#!/bin/bash

# get helm secrets from Kubernetes cluster
SECRET=$(kubectl get secret $1 -o jsonpath='{ .data.release }' )

# decode the secrets
DECODED_SECRET=$(echo $SECRET | base64 -d | base64 -d | gunzip -c )

# parse the decoded secrets, pulling out the templates and removing whitespace
DATA=$(echo $DECODED_SECRET | jq '.chart.templates[]' | tr -d '[:space:]' )
	#######################################################################################################
	#
	# How to install the mssql-cli on Ubuntu 22.04 running python 3.10
	#
	# This is pretty hacky so please only do this on dev/test servers
	#
	# The first few steps here will also get the mssql-cli working on Ubuntu 20.04 (running python 3.8)
	#
	#######################################################################################################
	<!doctype html>
	<html>
	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

	<title>Test Presentation</title>

	<link rel="stylesheet" href="dist/reset.css">
	<link rel="stylesheet" href="dist/reveal.css">
	"vim generic settings
	set number
	set nocompatible
	set backspace=indent,eol,start
	set nowrap
	set nobackup
	set noswapfile
	set noundofile
	package main

	import (
	"fmt"
	"io/ioutil"
	"os"
	"os/exec"
	"path/filepath"
	"strconv"
	"syscall"
	apiVersion: apps/v1
	kind: Deployment
	metadata:
	name: sqledge-deployment
	spec:
	replicas: 1
	selector:
	matchLabels:
	app: sqledge
	template:
	apiVersion: v1
	kind: PersistentVolumeClaim
	metadata:
	name: sqlsystem-pvc
	spec:
	volumeName: sqlsystem-pv
	accessModes:
	- ReadWriteOnce
	resources:
	requests:
	apiVersion: v1
	kind: PersistentVolume
	metadata:
	name: sqlsystem-pv
	spec:
	capacity:
	storage: 1024Mi
	accessModes:
	- ReadWriteOnce
	nfs:
	apiVersion: networking.k8s.io/v1
	kind: Ingress
	metadata:
	name: ingress-testwebsite
	annotations:
	kubernetes.io/ingress.class: "nginx"
	spec:
	rules:
	- host: www.testwebaddress.com
	http:
	#!/bin/bash

	# get helm secrets from Kubernetes cluster
	SECRET=$(kubectl get secret $1 -o jsonpath='{ .data.release }' )

	# decode the secrets
	DECODED_SECRET=$(echo $SECRET \| base64 -d \| base64 -d \| gunzip -c )

	# parse the decoded secrets, pulling out the templates and removing whitespace
	DATA=$(echo $DECODED_SECRET \| jq '.chart.templates[]' \| tr -d '[:space:]' )