#!/usr/bin/env python
""" A tool to create initial database, users etc for urlrep """

# Run this script as a PostgreSQL superuser - the user postgres works fine normally.
import sys, os

db = 'eiaourlrep'
user = 'eiaourlrep'
passwd = ''
role = 'urlrepuser'

def delete():
    print 'Dropping db %s' % db
    cmd = 'dropdb %s' % db
    os.system(cmd)
    print 'Dropping user %s' % user
    cmd = 'dropuser %s' % user
    os.system(cmd)
    print 'Dropping user %s' % role    
    cmd = 'dropuser %s' % role
    os.system(cmd)    

def main():
    delete()

if __name__ == "__main__":
    main()