nongxiaohe/db/postgresql.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
    demeter database
    name:postgresql.py
    author:rabin
"""
import psycopg2

class Postgresql(object):
	instance = None
	def __new__(cls, *args, **kwd):
		if Postgresql.instance is None:
			Postgresql.instance = object.__new__(cls, *args, **kwd)
		return Postgresql.instance
		
	def __init__(self, config):
		self.connect = psycopg2.connect(host=config['host'], port=config['port'], user=config['username'], password=config['password'], database=config['dbname'])

	def get(self):
		return self.connect

	def create(self, name):
		'psql -U postgres'
		sql = 'CREATE DATABASE '+name+' WITH OWNER = postgres ENCODING = "UTF8"'
		return sql