Weekend project - my first Flask app "Quotes to live by"

from flask import url_for

BADGE = 'badges/{award}{num}.png'

class Badge:
	def __init__(self, award, badges, num_actions):
		self.award = award
		self.badges = badges
		self.num_actions = num_actions
		self.title = "Badge earned for {} {}".format(
			self.num_actions, self.award)
		self.src = self._get_badge()

	def _get_badge(self):
		res = [i for i in self.badges if self.num_actions >= i]
		if not res:
			return False
		badge = BADGE.format(award=self.award[0], num=res[-1])
		return url_for('static', filename=badge)

def get_badges(user):
	yield Badge("quotes", (1, 5, 10, 25, 50), user.posts.count())
	yield Badge("comments", (1, 5, 10, 25, 50), user.comments.count())
	yield Badge("followers", (5, 10, 25, 50, 100), user.followers.count() -1)

@main.route('/user/<username>')
def user(username):
	user = User.query.filter_by(username=username).first_or_404()
	...
	badges = list(get_badges(user))
	return render_template('user.html', user=user,
						posts=posts, badges=badges,
						pagination=pagination)

import json
import os
import requests
import socket
import sys

QOD_LINK = "http://quotes.rest/qod.json"
LOCAL = "macbook" in socket.gethostname().lower()
API_URL = "http://127.0.0.1:5000/" if LOCAL else "https://qtlb.herokuapp.com/"
POST_URL = API_URL + "api/v1.0/posts/"
USR = os.environ.get('QTLB_USR') or sys.exit("set USR env var")
PW = os.environ.get('QTLB_PW') or sys.exit("set PW env var")
AUTH = requests.auth.HTTPBasicAuth(USR, PW)
HEADERS = {'Content-Type': 'application/json'}
CATEGORIES = {
	"inspire": "Inspiring Quote of the day",
	"management": "Management Quote of the day",
	"sports": "Sports Quote of the day",
	"life": "Quote of the day about life",
	"funny": "Funny Quote of the day",
	"love": "Quote of the day about Love",
	"art": "Art quote of the day ",
	"students": "Quote of the day for students",
}

def get_qod(category=None):
	link = QOD_LINK
	if category:
		link += '?category={}'.format(category)
	resp = requests.get(link)
	if resp.status_code != 200:
		sys.exit("failed to get daily quote")
	return resp.json()["contents"]["quotes"][0]

if __name__ == "__main__":

	category = None
	if len(sys.argv) > 1:
		category = sys.argv[1].lower()
		if not category in CATEGORIES.keys():
			sys.exit("unknown category")

	qod = get_qod(category)
	data = {
		'body': qod['quote'], 
		'who': qod['author'],
		'inspiration': ' '.join(['#'+tag for tag in ['qod'] + qod['tags']]),
		'cover': qod['background'], 
	}
	resp = requests.post(POST_URL, auth=AUTH, 
		headers=HEADERS, data=json.dumps(data))
	if resp.status_code == 201:
		print("OK")
	else:
		print("FAIL with status code: {}".format(resp.status_code))

SLACK_WEBHOOK_SECRET = os.environ.get('SLACK_WEBHOOK_SECRET')
SLACK_USER = os.environ.get('SLACK_USER')
DELIMIT = "-"

...
...

@api.route('/slack', methods=['POST'])
def inbound():
	if request.form.get('token') != SLACK_WEBHOOK_SECRET:
		return Response('Not authorized'), 403
	text = request.form.get('text')
	if not DELIMIT in text:
		return Response('No valid delimiter between quote body and who'), 400
	user = User.query.filter_by(username=SLACK_USER).first_or_404()
	post = Post()
	post.author_id = user.id
	post.body = "".join(text.split(DELIMIT)[:-1]).strip().replace('"', '')
	post.who = text.split(DELIMIT)[-1].strip()
	db.session.add(post)
	db.session.commit()
	return Response('Post created'), 201

$(function(){ 
	var currentUrl = window.location.href
	...
	var regex = /.*\/post\/\d+.*/
	if(currentUrl.match(regex)){
		var pic = $('#bgImg').text();
		$("body").css("background", "url("+pic+") no-repeat center center fixed");
		$("body").css("-webkit-background-size", "cover");
		$("body").css("-moz-background-size", "cover");
		$("body").css("-o-background-size", "cover");
		$("body").css("background-size", "cover");
		$(".mainContent").css("background", "#fff");
		$(".mainContent").css("opacity", "0.9");
	}
});

#  login and create app

$ heroku login
$ heroku create <appname>

# local DB = sqlite3, remote = Postgres, hobby is free Heroku version

$ heroku addons:create heroku-postgresql:hobby-dev
..
$ heroku pg:promote HEROKU_POSTGRESQL_PUCE_URL


# test the Heroku configuration locally

# test locally defining an .env file (and add it to .gitignore!)

$ more .env 
FLASK_CONFIG=heroku
MAIL_USERNAME=<your-email>
MAIL_PASSWORD=<your-pw>
FLASKY_ADMIN=<your-email>
FLASKY_MAIL_SENDER=<your-email>

$ pip install gunicorn

$ gunicorn manage:app


# define dependencies (requirements.txt)
$ pip freeze > requirements.txt

# Procfile tells Heroku how to start your app
$ echo “web: gunicorn manage:app” > Procfile

# specify the Py version to be used
$ echo “python-3.5.2” > runtime.txt

# setup remote env variables

heroku config:set FLASK_CONFIG=heroku
heroku config:set FLASKY_ADMIN=<your-email>
heroku config:set FLASKY_MAIL_SENDER=<your-email>
heroku config:set MAIL_USERNAME=<your-email>
heroku config:set MAIL_PASSWORD=<your-pw>
heroku config:set SLACK_USER=<your-user>
heroku config:set SLACK_WEBHOOK_SECRET=<your-secret>

# push code to Heroku
$ git push heroku master

# deploy 

$ heroku run python manage.py deploy
$ heroku restart


# review logs
$ heroku logs (-t) 

# to upgrade
$ heroku maintenance:on
$ git push heroku master
$ heroku run python manage.py deploy
$ heroku restart
$ heroku maintenance:off


$ postgres backup:
GUI: https://data.heroku.com
CLI: heroku pg:backups capture --app <app>

# restore locally
pg_restore -C  <file-name>

# to connect to remote DB directly:
heroku pg:psql DATABASE_URL --app <app>

# learned some postgres: 
- show tables:
qtlb::DATABASE=> \dt;
- update sql queries:
qtlb::DATABASE=> UPDATE users SET role_id = 3 WHERE username = 'bob';