PostgreSQL 包装

安装

sudo pip install pgdb
# sudo python3 -m pip install pgdb

使用方法

from pgdb import Connection

## 链接PostgreSQL
connection = Connection(user='postgres', database='main', host='localhost')

## 执行普通查询，查询结果会根据字段名进行包装编程字典，不再是元组
connection.query("select * from main")

## 执行单条查询，结果与query类似
connection.get("select * from main limit 1")

## 执行普通操作
connection.execute("update main set status = 0")

## 执行普通多条操作
connection.executemany("insert into main values %(status)s", [{'status': 1}])

# 其他操作

cursor = connection.cursor()
connection.commit()
connection.rollback()
connection.close()

欢迎大家前来贡献代码

For development

python setup.py sdist

## edit ~/.pypirc
### [pypi]
### repository = https://pypi.python.org/pypi
### username =  
### password =  

twine register dist/pgdb-0.0.1.tar.gz
twine upload dist/pgdb-0.0.1.tar.gz