Jonathan Willitts JonathanWillitts

Setting up `edc_source` dev environment

This document describes using the update_edc_code.sh script for both:

the initial setup of the edc_source development environment
updating the edc_source development environment, to pull down any recent additions/changes

1. Setup ODBC on your Mac (including Apple Silicon)

Install brew

unixodbc package from brew works for Apple Silicon

	#!/bin/bash
	################################################################################
	# Searches remote directory for newest *.sql file and downloads it to current
	# directory
	#
	# Usage: bash download_latest_db.sh <db_dir_name>
	#
	# Note: requires values for $REMOTE_USER, $REMOTE_HOST and $REMOTE_BACKUP_ROOT
	# to be set in corresponding env_variables.conf file
	################################################################################

	#!/bin/bash
	################################################################################
	# Creates a new user and configures for SSH tunnel only DB access.
	#
	# Usage: create_ssh_tunnel_user.sh <username_to_create>
	#
	################################################################################
	set -e # on error, exit early

	if [[ -z $1 ]]

	#!/bin/bash
	################################################################################
	# Grants privileges to specified user on specified database.
	#
	# Grants/privileges currently defined in: generate_edc_select_grants.sql
	# which provide select-only access to all tables in specified database,
	# excluding those containing 'rando' or 'erik' in their name.
	#
	# Usage: db_grant_select_access.sh <user_to_grant_to> <database_to_grant_on>
	#

	#!/bin/bash
	#####
	# Shows the last (accepted, via SSH Key) connection for each user.
	#
	# How? By searching all auth logs (inc gzipped ones), and filtering to show
	# most recent accepted connections
	#
	# Works/tested on: Ubuntu 18.04.6 LTS (bionic)
	#
	# Usage: [sudo] last_ssh_login.sh

	#!/bin/bash

	echo ""
	echo "Running pre-release script for: "
	echo "$PWD"

	set -e
	echo "Checking repo statuses ..."
	git checkout main && git pull && \
	git checkout develop && git pull

	"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
	" Jonathan Willitts - Basic vim config
	"
	" To download and start using:
	" $ cd ~
	" $ wget https://gist.github.com/JonathanWillitts/b1636e69f332b79ff52c4a51576efc67/raw/.vimrc
	"
	"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

	set background=dark