Kevin Colten kevincolten

Web

Put app in maintenance mode on Heroku
Download backup of database in mLab
Copy database to DO Droplet scp backup.tgz root@x.x.x.x:~/
SSH into droplet and unzip the file tar zxvf backup.tgz
Inside the unzipped directory, rename the database directory to parties/ mv backup/database-name/ backup/parties

Here's another post about what technologies I love to use, or about what I ate for breakfast.

	SELECT users.id, users.first_name, users.last_name, users.email, stripe_payments.customer, stripe_payments.source, CAST(SUM(stripe_payments.amount) as FLOAT) / 100
	FROM users
	JOIN stripe_payments as sp ON INSTR(sp.source, users.email) > 0
	JOIN stripe_payments ON users.customer_id = stripe_payments.customer
	WHERE stripe_payments.customer != ''
	AND sp.customer = ''
	GROUP BY users.email;

	/* SELECT users.id, users.first_name, users.last_name, users.email, stripe_payments.customer, stripe_payments.source, CAST(SUM(stripe_payments.amount) as FLOAT) / 100
	FROM users

	SELECT idn, first_name, last_name, email, phone, COUNT(users.email) as courses
	FROM users
	INNER JOIN registrations ON users.id = registrations.user_id
	GROUP BY users.email
	HAVING COUNT(users.email) < 3 AND COUNT(users.email) > 1
	ORDER BY courses DESC, cast(idn as Number) ASC;

	//Intermediate Midterm

	//Please fork this gist. Complete it, and remember to save often!



	// 1. How do you make comments and why do you make them?