Dinesh Weerapura xydinesh

Delete

DELETE 
FROM m_productprice
WHERE m_pricelist_version_id='1000020' AND 
      m_product_id IN (SELECT m_product_id 
                       FROM m_product 
                       WHERE upc = '7094');

(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/

Intermediate CA Signing with Puppet

Problem statement

Many sites have a requirement to use an enterprise-wide certificate authority. They either have a "real" signing cert that chains to a public root CA or an internal root (usually air-gapped) which only signs issuing CA certificates, one per PKI application.

Puppet does not have a currently supported configuration which fits into this model. The [existing documentation][existing] describes using an "external CA" instead of Puppet's internally generated CA (which is a combined self-signed Root and issuing CA in one), but requires that the user turn off Puppet's issuance code and leaves the whole certificate generation and distribution workflow as an "exercise to the reader".

The procedure in this document describes a supportable configuration which bridges the gap between these two positions: it is possible to use Puppet's internal signing code to issue certificates from an intermediate CA cert which was externally generated and signed. There are a

	SELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner,
	CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
	THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))
	ELSE 'No Access'
	END AS Size
	FROM pg_catalog.pg_database d
	ORDER BY
	CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')
	THEN pg_catalog.pg_database_size(d.datname)
	ELSE NULL

	SELECT nspname \|\| '.' \|\| relname AS "relation",
	pg_size_pretty(pg_relation_size(C.oid)) AS "size"
	FROM pg_class C
	LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
	WHERE nspname NOT IN ('pg_catalog', 'information_schema')
	ORDER BY pg_relation_size(C.oid) DESC
	LIMIT 20;

	import unittest
	from pyramid import testing
	from paste.deploy.loadwsgi import appconfig

	from webtest import TestApp
	from mock import Mock

	from sqlalchemy import engine_from_config
	from sqlalchemy.orm import sessionmaker
	from app.db import Session

	from keystoneauth1 import loading
	from keystoneauth1 import session
	from novaclient import client as novaclient
	import boto3


	def get_session():
	loader = loading.get_plugin_loader('password')
	auth = loader.load_from_options(
	auth_url='https://auth_url',