Mark Headd mheadd

Note - the steps below are adapted from these instructions.

Prerequisites

Install Cloud Foundry CLI tool.
Install Cloud Foundry CLI Service Connection Plugin.

Create an RDS service

Using an SSH tunnel to remotely administer a cloud.gov RDS

Cloud.gov let's you interact with your apps and bound services via SSH.

The cf-service-connect plugin lets you connect to your bound services, and is often your beset choice for interacting with services in cloud.gov. But what if cf-service-connect doesn't work for you (e.g., if you are using a newer version of the cf CLI?

SSH tunneling to the rescue!

Usage

Keybase proof

I hereby claim:

I am mheadd on github.
I am mheadd (https://keybase.io/mheadd) on keybase.
I have a public key ASDf5v_IBXcBfsgDRP1fwqY16evvJMtC_SLI6H_bMN1VpAo

To claim this, I am signing this object:

Here are some steps to bring the bulk Philly311 CSV file into a local SQLite database to enable SQL queries.

Tools you'll use

sqlite3 (installed by default on OS X - try typing in ~$ which sqlite3 at a command prompt).
csvsql (follow installation instructions here if not already installed).
SQLite Manager for Firefox.

	const { batch } = require('frontmatter-file-batcher');

	// The name of the file to modify.
	const file_name = process.argv[2];

	// The name of the new front matter property to add.
	let fm_property = process.argv[3];

	// The value of the new front matter property
	let fm_value = process.argv[4];

	FROM php:5.5-apache

	RUN a2enmod rewrite

	# install the PHP extensions we need
	RUN apt-get update && apt-get install -y libpng12-dev libjpeg-dev libpq-dev \
	&& rm -rf /var/lib/apt/lists/* \
	&& docker-php-ext-configure gd --with-png-dir=/usr --with-jpeg-dir=/usr \
	&& docker-php-ext-install zip \
	&& docker-php-ext-install gd mbstring pdo pdo_mysql pdo_pgsql

	#!/bin/bash
	#
	# A simple script to get a GUID for an applications. Note - assumes you have jq installed.
	#

	# The GUID for the app you want to check
	APP_NAME=$1

	if [[ ! $(which jq) ]]; then
	echo "Error: You must have the jq utility installed to run this script. https://stedolan.github.io/jq/" >&2

	# Install base image
	FROM microsoft/mssql-server-linux

	# Copy over the SQL file to set up the database
	COPY setup.sql /

	# Copy over the file with sample data.
	# This data is from https://people.sc.fsu.edu/~jburkardt/data/csv/csv.html
	COPY data.csv /

	##!/bin/bash

	## The name of the Github account user or org
	OWNER=$1

	## The name of the repo
	REPO=$2

	## Append the file with listd of issues
	curl -s "https://api.github.com/repos/$OWNER/$REPO/issues?page=1&per_page=100&state=closed" \

	##!/bin/bash

	# License number (e.g., 3381).
	LICENSE_TYPE=$1

	# The name of the file to populate with records.
	FILE_NAME=$2

	echo "pri_contact_last_name, pri_contact_first_name, pri_contact_company_name, pri_contact_address1, pri_contact_city, pri_contact_state, pri_contact_zip, license_number, license_type_name, license_type_code" > $FILE_NAME