Mauricio Valencia mauriciovalencia

This is a fork of original gist https://gist.github.com/nrollr/3f57fc15ded7dddddcc4e82fe137b58e, with slight changes on pointing to 5.7 version branch, instead of 8 (latest default of MySQL in Hombrew).

Install MySQL 5.7 on macOS

This procedure explains how to install MySQL using Homebrew on macOS (Sierra 10.12 and up)

Install Homebrew

Installing Homebrew is effortless, open Terminal and enter :
$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
Note: Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.

Cheat Sheets are greate but they are not a substitute for learning the framework and reading the documentation as we most certainly have not covered every potential example here. Please refer to the Rails Command Line Docs for more information.

Command Line Generator Info

Reference

You can get all of this information on the command line.

rails generate with no generator name will output a list of all available generators and some information about global options. rails generate GENERATOR --help will list the options that can be passed to the specified generator.

Resources

http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Scan.html

http://docs.aws.amazon.com/sdkforruby/api/Aws/DynamoDB/Client.html

Summary

DynamoDB's scan operation fetches only 1MB at one time and it adds LastEvaluatedKey (LEK) in the response if it has a next page.

Variables

Ruby

Name a value.

color = "red"

	const AWS = require('aws-sdk');

	const client = new AWS.SecretsManager({});

	// Call the AWS API and return a Promise
	function getAwsSecret(secretName) {
	return client.getSecretValue({ SecretId: secretName }).promise();
	}

	// Create a async function to use the Promise

	import pandas as pd
	import pandas.io.sql as sqlio
	import psycopg2

	conn = psycopg2.connect("host='{}' port={} dbname='{}' user={} password={}".format(host, port, dbname, username, pwd))
	sql = "select count(*) from table;"
	dat = sqlio.read_sql_query(sql, conn)
	conn = None

	############ REQUIREMENTS ####################
	# sudo apt-get install python-pip
	# sudo apt-get install libpq-dev
	# sudo pip install psycopg2
	# sudo pip install sqlalchemy
	# sudo pip install sqlalchemy-redshift
	##############################################

	import sqlalchemy as sa
	from sqlalchemy.orm import sessionmaker

	var prompt = require("gulp-prompt");

	// Promts you to choose a task
	gulp.task('default', function() {
	var taskNames = [];
	for (var taskName in gulp.tasks) {
	if (gulp.tasks.hasOwnProperty(taskName)) {
	taskNames.push(taskName);
	}
	}

	/*
	* AWS Sdk KMS spike: (assuming node v6.6+)
	* 1 - Create master key at KMS
	* 2 - Copy alias or ARN
	* 3 - run this i.e.
	* $ node spike.js KEY_ALIAS YOUR_PLAINTEXT_TO_ENCRYPT
	*/
	const AWS = require('aws-sdk');

	// aws-sdk is not reading my region info so i'll have to set it here

	# Install Homebrew
	/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

	# Install nvm
	brew install nvm

	# Export nvm environment
	export NVM_DIR="$HOME/.nvm"
	. "$(brew --prefix nvm)/nvm.sh"