Aaron ("AJ") Steers aaronsteers

WARNING

THIS GIST IS EXTREMELY OBSOLETE. DO NOT FOLLOW THESE INSTRUCTIONS. SERIOUSLY.

IF YOU IGNORE THE ABOVE WARNING, YOU AGREE IN ADVANCE THAT YOU DIDN'T GET THESE INSTRUCTIONS FROM ME, THAT I WARNED YOU, AND THAT I RESERVE THE RIGHT TO POINT AND LAUGH MOCKINGLY IF AND WHEN SOMETHING BREAKS HORRIBLY.

I'll do a write-up of current custom-kernel procedures over on Random Bytes ( https://randombytes.substack.com/ ) one day soon.

NOTE

Goal: Connect to MSSQL using FreeTDS / ODBC in Python.

Host: Ubuntu 11.10 x86_64

Install:

sudo apt-get install freetds-dev freetds-bin unixodbc-dev tdsodbc
pip install pyodbc sqlalchemy

In /etc/odbcinst.ini:

	import json
	import logging
	import os
	import sys
	from pathlib import Path
	from typing import List

	"""
	Transform meltano schedules from a json format into a crontab file.

	#!/bin/sh
	# -- coding:utf-8 posix --
	# === Initialize shell environment =============================================
	#set -u # Just stop undefined values.
	#set -e # Just stop error.
	#set -x # Debug running command.

	umask 0022
	export LC_ALL=C
	export LANG=C

	#!/bin/bash

	module=$1

	for resource in `terraform show -module-depth=1 \| grep module.${module} \| tr -d ':' \| sed -e 's/module.${module}.//'`; do
	terraform taint -module ${module} ${resource}
	done

	from pyspark import SparkContext, SparkConf
	from pyspark.sql import HiveContext, SQLContext
	import pandas as pd

	# sc: Spark context
	# file_name: csv file_name
	# table_name: output table name
	# sep: csv file separator
	# infer_limit: pandas type inference nb rows
	def read_csv(sc, file_name, table_name, sep=",", infer_limit=10000):