db_psql.py

Go to the documentation of this file.

import subprocess

def create(config, site):
    if 'HOST' not in config.DATABASES['default']:
        subprocess.call(['su', 'postgres', '-c', "psql -c \"CREATE USER cc1;\""])
        subprocess.call(['su', 'postgres', '-c', "psql -c \"CREATE DATABASE %s WITH OWNER cc1;\"" % site])
    return 0

def remove(config, site):
    if 'HOST' not in config.DATABASES['default']:
        subprocess.call(['su', 'postgres', '-c', "psql -c \"REVOKE ALL PRIVILEGES ON DATABASE %s FROM cc1;\"" % site])
    return 0

def purge(config, site):
    remove()
    subprocess.call(['su', 'postgres', '-c', "psql -c \"DROP DATABASE %s;\"" % site])
    return 0