hunt3ri

# Tag Prod version
git tag -a v1.0 -m "v1.0 deployed to $ENV"
git push origin v1.0

hunt3ri

import argparse
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.dialects.postgresql import TSVECTOR
from sqlalchemy.orm import sessionmaker

# Create DB Session
engine = create_engine('postgresql://iain:password@localhost:5432/Real-World')
Session = sessionmaker(bind=engine)
session = Session()

hunt3ri

CREATE TABLE IF NOT EXISTS sports_articles(
    id BIGSERIAL PRIMARY KEY,
    title VARCHAR(100),
    article VARCHAR(2000));
    
Insert into sports_articles (title, post) values('Francesco Totti brings down curtain on "something beautiful" at Roma', 'Francesco Totti tried to raise a smile. Striding out on to the Stadio Olimpico pitch for a farewell address at the end of his last-ever match for Roma, he shushed the home crowd and then teased that staying quiet “ought to be easy for you”.');
Insert into sports_articles (title, post) values('Brendan Rodgers pays tribute to Barcelona after Celtic are thrashed', 'Brendan Rodgers said that Barcelona “beat you up with the ball” on a night on which he likened the Camp Nou pitch to an ice-rink, the game whizzing past his helpless players. Celtic fell to a 7-0 defeat but their manager insisted that there was “no embarrassment” and that he could not have asked for any more from his team.');
Insert into sports_articles (title, post) values('Arsenal board expected to ru

hunt3ri

pg_restore --host=<youHost>.eu-west-1.rds.amazonaws.com --port=5432 --username=<yourAdminUser> --password --dbname=<yourDB>  /data-loader/dumpfile.dmp

hunt3ri

mkdir data-load
vi Dockerfile   # Copy Docker commands listed above into your local Dockerfile
docker build -t postgres-db .
docker run -d -v /Users/iainhunter/dev/docker/postgres/data-load:/data-loader -p 5432:5432 postgres-db
docker ps
docker exec -it <imageId> bash

hunt3ri

FROM postgres

ENV POSTGRES_USER postgres
ENV POSTGRES_PASSWORD password

hunt3ri

@manager.command
def profile(length=500, profile_dir=None):
    """Start the application under the code profiler."""
    from werkzeug.contrib.profiler import ProfilerMiddleware
    application.wsgi_app = ProfilerMiddleware(application.wsgi_app, restrictions=[length], profile_dir=profile_dir,
                                              sort_by=('time', 'calls'))
    application.run()

hunt3ri

docker run --name my-local-mongo -v mongo-data:/data/db -p 27017:27017 -d mongo

hunt3ri

import tornado.ioloop
import tornado.web

class MainHandler(tornado.web.RequestHandler):
    def get(self):
        self.write("Hello, Python3")

application = tornado.web.Application([
    (r"/", MainHandler),
])

hunt3ri

export PATH=/Library/Frameworks/Python.framework/Versions/3.3/bin:$PATH