Kevin McGee dgnsrekt

Usage

(Create a symlink pytest for py.test)

pytest [options] [file_or_dir] [file_or_dir] ...

Help:

(This gist is pretty old; I've written up my current approach to the Pyramid integration on this blog post, but that blog post doesn't go into the transactional management, so you may still find this useful.)

Fast and flexible unit tests with live Postgres databases and fixtures

I've created a Pyramid scaffold which integrates Alembic, a migration tool, with the standard SQLAlchemy scaffold. (It also configures the Mako template system, because I prefer Mako.)

I am also using PostgreSQL for my database. PostgreSQL supports nested transactions. This means I can setup the tables at the beginning of the test session, then start a transaction before each test happens and roll it back after the test; in turn, this means my tests operate in the same environment I expect to use in production, but they are also fast.

I based my approach on [sontek's blog post](http://sontek.net/blog/

	import sys

	import sqlalchemy as sa
	from sqlalchemy.exc import IntegrityError
	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy.orm import sessionmaker

	base = declarative_base()
	print 'SQLAlchemy version {}'.format(sa.__version__)

	#!/usr/bin/env python
	"""
	Retrieve intraday stock data from Google Finance.
	"""

	import csv
	import datetime
	import re

	import pandas as pd

	<html>
	<body>
	<h1>I feel lonely</h1>

	<script type="text/javascript" src="//code.jquery.com/jquery-2.1.3.min.js"></script>
	<script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/socket.io/0.9.16/socket.io.min.js"></script>
	<script type="text/javascript" charset="utf-8">
	var socket = io.connect('http://' + document.domain + ':' + location.port);
	socket.on('connect', function() {
	socket.emit('connected');

	{
	"vars": {
	"@gray-base": "#fff",
	"@gray-darker": "lighten(@gray-base, 13.5%)",
	"@gray-dark": "lighten(@gray-base, 20%)",
	"@gray": "lighten(@gray-base, 33.5%)",
	"@gray-light": "lighten(@gray-base, 46.7%)",
	"@gray-lighter": "lighten(@gray-base, 93.5%)",
	"@brand-primary": "darken(#428bca, 6.5%)",
	"@brand-success": "#7bcc3a",

	py.test test_sample.py --collect-only # collects information test suite

	py.test test_sample.py -v # outputs verbose messages

	py.test -q test_sample.py # omit filename output

	python -m pytest -q test_sample.py # calling pytest through python

	py.test --markers # show available markers

	import luigi

	class ATask(luigi.Task):

	def output(self):
	return luigi.LocalTarget("atask_output.txt")

	def run(self):
	with self.output().open("w") as outfile:
	outfile.write("Test")

	import re
	import json
	import luigi
	import pandas as pd
	from mysolr import Solr
	from bs4 import BeautifulSoup


	class InputText(luigi.ExternalTask):

	// include the library code:
	#include <LiquidCrystal.h>

	// initialize the library with the numbers of the interface pins
	LiquidCrystal lcd(12, 11, 5, 4, 3, 2);

	void setup() {
	Serial.begin(9600);
	lcd.begin(16, 2);
	lcd.print("start");